v29 BMS and Fieldbook app v6.2.2 data transfer via file export/import
BMS version 29 has been thoroughly tested and confirmed to be compatible with the specific Fieldbook version indicated on this page title. Using other/newer Fieldbook versions downloaded from Github is at your own risk.
About Fieldbook app
Fieldbook app can be downloaded for free from Google Play or from Github
Fieldbook is an application that can be installed on Android tablets and phones. It was developed to work primarily on a tablet, but its performance on phones is very good.
Fieldbook App connects to BMS using BrAPI or export/import of Studybook files.
Citation : Rife, T.W.and J.A.Poland (2014) Field Book: An Open Source Application for Field Data Collection on Android. Crop Sci.54(4): 1624 – 1627.
Exporting a studybook from BMS in KSU Fieldbook format
The study files in the BMS can be exported and loaded into the Fieldbook App.
Open the trial in the Study Manager.
Click on Actions, go to Data collection options and click on Export study book.
Choose the dataset to work with. For this exercise choose Observations. Click Continue.
Choose KSU Fieldbook CSV or KSU Fieldbook Excel as export format, choose Data Collection Order - Plot Order and Study Environment/s. Click Export.
The BMS creates a zip folder containing a CSV (or Excel) file for each selected Study Environment, and a TRT file containing variables (traits) definitions.
Transferring files to data capture device
Files can be transferred to the Android device via apps like Dropbox, Google Drive, email or manually with a USB cable.
When Fieldbook was installed, a Storage Location was created to store Fieldbook information. Several folders were created including “field import” and “trait” under this Storage Location/Folder.
Copy CSV Fieldbook to “field_import” folder on the Android device.
Copy TRT file to the “trait” folder.
Loading BMS studybook files on Fieldbook App
Note : A particular Environment (Instance) Study Book is known in Fieldbook app as Field.
Launch the Fieldbook App on your Android device.
Click on Fields
Select the study book to work with i.e. the previously imported Fieldbook CSV file. If it is your first time working in this field, you need to add it by clicking the + icon (bottom right corner).
Import field from Local storage. Select the CSV (or Excel) file transferred from BMS in the previous section.
Select OBS_UNIT_ID as Unique identifier. If the experimental design or field layout has Range and Column, select Range as the Primary order, and Column as the Secondary order. Alternatively:
REP_NO as Primary order and PLOT_NO (or Block) as Secondary order, or
PLOT_NO as Primary order and DESIGNATION as Secondary order if there is neither REP nor BLOCK information.
6. Go back to the main menu, and click on Traits
7. Click on the icon with the 3 dots.
8. Delete all traits for a fresh start. Answer ‘Yes’ when asked if you are sure to delete.
9. Click on Import/Export
10. Import traits from Local storage. Select the TRT file describing variables to be recorded in the study.
Settings
Some useful settings may be enabled to facilitate data collection. Click on Settings.
Check the Datagrid and select button uses direct camera scan in ‘Move to unique ID field’
Selecting “Button uses direct camera scan” Adds a icon to the Collect top toolbar. When pressed, it opens the device camera to move to an entry by scanning the barcode label attached to the plot or plant using the camera of the Android device. The barcode must match a unique ID (OBS_UNIT_ID) within the active trial.
“Datagrid” icon appears on the collect top toolbar after checking the box and displays a grid of all the recorded values for each entry and trait.
With grid turned-on
Sounds :: “Primary order sound” to get an audio notification when changing observation unit (plot or plant)
Fieldbook App is ready for data capturing. For information on other settings, consult the Fieldbook manual.
Data capture
Click on “Collect” for data entry.
Note 1: On the Collect screen you can display two Germplasm descriptors, for example Designation and Cross or select any other field of interest e.g. Study name (Field name).
Note 2: TRT file can be common across several studies, also user can always make any trait active (checking the box next to the trait name) or hidden(Uncheck the box) from the Fieldbook App and select the traits to be recorded on a field visit session.
Note 3: The search function on the top enables you to locate all reps of an entry at one time.
Refer to the “Fieldbook Manual” for more details about the app.https://fieldbook.phenoapps.org/#/
Data can be captured in a variety of ways depending on how the trait is measured.
Some examples of Data Formats
Date type of data
Text Format
Sliding bar for percentages
Curated categories
Numeric
A most useful added trait is the Categorical for note taking where you can have words or phrases that can be picked in a single click.
Data export from Fieldbook App
Go back to the main menu, click Export
Select Table for “Format”, All imported columns for “Field columns” and all active traits for “Traits”. You may select “Bundle media data with export file” in cases where you took a photo or audio during data capture.
Fieldbook App will suggest a file name, click Save.
Select an application to use for sharing the file (e.g. Dropbox, Google drive, email) and proceed. A copy is saved on the device in the "field_export" folder.
Tip: User(s) can export audio, and photos captured in the field with the Fieldbook App by accessing the “Field Export folder' on the Android device.
Data upload on BMS
The export file from Fieldbook App can now be uploaded into the BMS.
In the BMS, open the study in MANAGE STUDIES.
Click on Actions, Data collection options, then Import Observations.
Specify KSU Fieldbook CSV or KSU Fieldbook Excel.
Browse Fieldbook file and click import.
Review imported data. Save or discard imported measurements.
More Fieldbook Setting Tips
Tip1: For taking pictures, you must create a trait in Fieldbook app with Photo format, for example "PlotPhoto", "PlantPhoto" and "FruitPhoto".
The picture will be in a file labelled as Plot_ID_Trait name_Sequence number_time stamp, for example: FH27Py7S9nLGJ_Plant_Image_1_2017-11-29-03-42-51
Tip2: For recording audio notes, you must create a trait with Audio format, for Example "PlotAudioNote".
The audio will be in a file labelled as Plot_ID+Time Stamp, for example: FH27PZuaX1mcZ 2017-11-23-10-53-05 and stored in the "plot_data" folder of Fieldbook.
Tip 3: Fieldbook App allows you to display on-screen scoring diagrams, disease symptoms pictures and other resources that can be helpful when out in the field. Drop these files into the “resources” folder.
Refer to the FieldBook Manual for more details : https://fieldbook.phenoapps.org/#/