Forum Discussion

Mooihoek's avatar
Mooihoek
Icon for Helper II rankHelper II
3 years ago

JSON Folder Import - OLE DB or ODBC error

Using the Desktop Client,  Folder option to import multiple JSON files (Combine & Transform) I get the following error:   Failed to save modifications to the server. Error returned: 'OLE DB or ODBC...
Need Help
Mooihoek's avatar
Mooihoek
Icon for Helper II rankHelper II
3 years ago

Yes the import is ok, but when you do close and apply the error message will be shown

  • Mooihoek's avatar
    Mooihoek
    Icon for Helper II rankHelper II
    3 years ago

    I see some additional steps in Queries in my pbx when I go through the Folder import compared to yours which still gives me the error.  When I update the source in the example you provided none of the data loads from the table

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      maybe something wonky with your JSON files.  Can you post the sample files onto a file share?

      • Mooihoek's avatar
        Mooihoek
        Icon for Helper II rankHelper II
        3 years ago

        You're right looks like the source files have an extra row at the end! This is causing issues