Adding a new system or revising an existing system
Log into website
Username: beginning of e+mail address (i.e. jsmith – do not include @gmail.com)
Password: same as username
Visit example.com/database_info.php, where example.com is the directory hosting Metalicious. Click "Create New DB"
Note: If a database has been created, you may open an existing database to create a new database
Enter all relevant information on the system
Select “Create New Database” once all information has been entered
Note: This will create the database, but it will not yet appear on the website
Activate the database
Click on your name at the top of the screen and select “Admin” from the drop down
Click on the database and then select “Activate Revision”
The system will now appear on the website. Note: The database will need to be activated in order for it to be complete and appear in the website as well as for you to add the business function.
Adding the Business Function
Use the “Search” feature to open up the new database
At the end of the database detail table, select the business function where this database belongs
Follow step 7 to update the revision
Making Revisions to a database
Click “Change Info” at the end of the database detail
Click “Save Revisions”
Click “Database Revisions” and click “Load this revision” next to the appropriate dated revision.
Copy all relevant fields (system, table, column/field, type, length, value range, description, examples, comments) with no header row and paste into a separate excel file and save as CSV (comma delimited) file.
The System name in the file must match exactly how the system is named in the website. For example, if the system is titled “Attendance System” in the website, the spreadsheet must have “Attendance System” listed under the system column.
Log into website
Select “import” from the drop down list under your name
Select the “browse” button under the second option - Choose your Tables.csv file and then click on the submit button
Copy all relevant fields (system, table, column/field, type, length, value range, description, examples, comments) with no header row and paste into a separate excel file and save as CSV (comma delimited) file.
The System name in the file must match exactly how the system is named in the website. For example, if the system is titled “Attendance System” in the website, the spreadsheet must have “Attendance System” listed under the system column.
Log into website
Select “import” from the drop down list under your name
Select the “browse” button under the second option - Choose your Variables.csv file and then click on the submit button