Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Importing General Ledger Journal into Pastel Xpress V 12

  1. #1
    New Member
    Join Date
    Sep 2013
    Location
    Durban
    Posts
    3
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Importing General Ledger Journal into Pastel Xpress V 12

    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

  2. #2
    Gold Member
    Join Date
    Mar 2012
    Location
    Vanderbijlpark
    Posts
    886
    Thanks
    83
    Thanked 381 Times in 298 Posts
    Perhaps it is expecting a "," as the delimiter, as opposed to a";"?

  3. Thanks given for this post:

    Stevie Mac (22-Sep-13)

  4. #3
    New Member
    Join Date
    Sep 2013
    Location
    Durban
    Posts
    3
    Thanks
    3
    Thanked 0 Times in 0 Posts
    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.

  5. #4
    Gold Member
    Join Date
    Mar 2012
    Location
    Vanderbijlpark
    Posts
    886
    Thanks
    83
    Thanked 381 Times in 298 Posts
    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.

    Click image for larger version. 

Name:	ListSeperator.jpg 
Views:	971 
Size:	87.4 KB 
ID:	3990

  6. Thanks given for this post:

    Stevie Mac (23-Sep-13)

  7. #5
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    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.
    Attached Files Attached Files
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  8. Thanks given for this post:

    Stevie Mac (23-Sep-13)

  9. #6
    New Member
    Join Date
    Sep 2013
    Location
    Durban
    Posts
    3
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Brilliant.

    Thanks so much for all you input.

  10. #7
    New Member
    Join Date
    Mar 2014
    Location
    Kampala
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.
    Attached Files Attached Files

  11. #8
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,648
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12
    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 )

  12. #9
    New Member
    Join Date
    Mar 2014
    Location
    Kampala
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing a CSV file into Pastel

    Quote Originally Posted by Dave A View Post
    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.

  13. #10
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    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.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  14. Thank given for this post:

    Dave A (08-Mar-14), mawirepower (06-Jun-19)

Page 1 of 2 12 LastLast

Similar Threads

  1. [Article] Pastel Accounting Tip: Journal Contras
    By Neville Bailey in forum Accounting Forum
    Replies: 12
    Last Post: 25-Apr-23, 09:21 AM
  2. Pastel General Ledger importing
    By osbert in forum Accounting Forum
    Replies: 8
    Last Post: 10-Dec-15, 10:23 PM
  3. [Question] Inventory journal entry on Pastel
    By Jackievdw in forum Accounting Forum
    Replies: 5
    Last Post: 19-Jul-13, 09:07 AM
  4. Debtors Ledger and General Ledger
    By Simimano in forum Accounting Forum
    Replies: 1
    Last Post: 15-Apr-13, 03:24 PM
  5. Create General Ledger accounts for take-on balances
    By Elize7 in forum Accounting Forum
    Replies: 5
    Last Post: 23-Jun-12, 09:26 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •