The fewer number of required generic icons also brings a uniformity to the diagram. (1) Informative and Uniform – Generic icons tell you the purpose of the device (ie: router, switch, etc), while a physical stencil must be recognized and interpreted by somebody familiar with the look of the specific product and what that product does. While many engineers prefer to use a physical stencil, which is essentially a picture of the actual device (with ports, fans, rack ears…), I prefer to use generic topology icons.
You can download this article’s template file using the link to the right. So I just call them “Physical” and “Logical” to avoid the confusion. It also removes the assumption (made by many non-technical people) that “L1” and “元” diagrams are incomplete without a “L2” diagram. I prefer to use the term “physical” instead of “L1” because it is more easily understood by somebody unfamiliar with the OSI model. (and consider deleting the personal access token on github).This article is a quick tutorial for creating and maintaining a physical network diagram. Then open the file with '|' as the column delimiter. bin/hub.exe issue -s all -f "%U|%t|%S|%cI|%uI|%L%n" outfile.csv and remember to cd (change directory) to the repository of interest! Then enter a line like: Here I presume the file is infile.txt in the repository's base directory. the first line is your github user name and on the 2nd line paste the personal access token, followed by a newline (so that both lines will processed when input to hub). bin directory).Ĭreate a github personal access token and copy the token text string to the clipboard.Ĭreate a text file (such as in notepad) to use as the input file to hub.exe.
the issues are loading in your spreadsheet and you are in businessĪs a one-time task, building on 'hub'-based recommendation from on a windows system with GitBash prompt already installed:ĭownload the latest hub executable (such as Windows 64 bit) and extract it (hub.exe is in the.click the "Done" button on the Advanced Editor, then "Close and Load" from the tool bar.now you click on "Advanced Editor" and paste the above query.in the editor, choose "New Query", "Other Sources", "Blank query".in a new sheet, on the "Data" tab, open the "Get Data" drop-down.If you have more, you need to duplicate the query (for page 2 etc) and combine the results. I just find it simpler to go the anonymous route in the query setup and instead provide the readily formatted request header.Īlso, this works for repos with up to 100 open issues. You can authenticate explicitly from Excel with the user and key if you don't want to deal with the token. I have tested the URL with a Chrome REST plugin and got the token from entering the user and api key there. Obviously, you also have to fill in your own organization name and repo name into the URL, and obtain the auth token.
I added and then removed columns in this and did not clean this up - feel free to do that before you use it.
In the mean time, if you have jq and curl, you can do this in two lines using something like the following example that outputs issue number, title and labels (tags) and works for private repos as well (if you don't want to filter by label, just remove the labels=)
It is unfortunate that does not make this easier.