how can I import an Excel file with ETL?

[DCIM_Support]

I've made a pentaho transformation with Excel file entry which run well execute from spoon application but not from SWO ETL. I've put the Excel file name as a parameter and I've tried to put the Excel file in local computer and upload it to the SWO server but in any case is working.

Best regards,

Enric

(CID:100339746)

[DCIM_Support]

Hi Enric, It is not easy to say what is causing this problem, but if you look at the etl log you might be able to see what is causing the problem. The etl log file can be found in # /opt/jboss-as/server/isxo/log Thanks Jesper

(CID:100339757)

[DCIM_Support]

If the transformation runs from Spoon but not on the DCO server, please double the location of the excel file, and the path you provide when setting up the transformation. Besides from this you should take a look at the log file as Jesper suggests.

(CID:100339779)

[DCIM_Support · Accepted solution]

Thanks to both, Jesper and Niels,

Finally, checking the log I've find the erros. Was a mistake in the path I have put as a parameter.

Now is working well.

(CID:100339782)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.