OpenSync

Home Forums OpenSync Vendor.name truncated to 11 characters on populate

This topic contains 6 replies, has 5 voices, and was last updated by  Yudel Rosales 1 year, 1 month ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #63254

    afarabee
    Participant

    OpenSync v3.0.18
    Quickbooks 2018 Enterprise
    Windows 10

    Populating database from company file truncates around 300 of our 2100 vendors’ names to 11 characters.
    Refreshing changes to vendor updates individual vendor names, but they still are missing 1 character at the end. The correct vendor name is in the XML log.

    #63269

    Yudel Rosales
    Keymaster

    That shouldn’t happen. It has enough character assigned. Can you send me the log files please? To do so on the main windows click on Help->Send Diagnostics.
    Best Regards,

    #63274

    Andrew
    Participant

    I figured it out, OpenSync 3.0.18 creates a default SQL database with vendor.name as varchar(31), but quickbooks allows for vendor names longer than 31 characters. Changing the datatype of that column and repopulating the vendor table corrects all the names.

    #63821

    Patricia
    Participant

    Andrew – is it the datatype of the the vendor name that you changed or the size of the field?

    #63833

    Yudel Rosales
    Keymaster

    Hello Patricia

    If you are having the same problem, you can change manually. This issue will be fixed on the next update, but it will only apply for new database. Current databases will have to be fixed manually.

    Sorry for the inconveniences.

    Best Regards,

    #66679

    wesrick
    Premium Member

    I just ran into this problem. We use the ‘alt phone’ field for email addresses’. This field is limited to 21 chars (I think) in our Access DB. I’ve changed it to 100, but it still truncates the information. Do I need to make a new DB, or just re-populate the current DB?

    Also, I have 2 tables that I sync, customers and invoices. If I deselect invoices, will it only re-populate customers, and leave the invoice table in-tact? My goal is to rectify the problem without having to wait for 3 or 4 hours for a re-population of the invoice table.

    #66683

    Yudel Rosales
    Keymaster

    You can change the length of the field in your database then run a full popular for that table. Or create a new and populate it, but this process will be longer. Up to you.

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

You must be logged in to reply to this topic.