Data Shuttle Error
Hi all,
I've been struggling with a Data Shuttle workflow that is very similar to many others we use that are working well. When I run it, I get this very vague error, which I have never encountered before:
What I am trying to do is take data from one sheet and, with a given trigger, map that data into a new sheet. Specifically, we are scheduling classes in one sheet, and then we they have been approved by a supervisor, they are getting moved to another sheet that queues them for entry into our Learning Management System. Currently, this is set up such that:
- There is WORKING offload workflow from sheet 1 that exports to csv all of the scheduled class information. I have reviewed this sheet and it looks as expected and is offloading data properly. It looks like this:
2. There is an upload workflow that is NOT WORKING. It takes the information from the attachment in the source sheet:
and is set to replace all data in the target sheet (because I do not have unique identifiers in the target sheet at first pass; this is the same reason I cannot do this in DataMesh. There is a third workflow that will update any information that has changed if I can ever get past this step):
There is no filter logic, and all of the columns are mapped:
and then it is set to run on attachment.
As you can see, there are a variety of unmapped columns in both sheets. I made sure all mapped columns in the target sheet are Text/number columns except for the two date columns.
If anyone has any insight into what may be causing this error, I'd really appreciate it. Or any thoughts about a different way to accomplish this. I can't use the automation to move the row to the other sheet because the columns do not exactly match between the two sheets.
Best Answer
-
Figured this one out. It had to do with the date columns in the target sheet being used in the project settings. I had to disable dependencies for this to work.
Answers
-
Figured this one out. It had to do with the date columns in the target sheet being used in the project settings. I had to disable dependencies for this to work.
-
For those who want to keep dependencies enabled, looks like if you put the date into the Start column instead of the Finish column, it works!
