Originally posted by: DianeC

I can't seem to find an example or explanation of how to use an Excel adapter for the input card of a map in the IFD for the launcher.  

When I add the map to the IFD I don't get the Source Event option for the Excel so I can't 'turn it on' for the spreadsheet.  Is that normal?

We will be receiving new spreadsheets weekly & want the map to run when it detects a new spreadsheet. 

Also - the "On Success" option only shows "Keep", there's no option to delete when the map is done.

Is there documentation on this that I am missing?

Originally posted by: PaulBrett

Use the FILE adapter to trigger from.  Grab a copy of the name of the spreadsheet with =GETRESOURCENAME(In1) then run the 'real' mapping with an Excel adapter override (-IAEXCEL1 ...) to re-read the data, this time with the Excel adapter.

If that RUN() maps is success, the top level map will be successful, then you can use the delete on success option for the FILE adapter.

Thank you.

Paul

Follow me on Twitter