Knowledge Base

How do I create a Database?

Create the Data File

  1. Create a .csv (comma separated values) file containing the data that will be used in the database.
  2. A spreadsheet program such as Excel can be used as long as the file is saved in the .csv format

    A picture of spreadsheet in Excel.
     
  3. The first row should contain the labels for each data field/ column.  Each row below represents a unique data entry.
  4. If the database is to contain links to files stored in the project, provide a column with the case sensitive name and extension of each file (e.g. “projectstep1.png”).

 

Upload the File to the Project

 

  1. Navigate to https://yourhub.org/projects.  
  2. Locate the project where the database is to be added in the My Projects section, or use the “Start a project” button to create a new project.  
  3. Click “Files” underneath Assets on the left project menu.

    A picture of the left project menu.
  4. Click “Upload”.  
  5. Drag and drop the .csv file as well as any files that are to be linked in the database into the “click or drop file” textbox.

    A picture of the file upload box.  
  6. Alternately, click the “Click or drop file” box and select the .csv file as well as any additional files to add (ctrl + click to select multiple) and click “Open”.

 

Create the Database - Step 1: Select the File

 

  1. Click “Databases” underneath Assets on the left project menu.

    A picture of the options on the left project menu.  
  2. Click “Create a database” in the upper right.  
  3. Select the .csv file that contains the data for the Database from the list.

    A picture of the file selection tool under databases.
  4. Click “Next”.

 

Create the Database – Step 2: Verify Data

 

  1. Click the pencil “Edit” icon underneath a column heading to make changes to it.  
  2. On the “General” tab of the Column Properties window, several values can be set:

    A picture of the General tab of the Column Properties window.
    Label (Required) ­– This is the title that is shown for the column.

    Description – A column description can be provided here.  The user will see this description when clicking on the column title.

    Width – This column accepts a numeric pixel value.  With this set, the column will remain fixed at the specified width.

    Units – This column accepts a unit of measure (e.g. inches, meters, liters) and will show underneath the column heading.
     
  3. On the “Column Type” tab of the Column Properties window, select the appropriate column type from the drop down list:

    Text [small] – This column type should be used to display a title or short description of the entry.

    Text [large] – This column type should be used for a long description or text that is more than one sentence.
    A picture of the Column Type tab on the Column Properties window.
    On either text Column Type, check “Limit text to a single line” to prevent the provided text from wrapping.  If the length of the text exceeds the width of the column, it will truncate what displays and the user can click on the text to view the entire content of that particular field.

    Image – This column type will display a preview of the image directly in the data field.  This can be either a URL to an image on the web, or the name of an image contained in the Project files. 

    Link - This column type will provide a hyperlink to the file specified.  It can either be a full URL link to the page, or the name of a file contained in Project files.
    A picture of the column properties tool.
    Check “Repository Files?” and choose the Repository Path from the drop down if the images or files are contained within the Project.
  4. On the “Other” tab of the Column Properties window the content alignment, text color, and background color can be configured.
    A picture of the Other tab of the Column properties window.
  5. Click “Update Column” to save all changes made.
  6. When you have verified all the columns look as intended, click “Next”.

 

Create the Database - Step 3: Title & Description, Finish

 

  1. Type a title and description to the Database in the text boxes provided.

    A picture of the Title and Description tool for creating a Database.
     
  2. Click “Finish” to finalize all changes and make the database available.

0 Dislike

Last updated