Results 1 to 7 of 7

Thread: Pastel Import

  1. #1
    New Member
    Join Date
    May 2019
    Location
    KZN
    Posts
    8
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Pastel Import

    Hello

    Can someone please assist me?
    I am struggling to import a suppliers masterfile on to pastel partner.

    I exported the masterfile from the original pastel.
    After this I edited the data in excel as required.
    I saved the excel in a csv format.
    I follow the steps to import the masterfile on pastel, and get a few errors like:

    "Line 1: There are blank spaces in the code"
    "Line 1: The ID number is not valid"


    This goes on an on...
    Not sure what I should do to fix this?

    Thank you,

  2. #2
    New Member
    Join Date
    May 2019
    Location
    Hillcrest
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, did you check the box to map fields?

  3. #3
    New Member
    Join Date
    May 2019
    Location
    KZN
    Posts
    8
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi no I unchecked the "Map Fields" box

  4. #4
    New Member
    Join Date
    May 2019
    Location
    KZN
    Posts
    8
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Here is a sample of the file I am trying to import
    Attached Files Attached Files

  5. #5
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Hi Cilly

    Firstly, that is not a .csv file - you have separated your fields with ; instead of , . Issue is probably with your regional settings - go to control panel - region and language - set decimal to . and digit grouping and list separator to , in both the numbers and the currency tabs, so when you save the files as a .csv you field separator is now a ,
    You will need to delete the header row from your file as well
    Also, delete all the ;;;;;;;;;;;;;;;;;;;;;; at the bottom of your document.
    Supplier codes in Pastel Partner can be up to 6 digits long, but may not contain any spaces. Your codes have the ; separator at the end of the 6 digits, but there are spaces in between the end of the code and your field separator , - you will either need to remove the spaces, or pad your supplier codes to the full 6 digits allowed.

  6. #6
    New Member
    Join Date
    Oct 2021
    Location
    Mutare
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Kevin

    I am having a similar issue as above, I have been doing imports for many years and have never experienced this before. I also followed all your instructions above for in case, but to no avail.

    Errors I am getting are below:

    1) Blank Code
    2) Blank Spaces in Code
    3) Blank Description

    The very final Error right at the end is the following:

    4) Undetectable Error (Input past end of file)

    I have tried to attach the file for your perusal, however it exceeds the upload limit - 131kb.

    Thank you in advance.

    I really would appreciate your assistance with this.

  7. #7
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Hi Brendon

    You are welcome to email it to me and I will see if I can detect the issue. I will PM you my email address. Please also let me know what version of Pastel you are trying to import it into.
    Kevin Smith
    Sage Pastel Support Consultant
    KS Consulting
    www.ksconsulting.co.za

Similar Threads

  1. [Question] Pastel 14 Inventory import
    By SHAUN45 in forum Accounting Forum
    Replies: 2
    Last Post: 31-Aug-17, 03:33 PM
  2. Import excel into Pastel
    By nikkidv in forum Accounting Forum
    Replies: 5
    Last Post: 20-Jul-17, 01:34 PM
  3. [Question] Pastel Import
    By StephenJS in forum Accounting Forum
    Replies: 0
    Last Post: 28-Mar-17, 12:18 PM
  4. [Question] Pastel Xpress import templates
    By Lumberjosh in forum Accounting Forum
    Replies: 2
    Last Post: 25-Oct-16, 06:19 PM
  5. [Question] Pastel inventory import
    By Aldren in forum Accounting Forum
    Replies: 0
    Last Post: 28-May-16, 07:44 PM

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
  •