Skip to main content
  • EN

I'm completing a government return which will need to be sent daily and they require the file to be named as below:

"

File naming:

CAZ-yyyy-mm-dd-XXXX-#.csv

where:

yyyy-mm-dd represents the date the file was generated

XXXX is the agreed identifier for each Licensing Authority (to be confirmed)

# is the total number of records included in the file.

"

The date is easy enough to solve, but I'm hitting a brick wall trying to insert the feature count into the file path. So far I've got:

CAZ-@DateTimeFormat(@DateTimeNow(),%Y-%m-%d)-XXXX-#

Could anyone help with the #?

You can use a Statistics Calculator to count the number of features - the total will be added to all features coming out the complete port and you can then this as part of your fanout

 

e.g. CAZ-@DateTimeFormat(@DateTimeNow(),%Y-%m-%d)-XXXX-@Value(total_count)

You can use a Statistics Calculator to count the number of features - the total will be added to all features coming out the complete port and you can then this as part of your fanout

 

e.g. CAZ-@DateTimeFormat(@DateTimeNow(),%Y-%m-%d)-XXXX-@Value(total_count)

Thanks but, I don't want the file to fanout, just a single file with the total features in the filename

You can use a Statistics Calculator to count the number of features - the total will be added to all features coming out the complete port and you can then this as part of your fanout

 

e.g. CAZ-@DateTimeFormat(@DateTimeNow(),%Y-%m-%d)-XXXX-@Value(total_count)

It won't actually fanout, because all the features will have the same value

It won't actually fanout, because all the features will have the same value

Ah I see, that worked nicely!

 

Thanks!

Reply


Community Stats

31,821
Posts
120,861
Replies
39,452
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.