Kryptronic Software Support Forum

First question is what is your goal for this new field of information?

What other table are you wanting to show up in the categories area?
Where would you be using this informaion?
This would require a modification to core scripts.

If you want to change the behavior of the new field at this point you will have to go to the core_columndefs database table, browse that table and find your new entry for the ecom_prod database, it will look like ecom_prod.new_table_name, find the cnumeric field and insert the number of characters you want that field to handle ( this is because when you created the new column you didn't give the correct character number or text count you want for the field). If you want to change the type of field this is (example from a text box to check box) then you will need to edit two columns, these are cinsdisplaytype and cupddisplaytype (checkbox entry would look like CHECKBOX-TABLE). One field controls the Raw Database Admin view (known as the core side of admin) and the other controls the view from the ecom side of admin like when you view the product thru the System Dashboard > Store > Catalog > Products page(s). A wrong entry into either of these field will cause that display to crash or not be produced, there is a specific list of except able entries that these fields can hold, the ones you can see if you browse thru the table at the other entries for these fields. A field type of SELECT-CUSTOM will require entries in the core_selectcustom database table for that field name or it will also cause an error and not generate a display. So in short if you make an edit to either of these fields and then you can not see the product edit screen in either Raw Database Admin or thru System Dashboard > Store > Catalog > Products then you need to check what you have entered into one of these fields.

Now comes the really bad news which connects back to the first question. Any new database table or column added to a table will not be acted upon by ccp with out minor or major modification to the some core scripts or the creation of a new class or script(s) that look for and work with that information, so where back to question one what are you wanting to do.?

John

Been thinking about this a bit more.
My initial requirement is to have two sets of categories. So I can display one or the other oR both on the splash and category pages.
I think it might be easier to do the following, what are your views on the complexity of this.
Ie
Category set 1 & category set 2

If I create a new column in the category table say called 'set' and then allocate a set name 1 or 2 for each category

Clone a category display but change the code to display

Heading: Category 1
Show categories where 'set' = category 1

Heading: category 2
Show categories where 'set ' = category 2

Your thoughts here are appreciated. Would I need to change core code?
Thanks
James

Last edited by Jimjay (05-01-2012 12:19:25)

bump