Staff have complained about the Mac version of the Symphony Report to Barcode Program. This app even though made for windows will serve as a guidline for developing the macOS version of this app.
The app should take a report generated by Symphony Workflows and parse through the information within and once done report to the user what its status is and if successful export the data to an excel spreadsheet with propper formatting.
The app will use EPPlus. EPPlus is library created by Jan Kallman which gives users the ability to generate, read & edit .xlsx files. The benefits of using this compared to Office.Excel.Interop is that having excel installed on the host machine is not a requirement making it compatible on a mac machine also
Firstly it'll ask for the class / location that the report will be for. The program will then ask for the directory that the symphony report is stored in. The final prompt will be that for the output location (where the .xlsx should save to). Once pointed to the directory the program will parse through the data and remove any unnecessary data. It will then move the parsed data to an .xlsx document. which would be kept in local storage. Student IDs should be written in the font Free 3 of 9 extended with an appropriate font size.
If done correctly the program will export an xlsx file that contains all users and their barcodes (Student Id), all of which should be properly spaced appart and easy to read.