Results 1 to 3 of 3

Thread: Pastel Xpress import templates

  1. #1
    New Member
    Join Date
    Oct 2016
    Location
    Bromhof, Randburg
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Xpress import templates

    Hi everyone,

    Where can one obtain import template files for Pastel Xpress, specifically for customers and suppliers, customer and supplier invoices (no product items) and allocated bank statement transactions.

    Thank you

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,662
    Thanks
    44
    Thanked 440 Times in 386 Posts
    All the import CSV file layouts can be found in the Help documentation in Pastel. Do a search for "Import".
    Neville Bailey - Sage Pastel Accounting Consultant
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    IronTree Online Solutions

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

  3. #3
    New Member
    Join Date
    Oct 2016
    Location
    Bromhof, Randburg
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lightbulb Client import template (open document format)

    Quote Originally Posted by Neville Bailey View Post
    All the import CSV file layouts can be found in the Help documentation in Pastel. Do a search for "Import".
    Thanks, sorry to say that didn't go well at all, so I just bumbled forth, and well, here you go. Paste your data into sheet one, write formulae or whatever to draw it into sheet two (don't change or move the headings and then Pastel should match them up, but this seems to be on a "if Pastel feels like it" basis, so good luck), and then paste sheet 2 as text into sheet 3 (or a new document) and save sheet 3 as CSV.

    Pasting as text might change the dates to nn,nnn format and boolean fields to 0/1 and lop the leading zeroes off Pretoria postal codes and dialling codes ... and probably ID numbers of kids between 6 and 16 ... so check dates and things, and change boolean fields 1 to "TRUE" and 0 to "FALSE" before saving as CSV.



    Hope it helps others.
    Attached Files Attached Files

Similar Threads

  1. Replies: 3
    Last Post: 19-Jul-18, 11:49 AM
  2. [Question] Pastel Xpress V11 CSV file layout to import Invoices
    By Braam in forum Accounting Forum
    Replies: 1
    Last Post: 06-Jun-16, 08:41 AM
  3. [Question] Pastel inventory import
    By Aldren in forum Accounting Forum
    Replies: 0
    Last Post: 28-May-16, 07:44 PM
  4. Import excel into xpress 2009
    By RCerva in forum Accounting Forum
    Replies: 0
    Last Post: 12-Jul-13, 02:27 PM
  5. Pastel Xpress Purchase Order Import
    By GerhardvdHeever in forum Accounting Forum
    Replies: 9
    Last Post: 12-Nov-11, 05:08 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
  •