Welcome to Importing Data

in this series, you'll find out how to prepare and import your data from any source.

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.

S3: E4 | Column Calculations

Video tutorial coming soon!

Column Calculations allow you to add, subtract, divide or multiply the values of your columns. To calculate the value of your columns go to My Data and to the asset you’d like to like to do a column calculation.

In the top right corner of the asset card there’s a ADD COLUMN button, click on that and the New Column box will appear. Now click on the Data Type box and a list will appear. At the bottom of the list you’ll find Special Formats, click on Function in this section and Function Builder will appear below. 

Now you can start writing your calculation. When you’re writing your calculation use the following operations on your keyboard + to add, – to subtract, * to multiply and / to divide. Use the arrows and enter keys to select columns from the list. Each item in your calculation will turn blue when it’s selected. 

Before creating your new column make sure you’ve given it a title. And once that’s done click CREATE COLUMN. 

If you’re having trouble, please visit our FAQ and Community pages. Don’t hesitate to contact us if you can’t find a solution; we really value your feedback and aim to make your experience as easy as possible. You can submit a support ticket right here. And don’t forget to follow us on Twitter, Facebook and LinkedIn!

S3: E5 Writing Notes

Video tutorial coming soon!

You can jot down any information you’d like to save for later in GlasCore. To do this go to My Data.

In the bottom right corner of the screen you’ll see a green circle with a +, click on that and the New Topic box will appear. Enter the name of your topic; something to do with notes will make it easier for you to find in the future. When you’ve named your topic click CREATE TOPIC and it should appear on your data page along with all your other topics.

Now, click on the topic. So an asset needs to be created; it’s the same process as creating a topic. Go to the green + circle in the bottom right corner of the screen and select it. Give the new asset a name, click CREATE ASSET and it should appear in the topic. 

Click on the asset, so that it takes you to the asset card. In the top right corner of the asset card you’ll see + ADD COLUMN, click there. Enter the column name and then click on Data Type. From the drop down list select Text from Standard Formats; it’s at the top of the list. Once you’ve selected Text and given the column a name click CREATE COLUMN. 

To enter notes stay on the asset card and at the bottom of the card click + ADD ROW FOR NOTES. In the New Event box you can type your notes on the bottom line and when you’re finished click CREATE EVENT.

If you’re having trouble, please visit our FAQ and Community pages. Don’t hesitate to contact us if you can’t find a solution; we really value your feedback and aim to make your experience as easy as possible. You can submit a support ticket right here. And don’t forget to follow us on Twitter, Facebook and LinkedIn!