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

[Former Member]

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

[Former Member · Accepted solution]

Hi Louis,

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

[Former Member · Accepted solution]

Hi, Yogev. Thanks for your help. I have no idea how to upload the file here.

It`s just a very simple excel file. I just chaged all fields` format into " test" type.

That`s all. Nothing special with my sample file.

[Former Member · Accepted solution]

Hi Louis,

You said that fields in each record must be delimited by tab charactors, and each record seperated by new line charactors,

I'm not sure I'm getting you.

Can you clarify, or even write a sample dummy data that illustrates the output you desire ?

For example: http://www.box.net/shared/51rj7k8nm3

[Former Member · Accepted solution]

Hi Logev,

Here is my example.

http://www.box.net/shared/c80ofco7qb

[Former Member · Accepted solution]

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