tsql categories import

[david.schneider]

hi folks,

to import a large number of categories i'd like to import them in a batch job.

texis -d "Texis\default\db1" -s "insert into categories (Catno, Category,Url) values (6, 'test', '*/test/*')"

works fine to import one category.

Unfortunately the category shows up in the "Test Search" but doesn't show up in the "All Walk Settings" and is discarded after the next walk.

any idea how to persist the category using SQL?

cheers
dave

[John]

Assuming you are talking about Webinator the simplest way to add a category would be with the addcat function or a derivation thereof. The data needs to be stored in the options table in texis/testdb, and once all the categories are added the database needs to be recategorized.

You could then run something like:

texis profile=default Catname=test Pat="*/test*" dowalk/addcat2.txt

and then:

texis profile=default dowalk/recat.txt

That assumes you've created addcat2 based on addcat that works from the command line only (change <perm> to <usage>) and doesn't call recat itself for each category.