Topic
  • 10 replies
  • Latest Post - ‏2016-02-04T13:24:31Z by paul.brett
lalit@accenture
lalit@accenture
2 Posts

Pinned topic How to read .xls files by input card

‏2009-10-08T13:04:06Z |

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 ?????

Updated on 2016-02-04T13:22:17Z at 2016-02-04T13:22:17Z by paul.brett
  • TarunB
    TarunB
    211 Posts

    Re: How to read .xls files by input card

    ‏2009-10-08T13:31:30Z  
    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.
  • lalit@accenture
    lalit@accenture
    2 Posts

    Re: How to read .xls files by input card

    ‏2009-10-08T15:09:38Z  
    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.
  • raj1
    raj1
    66 Posts

    Re: How to read .xls files by input card

    ‏2009-10-09T08:44:25Z  
    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.
  • TarunB
    TarunB
    211 Posts

    Re: How to read .xls files by input card

    ‏2009-10-09T14:29:02Z  
    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.
    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.
  • SystemAdmin
    SystemAdmin
    6184 Posts

    Re: How to read .xls files by input card

    ‏2009-11-19T09:40:57Z  
    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
  • Krishna Kanth
    Krishna Kanth
    2 Posts

    Re: How to read .xls files by input card

    ‏2009-12-04T11:24:43Z  
    Convert .xls file to CSV file(Comma Seprated ) and take as input
  • SystemAdmin
    SystemAdmin
    6184 Posts

    Re: How to read .xls files by input card

    ‏2009-12-04T18:09:18Z  
    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
    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.
  • Muk1234
    Muk1234
    22 Posts

    Re: How to read .xls files by input card

    ‏2013-04-26T12:36:37Z  

    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

  • Venkateshs17
    Venkateshs17
    1 Post

    Re: How to read .xls files by input card

    ‏2016-02-04T10:17:40Z  
    • Muk1234
    • ‏2013-04-26T12:36:37Z

    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

    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

  • paul.brett
    paul.brett
    761 Posts

    Re: How to read .xls files by input card

    ‏2016-02-04T13:24:31Z  

    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

    Updated on 2016-02-04T13:24:50Z at 2016-02-04T13:24:50Z by paul.brett