Developer forum

Forum » PIM » Validate list options on import form excel

Validate list options on import form excel

E-mail notifications
Helene Kjærbøl
Reply
Posted on 02/12/2022 13:16:51

Our customer is asking for some kind of validation possibility on import from excel to PIM.

As it is now the import - even if you use the template from an export from PIM - DW gives no warning or options if you try to import values to a list, when the values doesnt exist in PIM. This could be a new color og a misspelling on a existing color (yes this is possible also in the DW excel template with the drop down as the drop down isn't locked). For now nothing is imported from excel to this field, when there is no match in the PIM list PIM.

It would be nice to have at least some kind of warning - or even better the option to choose wether or not new values should be created in the list in PIM.

BR Helene


Replies

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Posted on 21/12/2022 10:14:51
Reply
This post has been marked as an answer

Hi Helene,

Sorry for the late answering ..

At the moment, there are no validation on that kind of information on Import.

But the value, you mention in above description, will be imported and stored on Product in database. But you can't see it, before the "key" are created on the Listbox-field.

You can construct a Query, to show Products there have "Illigal keys" on a specific fields, so validation can be done that way

/Søren

Votes for this answer: 1
 
Helene Kjærbøl
Posted on 20/01/2023 09:37:44
Reply

Hi Søren,

How do you construct the query to show products with "illegal keys"?

BR Helene

 
Helene Kjærbøl
Posted on 03/02/2023 08:50:30
Reply

Hi Søren,

Any news on this one?

/Helene

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Posted on 10/02/2023 14:02:01
Reply

Hi Helene,

This query has to be done directly in the database with SQL ..

You could make the SQL within a "SQL Widget", so the widget could show these Products, there have the "illegal values"

Be aware .. depending on how this SQL are made, it can be a heavy load on the database ..

/Søren

 
Helene Kjærbøl
Posted on 13/02/2023 08:06:02
Reply

Hi Søren,

Ok, thank you - what table/tables should I query?

BR Helene

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Posted on 13/02/2023 09:12:17
Reply
This post has been marked as an answer

Hi Helene,

Depending on what fieldtype you are using, the OptionId are stored in one of following tabel ..

  • EcomProducts
  • EcomProductCategoryFieldValue

I hope that helps you

/Søren

Votes for this answer: 1
 
Helene Kjærbøl
Posted on 13/02/2023 13:20:21
Reply

Perfect, thanks Søren.

/Helene

 

You must be logged in to post in the forum