S3: E1 | Preparing Data

Data Import reads your existing spreadsheets or CSV files and imports them into the dashboard. 

To prepare your data for importing make sure that it meets the dashboard’s requirements. 

Data Requirements

Your spreadsheet needs to contain a header row and all columns should be titled.

One column should identify the asset you’re recording data on. Data Import assigns this to an asset. 

One of the columns should record the date when the event occurred. Data Import assigns this to the date column in the event table. 

Editing Your Spreadsheet

Find and open the spreadsheet you’d like to import to GlasCore. 

Remove all of the unnecessary information, but make sure that all the columns have titles and that there’s a date column identifying when the data was collected (event).

To change your spreadsheet into a CSV format go to file and click on export. Select CSV and save the file to your computer. 

If you’re having trouble preparing your data please visit our FAQ or Community pages. Please don’t hesitate to contact us if you can’t find a solution —we’re always happy to help. You can submit a support ticket on our Support page. 

S3: E2 | Importing Data to a New Topic

Data Import reads your existing spreadsheets or CSV files and imports them into the dashboard. 

Make sure your data meets the dashboard’s requirements. Go to Preparing Your Data if you’d like to see the requirements.

Go to the Toolshed and open Data Import.

Click Start an Import and select the data file from your computer. 

Select Create a New Topic and enter a topic name. Create a name that focuses on the subject of the data. 

Select the column identifying the assets. Assets are the source of the data, e.g. a cow, tractor, supplier.

Select the date column. If there’s more than one date column you’ll need to select the one recording the date or time when the event took place.

Select the columns you’d like imported into the dashboard. You can select as many as you’d like. 

If you’re having trouble importing your data please visit our FAQ or Community pages. Please don’t hesitate to contact us if you can’t find a solution —we’re always happy to help. You can submit a support ticket on our Support page.

S3: E3 | Importing to an Existing Topic

Data Import reads your existing spreadsheets or CSV files and imports them into the dashboard. 

To prepare your data for importing make sure that it meets the dashboard’s requirements. 

Go to the Toolshed and open Data Import.

Click Start an Import and select the data file from your computer. 

Select Add to an Existing Topic. Now, select a topic from the drop-down bar.

Select the column identifying the assets. Assets are the source of the data, e.g. a cow, tractor, supplier.

Select the date column. If there’s more than one date column you’ll need to select the one recording the date or time when the event took place.

Select the columns you’d like to import into the dashboard. You can select as many as you’d like. 

If you’re having trouble importing your data please visit our FAQ or Community pages. Please don’t hesitate to contact us if you can’t find a solution —we’re always happy to help. You can submit a support ticket on our Support page.