web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

export/import default data using xml during installation AL, D365BC ??

(0) ShareShare
ReportReport
Posted on by 782

Hi Experts:

 I have one table with the name of "Test"  now i want to insert mean import data into my table when i install the extension through xml how it is possible?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    You can export some table data via Export-NAVAppTableData and then create a TABXXXX.navxdata file. Place that in your AL project and in your install codeunit you can import it by using

    NavApp.LoadPackageData(XXXX);

    Never tryed with XML. You can try to add the XML file to the project and then read it using XML objects and load the data into your table.

  • Muhammad Arif Maseed Profile Picture
    782 on at

    sir can you please share any example or example link ?

    i have a problem that how to define table in xml

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    Try to explain in details what you want to do...

  • Muhammad Arif Maseed Profile Picture
    782 on at

    i want to export/import default data using xml during installation

  • Muhammad Arif Maseed Profile Picture
    782 on at

    How to export the NavAppTableData from BC i tried a lot of commands but not working

    I tried the command( Export-NAVAppTableData -ServerInstance BC -Path ‘C:\TAB18.navxdata’ -TableId 18)

    error ("Unable to locate the server instance: MicrosoftDynamicsNavServer$BC").

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    Use Export-NAVAppTableData -ServerInstance YOURSERVERINSTANCENAME -Path 'C:\NAVAppTableData' -TableId XXXX where XXXX is the table ID to export.

  • Muhammad Arif Maseed Profile Picture
    782 on at

    I tried to export table data from nav 2018 on this command ( "Export-NAVAppTableData -ServerInstance 'DynamicsNAV110' -Path' ‘C:\TAB18.navxdata’ -TableId 9000" ).

    this command can only allow me export data from those table which are non-company table,

    is there any way to export table data from company table.

  • Muhammad Arif Maseed Profile Picture
    782 on at

    @Stefano Demiliani

    sir the below link is your blog post sir it is very useful and nice post but i need some help from you regarding this post as you told how to publish objects as a web service i published a codeunit on method as you told in the below post now i want to show the soapurl of the publish object how it is possible to get the soap url ?

    community.dynamics.com/.../dynamics-365-business-central-publishing-a-web-service-from-extensions

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    You don't need the read the url. The URL has always the following format:

    api.businesscentral.dynamics.com/.../ObjectWSName

  • Muhammad Arif Maseed Profile Picture
    782 on at

    @Stefano Demiliani

    I have developed app for business central so need the soapUrl for setup page i want to install the app on different instance i don't want to use in hard code but because on every instance the url is changing as below. So is there any process to get the soapUrl.

    bcsandboxdev1:7047/.../CRONUS DK A%2S
    bcsandboxdev3:7047/.../CRONUS DK A%2S
    bcsandboxbfdev3:7048/.../Company('CRONUS Dk A%2S')

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans