Import invoices from Charleston Seafood's website database.

 

entrée Folder

necs_shared\01\Charleston Seafood\

 

Where "01" is the entrée company number.

 

A folder for  "Charleston Seafood" needs to be created for entrée V4 in the necs_shared\01\Charleston Seafood\ folder. For entrée V3 use the folder that contains the NECS data files.

Configure & Import

1.In the Charleston Seafood Access database, export the CustExp Query to a delimited file called CustExp.txt and export the ItemExp Query to a delimited file called ItemExp.txt.

Both these files will have a delimiter character of a Tab character and no text qualifier. These files need to be saved in the "Charleston Seafood" folder.

2.In the entrée V4 the import process is accessed from the entrée Add-Ons ribbon menu > Import/Export > Import Data > entrée Import > select Charleston Seafood Import.

3.Click Generate. Both exported .txt files will be imported into temporary databases.

4.A dialog box will display asking for the Charleston Seafood Order Number to import. This is a continuous loop where one at a time it will ask for the order numbers.

5.Once all the orders are processed you can finish the import by clicking the Cancel button and exit the import.