November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
Export of Swedish catalog gets values in en
Hi,
Not sure which version you are working on - but is Svenska your catalog default language (master language)?
Regards,
/Q
May 30, 2016 8:47
CMS v 9.8.2 Commerce 9.13.
Yes, Svenska is the catalogs default language that's what makes this so strange. I can't find any other setting that would affect this
May 30, 2016 8:55
Hi,
Is there a chance that it was English but then you changed it to Svenska?
/Q
May 30, 2016 8:58
The catalog is generated by InRiver.
From InRiver the catalogspecification looks like this in the Catalog.xml that it generates:
<Catalog name="Web" lastmodified="2016-05-16 09:15:00" startDate="2016-05-30 02:27:16Z" endDate="2116-05-30 02:27:16Z" defaultCurrency="SEK" weightBase="kilogram" defaultLanguage="sv" sortOrder="0" isActive="True" languages="sv,en">
May 30, 2016 9:01
Hi,
What do you have in database if you run this query against Commerce db:
Select * from dbo.CatalogContentProperty where MetaFieldName = ItemMaterial
Where ItemMeterial is the name of your field
Regards,
/Q
May 30, 2016 9:28
Data like this
5448216 22518 0 429 47 ItemMaterial en NULL 69780 NULL NULL NULL NULL NULL NULL NULL NULL
5448217 22518 0 429 47 ItemMaterial sv NULL 69779 NULL NULL NULL NULL NULL NULL NULL NULL
5448218 22520 0 429 47 ItemMaterial en NULL 69782 NULL NULL NULL NULL NULL NULL NULL NULL
5448219 22520 0 429 47 ItemMaterial sv NULL 69781 NULL NULL NULL NULL NULL NULL NULL NULL
May 30, 2016 9:33
Hmm - that's very strange.
I would suggest you to contact our developer support service. We'll need to investigate your database.
Or perhaps you can send me the catalog generated by inRiver so I can see if this is a bug or not. quma [at] episerver.com
Regards,
/Q
May 30, 2016 9:56
It is registered as a support ticket. Unfortunately all exports from InRiver comes in small chunks so I don't have a good export file to send. But if needed I can send the database connetced to the support ticket.
May 30, 2016 10:49
It was created a while back but since InRiver sends all updates in small chunks we have had to implement a removal job that cleans the syncfolder every once and a while to keep it from bloating the folder. So therefor I only have small catalog.xml created for updating specific products and skus and not a complete syncing. But the InRiver sync hasn't been changed in a long time so I can't see that it would generate a different catalog.xml when the catalog was created a couple of weeks ago. We have had the catalog removed and recreated a couple of times before to handle changes in Meta data fields so it's a fairly new catalog that we run now and I'm almost certain that the language setting has been correct all the time.
May 30, 2016 11:09
When we export our catalog which has Svenska as primary language all metadatavalues that are not set as multilanguage is set to language="en".
Is there a way to control this?
Here's a good example of the error from the generated Catalog.xml:
Multilanguage fields are correctly setting the sv values but non multilanguage fields are specified in en. This kind of ruins the whole import/export functionality because an environment setup using the exported data gets completely wrong.