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,731
    Thanks
    231
    Thanked 355 Times in 311 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.
    People will forget what you said, people will forget what you did, but people will never forget how you made them feel. - Maya Angelou

  3. #3
    Silver Member Christel's Avatar
    Join Date
    Feb 2012
    Location
    Port Elizabeth
    Posts
    351
    Thanks
    56
    Thanked 92 Times in 66 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
  •