Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my solution. Took me a while to figure out I needed to change the output settings in Interface Designer.
Same Workflow and Macro as everyone else seems to have.
Note:
I didn't realise this for a while but in order for the batch macro to run more iterations you need to make sure there is a tool after in it your workflow. This may be common knowledge but it took me a while to work out that this was my problem!
My solution is not really MY solution (gathered from all of your solutions, but I made it work...) A lot of learning points from this one:
- I did not consider the helper files as irrelevant for importing with the macro
- I did not know of updating @FileFormat with a numerical value; is there any documentation on this?
- I did not know about the FileGetExt function, solved it with RegEx at first
Did not use the @FileFormat solution in the end, found the 'Update Input Data Tool' option mentioned by @Garrett more elegant.
Regards,
Arjan Loogman
good challenge!