#READWRITE GITHUB FOR BEGINNERS CODE#

The purpose of this blog is to get you familiar with using GitHub, and then by the time you're creating scripts and code to automate your DDI environment, you'll know exactly what to do. I personally got started several years ago learning helping out with Cisco DevNet instructions on GitHub.

I use the word code very loosely here, because you can also do things like write and track documentation, course instructions, or even books in GitHub. The term 'git' describes a distributed version control system designed by Linus Torvalds (creator of Linux) which allows users to easily find code, keep track of versioning, and modify code as needed. GitHub is a very popular service which allows people to store their code in containers called repositories. But there's a ton of Git and GitHub information out there to help you with these concepts and, of course, we're here to help if you have questions, as well! What is GitHub? This blog is meant more to familiarize you with concepts using the Micetro documentation as an agent to help you learn. Luckily Men&Mice provides our documentation repo publicly on GitHub for you to see and play around with.ĭocumentation is a really safe place to get started and don't worry, we won't let you publish anything inaccurate.

#READWRITE GITHUB FOR BEGINNERS HOW TO#

If you enjoy what you read here, feel free to sign up for my monthly newsletter to catch up on all things learning, edtech and storytelling.Ĭreating a Catalogue in Google Sheets by Aaron Davis is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.Getting started with automating your network management? Understanding how to use Git tools like GitHub is a great place to start. Therefore, I will stick to using various formulas to filter out the data for me. However, that is beyond my current skillset and patience level to dig any further at this point. I feel that it would be plausible to find a different script (see for example these examples from Alice Keeler, mesgarpour and Spreedsheet Dev) that might do some other things, such as run the process as a cron job or pull only the desired data. It is definitely easier to pass on to somebody else. I also like the idea of using the SWITCH formula to manage which folders are displayed. Ideally, if creating this solution from scratch, I would probably have started each folder with a prefix indicating which area it belonged to, therefore avoiding the need for the SWITCH formula. =SORT(QUERY(IMPORTRANGE('/spreadsheets/d/./edit','Sheet2!A:D'),'SELECT Col1,Col4,Col3 WHERE Col4 is NOT NULL'),2,FALSE) With this addition column, I then used a QUERY to capture the title, area and link to present as a directory in a separate spreadsheet to share with a wider audience: 'ICON General Information','General Information', 'End of Year 2020 - eHR & Payroll Guide','eHR', I then copied this list into the SWITCH formula and added in the commas: =IFNA(SWITCH(B1:B, Once I had these two columns complete, I used this formula to add quotation marks to them all: =ArrayFormula(''''&Sheet1!A:D&'''') After culling the list, I then added the area in the cell next to each folder. To create the SWITCH, I created a UNIQUE list of all the folders and then pasted them as values so that I could delete those not required to be displayed in the directory. Therefore to manage this, I used a SWITCH formula to create a new column updating the folder name to the overall area it belonged to.

#READWRITE GITHUB FOR BEGINNERS UPDATE#

Therefore, it had become manual heavy exercise to refresh the data and update the directory meaning it did not happen that regularly.Īfter looking at the list and the current finished product and the list produced using File Cabinet, I realised that rather than displaying the sub-folder, that the directory was showing a top level folder. In addition to that, there were some folders and files listed that needed to be removed. Whereas the output focused on file, folder and link, the list produced using File Cabinet included other information such as owner, creation date and file size.

The problem with this list is that the exported data was not in the desired format. The current workflow involved using an Add-on File Cabinet from the developers behind Awesome Table to generate a list. This folder also included a number of folders within folders, which created a level of complexity. I was recently asked to have a look at spreadsheet that listed all the guides and videos located in a support folder as a reference.

Readwrite github for beginners