Data Shuttle Not Updating Cells - Can Any one Assist

I have set up a data shuttle to export a list of e-mail addresses, with one other collum which is an autogenerated number which is the unique ID, this works fine.

When I came to run another data shuttle to import this file into another sheet, I set up the settings, selected the unique ID to the autogenerated number collum on the target sheet and mapped the collum to update the e-mail addresses, when this was run no updates where made as I believe it did not match the ID numbers.

To try and solve the issue I added another collum and manually added the unique ID to the cells (no formula or auto number), adjusted the data shuttle to export this data, and tried the import again and it worked.

Is there an issue with using autogenrated number columns (I also found this with formula columns) as the unique ID, is there any way around this?

Find more posts tagged with

Data Shuttle

Accepted answers

Michelle Choate 2

So yes, when you are importing data it must be to a column that is not locked. How to tell if a column is locked? If when you click on a cell in that column, is it surrounded by grey (meaning data CANNOT be written to that column, or is it blue, meaning it CAN be written to)?

System Columns - such as Created Date, Created By, Modified By, Auto Number, etc. - Are all not able to have information from Data Shuttle write to them. Same thing with Formula columns.

Hope this helps!

All comments

Michelle Choate 2

System Columns - such as Created Date, Created By, Modified By, Auto Number, etc. - Are all not able to have information from Data Shuttle write to them. Same thing with Formula columns.

Hope this helps!

Keith Taylor

Hi Michelle,

Thank you for confirming, I thought that was the case, and I have found a workaround, which means an additional smartsheet that now functions how I need it to.

Keith

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.