| | 8 | |
| | 9 | === As a user I want to be able to import data as quickly and easily as possible === |
| | 10 | |
| | 11 | Acceptance criteria: |
| | 12 | * The import must be a (semi) guided process where it is clear what I must do (next), and what I have done wrong or right |
| | 13 | * I want to import .xls formats |
| | 14 | * I want to add the data to a specific project |
| | 15 | * I want to see if columns are missing in the file and be able to set a default value for that column |
| | 16 | * I want to see if there are unidentified columns and be able to assign them to a known column |
| | 17 | * Before the data is imported i want to output the sql code to a file |
| | 18 | |
| | 19 | === As a user I want to be able to extract data out of the database === |
| | 20 | * I want to export all the data out of the database |
| | 21 | * I want to export all the data from 1 project out of the database |
| | 22 | * I want to export a selection of entries in the database |
| | 23 | * I want to export data based on a inputfile |
| | 24 | * The method export based on file should be able to map a (or multiple) column(s) in the file with a column in the database |
| | 25 | * The method export based on file should be able to have a free selection of columns that I want to see in the outputfile |
| | 26 | * The method export based on file should be able to deal with multiple line matches |