Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: importing inventory items into pastel

  1. #1
    New Member
    Join Date
    Sep 2013
    Location
    Pretoria
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    importing inventory items into pastel

    Good day

    I am struggling to import inventory items into pastel.

    One spread sheet will work and the next will give me errors.

    Please I need help - It took me three years to get the Directors to buy Pastel and now that we have it the problems are never ending.

    Regards

    Stenette

  2. #2
    New Member
    Join Date
    Sep 2013
    Location
    Pretoria
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi - Is there no one that can help me with this problem! Please!

  3. #3
    Gold Member
    Join Date
    Mar 2012
    Location
    Vanderbijlpark
    Posts
    886
    Thanks
    83
    Thanked 381 Times in 298 Posts
    Hi Stenette, it will help if you provide the exact nature of the errors.

  4. #4
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Hi Stenette,

    The three columns in the Inventory Masterfile import CSV file, that give the most problems, are the Group column (AB), the Store column (AJ) and the Category column (AK), as these codes all have leading zeroes.

    The very nature of a CSV file is that, when you open it, it drops any leading zeroes in numbers. The way to handle this is to insert a single quotation mark in front of the leading zero, i.e. store code 1 will display as '001. Then save the CSV file, but don't close the file until you have successfully imported the file, otherwise the leading zeroes will drop off again.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  5. #5
    New Member
    Join Date
    Jul 2014
    Location
    Gauteng
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Neville Bailey View Post
    Hi Stenette,

    The three columns in the Inventory Masterfile import CSV file, that give the most problems, are the Group column (AB), the Store column (AJ) and the Category column (AK), as these codes all have leading zeroes.

    The very nature of a CSV file is that, when you open it, it drops any leading zeroes in numbers. The way to handle this is to insert a single quotation mark in front of the leading zero, i.e. store code 1 will display as '001. Then save the CSV file, but don't close the file until you have successfully imported the file, otherwise the leading zeroes will drop off again.
    Hi Neville

    I tried importing a inventory item file based on your suggestion and included the quotation mark in the group field, I also left the file open while importing but I get a run-time error and Pastel closes. Anything else I can try?

  6. #6
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Quote Originally Posted by blueboy View Post
    Hi Neville

    I tried importing a inventory item file based on your suggestion and included the quotation mark in the group field, I also left the file open while importing but I get a run-time error and Pastel closes. Anything else I can try?
    Hi blueboy,

    Can you please send me a copy of your CSV file so that I check where the problem could be?
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  7. #7
    New Member
    Join Date
    Jul 2014
    Location
    Gauteng
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Neville Bailey View Post
    Hi blueboy,

    Can you please send me a copy of your CSV file so that I check where the problem could be?
    Hi Neville

    Thanx for the offer to assist me.

    Attached is the csv file that I tried uploading.Inv_Upload_test.csv

  8. #8
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    There were a number of errors with your CSV file.

    Firstly, you need to delete the heading row.

    You only had three selling price columns, instead of 10. Even though Xpress only provides for 3 price lists (whereas Partner provides for 10), you still need to have all 10 columns in the CSV file.

    You only had one column for the user defined text fields, instead of 3. The same applies to the user defined numeric fields.

    The last four columns were displaced from from the 4th last heading, i.e. Commission Item.

    I have fixed the errors and attached the modified CSV file. I have left the heading row in so that you can see what I have changed, but you must delete that row before you save the file and import it. Also, you will need to reformat the Group, Category and Store data cells.
    Attached Files Attached Files
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  9. #9
    New Member
    Join Date
    Jul 2014
    Location
    Gauteng
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanx Neville!

    I will give it a go.

  10. #10
    New Member
    Join Date
    Nov 2015
    Location
    Durban
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Neville, can you please send me a copy of the import document u edited for blueboy

Page 1 of 2 12 LastLast

Similar Threads

  1. [Question] Importing into Pastel
    By mtpocket in forum Accounting Forum
    Replies: 11
    Last Post: 04-Nov-15, 11:03 AM
  2. [Question] Pastel - Inventory
    By elaine25 in forum Accounting Forum
    Replies: 12
    Last Post: 26-Feb-15, 09:09 PM
  3. [Question] Pastel Evolution inventory costing methods
    By Mynhardt in forum Accounting Forum
    Replies: 3
    Last Post: 29-Jul-13, 07:22 AM
  4. [Question] Inventory journal entry on Pastel
    By Jackievdw in forum Accounting Forum
    Replies: 5
    Last Post: 19-Jul-13, 09:07 AM
  5. [Question] Changing GL Codes for Inventory in Pastel v11
    By steyn.annemarie@gmail.com in forum Accounting Forum
    Replies: 1
    Last Post: 17-Jul-13, 12:55 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
  •