Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

Export of Swedish catalog gets values in en

Vote:
 

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:


ItemMaterial
EnumMultiValue





ItemName
LongString


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.

#149308
May 29, 2016 20:00
Vote:
 

Hi,

Not sure which version you are working on - but is Svenska your catalog default language (master language)?

Regards,

/Q

#149325
May 30, 2016 8:47
Vote:
 

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

#149326
May 30, 2016 8:55
Vote:
 

Hi,

Is there a chance that it was English but then you changed it to Svenska?

/Q

#149328
May 30, 2016 8:58
Vote:
 

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">

#149329
May 30, 2016 9:01
Vote:
 

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

#149331
May 30, 2016 9:28
Vote:
 

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

#149332
May 30, 2016 9:33
Vote:
 

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

#149333
May 30, 2016 9:56
Vote:
 

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.

#149336
May 30, 2016 10:49
Vote:
 

So how was the catalog created?

#149338
May 30, 2016 10:54
Vote:
 

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.

#149339
May 30, 2016 11:09
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.