Befdata workbook

Karin Nadrowski edited this page Sep 4, 2013 · 12 revisions

The BEFdata workbook allows to upload data and metadata at once. It additionally allows to specify naming conventions for the primary data. The workbook is currently given in an Excel 2003 (TM) format, in five sheets. The easiest way to get a valid workbook is to download an existing workbook from a dataset that is somewhat similar to your dataset. Every BEFdata instance also includes a data set called "How to fill a BEFdata Workbook".

Re-assembling the workbook for download from the database is a huge task. For performance reasons, BEFdata implements a Background worker that prepares all datasets for download in the background. As soon as changes in data or metadata have occured, including changes to Categories linked to a dataset, the dataset is put on a priority list for regeneration.

The workbook consists of 5 sheets, the last of which stores the primary data.

Name Description
General metadata Contains fields for dataset title, abstract, location, project and data ownership.
Acknowledgements Lists users who have contributed to data capture or collection for a particular column, other than those listed in the ‘General metadata’ sheet.
Columns and datagroups Lists all the columns in the ‘Raw data’ sheet. Column headers have to be unique. Meta data on columns includes definitions, unit of measure and Data type. Datagroups are the last two columns on these sheet and manage the naming conventions through unique Categories, which can be specified on the next sheet.
Categories Lists the individual options available for category datatypes used in the ‘Raw data’ sheet. Providing categories for upload automatically accepts the categories as validated, to that no further validation has to be performed online.
Raw data Contains the actual data, each row as a single observation. BEFdata portals save the primary data values in Sheetcells, which may be linked to categories.