This article describes the process to copying data from Reloading Studio to a spreadsheet. .
Reloading Studio is a reloading data management software. Fundamentally, it’s here to help you manage data and keep your data safe. As such it does not prevent you from accessing your data directly or exporting data into other tools.
It’s important to note that some of the data models (e.g. relationships between various components and firearms) that you have built inside the application are complex and cannot be represented in a generic spreadsheet. However, we try our best to assist you with data export.
Exporting data tables
In all component screens and some advanced options screen, you will see 2 versions of a ‘copy data’ buttons.
In component screens
While the actual table shows summary data, the copy feature will copy all data and make it available to ‘paste’ in to your favourite text editor or spreadsheet application.
Images cannot be inserted into a text editor or spreadsheet application. To solve this issue, export feature will list all file names of the attached files.
Also see: Where is my data.
By knowing the associated filenames, these file attachments can be copied from the application data directory.
In advanced options screens
This button will copy the entire number series form the table and make it available to ‘paste’ in to your favourite text editor or spreadsheet application.
Exporting load data
This is a technical topic and assumes advanced level of understanding, including HTML, JSON and ‘view source’ function of your web browser.
Exporting load data is complex, because this data model includes multiples screens, options, media types and free-form notes. Exporting this data (with all relationships) in a linear record (for example, in to Excel) is near impossible and unusable for humans. Instead, this data can be extracted using a ‘Print load recipe report’ feature, in JSON format.
After the report is opened in a web browser we will need to view page source:
In the ‘view-source’ screen, scroll all the way to the bottom of the page until you see the following section markers:
- // <!– data entry start –>
- // <!– data entry end –>
Between these two markers is a JSON object representing your batch report. You can copy this object out of the report and programmatically process it into a format that you require.
Please note, if you are diving into this level of detail, please don’t hesitate to get in touch and we may be able to assist you with advice and existing tools that we may have built during development.