I am having trouble importing the data source using excel sheet?

[User206787]

Good Morning All,

I am trying to mass import some software assets using data sources and while i set up all the field mapping and try to test it for 4 records, The excel doesn't gets transformed and while i open the ISet and try to reprocess it all   the assets get uploaded and in the right places without any trouble.

Why is it that i have to reprocess it? Please suggest what is it that i am missing?

Thanks,

Praveen

[Pradeep Sharma]

Hi Praveen,

You have to click on Load all records UI action to get data transform.

[Mike McCall]

This blog post goes into some helpful detail: Transforming your data: "Load All Records" vs. "Test Load 20 Records"

[User206787]

Hi Pradeep,

Thanks for your help it works with load all records as you said. Do you know why the Number value is being pulled into service now with a comma? I try to import a PO number say 1230199 but while i import it it converts to 12,30,199. It would be really helpful to know this.

Thanks,

Praveen.

[Mike McCall]

When you first create a new import set table by using either "Test Load 20 Records" or "Load All Records" in a data source, the system will attempt to set your field types based on the data it sees. I've run into a similar issue when I have test data that's only numbers in a field (but that same field later includes letters).

You could avoid this by loading a file with every single type of data the first time, but what's more likely is that you'll have to manually update the field type (especially if your field will only ever contain numbers).

To remove the commas you're seeing, go to your import set table and update the field Type to be "String": Dictionary entry form