1
00:00:11,800 --> 00:00:13,300
Hello I’m Ted Shields.

2
00:00:13,300 --> 00:00:15,300
Today I’m going to show
you a feature we have

3
00:00:15,300 --> 00:00:16,766
in the Olympus Scientific Cloud

4
00:00:16,766 --> 00:00:20,266
that takes the data from the
JSON format that it’s stored in,

5
00:00:20,266 --> 00:00:24,200
in the cloud, which is a very common
format for software developers,

6
00:00:24,200 --> 00:00:26,566
and convert it into a CSV format

7
00:00:26,566 --> 00:00:30,200
that’s used for most
spreadsheet programs.

8
00:00:30,200 --> 00:00:31,933
So, first of all, we need to

9
00:00:31,933 --> 00:00:37,233
log in to the
Olympus Scientific Cloud.

10
00:00:37,233 --> 00:00:38,966
Go to the tools section,

11
00:00:38,966 --> 00:00:41,966
and then the JSON to CSV manager.

12
00:00:41,966 --> 00:00:44,100
We do it with the idea of a template

13
00:00:44,100 --> 00:00:47,100
so you can create a new template
with any name that you want,

14
00:00:47,100 --> 00:00:50,200
just be sure to choose
the Vanta shot template

15
00:00:50,200 --> 00:00:51,966
because we’re going
to be creating templates

16
00:00:51,966 --> 00:00:54,133
for other instruments as well.

17
00:00:54,133 --> 00:00:55,533
But I’ve already made one

18
00:00:55,533 --> 00:00:57,966
so let’s look at the one
I’ve already made

19
00:00:57,966 --> 00:01:02,766
by looking at the pencil icon to edit.

20
00:01:02,766 --> 00:01:04,966
So we come here, we see
we’ve got a serial number,

21
00:01:04,966 --> 00:01:07,666
we’re including that with a checkmark.

22
00:01:07,666 --> 00:01:09,800
And we also have the ability to rename

23
00:01:09,800 --> 00:01:15,433
any of the data headers that we
have with any other name

24
00:01:15,433 --> 00:01:18,500
if your data conventions
have something different.

25
00:01:18,500 --> 00:01:20,733
So we’ve also got the elevation,

26
00:01:20,733 --> 00:01:24,933
latitude and longitude,
so those are from our GPS.

27
00:01:24,933 --> 00:01:27,766
If we scroll down further
we’ve also got things like

28
00:01:27,766 --> 00:01:32,833
chemistry which is a
key part of our data.

29
00:01:32,833 --> 00:01:35,866
And for alloy users we’ve got
grade match information

30
00:01:35,866 --> 00:01:37,833
so you can choose
whatever it is you want

31
00:01:37,833 --> 00:01:42,100
from the full export in the JSON file.

32
00:01:42,100 --> 00:01:44,833
So once you’ve chosen what you want

33
00:01:44,833 --> 00:01:47,033
you can save your changes
so I’ve already done that

34
00:01:47,033 --> 00:01:48,800
so we’ll just cancel out here.

35
00:01:48,800 --> 00:01:51,366
And then to use it we’re going
to need to go to the data,

36
00:01:51,366 --> 00:01:53,166
and we’re going to need
to select some data

37
00:01:53,166 --> 00:01:54,833
so let’s choose an instrument

38
00:01:54,833 --> 00:01:57,566
and a data range and search
and find some data.

39
00:01:57,566 --> 00:01:58,800
We’ve done that.

40
00:01:58,800 --> 00:02:01,800
To get it to export
we can add those results

41
00:02:01,800 --> 00:02:04,966
to our cloud export
which we now see up here.

42
00:02:04,966 --> 00:02:06,166
Select that.

43
00:02:06,166 --> 00:02:09,966
The important part of this is that
you need to select the CSV

44
00:02:09,966 --> 00:02:12,066
rather than the JSON format.

45
00:02:12,066 --> 00:02:13,700
And then you select the template.

46
00:02:13,700 --> 00:02:17,233
I’m going to select the template
that we’ve just done and looked at.

47
00:02:17,233 --> 00:02:20,166
And then download.

48
00:02:20,166 --> 00:02:23,700
And with that download
you now have an email

49
00:02:23,700 --> 00:02:26,433
that has a link to the CSV information

50
00:02:26,433 --> 00:02:29,266
so that you can import that into
any spreadsheet program

51
00:02:29,266 --> 00:02:32,300
that you want
in the format that you need.

52
00:02:32,300 --> 00:02:34,266
So I hope you found this
to be a useful tool

53
00:02:34,266 --> 00:02:35,866
and thank you for watching.