Feature #1442
Export data from Excel into QuanTB
0%
Description
Suggestion:
- Browses an excel spreadsheet in the user's computer.
- Allows exportation of ALL parameters data at once.
- Before importation QuanTB checks if the format of the spreadsheet is compatible with its data set and warns the user.
- QuanTB should display a sample of the spreadsheet with the required data format for user viewing and downloading.
Exception exporting to Excel.JPG (79.4 KB)
Exception Import Excel.JPG (94.1 KB)
Exception Import Excel 2.JPG (52.4 KB)
Test Two.xlsx (24 KB)
Test importing Excel.qtb (21.3 KB)
Exception import Oct 30.JPG (155 KB)
2015-10-30err.qtb (6.04 KB)
Import excel error message.jpg (92 KB)
Import excel labels.JPG (41.3 KB)
History
#1
Updated by Oleksii Kurasov almost 10 years ago
- Status changed from New to In Progress
#2
Updated by Luis Gustavo do Valle Bastos almost 10 years ago
- File Exception exporting to Excel.JPG added
- Status changed from In Progress to Feedback
- Exception caught when exporting from Excel generated by QuanTB.
- See message attached.
#3
Updated by Oleksii Kurasov almost 10 years ago
- Due date set to 06/02/2015
- Status changed from Feedback to Resolved
- Assignee changed from Oleksii Kurasov to Luis Gustavo do Valle Bastos
#4
Updated by Luis Gustavo do Valle Bastos over 9 years ago
- File Exception Import Excel.JPG added
- File Exception Import Excel 2.JPG added
- File Test Two.xlsx added
- File Test importing Excel.qtb added
- Status changed from Resolved to Feedback
- Assignee changed from Luis Gustavo do Valle Bastos to Oleksii Kurasov
- Exception problem mentioned above still persists when using excel previously exported from QuanTB. See figure attached called "Exception Import Excel". It seems to be because QuanTB exports to excel version 1997-2003.
- Another exception was caught when using excel previously exported from QuanTB, but updated to the latest version of Excel. See attached: exception screenshot called "Exception Import Excel 2", Excel file and QTB file.
Suggestions:
- Change exportation from QuanTB to excel worksheet (latest version).
- In the first situation mentioned above (potentially due to version incompatibility), instead of displaying an exception show a warning message: "The worksheet version your are trying to import is incompatible. Please update to the lastest version."
- Change the label at the menu from "Medicines Stock" to "Stock on hand".
- Implement same logic of importation for Stock on order as well.
#5
Updated by Oleksii Kurasov over 9 years ago
- Due date changed from 06/02/2015 to 10/26/2015
- Assignee changed from Oleksii Kurasov to Luis Gustavo do Valle Bastos
Currently I disabled any file types except XLSX for import and changed menu label. Please, define as separate issues exportation to xlsx format and exportation stocks of order. I think these tasks have very different priorities.
#6
Updated by Luis Gustavo do Valle Bastos over 9 years ago
- File Exception import Oct 30.JPG added
- File 2015-10-30err.qtb added
- Assignee changed from Luis Gustavo do Valle Bastos to Oleksii Kurasov
- The second exception mentioned above still persists. As before it happened when trying to import from the excel "Test Two" to the qtb file "Test importing Excel". Both already attached before.
- See also the new screenshot and the error log file attached.
#7
Updated by Oleksii Kurasov over 9 years ago
- Due date changed from 10/26/2015 to 11/05/2015
- Status changed from Feedback to Resolved
- Assignee changed from Oleksii Kurasov to Luis Gustavo do Valle Bastos
Should be tested again :(
#8
Updated by Luis Gustavo do Valle Bastos over 9 years ago
- File Import excel error message.jpg added
- File Import excel labels.JPG added
- Status changed from Resolved to Feedback
- Assignee changed from Luis Gustavo do Valle Bastos to Oleksii Kurasov
- Change the message "MEDICINE NAME batches not defined. Please check Excel data" to "MEDICINE NAME expiration date and quantity must be defined. Please correct and try again." See file "Import excel error message" attached.
- Change the title of the dialog box from "Import from Excel" to "Import from Excel - Stock on hand". If the importation of stock on order will be using the same dialog box, so no change is required.
- Change the label in the dialog box from "Imported medicine" to "Medicine to import".
See file "Import excel labels" attached.
#9
Updated by Oleksii Kurasov over 9 years ago
- Due date changed from 11/05/2015 to 11/18/2015
- Status changed from Feedback to Resolved
- Assignee changed from Oleksii Kurasov to Luis Gustavo do Valle Bastos
#10
Updated by Luis Gustavo do Valle Bastos over 9 years ago
- Status changed from Resolved to Closed
Tested and adequate.