# Replace the json files with google sheets **URL:** \ **Category:** SEF site\ **Created:** [June 14, 2021, 12:21pm UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296 "2021-06-14T12:21:28Z")\ **Posts on this page:** 20\ **Page:** 4
**Author:** ![YohanAvishke](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/yohanavishke/32/106_2.png) [@YohanAvishke](https://sef.discourse.group/u/YohanAvishke)\ **Post date:** [July 21, 2021, 9:22am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/61 "2021-07-21T09:22:05Z")
Great job @Gajindu_Bandara . BTW there are few more mentor headshots that needs to be added > **[Welcome to your new HQ](https://sefheadquarters.slack.com/?redir=%2Farchives%2FC01B9280W4E%2Fp1626814109016700)** > > Slack is a new way to communicate with your team. It’s faster, better organized, and more secure than email. Can you please help @Dharana_J with it? ---
**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\ **Post date:** [July 21, 2021, 11:48am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/62 "2021-07-21T11:48:55Z")
Sure! I’ll help him with that ---
**Author:** ![Akeel\_malik](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/akeel_malik/32/666_2.png) [@Akeel\_malik](https://sef.discourse.group/u/Akeel_malik)\ **Post date:** [July 21, 2021, 3:16pm UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/63 "2021-07-21T15:16:47Z")
[Replace ScholarX 2021 mentor’s images with Cloudinary URLs · Issue #1036 · sef-global/sef-site (github.com)](https://github.com/sef-global/sef-site/issues/1036) please grant edit access into the spreadsheet to update the URLs. Thank you ---
**Author:** ![Akeel\_malik](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/akeel_malik/32/666_2.png) [@Akeel\_malik](https://sef.discourse.group/u/Akeel_malik)\ **Post date:** [July 22, 2021, 7:54am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/64 "2021-07-22T07:54:25Z")
[Replace ScholarX 2021 mentor’s images with Cloudinary URLs by akeel230 · Pull Request #1042 · sef-global/sef-site (github.com)](https://github.com/sef-global/sef-site/pull/1042) [Replace ScholarX 2020 mentor’s images with Cloudinary URLs by akeel230 · Pull Request #1041 · sef-global/sef-site (github.com)](https://github.com/sef-global/sef-site/pull/1041) Updated both mentors images(2020,2021) in google sheets with cloudinary URLs… ---
**Author:** ![Akeel\_malik](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/akeel_malik/32/666_2.png) [@Akeel\_malik](https://sef.discourse.group/u/Akeel_malik)\ **Post date:** [July 23, 2021, 5:55am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/65 "2021-07-23T05:55:47Z")
[Replace ScholarX 2019 mentor’s images with Cloudinary URLs by akeel230 · Pull Request #1045 · sef-global/sef-site (github.com)](https://github.com/sef-global/sef-site/pull/1045) Updated mentors images(2019) in google sheets with cloudinary URLs… ---
**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\ **Post date:** [July 26, 2021, 8:40am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/67 "2021-07-26T08:40:44Z")
In the last dev standups meeting, we discussed adding a preloader to the web pages. Because some pages are consuming some time to load the data to the site, especially after replacing the JSON files. So for that, I worked with that preloader thing. I found out some gifs for preloaders. Can you guys choose one from below @akshika47 [@EngTeam](https://sef.discourse.group/groups/engteam) ![](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/798cdfa436741cfaf7985de76ba1b52440ff5ea3.gif) 1 ![](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/19f4ebb689884c146adca8b2986650551ae0a90f.gif) 2 ![](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/2f1e02f7cce5ea215c673d90ee3f8beb3b701705.gif) 3 ![](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/ccebfe2e27aeea55b56e38fa8cff9744b2c164ea.gif) 4 ![](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/66cfcadfcba7abcc7627292a17a493b529d754a1.gif) 5 ![](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/65167302cf6423f5b15aaff973f7d9e599d3f9dd.gif) 6 ![](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/2910c47d9ad84e531ddbddc1f2b7fa0b27356553.gif) 7 ![](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/98554b2ba456b2b5cf469db8de27441ed3c69e8d.gif) 8 ![](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/35d9cfa093cfa53d644fecb50917b9b9480deb8c.gif) 9 ---
**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\ **Post date:** [July 27, 2021, 6:43am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/68 "2021-07-27T06:43:33Z")
I created an issue for the preloader thing 😁 > > > \*\*Is your feature request related to a problem? Please describe.\*\* > The team pag…e is taking some time to load the data to the page. It shows as in below for few seconds > > !\[Screenshot from 2021-07-27 12-09-23\](https://user-images.githubusercontent.com/63200586/127107642-87e7139c-f360-45d3-a9dd-4752d0a7e798.png) > \*\*Describe the solution you'd like\*\* > Add a preloader to the team page to avoid that ---
**Author:** ![akshika47](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/akshika47/32/993_2.png) [@akshika47](https://sef.discourse.group/u/akshika47)\ **Post date:** [July 27, 2021, 7:30am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/69 "2021-07-27T07:30:56Z")
@Gajindu_Bandara can you make your choices a poll? So people can pick their best or the ones they like? ---
**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\ **Post date:** [July 27, 2021, 8:11am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/71 "2021-07-27T08:11:54Z")
Vote for a gif from the above list _Poll ([view on site](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/71))_ ---
**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\ **Post date:** [August 2, 2021, 3:43am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/72 "2021-08-02T03:43:16Z")
So I guess we have to choose one preloader among the top two 😁 . Guys, please vote again to chose one from the below [@EngTeam](https://sef.discourse.group/groups/engteam) @akshika47 [https://global.discourse-cdn.com/free1/uploads/sef/original/1X/798cdfa436741cfaf7985de76ba1b52440ff5ea3.gif](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/798cdfa436741cfaf7985de76ba1b52440ff5ea3.gif) A [https://global.discourse-cdn.com/free1/uploads/sef/original/1X/35d9cfa093cfa53d644fecb50917b9b9480deb8c.gif](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/35d9cfa093cfa53d644fecb50917b9b9480deb8c.gif) B _Poll ([view on site](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/72))_ ---
**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\ **Post date:** [August 5, 2021, 7:01am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/73 "2021-08-05T07:01:18Z")
Then I’ll use “B” as the selected preloader to the site 😁 ---
**Author:** ![jaye](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/jaye/32/810_2.png) [@jaye](https://sef.discourse.group/u/jaye)\ **Post date:** [August 6, 2021, 8:53am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/74 "2021-08-06T08:53:32Z")
I know this is overdue. To be honest, I don’t like animations. The most appropriate way is displaying a [skeleton](https://uxdesign.cc/what-you-should-know-about-skeleton-screens-a820c45a571a?gi=bd3aa11ba5d4). But we don’t need to make it much complex. A simple “Loading…” text seems professional than using animation for me. Just my 2 cents. Also I saw that it was a full page animation in your [Pull Request.](https://github.com/sef-global/sef-site/pull/1073). Adding the loader within only the loading area would better instead of displaying a full page because it breaks breaks the flow when switching between pages. A good study : [https://uxdesign.cc/what-you-should-know-about-skeleton-screens-a820c45a571a?gi=bd3aa11ba5d4](https://uxdesign.cc/what-you-should-know-about-skeleton-screens-a820c45a571a?gi=bd3aa11ba5d4) Cc: @akshika47 ---
**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\ **Post date:** [August 6, 2021, 10:20am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/75 "2021-08-06T10:20:59Z")
Then I’ll use "Loading… " for the relevant sections on the page without using the full page preloader. But until the profiles are loaded the page only shows the topics and “Loading…” marks in the relevant sections. Is it ok ?? @jaye ---
**Author:** ![akshika47](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/akshika47/32/993_2.png) [@akshika47](https://sef.discourse.group/u/akshika47)\ **Post date:** [August 6, 2021, 1:45pm UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/76 "2021-08-06T13:45:40Z")
I agree with @jaye here! ---
**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\ **Post date:** [August 8, 2021, 8:24am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/77 "2021-08-08T08:24:27Z")
As everyone requested to use skeleton loading profiles rather than using a full-screen preloader animation, I worked on that and came up with a solution and demonstrated it at the last dev team weekly standups meeting and did some corrections as requested in that meeting 😁 , So this is the final view.WDYT??? 🤔@akshika47 [@EngTeam](https://sef.discourse.group/groups/engteam) ![pre](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/41bdd2d3824f8c90790dd4254ec0743c36593c4a.gif) ---
**Author:** ![jaye](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/jaye/32/810_2.png) [@jaye](https://sef.discourse.group/u/jaye)\ **Post date:** [August 8, 2021, 8:28am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/78 "2021-08-08T08:28:25Z")
This is next level!!! 😍 ---
**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\ **Post date:** [August 8, 2021, 8:29am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/79 "2021-08-08T08:29:45Z")
Is this ok or is there anything to be improved 😀 ---
**Author:** ![jaye](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/jaye/32/810_2.png) [@jaye](https://sef.discourse.group/u/jaye)\ **Post date:** [August 8, 2021, 9:46am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/80 "2021-08-08T09:46:49Z")
Shall we remove the smaller lines from the skeleton? The simpler, the better. ---
**Author:** ![akshika47](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/akshika47/32/993_2.png) [@akshika47](https://sef.discourse.group/u/akshika47)\ **Post date:** [August 8, 2021, 10:12am UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/81 "2021-08-08T10:12:08Z")
Yeah! love this Gajindu and agree with Jaye’s comments as well. ---
**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\ **Post date:** [August 8, 2021, 1:16pm UTC](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296/82 "2021-08-08T13:16:25Z")
Ok! I’ll remove them 😁 [Previous page](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296.md?page=3) [Next page](https://sef.discourse.group/t/replace-the-json-files-with-google-sheets/296.md?page=5)