Results 1 to 3 of 3

Thread: IMPORTING CSV FILE TO PASTEL

  1. #1
    New Member
    Join Date
    Feb 2017
    Location
    Cape Town
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IMPORTING CSV FILE TO PASTEL

    Can anyone please help me. I am trying to import a csv cash book file to Pastel. I am getting the following error:

    Line 1 date must be in the format DD/MM/YYYY
    Line 1 invalid date
    Line 1 GDC field must be....
    Line 1 the contra account must be this cash book's contra account.....

    I have attached my csv file.

    Thank You
    Attached Files Attached Files

  2. #2
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Umkomaas
    Posts
    2,867
    Thanks
    249
    Thanked 372 Times in 328 Posts
    One of the very clever hints given on importing csv files is to export one from Pastel first, and then using that excel sheet and format insert your data and do the import. Don't know if that will help you, but I thought it a very clever suggestion as then you match the Pastel requirements perfectly.
    No act of kindness, no matter how small, is ever wasted. - Aesop "The Lion and the Mouse"

  3. #3
    Silver Member Christel's Avatar
    Join Date
    Feb 2012
    Location
    Port Elizabeth
    Posts
    360
    Thanks
    57
    Thanked 96 Times in 68 Posts
    SandiR... this file is not right... what bank is it? Maybe you should try and download it in another format?
    always fear when Christel is near....

Similar Threads

  1. Pastel Payroll/Easy File Import
    By Azhar in forum Accounting Forum
    Replies: 1
    Last Post: 18-May-16, 09:21 PM
  2. [Question] Pastel File Names
    By Dientjie in forum Accounting Forum
    Replies: 3
    Last Post: 15-Jun-15, 09:39 AM
  3. [Question] pastel 12, file corruption : network ?
    By Niellaufs in forum Accounting Forum
    Replies: 1
    Last Post: 28-Jul-14, 12:02 PM
  4. [Question] Exporting and Importing Inventory Master File in Pastel
    By HermanS in forum Accounting Forum
    Replies: 6
    Last Post: 26-Feb-14, 09:12 AM
  5. File name for Tax Type report (Pastel Xpress)
    By J7J in forum Accounting Forum
    Replies: 4
    Last Post: 25-May-12, 10:06 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
  •