Export and import

(0) Share

Report

Posted on by David Lo

570

Hi,

I would like to export some customer and items record from our Production instance to Testing, is there anyway I can export specific range of customer and items and import it back to the testing environment? many thanks

Regards,

David Lo

*This post is locked for comments

All responses (7)

Answers (1)

4BzSoftware 6,071 on at

Like (0)

Report

RE: Export and import

Hi David,

The end user license fee is for whole company (multiple users).

Top 5 users is for trial purpose.
David Lo 570 on at

Like (0)

Report

RE: Export and import

Hi 4bzsoftware,

May I know the end user license fee is for a single user or for whole company?

Many thanks

Regards,

David Lo
4BzSoftware 6,071 on at

Like (0)

Report

RE: Export and import

Hi David,

I have S-003 Excel Import Export Wizard. You can try it at my OneDrive.

Hope this can help you!
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Export and import

To filter a range of customers, on the XMLPort designer, select the Table Element properties and set a Table Filter on the SourceTableView Property.

To setup the XMLPort for importing, you have to set the Direction property to Import or Both. You should be able to use the same XMLPort for exporting and exporting.
David Lo 570 on at

Like (0)

Report

RE: Export and import

We are using NAV 2013, yes we would like to export specific customer and items only. I have to set up two XMLPorts one for customer and one for items?

When I import them back to Testing instance, do I need to setup two XMLPorts for import? many thanks
Community Member Microsoft Employee on at

Like (0)

Report

RE: Export and import

Yes, you can set a filter on the export. How are you exporting them? Are you using a Dataport or an XMLPort? What version of NAV are you using?
Aleksandar Totovic 16,765 on at

Like (0)

Report

RE: Export and import

What NAV version you use? Do you want only customers/items or you want entries also?