Import GL batches from Paymate

Posted by: David

Import GL batches from Paymate - 05/15/12 10:12 AM

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.
Posted by: Brian Puddington

Re: Import GL batches from Paymate - 05/15/12 11:23 AM

Are you importing a csv file?
Posted by: David

Re: Import GL batches from Paymate - 05/15/12 12:56 PM

Yes.
Posted by: Brian Puddington

Re: Import GL batches from Paymate - 05/15/12 02:25 PM

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.
Posted by: David

Re: Import GL batches from Paymate - 05/15/12 02:53 PM

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?
Posted by: Brian Puddington

Re: Import GL batches from Paymate - 05/16/12 11:07 AM

What version of Paymate? What export format selected? What version of Adagio Ledger?
Posted by: David

Re: Import GL batches from Paymate - 05/16/12 01:15 PM

Paymate version:5.97, export format: ACCPAC version 6.1 - multi curreny (chosen from the list on set up), Adagio Ledger: 9.0C
Posted by: Retired_Guy

Re: Import GL batches from Paymate - 05/16/12 01:20 PM

Perhaps choosing Adagio from the Payment list would work better? They certainly wrote an export for Adagio Ledger.
Posted by: David

Re: Import GL batches from Paymate - 05/16/12 02:35 PM

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!