Creating a Database

Classic Interface

The following section describes how to create a new Database.

A Database is the place where you store data related to a particular organisation, project or activity. All data entered by users will be kept here, in a format which you specify.

A Database allows you to control user access and their rights to view, enter and update data. It also allows you to organize Partners, Projects and Targets for your activities.

Databases in ActivityInfo are linked to a specific Country. This allows you to assign Administrative Levels to data entries.

You can create a New Database or Clone an Existing Database instead.

The geographic information stored in our platform for each Country varies. 

Is the Location data not precise enough for your needs? Don't hesitate to Contact Us. If the information is available, we will add/update Administrative Levels for the Country.

Next steps

Once you create a Database you can start designing your first Form and invite other Users to work with the Form. If you work with many users that belong to different Partners you can create Partners and assign users to them to manage them more efficiently.

How to Create a Database

Creating a New Database
  • The "Create a New Database" dialog will appear in a pop-up.
  • Select the "Create a new empty database" option, and click "Next".
  • Enter a name for your Database in the "Name" field.
  • Select the Country your Database is related to from the drop-down menu. If your Database monitors data from various countries, select the "Global" option.
  • You can also add a description of your Database in the "Description" field. This will be visible to Users invited to your Database, and will help to explain the contents of your Database.
  • When you are ready, click on "Create" button to create your new Database.

We recommend choosing a short and self-descriptive name for the database so that the name doesn't appear shortened in the platform. 

The name of the database should correspond to information contained in the Database (program, country activities, etc.) and should be comprehensive for the users who will perform data entry. 

Use the description field to give more information of your Database.

Cloning an Existing Database

If you wish to reuse the structure of a previous Database, you can copy its structure to create a new Database. Only the data structure will be copied - no data entered into the Database will be copied.

You can only copy a Database to which you have Design Permissions.

  • The "Create a New Database" dialog will appear in a pop-up.
  • Select the "Use an existing database as a template" option, and click "Next".
  • Select an existing Database from the drop-down menu, and click "Next".
  • Enter a name for your Database in the "Name" field.
  • Select the Country your Database is related to from the drop-down menu. If your Database monitors data from various countries, select the "Global" option.
  • You can also add a description of your Database in the "Description" field. This will be visible to Users invited to your Database, and will help to explain the contents of your Database.
  • If desired, you can copy the Partners and User Permissions of the previous Database. If neither of these options are selected, only the Database structure will be copied.
  • When you are ready, click on "Create" button to create your new Database.

We recommend choosing a short and self-descriptive name for the database so that the name doesn't appear shortened in the platform. 

The name of the database should correspond to information contained in the Database (program, country activities, etc.) and should be comprehensive for the users who will perform data entry. 

A description field can be added to give more information of your Database.