Kryptronic Software Support Forum

picstart · 07-24-2007 02:16:47

I only ship my products to the UK (would like to include Ireland, channel isles etc) is there a quick way to remove all unwanted countries, states etc without having to remove them one at a time manually

qmstores · 07-24-2007 04:36:23

You could remove them all and then add back the small number you do need, but you'd have to make sure you added them back exactly.

picstart · 07-24-2007 05:37:01

sounds risky that one,

are they stored in a file that can be downloaded as a csv edited then put back?

qmstores · 07-24-2007 06:00:13

If you go to Raw Database Admin you can take a copy of the current contents by doing an 'Export' and then downloading the file.

Then you could edit this file and remove all the ones you don't want, then empty the databaes table, then import the edited file.

Importing does not, by itself, empty the destination table first which is why you need to empty it by hand.

picstart · 07-24-2007 06:40:06

Thanks qmstores ,

will i have to empty the database file one at a time , if so i might as well just delete the ones i dont require. or does anyone know if there is an sql statement i could run. ?

Litemaster · 07-24-2007 06:52:16

Access: Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin

Then choose the 'SQL Statement: Submit a Raw SQL Statement' function and execute the appropriate statement for the database file you need to clear.

For the international version run the statement: DELETE FROM ccp0_stateprov this will delete all entry's in the stateprov database.

Mike Simpson
wwwdjshopper.net

picstart · 07-24-2007 07:33:03

thanks mike , its the uk version so i guess all that will be diferent is gbu_0 so will have ago at that now.

thanks

qmstores · 07-24-2007 10:13:45

gbu0_...

For the countries and stateprov tables.

Last edited by qmstores (07-24-2007 10:14:30)

Kryptronic Software Support Forum

#1 07-24-2007 02:16:47

quick way to remove unwanted countries

#2 07-24-2007 04:36:23

Re: quick way to remove unwanted countries

#3 07-24-2007 05:37:01

Re: quick way to remove unwanted countries

#4 07-24-2007 06:00:13

Re: quick way to remove unwanted countries

#5 07-24-2007 06:40:06

Re: quick way to remove unwanted countries

#6 07-24-2007 06:52:16

Re: quick way to remove unwanted countries

#7 07-24-2007 07:33:03

Re: quick way to remove unwanted countries

#8 07-24-2007 10:13:45

Re: quick way to remove unwanted countries

Board footer