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

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

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

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

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

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

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

You should be able to copy and paste any data that you use from your exc

0 Comments

Add your comment

E-Mail me when someone replies to this comment