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.
Best Answer
-
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.
Answers
-
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.
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)
-
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.
-
It appears to be working now. Thank you so much for working through the weekend to help me! I appreciate it.
-
Happy to help!😁
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives