Results 1 to 5 of 5

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
    209
    Thanks
    0
    Thanked 33 Times in 29 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.

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
  •