Question

Can't import campaigns

16:31 Sep 17, 2021

Hi Community!

I tried to import into the campaign table, but it doesn't work as expected.

I can see them in the campaign list, but when I open one of the imported records, the page is messed up (see screenshot 2021-09-17 15_31_03-Window.png).

The dev tools show errors as seen in screenshot Console Errors.png

I imported the following columns:

Name
Status (as finished)
Startmode (manual)
Endmode (manual)
Owner

The import log showed the following error on every row, but the records were created none-the-less:

Row 51: Error reading JObject from JsonReader. Path '', line 0, position 0.

Any thoughts on what went wrong and how to import campaigns properly? Am I missing some fields? Do I have to create other records in related tables?

Thanks,

Robert

File attachments

2021-09-17 15_31_03-Window.png

Console Errors.png

5 comments

Best reply

Robert Pordes

11:59 Sep 19, 2021

So I got this working...kind of.

In the table CampaignType, the following two records are stored:

235273BB-91CB-47FC-8A34-01F0002E38D4 Campaign

389EB587-52D4-4AB6-B4AD-E7E2F0D62EAC Campaign (old)

The problem is that imported campaigns will default to the wrong TypeId (type "Campaign (old)").

However, the Type lookup cannot be selected during the import, so I fixed it by updating the imported records directly via SQL with this simple script:

update Campaign
set TypeId = '235273BB-91CB-47FC-8A34-01F0002E38D4'
where TypeId &lt;&gt; '235273BB-91CB-47FC-8A34-01F0002E38D4'

Hope this helps someone and I also hope Creatio fixed this issue!

BR,

Robert

Max

18:32 Sep 17, 2021

Hello Robert,

You can try fixing the campaign schema object bindings by running the following script:

update SysModuleEntity

set TypeColumnUId = '876C6749-2C05-4861-856E-EFD51B847904'

where SysEntitySchemaUId = '1F9BB71A-EB9C-4220-A40E-9B623EACFEC8'

Hope it helps!

Best regards,

Max.

Robert Pordes

20:41 Sep 17, 2021

Max,

Hi Max,

thanks for the hint! Could you elaborate a little bit on what this script does? It's a production system so I don't want to risk too much ;)

Thanks,

Robert

Max

21:50 Sep 17, 2021

Robert Pordes,

It will set the type for the campaigns section and should not affect the system in any negative way.

Best regards,

Max.

Robert Pordes

02:28 Sep 18, 2021

Max,

it was already set...any other tips?

Btw, manually created campaigns can be opened normally.

BR,

Robert

Robert Pordes

11:59 Sep 19, 2021

So I got this working...kind of.

In the table CampaignType, the following two records are stored:

235273BB-91CB-47FC-8A34-01F0002E38D4 Campaign

389EB587-52D4-4AB6-B4AD-E7E2F0D62EAC Campaign (old)

The problem is that imported campaigns will default to the wrong TypeId (type "Campaign (old)").

However, the Type lookup cannot be selected during the import, so I fixed it by updating the imported records directly via SQL with this simple script:

update Campaign
set TypeId = '235273BB-91CB-47FC-8A34-01F0002E38D4'
where TypeId &lt;&gt; '235273BB-91CB-47FC-8A34-01F0002E38D4'

Hope this helps someone and I also hope Creatio fixed this issue!

BR,

Robert

Show all comments