Data Shuttle Issues

I am using Data Shuttle to export certain rows that meet certain criteria from a sheet. The goal is to have this run during a certain window of time, check where the criteria are met, put the rows into a csv file, and attach it to the same sheet as the source, replacing the old with an updated one every 15 minutes. The criteria are that a checkbox is unchecked in 2 specified columns. It worked briefly when I first created it, but after I tweaked a few things, now I'm having some issues. One is that it's not running on time. When I check the Data Shuttle, it's not running every 15 minutes. It usually runs once in the morning and that's it. The attachment is also just not appearing in the sheet anymore. I did manually delete the attachment csv at one point assuming a new one would appear when I ran the Data Shuttle again but it didn't. Now even when I run it manually, there's no attachment. Here's the breakdown:

Above I have my target file "OXO NY Visitors" which is the same sheet where the data will be pulled from. The goal is to have it go in as a sheet attachment.

Here are my criteria. I need all the rows in which the "Registered" and "Gone" checkbox columns are not checked to be the ones to go to the csv. I currently have a test row in where neither is checked and no attachment is appearing. I also tried referring to an unchecked box as 0 as opposed to false and had the same issue.

These are my columns that I need to include. The names are all long because they have to match the csv template. I haven't changed them and I don't think that's affecting anything.

Here are my run options. I'm in Eastern US Time zone so this is supposed to be 6am-11pm Eastern.

I just ran it manually as I was typing this is and here is the result. The sheet still has no attachment.

Is anyone noticing any flags in my process here? Something I'm missing or doing wrong? Thanks in advance for any help.

Find more posts tagged with

Data Shuttle

Accepted answers

jmyzk_cloudsmart_jp

As my UTC setting was wrong, I updated it, and here is the result.

JPS (Tokyo) is 9 hours ahead of UTC or GMT. So, to run from 12 PM( noon) in JST, I updated the Start time(UTC) to 3:00 AM UTC.

The workflow runs every 15 minutes.

All comments

jmyzk_cloudsmart_jp

Hi @Shane Brown

The first issue is the filter.

I tested various combinations of the checkbox filters and found that they work.

not equal to 1: Not work
equal to 0: Not work
equal to false: Not work correctly
not equal to true: Work

The issue with using "false" is that, as shown in the second image below, though the filter should have returned two rows, it returned only one row.

https://app.smartsheet.com/b/publish?EQBCT=56e08e8a96824cdaa45a068ba9b84b45

Result of [equal to false AND equal to false] run

Filter that worked

When I ran the "not equal to true" workflow, as shown in the above image, it returned two rows, as expected. However, the CSV file shows some unchecked boxes with "FALSE" and others that are blank. This discrepancy may explain why false does not work correctly.

Result of [not equal to true AND not equal to true] run

As for the second 15-minute interval issue, I will return to see if I have the same problem. (11:26 JST. I Expect the next run at 11:30)

jmyzk_cloudsmart_jp

As my UTC setting was wrong, I updated it, and here is the result.

JPS (Tokyo) is 9 hours ahead of UTC or GMT. So, to run from 12 PM( noon) in JST, I updated the Start time(UTC) to 3:00 AM UTC.

The workflow runs every 15 minutes.

Shane Brown

It appears to be working now. Thank you so much for working through the weekend to help me! I appreciate it.

jmyzk_cloudsmart_jp

Happy to help!😁

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.