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
    Durban
    Posts
    2,518
    Thanks
    221
    Thanked 334 Times in 291 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.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  3. #3
    Silver Member Christel's Avatar
    Join Date
    Feb 2012
    Location
    Port Elizabeth
    Posts
    333
    Thanks
    54
    Thanked 90 Times in 64 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
  •