#data | Community Creatio

Question

19:58 Oct 24, 2024

Hi All,

We are trying to insert data in a datetime field in contact table from database via API. But the time shown in Creatio is different from the database. For example - one record shows as 2024-01-15 16:54:48.000 in the database whereas in Creatio it shows as 1/15/2024 10:54 AM. We are in central timezone and user profile is set to central timezone. How can we correct this?

Thanks

1 comments

Kyrylo Atamanenko

17:37 Oct 29, 2024

Hello!

Actually it occurs because all dates savings in DB in UTC time zone and only then converting to users according their timezone settings. But when you making API request it returns date same as in DB. There is no possibility to change this behavior at this moment.

Show all comments

Question

Can be Check Data before import while comparing it with existing data

Braj Raj singh Kushwaha

10:54 Jul 01, 2021

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

1 comments

dean parrett

13:49 Jul 01, 2021

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

Subscribe to #data