Results 1 to 9 of 9

Thread: Pastel Cashbook import error Windows 8 / Office 365

  1. #1
    New Member
    Join Date
    Oct 2013
    Location
    South Africa
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Cashbook import error Windows 8 / Office 365

    Hi,
    I am struggling to import cashbook batches into pastel.
    It seems that it is an Office 365 or Windows 8 issue, as once I have opened the batch in excel and do the text to coloms, save it and then try to import I get the following:
    Line 1: Date must be in the format DD/MM/YYYY
    Line 1: Invalid Date
    Line 1: GDC field must be G.......
    Line 1: Contra account must be this cash book.....
    This problem is exactly the same on 2 different machines running Win 8 & Office 365

    I don't have this problem on a Win7 machine running Office 2012.

    Does anyone have the same problem?
    Thanks

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 Posts
    I doubt that it is Windows 8 or Office 365, as I am running both and I don't have issues with importing of batches.

    Could you send me a copy of the CSV file so that I can check it out on my side?
    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)

  3. #3
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,978
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    Quote Originally Posted by arnokoen View Post
    Line 1: Date must be in the format DD/MM/YYYY
    You might want to look at the default short date format settings for Windows - many programs use this setting to format the date field.
    The trouble with opportunity is it normally comes dressed up as work.

  4. #4
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 Posts
    Quote Originally Posted by Dave A View Post
    You might want to look at the default short date format settings for Windows - many programs use this setting to format the date field.
    Good point, Dave.

    In fact, these are the Regional Settings that you need to make in Windows 8:

    Make sure you are set to English (South Africa).

    Under Additional Settings, do the following under both the Number tab and the Currency tab: decimal symbol must be changed from a comma to a fullstop and digit grouping symbol must be changed from a space to a comma.
    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
    Jun 2014
    Location
    South Africa
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Neville Bailey View Post
    Good point, Dave.

    In fact, these are the Regional Settings that you need to make in Windows 8:

    Make sure you are set to English (South Africa).

    Under Additional Settings, do the following under both the Number tab and the Currency tab: decimal symbol must be changed from a comma to a fullstop and digit grouping symbol must be changed from a space to a comma.
    I also have the exact same problem at the moment. I have changed the settings as you described above but Pastel still gives the same error. If you could please help me as soon as possible it would be appreciated.

  6. #6
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,373
    Thanks
    35
    Thanked 392 Times in 339 Posts
    Hi Heinrich,

    Drop me a PM or email with your contact details and I will call you to arrange a TeamViewer session.
    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
    Oct 2013
    Location
    South Africa
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi HeinrichFab.
    I have struggled to get this rightplease see my screenshot attached
    Click image for larger version. 

Name:	Capture.jpg 
Views:	329 
Size:	56.0 KB 
ID:	4753

    Goodluck
    Arno

  8. #8
    New Member
    Join Date
    Mar 2017
    Location
    Cape Town
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Neville Bailey View Post
    Hi Heinrich,

    Drop me a PM or email with your contact details and I will call you to arrange a TeamViewer session.
    Hello!

    I came across all this valuable knowledge whilst searching how to import CSV files into Pastel from Excel. I'm working for a charity that is running Pastel Xpress 11 - old I know - but as stated we are a charity where old software is the norm. I'm struggling with the same issue at the top of this thread with the import date etc - I've changed the settings on Windows 10 as per the feedback here, and hoping that someone can scratch their heads and remember all these years back as to how to get around this.

    Yours in hope
    Lorraine, eMzantsi Carnival.

  9. #9
    New Member
    Join Date
    Oct 2017
    Location
    Western Cape
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am struggling now for a week and have tried everything I think maybe the descriptions are causing all the problems but not sure?

Similar Threads

  1. Replies: 4
    Last Post: 30-Apr-14, 09:10 AM
  2. [Question] Pastel Xpress v12 Cashbook updating error message
    By Kathy1 in forum Accounting Forum
    Replies: 2
    Last Post: 01-Mar-13, 02:09 PM
  3. pastel cashbook
    By tinach in forum Accounting Forum
    Replies: 6
    Last Post: 04-Jul-12, 07:20 AM
  4. Best Windows error ever..
    By SilverNodashi in forum Technology Forum
    Replies: 1
    Last Post: 23-Nov-10, 11:12 AM
  5. Windows Defender Beta error message
    By Dave A in forum Technology Forum
    Replies: 0
    Last Post: 04-Jan-07, 07:57 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
  •