SchemaEditor.asp Usage

See also Readme
See also Edit.asp Usage

INSERT

You can insert columns by selecting the column you want to insert before and clicking the INSERT button.

ADD

This appends a new column to the end of the list.

DUP

This duplicates the currently selected column.

REMOVE

To remove a column, select the row then click this button. When you click SAVE this will also remove the column from the data on the server - so be careful !!

BACK

Takes you back to the Edit.asp view.

@id

This column is autogenerated. Each row in the schema must have a unique id.

@type

The name of the XML elements in each list item. If the name starts with "@" then the column will be stored as an XML attribute. You can rename columns, but you cannot change an element into an attribute or visa versa.

@title

This allows you to specify a different title for the column which shows up in the HTML view.  You can use this to insert spaces and other special characters into the column titles that would otherwise be invalid XML.

@values

This fieldcan be used for two purposes:

1. Specify a specific set of choices for a given column separated by commas. For example [0,1,2,3] woulc specify that this column can only have those values. The user interface for this column when editing values in the data view will be a drop down list instead of an edit box, showing these options.
2. If the value of this field starts with "=" then it is a JScript expression for calculating the value of the column. THis allows your list to behave kind of like a spreadsheet. These expressions can reference fields in the current row using the syntax "@name".  For example the following expression sets the column to "0" or "1" of the <area> column contains the string "DOM".

   =(%area ==   "DOM") ? "0" : "1"

@view

This field contains the default value of the "visibility" check mark for that column.  The default is to ake all columns visible.  Set this to the value "no" to make the column invisible by default.

@color

You can define a background color for the column.  If this starts with "=" then it is a JScript expression to calculate the background color of a column. The following expression sets the column background to red if the <area> column contains the string "DOM":

=(%area ==  "DOM") ? "#FFA0A0" : ""

SHOW UPDATE HISTORY

This button will return the current XML update gram log which is stored in memory on the server and is used to synchronize the clients currently editing the same XML file.

CLEAR UPDATE HISTORY

You might want to do this from time to time to stop the update history in the Application state of save.asp from getting too big.