Topic Options
#5060 - 06/15/05 02:46 AM Re: IC Template & Import problem
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11618
Loc: Vancouver, BC Canada
Hi Christi,

Without knowing the contents of your import template for importing Shipments into Adagio Inventory, I couldn't answer as to whether they file layout is incorrect, or some other scenario is occuring.

If you are using the default template, then nothing appears incorrect, based on the CSV file contents you posted. What do you mean by 'defining all the shipment fields as import fields'? This might be the problem, as the ICSBATCH format only has 15 fields, 7 in the header and 8 in the footer. If your template does not have Det-Record Type(D) as the 8th field in the list, then that explains your problem.

There is a checkbox on the first screen called IC Shipment format, which automatically assigns the correct field layout for importing batches. Perhaps try checking this - you may have to make sure the import file name of ICSBATCH.GLS is maintained.

As for your other question, the IC import template files are actually a collection of files prefixed by 'ICIO' in your data directory. And of course the file you are trying to import is ICSBATCH.GLS, which will also be in your data directory.


Top
#5062 - 06/14/05 05:27 PM Re: IC Template & Import problem
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11618
Loc: Vancouver, BC Canada
Oops sorry - miscounted. There are 9 detail fields for a total of 16. Still the same regarding field number 8 being the "D".

If you don't have any luck, then the problem might be related to a field having too many characters than it should, or an extra comma somewhere throwing the field count off.


Top
#5064 - 06/15/05 11:26 AM Re: IC Template & Import problem
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11618
Loc: Vancouver, BC Canada
Hi christi,

I copied and pasted the import file information from your posting, and edit the detail fields to match my data. It imported without a problem, using Adagio Inventory 8.0A. Mind you, I'm not importing your import file, but the printable characters your posted here.

The layout of the information is correct, and I agree with Doug on the other posting that something like an invalid line break or extraneous character (like a comma) is getting in the way; we've seen this before. Perhaps open the ICSBATCH file with MS Word so you can see the non-printing characters?


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 65 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1873 Members
5 Forums
14529 Topics
70939 Posts

Max Online: 432 @ 01/20/25 10:17 PM
August
Su M Tu W Th F Sa
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31