Skip to main content
Question

Connected Table refresh errors

  • October 24, 2018
  • 0 replies
  • 97 views
I am not able to get quickbase to successfully fully sync with connected tables. The source csv files are UTF-8 and stored in a google drive. I have also tried dropbox and get the same errors with different csv's and different data

- It only imports many less rows than are in the CSV file for example 1,000 rows (exactly) of 16,560 rows
- another table imported only 15,000 of 185,000 rows

The typical error on all these tables looks like this: "There was a problem refreshing the table.
Elapsed time was 2 minutes. The file was CRM0003.csv. The error was: Could not parse XML input - XML Parsing Error. reference to invalid character number at line 90 column 3 (which is byte 18351)"

but although I get this type of error on all tables it does not at all correspond to the number of rows imported.

If anyone has experienced similar issues and overcome it I would be very interested to hear from them.

Kind regards

Morgan
    This topic has been closed for replies.

    • anomDiebolt
    • Quickbase Alumni
    • October 24, 2018
    More than likely you have one of these five characters:

    & < > " '

    in your CSV that are not being substituted with character entities.

    I think this occurs because QuickBase is using API_ImportFromCSV with an XML payload.
    • MorganDrew
    • Author
    • Quickbase Alumni
    • October 24, 2018
    Hi Dan, thanks for your quick response. I do have some of those but it doesn't seem to correspond with the error. Will do a search and replace for each and see if I still get it.
    • MorganDrew
    • Author
    • Quickbase Alumni
    • October 26, 2018
    After I removed all of the offending characters I still get the issue. Any other ideas?
    Did you say it should be encoded as a non UTF-8 file (windows or MS DOS)?
    Terms & ConditionsAccessibility statement