Uploading a CSV to salesforce whenever it's put into a specific folder. Help a rookie

[Anonymous]

Hi everyone,
I'm a totally beginner with ETL, this is my really first day.
I'm trying to build a flow that triggers whenever someone puts a .CSV in a specific folder, and then uploads its records to SalesForce.

Any link/resources will be appreciated.
I hope I was clear enough,
Thank you in advance.
P.S. I gotta use the OpenSource version of Talend. hope it won't be a problem.

[TRF]

As a minimalist flow you may have tFileInputDelimited --> tMap --> tSalesforceOutput, it's enough.

tMap is here just in case fields name from input file are not exactly the as for your Salesforce object (mapping operation).

When this works, have a look at tWaitForFile component.

[TRF]

As a minimalist flow you may have tFileInputDelimited --> tMap --> tSalesforceOutput, it's enough.

tMap is here just in case fields name from input file are not exactly the as for your Salesforce object (mapping operation).

When this works, have a look at tWaitForFile component.

[Anonymous]

Hi,
thanks for the answer,
Ifollowed your advice, the minimal flow works but i'd need to know how to add the tWaitForFile to it.
If you can support me, it'd be great
Thank you again,
ochiatt

[Anonymous]

Hi,
thanks for the answer,
Ifollowed your advice, the minimal flow works but i'd need to know how to add the tWaitForFile to it.
If you can support me, it'd be great
Thank you again,
ochiatt

[TRF · Accepted solution]

You can follow this design:

tWaitForFile should be configured like this:

Every 10 seconds, tFileWaitForFile check for new files in the directory pointed by the context variable "PathWhereFilesAreCreated". When a new file is detected, an iteration starts for this file to read the content and pass it to Salesforce. In tFileInputDelimited, use this expression for "File name":

context.PathWhereFilesAreCreated + ((String)globalMap.get("tWaitForFile_1_FILENAME"))

[TRF]

You can follow this design:

tWaitForFile should be configured like this:

Every 10 seconds, tFileWaitForFile check for new files in the directory pointed by the context variable "PathWhereFilesAreCreated". When a new file is detected, an iteration starts for this file to read the content and pass it to Salesforce. In tFileInputDelimited, use this expression for "File name":

context.PathWhereFilesAreCreated + ((String)globalMap.get("tWaitForFile_1_FILENAME"))

[Anonymous]

Thank you very much, you helped me, it's working fine.

Awesome community, thank you again.

[Anonymous]

Thank you very much, you helped me, it's working fine.

Awesome community, thank you again.

[TRF]

Great!
Thanks to mark your case as solved, kudos also accepted.