Skip to main content
Question

how to upload new csv file to database via fme


sunita22
Contributor
Forum|alt.badge.img+2

I need to upload new csv file each day with there is date on file each day

9 replies

redgeographics
Celebrity
Forum|alt.badge.img+49

If you have the workspace that does the translation you can use that in an Automation: start with a FME Form Schedule trigger and then add a Run Workspace action


sunita22
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • March 13, 2024

If I want to add translation which one need to use?


redgeographics
Celebrity
Forum|alt.badge.img+49

Can you explain what you are trying to do?


sunita22
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • March 13, 2024

I have each day with date stamp CSV file data, I need to upload SQL Server via FME, what transformer I need to use in order to pick up new CSV file data automatically from  folder and load to SQL server via FME.

 


redgeographics
Celebrity
Forum|alt.badge.img+49

Does the CSV filename contain the date or is it always the same filename?


sunita22
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • March 13, 2024

CSV filename contain the date of each day 

and each day their is new file with each day date.


redgeographics
Celebrity
Forum|alt.badge.img+49

Right, so use a Creator and a DateTimeStamper to get the current date (DateTimeConverter if you need to format it in a specific way), then FeatureReader to read csv and construct the filename with that timestamp.


sunita22
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • March 13, 2024

same file name with everyday data stamp

 


redgeographics
Celebrity
Forum|alt.badge.img+49

Yes, so you need to construct the final filename in the text editor of the FeatureReader. E.g. filename_@Value(date).csv where date is your date attribute.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings