How to empty country table

[Former Member]

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?

[rohit31_raj92]

Hi

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

[VinayKumarS]

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.

[Former Member]

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

[arvind-kumar_avinash]

Please use the following ImpEx:

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