Data Uploader Add Rows

Chris Mondeau

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!

Genevieve P.

Hi @Chris Mondeau

There currently isn't a configuration within Data Uploader to continually add in rows, even if there are duplicates. However I may have an idea of how to always add data:

You could set up an interim sheet to use Data Uploader to continually add/replace all rows with the content from your source document. This will delete out your current rows in the initial Smartsheet sheet and add in entirely new rows each time (eliminating the need for a Unique Value to ID each row). Then set up a Copy Row workflow triggered whenever a new row is added to this sheet via Data Uploader to copy it to your destination sheet, which will house every row.

Would this work for your process?

Cheers!

Genevieve