OpenSync

Home Forums OpenSync Set up opensync to a existing sql database with a table prefix specified

This topic contains 9 replies, has 4 voices, and was last updated by  Yudel Rosales 1 month, 1 week ago.

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #12337

    Kris Reddy
    Participant

    Hello,

    We have a web application that uses different MSSQL database for each user. We use open sync to integrate Quickbooks for each user. The way we have it now is we have to create a new quickbooks database for each user.

    Is is possible in open sync to have a table prefix – so that it creates all the tables in user database (this way quickbooks tables are differentiated from other application tables). for example qb_customer, qb_invoice, etc.

    This would simplify a lot .

    Also, the ability to execute a sql script before and after the task runs would be awesome.
    we are having to use use sql server agent to do this using osrun

    Please advise

    Thanks,
    Kris

    #12435

    Kris Reddy
    Participant

    Hello,

    Any answer on this? Any possibility of having this in version 3?

    Thanks,
    Kris

    #12436

    Kris Reddy
    Participant

    Hello,

    Any answer on this? Any possibility of having this in version 3?

    Thanks,
    Kris

    #12446

    Tom Crawford
    Keymaster

    We will add thins functionality in version 3 which will be available this fall.

    #12861

    Kris Reddy
    Participant

    Any news on the new version?

    #12893

    Kris Reddy
    Participant

    Any update on when the new version will be released? Anybody?

    #12895

    Tom Crawford
    Keymaster

    Unfortunately, bugs in the QB 2016 API have set us back. Our new target is the end of this year.

    #13261

    Kris Reddy
    Participant

    Hello Tom,

    Any news on the new version, we have waiting for a long time.

    Thanks,
    Kris

    #66623

    Davy
    Participant

    Any updates on this?

    #66651

    Yudel Rosales
    Keymaster

    OpenSync doesn’t support and it won’t support changing the prefix on the databases. Sorry for the inconvenience.

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic.