Topic
8 replies Latest Post - ‏2013-04-26T12:36:37Z by Muk1234
lalit@accenture
lalit@accenture
2 Posts
ACCEPTED ANSWER

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 2009-12-04T18:09:18Z at 2009-12-04T18:09:18Z by SystemAdmin
  • TarunB
    TarunB
    211 Posts
    ACCEPTED ANSWER

    Re: How to read .xls files by input card

    ‏2009-10-08T13:31:30Z  in response to lalit@accenture
    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
    ACCEPTED ANSWER

    Re: How to read .xls files by input card

    ‏2009-10-08T15:09:38Z  in response to 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.
    • TarunB
      TarunB
      211 Posts
      ACCEPTED ANSWER

      Re: How to read .xls files by input card

      ‏2009-10-09T14:29:02Z  in response to lalit@accenture
      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.
  • raj1
    raj1
    66 Posts
    ACCEPTED ANSWER

    Re: How to read .xls files by input card

    ‏2009-10-09T08:44:25Z  in response to lalit@accenture
    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.
  • SystemAdmin
    SystemAdmin
    6184 Posts
    ACCEPTED ANSWER

    Re: How to read .xls files by input card

    ‏2009-11-19T09:40:57Z  in response to lalit@accenture
    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
    • SystemAdmin
      SystemAdmin
      6184 Posts
      ACCEPTED ANSWER

      Re: How to read .xls files by input card

      ‏2009-12-04T18:09:18Z  in response to 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.
  • Krishna Kanth
    Krishna Kanth
    2 Posts
    ACCEPTED ANSWER

    Re: How to read .xls files by input card

    ‏2009-12-04T11:24:43Z  in response to lalit@accenture
    Convert .xls file to CSV file(Comma Seprated ) and take as input
  • Muk1234
    Muk1234
    22 Posts
    ACCEPTED ANSWER

    Re: How to read .xls files by input card

    ‏2013-04-26T12:36:37Z  in response to lalit@accenture

    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