[ic] How can I add a custom product field in DB.

[AS]

Hi folks,

I am trying to add a field to my products db (mysql) using IC. I want to
add a field called 'use1' I have followed the instructions pasted below
but in my item editor I do not have the new field to edit?

I have an entry in the metadata table called products::use1 but don't
seem to be able to display the field to add data on the edit item
screen.

Any help appreciated,
Thanks,
Andy.

How to add your own fields to the ui Edit Item page ic4.8.x.
============================================================

These instructions show you how to add a field to the record editor
pages in
the admin ui. This assumes you are adding a field to the 'products'
table,
it has already been added in the database, and Interchange is aware of
it.

1) Log in to the admin ui with super user permissions.
2) Go to the Administration section.
3) Click on tables.
4) Click on the Products table icon to edit the table entries.
5) Click on the link 'products' immediately after the 'Select table to
edit'
heading.
 You are now at the mv_metadata settings which define the display of the
table data.
6) Add the name of your field to the list named 'Fields to edit'. These
are
in the order they will be displayed for editing.
7) Click OK
 The field should now appear in the edit item page.

8) Now go to edit an item - your field should be there.
9) Click on the 'meta' link next to the field name. (it there is no
'meta'
link you need to set the variable 'UI_META_LINK' to 1 in the Admin
Control
preference group.
10) set up the label, field type, width etc. and save.
11) thats it. There is no 11.

good luck,

Jonathan
Webmaint.


www.tvcables.co.uk