Records from a CSV file

Parent Previous Next

Gilbert 21 - initialising records from a CSV file

Gilbert 21 is software has been designed primarily to manage a database of personal biological records. So it doesn't boast sophisticated interfaces for importing, collating and managing records from diverse sources. Nevertheless, it is sometimes the case that new users of Gilbert 21 want a facility to import personal records that they have previously stored in another digital format. The facility described here was developed to enable that.


The facility enables new records to be initialised from a comma separated values (CSV) file with any of the following fields (which must be specified on the first row):



These fields correspond to the record fields in Gilbert 21. Not all of them need to be included - none are compulsory. Extra fields with unrecognised names will be ignored.


Once you have prepared a CSV file, select the 'Open files' item from the Gilbert 21 File menu. This should open the folder set as your Default import folder. If your prepared file is in this folder, you will be able to see and select it at this point - otherwise navigate to the folder where you saved it and select it from there.


Opening your file does not import records directly to the database. Instead it produces a number of 'candidate records' corresponding to each row in the file you prepared - in just the same way as it does for Visiontac / Columbus files or Evernote notes. As with other input methods Gilbert 21 will, where it can, fill in missing values. So if, for example, your import file has grid references but no location names, Gilbert 21 will match the grid references against its gazetteer database to come up with the names of the nearest locations. Similarly, if no determiner is specified, Gilbert 21 will use the default determiner name specified in the Gilbert 21 options.


Once you have opened your input file, you can change any of the candidate record properties or even remove some of them before saving the records to the database with the 'Save records' item of the File menu.

Created with the Personal Edition of HelpNDoc: Free CHM Help documentation generator