Topic Options
#21992 - 04/29/10 07:02 AM GL Import
Acrylon Offline
Adagio Specialist

Registered: 04/12/07
Posts: 384
Loc: Canada
Hi All,

I'm trying to import a batch into the GL. We are using GL 8.1A. I'm importing in CSV, and doing the Header and Detail. I have the seperator as a comma (,) and am validating before import.

When I try and import, I keep on getting the error message "Record 2 is a batch header record with no details in the import file."

I am importing all fields in their default order, and have an H in the Hdr-Record Type and a D in the Det-Record Type.

What do I need to change to make this import work?

Thanks!

Top
#21994 - 04/29/10 07:21 AM Re: GL Import [Re: Acrylon]
Ryan Brohman Offline
Adagio Pro

Registered: 01/03/07
Posts: 10
Loc: Waterloo, Ontario
Hard to say without looking at the file. Try comparing your file to the one found in the sample data folder (\Softrak\Ledger\Glhdbtchim.CSV) to see if anything differences jump out.
_________________________
Ryan Brohman

Kitchener, ON


Top
#21995 - 04/29/10 07:59 AM Re: GL Import [Re: Ryan Brohman]
Acrylon Offline
Adagio Specialist

Registered: 04/12/07
Posts: 384
Loc: Canada
That sample file is great. I see what I did wrong.

I got the detail only one to work in the mean time, but this will definately help going forward.

Thanks,

Cam

Top
#21997 - 04/29/10 08:01 AM Re: GL Import [Re: Ryan Brohman]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
The format of a 'Header Detail' import file would look something like this:
H, field, field,...
D, field, field,...
D, field, field,...

The format of a 'Detail only' import file woud look something like this:
H, field, field, D, field, field,...
H, field, field, D, field, field,...

I suspect that you are mis-matching the import file to the template type, and using a file layout in the latter case. Ryan's suggestion to compare the sample files is good, to ensure you are picking the correct template type.
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 48 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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