Releases: C-Accel-CRIPT/cript-excel-uploader
v1.0.1
v1.0.0
Version 1.0.0
Release Notes
Version
Version 1.0.0 does not have any breaking changes from v0.6.3 and is instead symbolic that CRIPT Excel Uploader is now stable and released. There are some new features with Excel Uploader 1.0.0
Excel Uploader Executable
- Feature: added ability to upload Property Methods for material and process sheet
- Feature: added Mac executable along with documentation on how to run it
- Feature: added “update_existing” for material sheet
- This feature was needed when users wants to add more characteristics to a material they have already uploaded. Previously the user would have to create a whole new material every time they upload, however, with this new feature they can
- add a column
- Row 1: property
- Row 2: update_existing
- Row 3: blank
- Row 4: instructions
- Row 5: Indicate TRUE when using it and False or blank when not using it
- sheets its available:
- Materials
- To learn more please refer to Material sheet within the documentation
Excel Template
- Feature: added and updated autofill for Property Methods for material sheet
- Feature: added and updated autofill options for process sheet
- Feature: added property:condition dropdowns
v0.6.3
v0.6.2
v0.6.1
Excel Template Changes
- Autocomplete has been updated from our newest additions and updates of controlled vocabulary. The dropdown list is very large but is not a comprehensive list of every single possible value for row 2 (column name).
- There have been more additions to the instructions rows that were previously blank.
- The template has been update to have less formulas and validations which should make it load faster, be smaller, and easier to work with.
- The Excel template example has been updated accordingly to use the newest Excel template.
There is documentation written for the Excel template that explains the Excel template in more details.
Executable Changes
- Bug fix: addressed issues where the program would freeze during the upload process
- The program should not freeze again
- Bug fix: updated broken documentation link on the start screen of the GUI
- Bug fix: improved start screen feedback as sometimes it would give the wrong feedback
- Feature: added upload again from the success screen
- User no longer needs to close the executable and reopen to upload a second file
- Feature: turning cursor into not allowed icon to indicate to the user they need to use the button
v0.6.0
Alpha version 0.6.0
Release Notes
This release includes several of breaking changes.
Graphical User Interface
This release includes a Graphical User Interface (GUI) for the Excel uploader instead of the terminal that was provided in previous releases. Users can now download the proper executable for their operating system and run that via double click. Users can also run the GUI from their terminal as well. The current documentation has been updated as well to reflect all changes.
New Excel template
This release also provides a new and improved Excel template that comes with autofill feature. Users can now click on row 2 (column names) and pick from a list of available columns options that each sheet supports. Once an options is selected, row 1 (category), row 3 (unit), and row 4 (instructions) are populated based on the selected option. This is much more convenient for users as they no longer need to think about any other details except what they want to record in the Excel sheets.
Excel Template New Autofill feature
The autofill is fairly new and has some drawbacks as well. Firstly, as controlled vocabulary is updated and changed within the CRIPT website, the Excel sheets does not have the ability to get the newest vocabulary and instead will keep the vocabulary that it came with at the time it was released. This could result in the Excel sheet giving validation errors that your new key that you got from CRIPT controlled vocabulary is not valid when in fact it is, but Excel is not aware of the changes on the CRIPT website, and therefore might give you warnings. If there are any issues with the controlled vocabulary or any errors at all the CRIPT Excel Uploader will show them as errors that you can easily fix.
Besides the autofill feature the new Excel template includes a 4th row which is an instructions row that helps simplify the values that can be recorded in that row. This too comes with the same drawbacks of the instructions could become outdated.
For most complete and up to date list of vocabulary please always check the CRIPT controlled vocabulary page.
Converting Past Excel Files to Latest Version
The previous Excel files can be easily compatible with the newest release by simply inserting a blank 4th row in all Excel sheets.
This is because the newest program knows that row 4 are instructions and therefore just skips that row and starts expecting user input from row 5.
Past versions Excel template
Past version upgraded to new version
