0
 Followers
2
 Likes

Specify Excel Sheet on Bootstrap

Integration
New

Hi team

I'd like to be able to specify which sheet is the one being used when I bootstrap data from an excel file to an entity. As of now apparently Service Studio searches the sheets and tries to match the column names and tells you what sheet is going to be used. That does not work however, if there are several sheets with the column names.


Thanks!


CLSJ

Created on 27 Aug 2018
Comments (5)

Hi Carlos,

I think you can already achieve that. The "Excel To Record List" tool has an input parameter called "Sheet Name" where you can specify which of your file's sheet is going to be bootstrapped.

Please let me know if you had something else in mind.


Cheers!

He probably refers to mapping before bootstrap logic


That's a good idea. Today the mapping is done only on the first sheet.

Hi Ricardo


Yes you can go into the bootstrap server action created and adjust there, though it would be nice to have it from the get go, as Huarlem illustrated so as not to have to. Just an idea, getting it out there.


Cheers!

  CLSJ

Ok, Carlos, I understand your point. That would be a nice accelerator.


Cheers!

Changed the category to Integration


views
207
Followers
0