Strange data problem with Google Sheets connector
I should stress that I've already submitted a support ticket about this issue, but I'm curious whether any other users have experienced something similar. (So far, support has been unable to replicate it - confusing all around!)
I have a large (~20,000 record) Google Sheets tab containing records of driver data - how many hours each driver works in a given day. There's one unique record for every combination of driver and date.
When we try to import this data into Google Sheets, we run into a bizarre problem where the first column in the spreadsheet (the date column) gets corrupted. Sometimes a date gets repeated twice; sometimes it gets eliminated entirely. Here's a couple screenshots of the first two columns, first in the original, second in the Sisense import showing the problem. *Only* the first column is affected; the other columns contain the exact data we would expect.
Google Sheets:
Sisense after import:
As you can see, 11/4 gets repeated, 11/6 disappears, 11/7 gets repeated, and 11/9 disappears.
These problems are scattered seemingly at random throughout the Sisense import; approximately 1 in 20 records is altered.
Does anyone have a clue as to what might be going on here, or has anyone experienced something in the ballpark of this?
I should also stress that Excel and CSV uploads of the exact same data work perfectly.
-
I believe this has happened to me in the past. Check you language settings on sheets. Also make sure you format the dates correctly or try to format as text. I believe a combination of this will work
0 -
Thanks so much for the suggestion, Scott! I checked the language settings - English as normal - and I'm trying a variety of plain-text dates, variously formatted dates, etc. Nothing doing yet, but we'll see!
0
Please sign in to leave a comment.
Comments
2 comments