Item master import regularly

kiyac

Item master and its foreign table will regular update from another NAV system. What is the simplest design for handle data import automatically?

Planned Solution :
File format : XML
NAS + Job Scheduler + Data Migration (as it already built in validation and error logging)

As update item master is not just update a single tables, we need to update its foreign tables one by one before item master can be imported.

Table No Table Name
204 Unit of Measure
5722 Item category
5723 Product Group
23 Vendor
260 Tariff No
9 Country
8 Language
27 Item
5404 Item Unit of Measure
5717 Cross Reference
279 Extended Text Header
280 Extended Text Line

What is the less effort solution design for this imporation?
Use csv or xml will be better?
Can scheduler pass parameter to FTP and get file for import? We use FTP or share folder will be easier?

matttrax

kiyac wrote:

Use csv or xml will be better?

Text is text. XML is a little nicer as someone who opens the file might have some understanding of what it actually is.

Obviously a shared folder would be easier. Then you don't have deal with any kind of FTP automation in NAV. You can just send a COPY command through the command prompt (SHELL) and move the file where you need it.

You could also look into SQS Server Integration Services if you are on SQL.

kiyac

More specifically, item and its related tables is exported from 3.7 and import to 2009SP1.
Any advice of less effort solution?

Besides, how can job schedular pass the ftp username and password for login and extract related files for import?

ara3n

you can use windows script host automation.

If you search for ftp automatic download, you'll find an example on mibuso.