Importing General Ledger Journal into Pastel Xpress V 12

**Baba Tadi** · 05-Mar-14, 11:32 AM

Originally Posted by Neville Bailey

I've had a look at your CSV file and the problem is that you have a blank row in between the rows with data.

If you delete the blank rows, it should import fine.

Ohhh my God i dont see any blank row there. Is it something i can read physically or its pastel which is just reading it.

**Baba Tadi** · 05-Mar-14, 11:37 AM

Originally Posted by Baba Tadi

Ohhh my God i dont see any blank row there. Is it something i can read physically or its pastel which is just reading it.

I agree with you 100% because i removed all other lines from my file and left only one line and it managed to import but still im confused coz i cant see the blank row physically on my file.

**Baba Tadi** · 05-Mar-14, 11:56 AM

Thank you very much i have managed to import. i used vbLf instead vbCr in my vb program.

**Neville Bailey** · 05-Mar-14, 12:30 PM

If you open the CSV file with Excel, you will be able to see the blank rows.

Glad you got sorted though.

**Baba Tadi** · 05-Mar-14, 06:57 PM

Thanks man Thank you very much

**Baba Tadi** · 06-Mar-14, 03:20 PM

Neville,

Please help, look on the batch i have sent, the last entry is a USD transaction, when i update the batch, Pastel is failing to convert it for me from local currency to USD amounts. I noted i had not put the exchange rate which i did but still the problem is there. What other parameter could i have left?

**krimpie** · 26-Aug-14, 11:42 AM

I have about 5 pages worth of entries that were captured in the wrong account on pastel. To correct this i need to journal each one out and then to the correct account. Is there anyway to export the transaction details and import it into journals to shorten the process?

**dylan.petzer007** · 01-Mar-20, 11:41 AM

Originally Posted by Neville Bailey

Hi Stevie,

Sorry about the delay in responding - I was too busy taking photographs over the weekend!

Clive is correct - your CSV file format is incorrect. I have attached a sample one-line GL journal for you to look at. A tip: if you want to make sure that you use the correct format, manually create a single line entry in Pastel and then export the batch to a file, with CSV as the file extension. Also, don't include any double-quotation marks in your CSV file, i.e. "

In Windows 8, over and above what Clive suggested, on the same Regional Settings screen, change the decimal symbol from a comma to a full stop and repeat the two edits in the Currency tab. Also make sure that your system is set to English South Africa.

Hi Neville,

At first, let me thank you for the absolutely valuable help that you provide to our community!

I have set up the excel file as directed in the Sage Self help documentation, after inputting data, deleting the first line (Headings) and saving as a CSV. I try to import into Pastel, I keep on getting the same error:

"Line 1: Period must be 1 to 13 only"

Could you possibly help with this error?

P.S: Find attached Excel File and CSV file for reference.

Thanks in advance!

Dylan Petzer

GL IMPORT TEMPLATE.xlsx
GL IMPORT TEMPLATE.csv

**Neville Bailey** · 02-Mar-20, 07:24 AM

Originally Posted by dylan.petzer007

Hi Neville,

At first, let me thank you for the absolutely valuable help that you provide to our community!

I have set up the excel file as directed in the Sage Self help documentation, after inputting data, deleting the first line (Headings) and saving as a CSV. I try to import into Pastel, I keep on getting the same error:

"Line 1: Period must be 1 to 13 only"

Could you possibly help with this error?

P.S: Find attached Excel File and CSV file for reference.

Thanks in advance!

Dylan Petzer

GL IMPORT TEMPLATE.xlsx
GL IMPORT TEMPLATE.csv

Hi Dylan,

I have checked the CSV file that you attached, and it seems fine. I also successfully imported it into a General Journal.

Not sure why you are having a problem. Have you tried importing the exact same file that you attached?