Data Shuttle Error

Leah Rankin

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:

1. 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.

Leah Rankin

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.

Leah Rankin

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.

Jon A

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!