Macro to append data to a CSV file

[agoel20]

Hi All , I have attached a macro which I use to append weekly data to a large csv file, which was working fine till last week, but when I ran it again today, I am getting the below error:

When I open this macro to test run and see if it is working fine, then I cannot find any error, but when I am using it in my workflow I get the above error, can you please help me, as this macro has been very useful for me till now and I want to keep using this in my workflow.

Appreciate your help in advance!

[clmc9601 · Accepted solution]

Hi @agoel20,

It looks like the error is coming from your .bat program. If you can determine what results in an error code of 1 from that file, it might help narrow down the problem.

Here are some of my guesses as to what could cause the error:

- The combination file path you're using is longer than 500 characters, causing syntax in [Call] to get truncated

- The data you're appending is not in csv-friendly format, is null, or some other data formatting problem

- There's a schema mismatch (column names) between the existing file and the newly appended data 

If you haven't already, I'd try using the Debug Workflow mode to recreate the issue. View > Interface Designer > wand button (second from top), configure the settings, then > Open Debug