Context
As a user I want to manually export trip information and logbook entries from the Firebase database to the MS Access database, so that I can maintain a centralised repository of data and utilise MS Access functionalities for analysis and reporting purposes.
In-scope
export trip information
export logbook information
marking the entries as exported in the Firebase database
removing the "+New" button from the logbook section on the Trip Summary page
Out-scope
allowing the user to edit a Trip that has been already exported
allowing the user to edit a Logbook entry that has been already exported
ScenariosScenario 1: Exporting Trip Information and Logbook Entries
GIVEN I have updated the script to export the trip and logbook entries available in the the Firebase database,
WHEN I initiate the export process,
THEN the system retrieves all trip details and logbook entries that has the status "ended" from Firebase,
AND generates a CSV file named "logbook.csv" containing all fields for the logbook table,
AND hydrophone comments are concatenated with logbook comments,
AND if GPS mark information is available, it should be added to the comments.
Scenario 2: Trip with status "exported"
GIVEN I have already exported a trip
WHEN I visit the "Trip Summary" page of this trip
THEN I see on the top of the page the following message "This trip has been exported"
AND the "+New" button in the logbook section is not present anymore
Acceptance Criteria
The export process retrieves only trip information and logbook entries that has the status "ended" from the Firebase database.
All the trip's and logbook values are correctly mapped in the MS Access DB
A Trip's time value is the first time-entry of a logbook
A CSV file named "logbook.csv" is generated as the output of the export process.
The CSV file contains all fields for the logbook table.
Hydrophone comments are concatenated with logbook comments in the CSV file.
If GPS mark information is available, it is added to the comments in the CSV file.
Once a trip has the status "exported" there is a message in the "Trip Summary" page of that specific trip informing the user that the trip has been exported and cannot be edited in the app
Once the trip status is "exported", the "+New" button is no longer visible in the Logbook section
Context As a user I want to manually export trip information and logbook entries from the Firebase database to the MS Access database, so that I can maintain a centralised repository of data and utilise MS Access functionalities for analysis and reporting purposes.
In-scope
Out-scope
Scenarios Scenario 1: Exporting Trip Information and Logbook Entries GIVEN I have updated the script to export the trip and logbook entries available in the the Firebase database, WHEN I initiate the export process, THEN the system retrieves all trip details and logbook entries that has the status "ended" from Firebase, AND generates a CSV file named "logbook.csv" containing all fields for the logbook table, AND hydrophone comments are concatenated with logbook comments, AND if GPS mark information is available, it should be added to the comments.
Scenario 2: Trip with status "exported" GIVEN I have already exported a trip WHEN I visit the "Trip Summary" page of this trip THEN I see on the top of the page the following message "This trip has been exported" AND the "+New" button in the logbook section is not present anymore
Acceptance Criteria