Solved

FTP CSV File Reader : need to read current date file

2 months ago
January 29, 2025
4 replies
68 views

+1

nikpatel
Contributor
2 replies

I am new bee and want to generate FME flow which reads every day file from SFTP server and populate the data

the first half of the file is default then their is date concatenation with “MMDDYYYY” format and then suffix with file extension

i use datetimestamper transformer and found the date but when pass that date to FeatureReader in Dataset with “default text”@Value(_Date) , it does not generate the file

Can someone help with if their is any example which can provide me guidance on how to set auto filenames

Best answer by j.botterill

Yes ‘feature types to read’ is likely the filename, I believe. So the trick with workflow transformers like the Feature Reader, is to sample/inspect one of the records, copy the value (the actual value for the field created by the last transformer) into clipboard and present it to the popup.

You may also need to read up about dynamic reading/writing, because the FeatureReader doesn’t alway need a feature type output port. You can direct the features through the Generic port and then attribute expose the schema (attribute by attribute… tip: inspect using the Feature Information for exposed vs unexposed attributes), filter the fme_feature_types (using a TestFilter, AttributeFilter of FeatureTypeFilter).

View original

Did this help you find an answer to your question?

This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

+35

j.botterill
Influencer
241 replies
2 months ago
January 30, 2025

Hi nik, perhaps prior to the FeatureReader use AttibuteManager/AttributeCreator to create a new attribute where you string together the other fields to crate Dataset field that you give to the Feature Reader. Inspect the values are correct prior to them going into the reader

+1

nikpatel
Author
Contributor
2 replies
1 month ago
January 30, 2025

Thanks @j.botterill for your response. the steps help me to set the file path

i can see the file path which i set basically FTP file path. when i set the Dataset variable the values i am getting an error :: Worker 5900 > Failed to obtain any schemas from reader 'CSV2' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

When i set the Dataset the variable value : @Value(FilePath_FileNamewithDate) - i get the above error so i cannot see the CSV output created as what you have in your image - what will be the issue for that

+35

j.botterill
Influencer
241 replies
Best Answer
1 month ago
January 31, 2025

Yes ‘feature types to read’ is likely the filename, I believe. So the trick with workflow transformers like the Feature Reader, is to sample/inspect one of the records, copy the value (the actual value for the field created by the last transformer) into clipboard and present it to the popup.

You may also need to read up about dynamic reading/writing, because the FeatureReader doesn’t alway need a feature type output port. You can direct the features through the Generic port and then attribute expose the schema (attribute by attribute… tip: inspect using the Feature Information for exposed vs unexposed attributes), filter the fme_feature_types (using a TestFilter, AttributeFilter of FeatureTypeFilter).

+1