how to change field size on multiple CSV Inputs from zip files

Hello

I have multiple ZIPs in a folder that I'm trying to open.

I have used a workflow from the community, (sorry I can't find the original post again) using ZIP metadata Macro and Multiple Zips extract Macro. That appears to work perfectly except the CSV files I'm trying to extract have more than the 254 fields Limit that is applied and I get "Too many fields ERRORs" for all files. I can change the limit when importing a CSV file on its own but cant when importing multiple as part of a Macro workflow extracting the CSV files from Zips.

Any help will be greatly received. Workflow below.

JKFoil

Accepted answers

danilang

Hi @JKFoil

In the MulitpleZips macro, just change the Field Length option of the Input tool to be a larger value

Original post

Dan

All comments

ENix

Can you upload the workflow including the macro you are having an issue with?

apathetichell

If you bundle the .csv call in a macro you can edit the field-len with an interface/action. I can't give you specifics without seeing how your specific workflow is laid out but I can tell you that FieldLen-value is the part of the input data tool you will want to highlight in your action tool. I might use a batch macro with a directory tool and a separate column for what I want fieldlen to be set at. Or you can have a numeric dropdown set field-len.

apathetichell

This is the base strategy - it's going to take some work to adjust for your specific macros and if the .csv have differing formats output can be a mess. but the core strategy works. fieldlen is set for 1000... You can just adjust that to a smaller value or larger value in the action tool in the macro.

workflow test for csv.yxzp

JKFoil

Thank you to both of you that replied.

The Macro was kindly donated by a member of the community and I cant find the original post sadly.

Can I amend the code? I could just overwrite the 254 with 1000 but I don't seem to have the option.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703