Not sure about the Python, but I would use the TimeStamper to find the current date/time, generate the output file name with the AttributeCreator, then use a fanout on that name to create the output.
For a non-Python use, I think that would be easier.
Regards
Mark
Mark Ireland | Product Evangelist
Safe Software Inc.
Suite 2017, 7445-132nd Street, Surrey, BC, CANADA
T 604.501.9985 | F 604.501.9965
| Twitter @FMEEvangelist |
http://www.FMEevangelist.com
Hi Mark
Thanks for your reply. I am not sure how to implement it though. I am reading the attributes of a single shapefile then applying an attribute filter to filter the data into 3 categories. Each of those are then written to a seperate excel file. Its the name of the excel files I want to change to allow the process to be run multiple times and preserve the output each time.
I have tried adding a timestamper and attributecreator (to create a filename based on a concatenation of constant value and the timestamp) after the attributefilter but before the XLS_ADO file writer. It adds that value (the created filename) to every row of the output. I am not sure this is right and don't know how use that for the .xls file name?
Regards
Following on from Mark's answer, and explaining how you rename each XLS file with the attribute you have created. You need to use the "Fanout Dataset" (search for this in help) which is an advanced parameter. Set the fanout directory to where you want the data to go and use the attribute you created as the "Attribute to Fanout on" (Just make sure to the attribute would be valid as a filename i.e. no illegal characters).
Good luck
Todd