Can't import campaigns

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

 

Like 0

Like

5 comments
Best reply

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 <> '235273BB-91CB-47FC-8A34-01F0002E38D4'

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

 

BR,

Robert

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.

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

Robert Pordes,

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

 

Best regards,

Max.

Max,

it was already set...any other tips?

Btw, manually created campaigns can be opened normally.

 

BR,

Robert

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 <> '235273BB-91CB-47FC-8A34-01F0002E38D4'

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

 

BR,

Robert

Show all comments