Data Shuttle Reorganization

Hi there,

We have +400 data shuttles currently. 3 per project and 100s of projects.

Is there a way to organize these.

I was thinking of restructuring our way to shuttle data in for these sheets.

Would it be possible to data shuttle into a template (parent project sheet) and redistribute somehow to to the child sheet. There would be +300 sheets for this one data shuttle. . (Not sure how or what the best way this would be or if its even possible.)

Would there be an issue with the large amount of data set. Can we somehow utilize data table to accomplish/manage this data.

Any ideas are welcome. I am trying to brainstorm a more efficient way to accomplish this.

Can someone confirm there is no limit to the number of data shuttles per account.

Find more posts tagged with

DataTable

Data Shuttle

Accepted answers

All comments

Cassie L

Hey there -

For the organization piece, there is no option to filter unless it is by "My Workflows", "Upload Workflows" vs "Offload Workflows". However, you can Search by Workflow name so if you have a naming convention on your flows, this could help. (You can rename DataShuttle Workflows by editing the DataShuttle workflow but this is admittedly not an ideal exercise for 400 separate workflows).

2. Brainstorm Suggestion — I have experienced issues and long waits myself when working with large datasets in DataShuttle. Have you considered looking into API? Here is a really good presentation on API from ENGAGE last year and why it is sometimes preferrable over other options like Global Updates in Control Center or how it could potentially be combined with DataShuttle.

https://youtu.be/HNqKNozuawU?si=_zzCZ3oV11LY1Saj&t=3206

3. It looks like the number of Workflows is limited based on your plan type — here is a link with some more information.

https://community.smartsheet.com/discussion/89986/data-shuttle-is-there-a-limit-to-amount-of-workflows-you-can-create

Good luck!

Best,

Cassie

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, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.