Custom fields in product import

E-mail notifications

Aki Ruuskanen

Posted on 25/11/2015 11:23:42

We have a product import set up in Data Integration.

The fields are set to map automatically.

It has worked as expected.

I have now added a new custom field to the products table.

The field is also present in the xml that is imported.

Example:

But when I now run the import I get the following error message in the import log.

"Import job failed: The source reader for the table: [EcomProducts] can not get a value for the column: [ProduktGruppsKod]"

Any ideas?

Regards / Aki

Replies

António Ramos

Posted on 25/11/2015 11:35:41

Hi Aki,

I encountered with a similar error in the other day. Because I'm manually reference the columns with the xml fields, every new field I need to manually reference in the data integration task.

BR,
António Ramos

Aki Ruuskanen

Posted on 25/11/2015 12:52:42

Thanks for the input António.

We have had field references in the XML for a long time with automatic column mapping. And the all other custom fields work fine. Seems strange that we would need to start doing that.

/Aki

Aki Ruuskanen

Posted on 25/11/2015 13:05:48

Also, if I look at the XML defining the Data Integration job I can see that the field is there.

   <column type="Dynamicweb.Data.Providers.SqlColumn" columnType="Dynamicweb.Data.Providers.SqlColumn">
       <name>ProduktGruppsKod</name>
       <type>System.String</type
           <isNew>False</isNew>
           <limit>50</limit>
           <isIdentity>False</isIdentity>
           <sqlDbType>NVarChar</sqlDbType><isPrimaryKey>False</isPrimaryKey></column>

<column type="Dynamicweb.Data.Integration.Column"><name>ProduktGruppsKod</name><type>System.String</type><isNew>False</isNew><isPrimaryKey>False</isPrimaryKey></column>

Aki Ruuskanen

Posted on 25/11/2015 14:12:14

This post has been marked as an answer

Never mind. False alarm

There were items in the source xml that did not have the columns.

/Aki

Votes for this answer: 1

René Poulsen

Posted on 07/03/2016 10:52:32

Hi Aki,

What was the error in this scenario? I'm getting the same error with NAV integration. I'm just using the setup as it is by default.

At first I only created one field with the same systemname in DW as in NAV - it was perfectly mapped and the data was imported like it was supposed to.

Now, I've created a lot of other fields (also with the same systemname in DW as in NAV) and now I get the same error as you did. Some of the fields only exists on some products.

Aki Ruuskanen

Posted on 07/03/2016 12:42:00

Hi,

As I recall it I had products in the source XML from NAV that did not have all columns. So if a column that is mapped is missing in the source the job fails.

/Aki

René Poulsen

Posted on 07/03/2016 12:43:35

Okay. Jonas just told me the same in another thread here: http://developer.dynamicweb.com/forum/integration.aspx?ThreadID=45666

Thank you for helping :-)

You must be logged in to post in the forum

Developer forum

Custom fields in product import

Replies