Adding Data

Adding a new system or revising an existing system

  1. Log into website Username: beginning of e+mail address (i.e. jsmith – do not include @gmail.com) Password: same as username
  2. 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
  3. Enter all relevant information on the system
  4. 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
  5. 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.
  6. 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
  7. Making Revisions to a database Click “Change Info” at the end of the database detail
  8. Click “Save Revisions” Click “Database Revisions” and click “Load this revision” next to the appropriate dated revision.

Importing a table

  1. Steps to take to get file ready for importing
  2. See examples of the table file derived from the City of Chicago Congregate Dining Meal Application
  3. 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.
  4. 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.
  5. Log into website
  6. Select “import” from the drop down list under your name
  7. Select the “browse” button under the second option - Choose your Tables.csv file and then click on the submit button
  8. Add the appropriate variable CSV file
  9. Select “submit”

Importing a variable

  1. Steps to take to get file ready for importing
  2. See examples of the variable file derived from the City of Chicago Congregate Dining Meal Application
  3. 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.
  4. 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.
  5. Log into website
  6. Select “import” from the drop down list under your name
  7. Select the “browse” button under the second option - Choose your Variables.csv file and then click on the submit button
  8. Add the appropriate variable CSV file
  9. Select “submit”