Offline CSV export to an Excel Report Format
Excel Reports are not available offline on the installed version of the software. To enable users to export their data out of the system offline and then paste it into an existing Excel Report users can now generate a csv. in the same format as an Excel report (for one specific data type).
This workflow is specifically for users who need to export data out of the system working offline to paste it into an existing Excel Report
Excel Reports are not available offline
A workaround to enable users to update their Excel Reports from data entered offline is now available. Firstly, open a previously generated Excel Report from your computer
The image here shows an Excel Report that has been opened and needs to be updated with data entered offline. The example here shows an Anthropometry and YoYo Excel Report. Now go back to the system to generate a csv export of the data that is used in the Excel Report (e.g. the Anthropometry Event Form and the YoYo Event Form).
Go to the system and run a report to show the latest data that has been entered offline
The example in the image here shows a report being generated for the Yoyo data. Then click on the Excel button to generate a csv report.
Click on Excel (top right) and then select "Export in Excel Report Format" the Data in the same format as the Excel Report that you are going to update
You can now select to export out all of the data in a column format that is the same as the data columns in the Excel Reports generated from the Excel Reports Module. This will download a csv. file:
-This could be Full Export in Excel Report Format
or
-Export Selected Columns Only in Excel Report Format
Open the csv output (as shown here), copy the data and paste it into the Original Excel Report
Copy the Data from the Report Output and Paste it into the Excel Spreadsheet
Once you have pasted in the Data Refresh the Report. If you need additional data from different Event Forms export it and paste it in
0 Comments
Add your comment