Question Re: How to empty country table in CRM and CX Q&A

How to empty country table

Former Member — Tue, 18 Jun 2019 10:38:19 GMT

In my own project impex file, I would like to empty the whole country table first, and then import the country table, so, I write in impex file as:

REMOVE country

But meet this error: Import script is invalid: no permitted type found for configured columns. omitted types: {8796093710418=[type Country has no unique columns - no permitted type for mode import_strict]}

Anyone know how to do it?

Re: How to empty country table

arvind-kumar_avinash — Tue, 18 Jun 2019 10:44:50 GMT

Please use the following ImpEx:

  REMOVE Country[batchmode=true];itemtype(code)[unique=true]
  ;Country

Re: How to empty country table

VinayKumarS — Tue, 18 Jun 2019 12:48:03 GMT

As Arvind mentioned in the example. Every insert update or remove impex should have alteast one uniqe column. in Arvind example he mentioend itemtype(code)[unique=true]. Without this unique column impex will not run.

Re: How to empty country table

rohit31_raj92 — Sat, 22 Jun 2019 18:25:23 GMT

You can also drop the table data using sql scripts or remove the table data using batch mode as said already by Arvind.

Re: How to empty country table

Former Member — Tue, 25 Jun 2019 09:52:55 GMT

As Raj mentioned sql is recommended option for removing the complete table data.