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?
Best Answer
-
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!
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
Answers
-
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!
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives