Importing XAG Data into FlyFreely

Manually import your XAG flight data in a corresponding FlyFreely mission.

 

This process has been published to assist users of the P30 XAG system in reformatting and importing their flight data into the FlyFreely platform. As XAG has no export function for flight data, this process is manual, and involves precise manupulation of the data in a spreadsheet application (we've used Excel in this article).

FlyFreely is unable to provide technical support or instruction in the use of Excel or other applications.

Instructions

The following instructions are divided into 4 sections:

  • Extract Data from XAG Platform
  • Manipulate Data In Excel
  • Download the Bulk Import template from FlyFreely
  • Upload Data to FlyFreely

The instructions assume that a pre-planned mission exists in FlyFreely, into which the resulting flight data can be uploaded.

Extract Data from XAG Platform:

  1. Open mission in XAG platform and select the History tab
  2. Select the relevant date from the Operational History section
    (each day's flying should correspond with a single FlyFreely mission)
  3. Select View Satellite Image
  4. Select the relevant field in the sidebar and click Operational Records
  5. Change the sidebar view format using this button:
    button
  6. copy all text carefully (easiest if you drag from the bottom upwards) - make sure not to exclude any text as it may cause the following steps to fail.
    selection
  7. Copy the text and paste it into notepad (this clears any formatting), then select all in notepad, copy and paste into excel

Repeat steps 4 - 7 for each field to be included in your mission record.

Manipulate Data In Excel

Your data should now be in Excel, with the data for each individual flight appearing in a single cell. The next steps will seperate this data out into useable fields.

excel1

  1. Remove any empty rows at the top of the file (your data should start in row 1)
  2. Select column A and select the Text to columns function under the Data tab.
  3. Choose the 'Delimited' data type > Next > tick 'space' and 'other' as delimiters and in other, enter the ":" (colon) character > Finish
    This will split the column into individual fields (don't worry that they seem a bit chaotic at this stage).
  4. Insert new column to the right of column X.
  5. Insert the following formula into Y1 and hit enter:
    =W1&":"&X1
  6. Drag to replicate the forumula down the whole column.
    Your flight start times should now be shown correctly in HH:MM format.
    starttime
  7. Select column M
  8. Text to columns > delimited > tick other "s" > set field to text
    Flight durations should now be shown in 00m:00 format.
    operator
    You might have one or more fields like that shown above, which will cause that line to fail during import. If the flight duration isn't shown anywhere in the XAG data, this line will have to be discared (we'll handle this later on in the process).
  9. Insert new column to the right of column P and leave blank
  10. Select column P
  11. Select Text to columnsfixed width > place the break after the numeric characters > data type: text Finish
    battery

    Your aircraft serial numbers should now be shown correctly in column P.
  12. Insert new column to the right of column and leave blank
  13. Select column R
  14. Repeat the process in step 11 on this column.
    Your battery serial numbers should now be shown correctly in column R.

All required fields should now be ready to copy across to the upload template.

Download the Bulk Import template from FlyFreely

  1. Open your completed mission in FlyFreely
  2. Select Edit Mission Record
  3. Click Bulk Upload in the flights section as shown below:bulk upload
  4. Download the template and open it in excel (you should now have 2 files open)
     

Populate The Bulk Import Template

  1. Resize columns as required for clarity
  2. Remove the example entres in row 2, except for 'Completed' in column A
  3. From your XAG data, copy/paste columns AA into the start time field in the template.
  4. Copy/paste column M into the duration field in the template.
  5. Copy/paste column P into the RPA field in the template
  6. Copy/paste column R into the battery field in the template
  7. Enter the 'Remote Pilot' name into row 2 of the template (this must exactly match their name in FlyFreely). Drag it down to copy into all rows.
  8. Enter a 'Reason' (eg 'aerial spraying') into row 2 of the template. Drag it down to copy into all rows.
  9. Drag 'Completed' in the status column down to copy to all rows
  10. Ensure all fields are populated in template, it should look something like this:
    csvfinish
  11. Save the template file.

Upload Data to FlyFreely

  1. Switch back to FlyFreely and click Select File 
  2. Browse to the saved template file and select it
  3. This will open the data in FlyFreely's Bulk uploader. Any invalid fields will be highlighted in red and you can see the reason by clicking on the warning icon.
    import
    You can rectify any issues by clicking on the field (in this case the word 'operator') and typing in a correct value.
  4. Use the tickbox at the top to select all fields for import, then deselect any individual rows to skip (if required) then click Import. Note that if there are any errors in an included row, the import button won't be available.

Your data should now be in the system, with flights created based on each row.