Originally posted by: lalit@accenture

Hi All,

I am using IBM WTX V8.1. Now i need to read a source file from my input card. The input file is type .xls (MS Excel files).

Any suggesting ?????

#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: TarunB

You need to set up the spreadsheet as a database. Create the data with column headings and select all of the content (including headings) as a range, and name the range.

Next, create an ODBC connection to the spreadsheet range.

Then use the Database Interface Designer (DID) to create a type tree for this table. Also, create a Select * from table (range) query in the DID. Use this in your map as the Database source input card.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: lalit@accenture

hey Tarun thanks a ton for the quick reply. But can we read that file in any other manner without using database functionality as we can read .txt files easily ?

reason is we have so many constraints in creating database tables in client server.

I got to know that we can user COM Adapter/object for this but i am not able to find the way to use it.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: TarunB

Less commonly used are the COM adapter and the DDEQuery command, as I believe both are limited to Windows environments.

If you don't want to set up the Excel spreadsheet as a database then you would need to ask the data provider to send the file in a different format, perhaps csv.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: raj1

I had similar kind of situation in one of my projects and I did exactly what TarunB said here and got the answer.So better follow this method only.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Everything runs smoothly with excel file as my input file in the WTX, but when I build the map to Datapower an error occurred. It says "Cannot change Runtime to Websphere DataPower. One or more Source or Target Adapters specified are incorrect. Please Rectify them before changing the Runtime to Websphere Datapower".
Attached is the screenshot of the error I encountered.

Hope you could help me.
Thanks
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Hi dongsTER,

You have in your maps setup or used adapters other than FILE . Datapower only supports FILE as a adapter.

change the map adpater to file and run you will be able to compile.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: Krishna Kanth

Convert .xls file to CSV file(Comma Seprated ) and take as input
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: Muk1234

Hey guys i m looking exactly wht lalit@accenture wntd to do.  Can't i use .xls file as any other file in the FILE adapter? Lalit if u know a thing or two please help.

 

 

Thanks

Muks

#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: Venkateshs17

Hi All,

 

Is there a way out for WTX to connect to mail server residing in AIX platform and process XLS (excel sheet) attachments. 

 

 

Thanks,

Venkat

#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: paul.brett

As per the answers above, you can access an Excel spreadsheet via ODBC.

From ITX version 9 onward, there is also a new way to access Excel spreadsheets:

https://www.ibm.com/developerworks/community/forums/html/topic?id=1051cfcf-48e9-4a0a-b87e-9d5b04b0785d&ps=25

To retrieve the email with attachments, you would use the email (and perhaps additionally the MIME adapter).  Once saved locally, you could then process them.

Thank-you.

Paul

Follow me on Twitter

#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender