We need to import lookup values in more than a language from an Excel file.

We have an Excel with two columns: Name (italian) and Name (english).

When we import from Excel the Name column goes into the "current language" lookup name but we want to import the names in two different languages (both active in Creatio) without duplicating them.

How can it be done?

Like 0

Like

1 comments

Hi Massimiliano, 



You need to import values into two different objects. Let's take [Lookup] for example. 



When you import the values for the English culture, you can import directly into [ObjectName] (Lookup in our case) and can only have two columns: Id of the record and the actual Value. 



When you import the values for Italian Culture you need to import into Sys[ObjectName]Lcz ( SysLookupLcz in our case) and you need 3 columns: Id of the record - mapped to RecordId, CultureId and the Actual Value. 



Best regards,

Yurii.

Show all comments

Hi Team

 

Just want to know can compare data before upload from existing data over the system

As we could see a lot of typing(Human) mistakes and each time a new record is created

 

And data over the system is of on use as no access is given 

the process gets stuck as they could find relevant data

 

is there something by which we can change/compare data before uploading as per system data

 

Thank You

Like 0

Like

1 comments

Hello,

 

You can run the duplicate search after each import to find potential duplicates. Additionally you can select the fields under which the records will be considered as duplicates (item 4 of the guide https://academy.creatio.com/docs/user/platform_basics/business_data/exc…)

So the idea is if I import a contact with name Dean, the existing contact with the name Dean will be updated with data from file and no duplicates will be created.

 

Regards,

Dean

 

Show all comments