Data Uploader Add Rows
Hi All, I'm trying to figure out why I keep getting skips on my import.
Here's my import data:
And existing data in Smartsheet:
I'm expecting datauploader to append my excel fil to create something like this, where blue is the newly uploaded rows from excel
Here's my uploader config (thinking I can just use add new rows to always append, even if values already exist):
And the mapping (I'm using the ID column [auto-number from smartsheet system column] as my unique field, and not mapping it since my import data doesn't have any values):
I'm getting successful runs, but it always says that the rows are being skipped. Am I missing something or just being daft 🙃? Any feedback is appreciated, thanks all!