(Talend -> Salesforce) Help on uploading data from multiple sources

[Anonymous]

Hi all,

I have an almost finished build as shown below:

my next issue to tackle is that the tFileInputExcel is mapped to a specific Excel file that I created and emailed to that account specifically for testing. In production, multiple excel files (filled out with the same column titles) will be emailed to this address, and automatically saved into the folder on my computer (via subjob 1), which we'll call "Folder 1". I need to have the information from each excel file uploaded into the salesforce environment through this process. Would it be more plausible to have the first half of subjob 1 occur, then have a subjob that will combine all excel files in "Folder 1" into one master file, then have that file be the specified file name in the tFileInputExcel, or is there a way to have it point to a directory instead of a specific file, where it would grab all excel files from "Folder 1" and upload them? I will have this job run once a day as to upload any new data that comes in.

[Anonymous]

Progress was made, I have got it to attempt to run, but am getting the following error message:

[cterenzi]

Ensure that you don't have context.fileName wrapped in quotes in your tFileInputExcel component. It's a variable, not a string literal.

[Anonymous · Accepted solution]

That worked, now I just have to figure out a flow on Salesforce (having issues with creating duplicate accounts without related contacts, need to create a flow to delete accounts that do not have associated contacts in the related lists) and this project is done. I can very well take this issue to salesforce community and mark your answer as the fix, I appreciate everything you have done. Are you familiar at all with Salesforce and would potentially be able to assist me with this issue, or should I just go there?

[cterenzi]

I am not, but others here might be. I would recommend opening a new topic specific to your SF questions.