Skip to Content
avatar image
Former Member

How to use a excel file to create a service component?

Dear all,

I want to use a excel file to create a service to be my data source. I used the wizard to do that but i always got a message. "The data format is not valid, fields in each record must be delimited by tab charactors, and each record seperated by new line charactors". How should I reformat my excel file to fit the requirements? I have already chang the field`s format into 'text' type. Thx ^^

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 11, 2008 at 08:22 AM

    Hi Louis,

    Can you please upload your excel file (or a look alike sample) ?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Louis,

      [Here|http://img125.imageshack.us/my.php?image=exceltestlo7.jpg] is the result of your data. I downloaded your excel sheet and created a simulated service in 7.1.1 and it works fine.

      Below are the steps:

      1. Go to Tools -> service component wizard

      2. The popup opens : Step1 : Enter the name of your service component

      3. Go to Excel spreadsheet Copy the data for which the service needs to be created.

      4. Step 2 : Paste the copied Excel data in the popup

      5. Step 3 : Define Input -> just click next

      6. Step 4: Define Conditions -> just click finish.

      Let me know if it helps.

      Good Luck,

      Dharmi