1
00:00:00,300 --> 00:00:07,380
Hey, and welcome our to our GSV section, so this one actually came to me from a student that was looking

2
00:00:07,380 --> 00:00:13,630
for a way to export data into a CSFI for their Web users to be able to download.

3
00:00:13,920 --> 00:00:19,380
So I created a little mini application and then I took it a step further, added the ability to get

4
00:00:19,380 --> 00:00:21,640
that information from a Google spreadsheet.

5
00:00:21,930 --> 00:00:27,660
So this is going to be taking essentially an array using that array format and generating a CSFI all

6
00:00:27,660 --> 00:00:28,890
using JavaScript.

7
00:00:29,070 --> 00:00:33,660
And the nice thing about it is this is really useful because once you tie it to a Google spreadsheet,

8
00:00:33,870 --> 00:00:37,980
then when you update the content in the Google spreadsheet, all the users come to your website are

9
00:00:37,980 --> 00:00:41,190
going to have a new version of content that they can download.

10
00:00:41,310 --> 00:00:44,340
And you don't have to give them access to your Google spreadsheet.

11
00:00:44,350 --> 00:00:45,800
So that's a really nice thing about it.

12
00:00:45,930 --> 00:00:52,080
And let me show you so I'm excited to show you this as this is a really unique approach to doing this

13
00:00:52,080 --> 00:00:52,520
format.

14
00:00:52,800 --> 00:00:54,330
So going over to Google.

15
00:00:54,330 --> 00:00:59,040
So whenever you have a Google spreadsheet, you can output the content as JSON format.

16
00:00:59,280 --> 00:01:05,410
And that's what we're using in order to generate the array that gets used to generate the CSV file.

17
00:01:05,520 --> 00:01:09,600
And then the downloadable CSV file as well is done via JavaScript.

18
00:01:09,600 --> 00:01:12,450
So that's just a few lines of code that enable us to do that.

19
00:01:12,630 --> 00:01:17,160
So we get JSON data and we pass through that Jason data.

20
00:01:17,310 --> 00:01:24,810
We develop and we construct an array, so we construct the array for the CSFI and then once we've created

21
00:01:24,810 --> 00:01:30,270
it, we can download and we can open up CSV file and you can see all of the content that's going to

22
00:01:30,360 --> 00:01:31,350
be contained in this.

23
00:01:31,470 --> 00:01:35,390
So this was just generated, just created in a second open up.

24
00:01:35,400 --> 00:01:38,310
So it's getting the content directly from the Google spreadsheet.

25
00:01:38,620 --> 00:01:39,510
This is a fun one.

26
00:01:39,510 --> 00:01:40,410
Do try this out.

27
00:01:40,410 --> 00:01:43,380
And it is a unique approach to generating CSP files.