Topic Options
#31861 - 05/15/12 10:12 AM Import GL batches from Paymate
David Offline
Adagio Fan

Registered: 02/16/11
Posts: 30
Loc: bc
It is OK to export the file. but when I import it from the same destination to Ledger, there is a error message: the file layout is incorret. I was set up correctly before I changed my computer and re-installed paymate.

Thanks.

Top
#31864 - 05/15/12 11:23 AM Re: Import GL batches from Paymate [Re: David]
Brian Puddington Offline
Adagio Ace

Registered: 06/09/08
Posts: 224
Loc: Montreal, Canada
Are you importing a csv file?
_________________________
Brian Puddington
Geneva Financial Systems
Montreal

Top
#31866 - 05/15/12 12:56 PM Re: Import GL batches from Paymate [Re: Brian Puddington]
David Offline
Adagio Fan

Registered: 02/16/11
Posts: 30
Loc: bc
Yes.

Top
#31868 - 05/15/12 02:25 PM Re: Import GL batches from Paymate [Re: David]
Brian Puddington Offline
Adagio Ace

Registered: 06/09/08
Posts: 224
Loc: Montreal, Canada
There is something at the very end of those csv files that Adagio doesn't like. Go to the rightmost place in the last line in the csv file and make sure that there are no invisible (e.g. CRLF) characters following your last data element. Using the backspace or delete will clear anything that you cannot see. Then re-save the file and try importing. If this does not work, go back to the same place at the very end of your file and hit Enter once immediately after your last bit of data. Re-save and import.

Works for me. Let us know if it works for you.
_________________________
Brian Puddington
Geneva Financial Systems
Montreal

Top
#31870 - 05/15/12 02:53 PM Re: Import GL batches from Paymate [Re: David]
David Offline
Adagio Fan

Registered: 02/16/11
Posts: 30
Loc: bc
I tried but it didn't work. The file exported from Paymate is a text file. On the import template in Ledger, the file format shows: ASCII CSV (Delimited), file name: data/GLBATCH.TXT.which is the same place as paymate files saved. Anything wrong with the template?

Top
#31873 - 05/16/12 11:07 AM Re: Import GL batches from Paymate [Re: David]
Brian Puddington Offline
Adagio Ace

Registered: 06/09/08
Posts: 224
Loc: Montreal, Canada
What version of Paymate? What export format selected? What version of Adagio Ledger?
_________________________
Brian Puddington
Geneva Financial Systems
Montreal

Top
#31878 - 05/16/12 01:15 PM Re: Import GL batches from Paymate [Re: Brian Puddington]
David Offline
Adagio Fan

Registered: 02/16/11
Posts: 30
Loc: bc
Paymate version:5.97, export format: ACCPAC version 6.1 - multi curreny (chosen from the list on set up), Adagio Ledger: 9.0C

Top
#31879 - 05/16/12 01:20 PM Re: Import GL batches from Paymate [Re: David]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Perhaps choosing Adagio from the Payment list would work better? They certainly wrote an export for Adagio Ledger.
_________________________
Andrew Bates

Top
#31882 - 05/16/12 02:35 PM Re: Import GL batches from Paymate [Re: Retired_Guy]
David Offline
Adagio Fan

Registered: 02/16/11
Posts: 30
Loc: bc
I am sorry I did not see Adagio - Single curreny on the list last time. It works. Thank you all so much for your time!

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 42 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1846 Members
5 Forums
14230 Topics
69689 Posts

Max Online: 359 @ 11/18/19 09:08 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