AccPac TimeCard CSV Import

[amarbirr]

Hello,
I just started working with AccPac, so I am running into a few problem because of my lack of experience with AccPac. I am trying to figure out minimal requirements for importing a timecard into accpac using a CSV file. AccPac isn't very helpful with problem description, all it says is "Description Incorrect CSV format".

I tried the help but nothing shows up. Can someone point me to a resource where I can find minimal requirements for import to work with a CSV?

Version 5.5A

 

[Jay Converse]

First export a manual timecard, and reduce all the columns you see. This will probably do:

RECTYPE,EMPLOYEE,PEREND,TIMECARD
RECTYPE,EMPLOYEE,PEREND,EARNDED,HOURS
1,XXX,20110101,1
2,XXX,20110101,HRLY,40

 

[amarbirr]

I am tyring to narrow it down to the problem, but so far unsuccessfull. Here are first few records from CSV:

"RECTYPE","TIMECARDNO","TRANSDATE","FISCALYEAR","STAFFCODE","BEGINDATE","COMPLETE"
"RECTYPE","LINENO","TIMECARDNO","CONTRACT","PROJECT","CATEGORY","EARNINGS","TDATE","STARTTIME","ENDTIME"
"1","AMBSTE101228","20101218","2010","AMBSTE","20101216","20"
"2","100","AMBSTE101228","IFA003224014","1000","1010","SIL","20101218","09:00:00","16:00:00"
"1","CLAKER101228","20101219","2010","CLAKER","20101216","20"
"2","100","CLAKER101228","IFA003224014","1000","1010","SIL","20101219","09:00:00","16:00:00"
"2","200","CLAKER101228","IFA003224014","1000","1010","SIL","20101219","16:00:00","21:00:00

 

[Jay Converse]

What's the message when you import?

 

[amarbirr]

The message I get is:

"Description: Incorrect CSV format."

I am afraid that error don't help much.

 

[DjangMan]

What is the import format that you've selected?

 

[Jay Converse]

Djangman -

This thread was cross posted on a couple forums. He needed a third header record:

RECTYPE,SEQ,LINENO,TIMECARDNO,CONTRACT,PROJECT,CATEGORY,DETAILNUM,EXPENSE

 

[amarbirr]

The third header solved the problem.