FTP CSV File Reader : need to read current date file
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
Page 1 / 1
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
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
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).
