Generating multiple entities from a list

Structuring your data

When importing a list of companies, people or similar data objects, it is helpful to convert your raw data into structured entities that Aleph can use to classify those entities for searching, cross-referencing, and many other operations.

For small and mid-size datasets, follow the instructions below to map your data into structured entities using the Aleph mapping editor. To map very large data straight from a SQL database, or to map complicated relationships, you will have to create a mapping file instead.

Using the Aleph mapping editor

1. Follow the "Importing documents and files" steps above to import your .csv, .xls, or .xlsx data file to a personal dataset.

2. Once the data file has finished uploading, browse to one of the tables you have uploaded. Click the "Generate Entities" tab to open the mapping editor.

3. Select the types of entities you would like to create from your data

4. Define any relationships - such as ownership or family relations - that exist between the entities.

5. Select columns from your data to use as unique keys for each entity.

Keys are usually ID numbers, email addresses, telephone numbers, or other properties of your data which are guaranteed to be unique. The more columns you are able to select as keys, the better, to ensure that Aleph correctly generates an entity for each unique entry in your data.

6. Assign data columns to properties of the entity types you have selected.

7. Add any fixed values to the entities. If, for instance, your data is a company registry from Moldova, it would be useful to set the "Country" property to "Moldova", so that all company entities that are generated will automatically have their country set as Moldova.

8. Verify and submit your mapping

When a mapping is submitted, Aleph will automatically generate structured entities based on the instructions you have provided it. It is important to note that any future edits you make to the mapping will re-generate these entities. Additionally, deleting the mapping will delete any entities generated from it.