Page 1 of 1
maintaing categories
Posted: Wed May 30, 2007 12:04 pm
by Anrew Allen
Hello,
I have about 25 categories defined and they are entered in the prticular order.
I need to insert 2 additional categories in the middle ( i.e. the 2 new categories need to appear as #5 and #9 on the dropdown).
What is the easiest way to do this?
It seems like using walk web intrface does not allow to do it easely.
Thanks,
Andrew
maintaing categories
Posted: Wed May 30, 2007 1:05 pm
by mark
You need to copy and paste the lower entries down to make holes for the insertions.
maintaing categories
Posted: Wed May 30, 2007 1:52 pm
by Anrew Allen
Mark,
I new that ...but what I am saying is that with 25 categories and growing it is very awkward and time consuming.
Do you know of any way I can change entries directly in database not using the web interface?
maintaing categories
Posted: Wed May 30, 2007 3:13 pm
by mark
Yes, but it requires some effort and care to setup. The settings are in the database "INSTALLDIR/texis/testdb" in table "options". There are 3 settings for the categories: "SSc_catname", "SSc_caturl", and "SSc_catvisible" for the category name, url pattern, and visible flag respectively. Each is an array of items separated by newline. So SSc_catname would contain
Category Name 1
Category Name 2
SSc_caturl would contain
http://pattern1
http://pattern2
SSc_catvisible would contain
Y
Y
Vortex SQL to update all 3 for profile "test" would be something like this:
<$myprofile="test">
<$newnames="Name 1
Name 2
">
<$newurls="
http://pattern1
http://pattern2
">
<$newvis="Y
Y
">
<sql novars "update options set String='$newnames' where Profile='$myprofile' and Name='SSc_catname'"></sql>
<sql novars "update options set String='$newurls' where Profile='$myprofile' and Name='SSc_caturl'"></sql>
<sql novars "update options set String='$newvis' where Profile='$myprofile' and Name='SSc_catvisible'"></sql>