Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 7.x > Portal Engine > Regarding Import Utility

View modes:

Certified Developer 12

chetan2309-gmail - 12/19/2013 10:24:00 PM

Regarding Import Utility

Hi All,

I have used in the past Data import utility to create documents from excel sheets. it worked like a charm. Now I have a little complex requirement which is as follows.

I have list of products which can belong to more than 1 state in U.S. Some products can belong to as much as 40 states or ma y be all. Is there any way I can automate document creation for multi-select fields? I have tried few ways but none of them were success.

Are there any better approaches to what I wish to accomplish?

Any pointers on this?

Regards,
Chetan


Kentico Legend	Brenden Kehren - 12/20/2013 9:28:10 AM RE:Regarding Import Utility if I remember right a multi-select in Kentico is a semi-colon delimited string. So couldn't you run a query to take those records and put them into a concatenated string then do the import?


Certified Developer 12	chetan2309-gmail - 12/20/2013 10:57:47 AM RE:Regarding Import Utility Thanks FroggEye, I will try this approach with small chunk of data and will get back!!


Certified Developer 12	chetan2309-gmail - 12/20/2013 7:15:58 PM RE:Regarding Import Utility Forming data was a problem, however kentico import worked like a charm. P.S - I have used "\|" as delimiter since I saw them in SQL. Thanks for you help!!

Top