MorganDrew
7 years agoQrew Trainee
Connected Table refresh errors
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
- 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