[Question] Importing General Ledger Journal into Pastel Xpress V 12

[Stevie Mac]

I have tried to import the attached file, and the error message I get is
Line 1: date must be in the format DD/MM/YYYY
Line 1: Invalid date
Line 1: GDC field must be G, D or C.

From what I can see, the file complies with this.



Can anyone point out where have gone wrong please?

import to gl.csv

[CLIVE-TRIANGLE]

Perhaps it is expecting a "," as the delimiter, as opposed to a";"?

[Stevie Mac]

Thanks for your help Clive.
Perhaps it is because I am using Windows 8.

Your suggestion helps me correct line 1, then I get all the same errors for lines 2-53.
I have tried a number of things, even one a time, but I cannot get this to work.

[CLIVE-TRIANGLE]

Stevie, access the Windows 8 equivalent of control Panel, then Region and Language, then Additional Settings
On the Numbers tab, change the List Seperator to a comma, the recreate that import file.

[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.

[Stevie Mac]

Brilliant.

Thanks so much for all you input.

[Baba Tadi]

date must be in the format DD/MM/YYYY

whats wrong with the csv file i have attached? Im getting "date must be in the format DD/MM/YYYY" error msg.

[Dave A]

A shot in the dark here, but I've had a little experience with date fields mucking around for the strangest reasons -
Check the short date format in your Regional Settings is set to dd/MM/yyyy
(Assuming Windows 7 - Start > Control Panel > Region and Language )

[Baba Tadi]

Importing a CSV file into Pastel

A shot in the dark here, but I've had a little experience with date fields mucking around for the strangest reasons -
Check the short date format in your Regional Settings is set to dd/MM/yyyy
(Assuming Windows 7 - Start > Control Panel > Region and Language )

Sure i checked that and my date format is dd/MM/yyyy. I dont see where im going wrong.

[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.

[Baba Tadi]

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]

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]

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

[Neville Bailey]

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

Glad you got sorted though.

[Baba Tadi]

Thanks man Thank you very much