Hi All,
I wanted to know how can I get access to the NAV database in MS Excel so that I can use it for XML Mapping?
Thanks in advance.
*This post is locked for comments
Hi All,
I wanted to know how can I get access to the NAV database in MS Excel so that I can use it for XML Mapping?
Thanks in advance.
*This post is locked for comments
Hi,
You can create a Page with source table as the table that you want data from.
Add Fields to the page that you need. If require add filters in the page properties.
Once all done. Create a Webservice for the page created.
Once the web service is created and published, you can use the SOAP URL for getting the data in XML Format.
** Remember use SOAP URL not the ODATA URL for getting data in XML Format.
Let us know if any issues.
Hi Saurav,
I want to save the file as a xml data file and not a excel workbook. Can you suggest a solution for the following.
Hi,
As you are using NAV 2017.
You can actually create a page / Query which you can Save as Excel. if there is no style sheet defined in the database you will get the XML Mapping for the data.
To start, open Microsoft Excel and select the Data tab.
From the Get External Data section of the menu, navigate to From Other Sources. | ...
In the data connection wizard, enter the name of the SQL Server and your login credentials:
Click on Next.
In the next window, select the database and table ...
Hi Sowkarthika,
I have already tried what you have suggested.
But how can I get access to the schema of the NAV database which i can use as XML Mapping so that i can create a .xml document from Excel.
Can you provide more details on your requirement ?
Guess this is what you are looking for : You can create an XML port and add tables & fields required. Then you can run the XML port and export it. You will get the format of XML Mapping.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156