v29 BMS and Fieldbook app v6.2.2 data transfer via file export/import

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

image-20240809-091743.png

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.

  1. Open the trial in the Study Manager.

  2. Click on Actions, go to Data collection options and click on Export study book.

    image-20240812-120245.png
  3. Choose the dataset to work with. For this exercise choose Observations. Click Continue.

    image-20240812-120732.png

  4. Choose KSU Fieldbook CSV or KSU Fieldbook Excel as export format, choose Data Collection Order - Plot Order and Study Environment/s. Click Export.

    image-20240812-121314.png

  5. 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.

    image-20240812-122707.png

     

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.

  1. Copy CSV Fieldbook to “field_import” folder on the Android device.

    image-20240812-135321.png

  2. Copy TRT file to the “trait” folder.

    image-20240812-134742.png

Loading BMS studybook files on Fieldbook App

Note : A particular Environment (Instance) Study Book is known in Fieldbook app as Field. 

  1. Launch the Fieldbook App on your Android device.

  2. Click on Fields

     

    image-20250112-160747.png
  3. 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).

 

image-20250112-162535.png

 

  1. Import field from Local storage. Select the CSV (or Excel) file transferred from BMS in the previous section.

image-20250112-163209.png

 

  1. 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:

    1. REP_NO as Primary order and PLOT_NO (or Block) as Secondary order, or

    2. PLOT_NO as Primary order and DESIGNATION as Secondary order if there is neither REP nor BLOCK information.

      image-20250112-163427.png

6. Go back to the main menu, and click on Traits

 

image-20250112-164853.png

 

7. Click on the icon with the 3 dots.

image-20250112-171254.png

 

8. Delete all traits for a fresh start. Answer ‘Yes’ when asked if you are sure to delete.

image-20250112-171806.png

9. Click on Import/Export

image-20250112-172553.png

 

 

image-20250112-172751.png

 

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.

image-20250112-173728.png

Check the Datagrid and select button uses direct camera scan in ‘Move to unique ID field’

Screenshot_20250112_204146_Field Book-20250112-174346.jpg

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.

 

image-20250112-180455.png

Datagrid” icon image-20250112-180710.png 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

 

image-20250112-180936.png

Sounds :: “Primary order sound” to get an audio notification when changing observation unit (plot or plant)

image-20250112-181522.png

Fieldbook App is ready for data capturing. For information on other settings, consult the Fieldbook manual.

Data capture

Click on “Collect” for data entry.

image-20250112-181919.png

 

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).

 

 

image-20250112-183111.png

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.

image-20250112-184015.png

 

Note 3: The search function on the top enables you to locate all reps of an entry at one time.

image-20250112-184739.png

 

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.

 

 

image-20250112-185100.png

Some examples of Data Formats

  • Date type of data

 

image-20250112-185258.png

 

  • Text Format

 

image-20250112-185517.png

 

  • Sliding bar for percentages

 

image-20250112-185614.png
  • Curated categories

Screenshot_20250112_220237_Field Book-20250112-190544.jpg

 

  • Numeric

 

image-20250112-190909.png

 

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.

image-20240812-150715.png

Data export from Fieldbook App

  1. Go back to the main menu, click Export

     

 

image-20250112-191348.png

  1. 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.

    image-20240812-151253.png

  2. Fieldbook App will suggest a file name, click Save.

  3. 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.

 

image-20240812-151624.png

 

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.

 

  1. In the BMS, open the study in MANAGE STUDIES.

  2. Click on Actions, Data collection options, then Import Observations.

  3. Specify KSU Fieldbook CSV or KSU Fieldbook Excel.

  4. Browse Fieldbook file and click import.

  5. 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/#/