Results 1 to 5 of 5

Thread: Data Integrity Pastel Partner 11

  1. #1
    New Member
    Join Date
    Aug 2012
    Location
    Edenvale
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Integrity Pastel Partner 11

    Hi There

    I have a customer that does data integrity every morning before they start work and I was wondering if there was a way of automating the data integrity
    so it happens during the middle of the night and not waste 20-45 Minutes of a staff members time every morning.

    Their setup is as follows:

    Pastel Partner 11 Sitting on Server 2008 R1 (x64) - 10 Workstations 7 x XP Pro and 3 x Win 7 x64. Pervasive version 10 Client / Server. Partner Ver 10.023

    I was hoping there was a command line option or Pervasive utility one could run to do a data integrity and send .txt report to a file. I know this can be done
    on evolution (Because it's SQL based?) as one of my other customers runs Evolution and I use a command line backup utlity during the night. I could set up a
    macro recorder on the server for Partner but it's not an elegant way to do it and a bit risky.

    Does anyone know what database format Pastel partner data is in and if there are any utilities available like this? Any suggestions wlecome

    Thanks in anticipation
    Mtech

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

    I don't know of any way that one can write a script to automate the running of the Data Integrity report in Pastel Partner. I am not saying that it can't be done, however.

    Partner runs on the Pervasive SQL database platform (essentially a modern version of Btrieve).

    If you find out if there is a way of doing this, I would be very keen to know about it!
    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
    Email problem
    Join Date
    Sep 2012
    Location
    England, Manchester
    Posts
    15
    Thanks
    0
    Thanked 1 Time in 1 Post
    Correct me If i am wrong but the data integrity is a stored procedure, basically what it does is make sure everything balances with debits and credits etc, so I suppose if you had a developer you could create a small app with an ODBC link in to your data to do this.

  4. #4
    New Member
    Join Date
    Aug 2012
    Location
    Edenvale
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would have to find someone with the neccesary skill sets. I was hoping one could just run a command line option like C:\Pastel11\DataIntegrityV11.exe /BR2013 /PW:23456789 passing the set of accounts BR2013 and using the password 23456789 to the exe via a commandline.

    There is an .exe called DataIntegrityV11.exe but it doesn't accept any command line options which is a pity.

    I personally think they should be running Pastel Evolution myself which seems far more efficient than Partner but they are comfortable with Partner and don't want the added expense of Evolution.

    I now just run the data integrity for them every night via Remote desktop but if there is someone out there that is capable of doing this and wants to earn a few $, let's discuss it.

  5. #5
    Email problem
    Join Date
    Sep 2012
    Location
    England, Manchester
    Posts
    15
    Thanks
    0
    Thanked 1 Time in 1 Post
    Unfortunately i don't think that's possible as you need to open the program itself and then choose your data location to connect to.

    Personally evolution is the better option, bigger, more robust, more flexible pretty much every concept of partner is used in evolution + more, if you know how to use partner you can use evolution and visa verse just takes a little patience.

    Regarding the data integrity I'll have a look to see if anything can be done or created for this.

    Regards

    Aaron Atkinson.

Similar Threads

  1. [Question] Data integrity problem
    By Suziem in forum Accounting Forum
    Replies: 3
    Last Post: 25-Jul-14, 09:17 AM
  2. How to recover SQL pastel evolution data from flash drive
    By SSS100 in forum Accounting Forum
    Replies: 2
    Last Post: 29-Jun-12, 10:10 AM
  3. Replies: 1
    Last Post: 22-Jun-12, 07:30 PM
  4. Replies: 2
    Last Post: 14-Apr-11, 11:22 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
  •