shell – Data Science, Data Analytics and Machine Learning Consulting in Koblenz Germany https://www.rene-pickhardt.de Extract knowledge from your data and be ahead of your competition Tue, 17 Jul 2018 12:12:43 +0000 en-US hourly 1 https://wordpress.org/?v=4.9.6 Cleaning up my network connections on ubuntu linux using the network manager nmcli https://www.rene-pickhardt.de/cleaning-up-my-network-connections-on-ubuntu-linux-using-the-network-manager-nmcli/ https://www.rene-pickhardt.de/cleaning-up-my-network-connections-on-ubuntu-linux-using-the-network-manager-nmcli/#respond Thu, 16 Apr 2015 19:03:34 +0000 http://www.rene-pickhardt.de/?p=1955 After 4 years of running a pretty stable linux on my notebook I realized that the time had come that too much software and dependencies have been on my system so I set up a clean system. By doing so I also switched to a tiling window manager called awesome (with which I am pretty happy so far). One problem (not really since it is the purpose of going to awesome) though is that everything has to be done from the command line. in particular when I join a network I have to use the network manager command line interface nmcli to set up my wireless connection or my wired connection. That is not too much of a problem but since I did a backup of all my old network connections I had quite a list of connections too look for in order to find the uuid of the network I wanted to join and enable the network with the suitable command. So I wanted to delete all the connections from hotels, airports and places that I am not visiting anymore. Obviously I could have done this by hand. But its much more fun to do it automatically and on the long term it is really faster when you are mastering your bash tools (:
So here we go with a step by step explanation of the following command that will remove all your network connections that you have never used:

$ for i in `nmcli c | grep "never" | grep -o -- "[0-9a-fA-F]\{8\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{12\}"` ; do nmcli connection delete uuid $i ; done

ok let us first see the connections that I had in my manager

$ nmcli connection

which would give me the following list

NAME UUID TYPE TIMESTAMP-REAL
Lobby 0f91bb0d-e2be-4f8a-a00e-457c8bdaf9a9 802-11-wireless never
TTH-Zentral 2d3ddca9-772f-47d9-99a1-1559640b0f25 802-11-wireless never
attwifi 6be3c5aa-fc85-415c-96e4-5583b25c23bb 802-11-wireless never
uni-koblenz 8a0d1d51-672c-4ded-ad92-18e27b8215df 802-11-wireless Do 16 Apr 2015 18:11:45 CEST
greenscafe 22dd0f8e-be2d-4402-af82-7716222add75 802-11-wireless never
WLAN-2DD138 5308ed9e-5def-430e-85f4-e1eb01426927 802-11-wireless never
Fairfield_GUEST b72080e0-c5dd-492a-b8a3-017fe7d6099c 802-11-wireless never
Hotel Sylter Hof d7c8fc6c-64e3-435f-b2c0-316c1f11ddf1 802-11-wireless never
TELENETHOTSPOT 1345bcda-26ab-4193-904c-088235d29873 802-11-wireless never
CHI_ECRC_2013 a316f6be-bb4c-4501-867b-6928f9f429ef 802-11-wireless never
AndroidAP5270 b5c5462c-072e-4e90-a3b2-def467562579 802-11-wireless never
hotel_harvey 7c6d1794-6d45-40aa-b7ac-f9a7f401d02e 802-11-wireless never
free-hotspot.com dc7351ce-ca6c-413e-ae8b-a82c2093525e 802-11-wireless never
PAT-WLAN 4662b075-9519-4f69-8ce9-b938ea8270c1 802-11-wireless never
dlink 5dab3493-cdd8-4d6c-a7a2-6def0836c2a5 802-11-wireless never
TTHKasse b9c2f9d9-aeda-454b-941b-bb1ccfc0ad9a 802-11-wireless never
BTOpenzone-B bede9d3a-9fc1-4dc2-9c75-0d2686c225f1 802-11-wireless never
MBTA_WIFI_Car0385_Box-068 17ac549c-574c-4bf4-a464-6b633f2a4ac3 802-11-wireless never
Wireless connection 1 17b18b79-411d-4d69-813d-6506f38b8ea5 802-11-wireless never
MBTA_WiFi_Car0620_Box-199 c36c572e-e469-4e86-a50f-87d6d68f4f7e 802-11-wireless never
*VIPARIS_WIFI 0593b927-644b-4604-a479-4fc652b6050d 802-11-wireless never
test 836af61a-8268-4a16-a5ab-036f3e0cf7e9 802-11-wireless So 15 Sep 2013 21:18:35 CEST
WL1A 46b6496f-6583-4306-a58f-4e4d2bdd5d50 802-11-wireless never
Hochhaus f6b80571-37d5-4bcd-b558-62084c61622b 802-11-wireless never
FreeWifi 379f9efd-b91d-433f-8ce2-209e4ed2099b 802-11-wireless never
NETCONNECT-6202 2f84b475-a852-49ac-a236-61b3f0bc9548 802-11-wireless never
stolteraa d789f49e-2643-4894-96a8-4e10ea3cbb69 802-11-wireless never
ALICE-WLAN28 17e4838f-bbaf-470c-bf24-9de948b42b00 802-11-wireless never
NAS QNAP ef6a08df-1c7c-48ba-b476-f3ff3b1e2669 802-3-ethernet Mi 15 Apr 2015 11:03:51 CEST
WLAN-8CA902 3046307e-69a3-4c99-89fb-b79f7f9ee24b 802-11-wireless Mi 01 Apr 2015 11:42:27 CEST
MfN-Guest 25d3765f-dcca-4f40-872a-8ffcfe307f25 802-11-wireless never
FRITZ!Box Fon WLAN 7360 7c428f50-078d-442a-9ba7-268853c888f0 802-11-wireless Mo 11 Feb 2013 23:39:08 CET
Arcor-362007-L 87a2d11c-3a3d-4b5e-a1b0-cc5b38916035 802-11-wireless Di 14 Apr 2015 17:42:33 CEST
Telekom_ICE 8763adcc-f27b-441f-9184-594128871351 802-11-wireless So 29 Mär 2015 19:56:35 CEST
IBMVISITOR 48227bb6-63e8-4a58-8b8f-1929f76d8ef2 802-11-wireless never
OWL 13ff2ed5-8ecf-4d67-b039-a3bc4cce56d9 802-11-wireless never
Parkhotel Kraehennest e763a256-4a2d-4813-b354-57ad8f642e2a 802-11-wireless never
EasyBox-AD3112 e4f342ae-d20b-4abc-9fe2-52b208d6b61b 802-11-wireless never
BTOpenzone 860cf4c0-45eb-4a57-a01e-cfd54933387f 802-11-wireless never
southshore 274cfaa8-2c08-4abc-bef3-3fd2608060b8 802-11-wireless never
annanet 06b3b3bc-a264-4d05-a848-3b5d6df9eed0 802-11-wireless never
shared 806c9806-fadc-472f-8460-318babbd38ea 802-3-ethernet Fr 10 Apr 2015 09:39:50 CEST
vidiu 3abf0848-b09c-457e-9c7a-958728f2c59f 802-11-wireless never
wlan 1 ad9e4a07-b66f-4f3f-8f6d-4f5a81b2ed54 802-11-wireless never
CITYHOTEL dec05243-06b6-4477-8813-0491b436f993 802-11-wireless never
eduroam f844713b-a726-4b5b-98a5-3b35411c4cf5 802-11-wireless never
Starlight-HotSpot 6842159f-94e9-4f5d-8a76-93b1f4c32912 802-11-wireless never
Dr_l)P35_21_22#342C5C e307b6e8-598b-4bd1-b47f-dc8a34ff12e0 802-11-wireless never
iPhone 5 9070ee1c-8ac1-4458-a590-cf241685b929 802-11-wireless never
Lummerland 7d2d4d89-9eb7-45c0-a963-a8a240e33100 802-11-wireless Mo 10 Feb 2014 22:35:03 CET
AndroidAP4089 ec201acc-9e6f-4c7b-9da8-6ed4539dde6c 802-11-wireless never
heartofgold 437e2b7d-5b76-4e3e-a101-698776293ede 802-11-wireless never
09FX09039648 e2cc4508-e18e-4c0c-a694-633ace5d095a 802-11-wireless never
WIRELESS_BEN_GURION_AIRPORT 8ff2846d-9e84-4175-8c4d-968e226e7a43 802-11-wireless never
Telekom 60aded97-f697-48c6-8070-91e1b786df82 802-11-wireless Mi 15 Apr 2015 00:14:14 CEST
Marriott_CONF a4ec2c22-8a31-46bb-a146-a02d8f7b2582 802-11-wireless never
TTH-Seminar4+5 23422256-0a4b-45b5-8394-43c92592564d 802-11-wireless never
FRITZ!Box 7330 SL a431f83e-6a73-4cf1-94ee-4409c19dfdb9 802-11-wireless Do 13 Feb 2014 18:45:48 CET
mycloud f3fcf1ae-eebb-4e37-a700-96035d0aea59 802-11-wireless never
ArcorWirelessLAN 428769c9-3dfc-43f0-a2dc-29f3c4ecb0fb 802-11-wireless never
TP-LINK_PocketAP_7329E2 a17a19b4-251e-41d7-a82e-1add52ec1317 802-11-wireless never
TTH-Taunus fbb24cae-c2aa-4057-be67-095b80604f5e 802-11-wireless never
BWI-WiFi 58e749f6-58e9-44fe-8528-6a1e3bacc88f 802-11-wireless never
uni vpn b28d76f8-57d2-4548-8959-9c47e189221e vpn never
Miri 🙂 74147f40-07c4-4e91-8a43-8c69bc733479 802-11-wireless never
wiew7 7193e045-9570-4d16-b4b6-d676fc19d05a 802-11-wireless never
ZurichAirport 0fe8cde1-de8b-48f9-9ca0-52ac129e9876 802-11-wireless never
mercure f3fbf40d-7c2b-4e6d-b5db-fce6888bb719 802-11-wireless never
HITRON-A600 501ac6d9-6912-46a1-9681-4a73e1009fe0 802-11-wireless never
HTC Portable Hotspot 61EF 3675cadc-251a-487c-8c4d-cf3747117f13 802-11-wireless never
FRITZ!Box 7312 a7d9b99d-63bc-4caa-b82c-1da9fec95cea 802-11-wireless never
o2-WLAN38 76a67dd7-3d50-4388-ba9f-07f52a328eca 802-11-wireless never
ALICE-WLAN36 e55d0ccd-7941-4da0-8ac8-99ed22adda49 802-11-wireless never
WEBPORTAL e2ce59eb-fa7d-4ece-88b7-bd0585a8d589 802-11-wireless never
FOSDEM 0cc3584b-1a5e-41fd-944e-df85f0a2d418 802-11-wireless never
BRITZ!Fox Fon WLAN 7360 SL fc70206c-04c8-4ae6-a0fd-7f769addf0b6 802-11-wireless never
Hotel Amsee3 f4ff9826-22d2-4f9b-91d9-8c63dc0f9bd4 802-11-wireless So 29 Mär 2015 11:56:21 CEST
ibis a348ed30-2fcf-4068-ba1c-176cdd9e7b10 802-11-wireless never
O2 Wifi 8935490d-313f-4fd0-b1fd-c78ab138af51 802-11-wireless never
FRITZ!Box Fon WLAN 7270 50d62587-5a48-4635-b30f-fbb1ded20455 802-11-wireless Di 30 Dez 2014 12:23:23 CET
Ambassador-Opera fdefea8c-d218-4632-bb07-b67ddb63f778 802-11-wireless never
HOTEL BB 05d9792c-6f9e-48a6-9c0c-6c03a9708954 802-11-wireless never
MBTA_WiFi_Car0353_Box-104 24a1527c-3083-44f3-8812-cacafb88cf7a 802-11-wireless never
theairline 54770eb9-78f2-4a3b-86cf-0e594a55c9f9 802-11-wireless never
republicansareontheirown 074ca340-643c-411e-95eb-d6e78f887fcf 802-11-wireless never
VPN/WEB 4a5f132b-81c2-49ba-8934-0257f98e5a54 802-11-wireless never
WLAN-6A1EA7 d2e80ec0-9bd3-4801-bada-65a695f7dc92 802-11-wireless never
Mahler 1d59c9a1-090c-4333-b2af-4154d5edd9c2 802-11-wireless never
guest-access c0ff03ac-a195-46a7-a507-5c1cf5c7f668 802-11-wireless never
Schlummerland 3d029511-2627-458a-a06b-e2c8e86d26b4 802-11-wireless never
MSDSL2 f2fbd0b7-26f6-4939-aece-c2c9d3621e40 802-11-wireless Do 16 Apr 2015 20:28:22 CEST
Urania 846e76bc-b96f-40aa-a30f-b6d2f84fd7f0 802-11-wireless never
CJDDSAWLN 55158cdb-07cc-4c02-8f44-a19ec2aeca06 802-11-wireless never
AndroidAP 375e398a-1b2e-4d2e-b4a5-4c05c904b109 802-11-wireless Fr 02 Jan 2015 16:29:17 CET
gesis-guest b9a00edd-9e28-4549-8f13-2634577c1276 802-11-wireless never
guests@WMDE 9aeccb7b-e629-4f0a-ab81-5300c7c433c0 802-11-wireless never
Wired connection 1 30ffcf0e-5181-41b0-b7d4-402de875889f 802-3-ethernet Mo 04 Mär 2013 15:10:44 CET
wlan a2f073a8-f0b0-4f58-a79a-2f22131016b1 802-11-wireless never
Wired connection 2 700ebb58-f049-4ec7-bac6-cd5801a975e2 802-3-ethernet Do 16 Apr 2015 18:11:44 CEST
Wired connection 3 bf70a943-9510-4883-ba64-a4bede826120 802-3-ethernet Do 16 Apr 2015 09:26:08 CEST
30 Min. Free Wi-Fi - Vodafone f5cd9efa-d735-41d5-a90f-ba83357f2e40 802-11-wireless never
WIKIMEDIA a40d0c35-8232-42db-b5a2-2118d69d6c41 802-11-wireless never
loganwifi 41e42d9c-efe9-45c5-9f8e-a2f5f441dd73 802-11-wireless never
WL3D efe99726-557a-4595-90e8-9c0fc3ee0c20 802-11-wireless never
m3connect 6ce7f634-5c44-4818-a055-cb32dca20738 802-11-wireless never
MIRI-PC_Network d1243377-9aed-4abf-8207-90b47840a48f 802-11-wireless never
innflux bd5be404-6a8b-402a-8a6f-856eaa054664 802-11-wireless never
LRTA24open2 dc95a098-107f-46c9-8d36-23cf575a319f 802-11-wireless never
LRTA24open3 5166cb9a-20ff-4d5c-b224-88f0b2276398 802-11-wireless never
Boingo Hotspot 954559e9-5f8c-4f9b-b2bc-36ff23f18d4a 802-11-wireless never

the interesting part is the fourth column which is luckily saying never if a connection was never used. so that is an easy grep:

nmcli c | grep "never"

from this list I need the second colum in particular the uuids. I could have done this with some awk magic but I decided greping for uuids should be easier so lets pipe the output to another grep:

nmcli c | grep "never" | grep -o -- "[0-9a-fA-F]\{8\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{12\}"

as we can see the regular expression is really straight forward. there are two arguments given first of all -o that is to only output what was matched and not the complete lines and the helps for greping hyphens. The cool thing is with having the web and search engines you don’t even have to build this regular expression on your own. Click on my search query for an blog article explaining the background: grep regular expression uuid
Next we have to iterate over the result and use it in the nwcli connection delete command. From the docu of nmcli we know

Usage: nmcli connection { COMMAND | help }
COMMAND := { list | status | up | down | delete }
list [id | uuid ]
status [id | uuid | path ]
up id | uuid [iface ] [ap ] [--nowait] [--timeout ]
down id | uuid
delete id | uuid

so the code should look something like:

nmcli connection delete uuid 954559e9-5f8c-4f9b-b2bc-36ff23f18d4a

only that 954559e9-5f8c-4f9b-b2bc-36ff23f18d4a will be replaced by all the uuids from my grep statements.
so let’s put this big grep in a loop and just echo everything to see if it is working. just use backticks around the grep and make a loop:

$ for i in `nmcli c | grep "never" | grep -o -- "[0-9a-fA-F]\{8\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{12\}"` ; do echo $i ; done
0f91bb0d-e2be-4f8a-a00e-457c8bdaf9a9
2d3ddca9-772f-47d9-99a1-1559640b0f25
6be3c5aa-fc85-415c-96e4-5583b25c23bb
22dd0f8e-be2d-4402-af82-7716222add75
5308ed9e-5def-430e-85f4-e1eb01426927
b72080e0-c5dd-492a-b8a3-017fe7d6099c
d7c8fc6c-64e3-435f-b2c0-316c1f11ddf1
1345bcda-26ab-4193-904c-088235d29873
a316f6be-bb4c-4501-867b-6928f9f429ef
b5c5462c-072e-4e90-a3b2-def467562579
7c6d1794-6d45-40aa-b7ac-f9a7f401d02e
dc7351ce-ca6c-413e-ae8b-a82c2093525e
4662b075-9519-4f69-8ce9-b938ea8270c1
5dab3493-cdd8-4d6c-a7a2-6def0836c2a5
b9c2f9d9-aeda-454b-941b-bb1ccfc0ad9a
bede9d3a-9fc1-4dc2-9c75-0d2686c225f1
17ac549c-574c-4bf4-a464-6b633f2a4ac3
17b18b79-411d-4d69-813d-6506f38b8ea5
c36c572e-e469-4e86-a50f-87d6d68f4f7e
0593b927-644b-4604-a479-4fc652b6050d
46b6496f-6583-4306-a58f-4e4d2bdd5d50
f6b80571-37d5-4bcd-b558-62084c61622b
379f9efd-b91d-433f-8ce2-209e4ed2099b
2f84b475-a852-49ac-a236-61b3f0bc9548
d789f49e-2643-4894-96a8-4e10ea3cbb69
17e4838f-bbaf-470c-bf24-9de948b42b00
25d3765f-dcca-4f40-872a-8ffcfe307f25
48227bb6-63e8-4a58-8b8f-1929f76d8ef2
13ff2ed5-8ecf-4d67-b039-a3bc4cce56d9
e763a256-4a2d-4813-b354-57ad8f642e2a
e4f342ae-d20b-4abc-9fe2-52b208d6b61b
860cf4c0-45eb-4a57-a01e-cfd54933387f
274cfaa8-2c08-4abc-bef3-3fd2608060b8
06b3b3bc-a264-4d05-a848-3b5d6df9eed0
3abf0848-b09c-457e-9c7a-958728f2c59f
ad9e4a07-b66f-4f3f-8f6d-4f5a81b2ed54
dec05243-06b6-4477-8813-0491b436f993
f844713b-a726-4b5b-98a5-3b35411c4cf5
6842159f-94e9-4f5d-8a76-93b1f4c32912
e307b6e8-598b-4bd1-b47f-dc8a34ff12e0
9070ee1c-8ac1-4458-a590-cf241685b929
ec201acc-9e6f-4c7b-9da8-6ed4539dde6c
437e2b7d-5b76-4e3e-a101-698776293ede
e2cc4508-e18e-4c0c-a694-633ace5d095a
8ff2846d-9e84-4175-8c4d-968e226e7a43
a4ec2c22-8a31-46bb-a146-a02d8f7b2582
23422256-0a4b-45b5-8394-43c92592564d
f3fcf1ae-eebb-4e37-a700-96035d0aea59
428769c9-3dfc-43f0-a2dc-29f3c4ecb0fb
a17a19b4-251e-41d7-a82e-1add52ec1317
fbb24cae-c2aa-4057-be67-095b80604f5e
58e749f6-58e9-44fe-8528-6a1e3bacc88f
b28d76f8-57d2-4548-8959-9c47e189221e
74147f40-07c4-4e91-8a43-8c69bc733479
7193e045-9570-4d16-b4b6-d676fc19d05a
0fe8cde1-de8b-48f9-9ca0-52ac129e9876
f3fbf40d-7c2b-4e6d-b5db-fce6888bb719
501ac6d9-6912-46a1-9681-4a73e1009fe0
3675cadc-251a-487c-8c4d-cf3747117f13
a7d9b99d-63bc-4caa-b82c-1da9fec95cea
76a67dd7-3d50-4388-ba9f-07f52a328eca
e55d0ccd-7941-4da0-8ac8-99ed22adda49
e2ce59eb-fa7d-4ece-88b7-bd0585a8d589
0cc3584b-1a5e-41fd-944e-df85f0a2d418
fc70206c-04c8-4ae6-a0fd-7f769addf0b6
a348ed30-2fcf-4068-ba1c-176cdd9e7b10
8935490d-313f-4fd0-b1fd-c78ab138af51
fdefea8c-d218-4632-bb07-b67ddb63f778
05d9792c-6f9e-48a6-9c0c-6c03a9708954
24a1527c-3083-44f3-8812-cacafb88cf7a
54770eb9-78f2-4a3b-86cf-0e594a55c9f9
074ca340-643c-411e-95eb-d6e78f887fcf
4a5f132b-81c2-49ba-8934-0257f98e5a54
d2e80ec0-9bd3-4801-bada-65a695f7dc92
1d59c9a1-090c-4333-b2af-4154d5edd9c2
c0ff03ac-a195-46a7-a507-5c1cf5c7f668
3d029511-2627-458a-a06b-e2c8e86d26b4
846e76bc-b96f-40aa-a30f-b6d2f84fd7f0
55158cdb-07cc-4c02-8f44-a19ec2aeca06
b9a00edd-9e28-4549-8f13-2634577c1276
9aeccb7b-e629-4f0a-ab81-5300c7c433c0
a2f073a8-f0b0-4f58-a79a-2f22131016b1
f5cd9efa-d735-41d5-a90f-ba83357f2e40
a40d0c35-8232-42db-b5a2-2118d69d6c41
41e42d9c-efe9-45c5-9f8e-a2f5f441dd73
efe99726-557a-4595-90e8-9c0fc3ee0c20
6ce7f634-5c44-4818-a055-cb32dca20738
d1243377-9aed-4abf-8207-90b47840a48f
bd5be404-6a8b-402a-8a6f-856eaa054664
dc95a098-107f-46c9-8d36-23cf575a319f
5166cb9a-20ff-4d5c-b224-88f0b2276398
954559e9-5f8c-4f9b-b2bc-36ff23f18d4a

that looks great so replace the echo with the real command:

nmcli connection delete uuid $i

this will lead to the follwing final command which is identical to the one on the top of the article but just with some line breaks for better readability.

$ for i in `nmcli c | \
grep "never" | \
grep -o -- "[0-9a-fA-F]\{8\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{4\}-[0-9a-fA-F]\{12\}"` ; \
do nmcli connection delete uuid $i ; \
done

Now I only have a few connections in my network manager so that I can easily switch connections from the command line depending on where I am:

$ nmcli c
NAME UUID TYPE TIMESTAMP-REAL
AndroidAP 375e398a-1b2e-4d2e-b4a5-4c05c904b109 802-11-wireless Fr 02 Jan 2015 16:29:17 CET
FRITZ!Box 7330 SL a431f83e-6a73-4cf1-94ee-4409c19dfdb9 802-11-wireless Do 13 Feb 2014 18:45:48 CET
NAS QNAP ef6a08df-1c7c-48ba-b476-f3ff3b1e2669 802-3-ethernet Mi 15 Apr 2015 11:03:51 CEST
MSDSL2 f2fbd0b7-26f6-4939-aece-c2c9d3621e40 802-11-wireless Do 16 Apr 2015 20:28:22 CEST
shared 806c9806-fadc-472f-8460-318babbd38ea 802-3-ethernet Fr 10 Apr 2015 09:39:50 CEST
Hotel Amsee3 f4ff9826-22d2-4f9b-91d9-8c63dc0f9bd4 802-11-wireless So 29 Mär 2015 11:56:21 CEST
Lummerland 7d2d4d89-9eb7-45c0-a963-a8a240e33100 802-11-wireless Mo 10 Feb 2014 22:35:03 CET
FRITZ!Box Fon WLAN 7270 50d62587-5a48-4635-b30f-fbb1ded20455 802-11-wireless Di 30 Dez 2014 12:23:23 CET
Arcor-362007-L 87a2d11c-3a3d-4b5e-a1b0-cc5b38916035 802-11-wireless Di 14 Apr 2015 17:42:33 CEST
Telekom 60aded97-f697-48c6-8070-91e1b786df82 802-11-wireless Mi 15 Apr 2015 00:14:14 CEST
Wired connection 3 bf70a943-9510-4883-ba64-a4bede826120 802-3-ethernet Do 16 Apr 2015 09:26:08 CEST
FRITZ!Box Fon WLAN 7360 7c428f50-078d-442a-9ba7-268853c888f0 802-11-wireless Mo 11 Feb 2013 23:39:08 CET
test 836af61a-8268-4a16-a5ab-036f3e0cf7e9 802-11-wireless So 15 Sep 2013 21:18:35 CEST
Wired connection 1 30ffcf0e-5181-41b0-b7d4-402de875889f 802-3-ethernet Mo 04 Mär 2013 15:10:44 CET
Telekom_ICE 8763adcc-f27b-441f-9184-594128871351 802-11-wireless So 29 Mär 2015 19:56:35 CEST
Wired connection 2 700ebb58-f049-4ec7-bac6-cd5801a975e2 802-3-ethernet Do 16 Apr 2015 18:11:44 CEST
WLAN-8CA902 3046307e-69a3-4c99-89fb-b79f7f9ee24b 802-11-wireless Mi 01 Apr 2015 11:42:27 CEST
uni-koblenz 8a0d1d51-672c-4ded-ad92-18e27b8215df 802-11-wireless Do 16 Apr 2015 18:11:45 CEST

]]>
https://www.rene-pickhardt.de/cleaning-up-my-network-connections-on-ubuntu-linux-using-the-network-manager-nmcli/feed/ 0
Analyzing the final and intermediate results of the iversity MOOC Fellowship online voting https://www.rene-pickhardt.de/analyzing-the-final-and-intermediate-results-of-the-iversity-mooc-fellowship-online-voting/ https://www.rene-pickhardt.de/analyzing-the-final-and-intermediate-results-of-the-iversity-mooc-fellowship-online-voting/#comments Thu, 23 May 2013 23:07:24 +0000 http://www.rene-pickhardt.de/?p=1609 As writen before Steffen and I participated in the online voting for the MOOC fellowship. Today the competition finished and I would like to say thank you to everyone who so far participated in the voting in particular to the 435 people supporting our course. I did never image to get that many people to be interested in our course!
The voting period went from May first till today. During this period the user interface of the iversity website changed several times providing different kind of information about the voting to us users. Since I have observed a drastic change in rankings on May 9th and since the process and scores have not been very transparent I have decided on that very day to collect some data about the rankings. I already did some quick analysis on the data and found some interesting facts but I am running out of time right now to conduct an extensive data analysis. So I will share the data set with the public domain:
http://rene-pickhardt.de/mooc.tar.bz2 (33MB)
If you download the zip file and extract it you’ll find folders for every hour after May 9th. In every folder you will find 26 html-files representing the current ranking of the courses at that time and a transaction log of the http-requests which were done to download the 26 html files. There are 26 html files since 10 courses were displayed per page and we had 255 courses participating.
During the time of data collection I had 2 or 3 short down times of my web server so it could be possible that some data points are missing.
I already wrote a “dirty hack” and pushed it on github which also extracts the interesting information out of the downloaded html files.

  1. There is a file rank.tsv (334 kb) that displays for every course on an hourly basis the rankings
  2. There is a file vote.tsv (113 kb) that contains for every course on an hourly basis (between may 20th and today) the number of votes the course did acquire. The period of time for vote.tsv is so short since the votes have only been available in the html files during this time. 

Skimming the data with my eyes there are already some facts that make me very curious for a deeper data analysis:

  1. Some courses gained several hundred votes within a short period of time (usually only 2 or 3 hours) whereas most courses (especially those gaining such a large amount of votes) often stayed far under 1000 votes at all. 
  2. Also it is interesting to see how much variation has been going on in the last couple of days. 
  3. Also I haven’t crawled the views of the Youtube videos of the courses and even now after observing the following I did not take a snapshot of them it is interesting that there is such a large difference in conversion rate. Especially the top courses seem to have much more votes than they have views of the application video. Where some really high class and outstanding applications like the ones from Chrstian Spannagel (Math) or  Oliver Vornberger (Algorithms and data structures) have two or three times as many views on Youtube as votes. Especially they have about the same amount of views on Youtube as the top voted courses.

I am pretty sure there are some more interesting facts and maybe someone else has collected a better data set over the complete periode of time and including Youtube snapshots as well as Facebook and Twitter mentions.
Since I have been asked several times already: here are the final rankings to download and also as a table in the blog post:

  Kursname Anzahl an votes
1 sectio chirurgica anatomie interaktiv 8013
2 internationales agrarmanagement 2 7557
3 ingenieurmathematik fur jedermann 2669
4 harry potter and issues in international politics 2510
5 online surgery 2365
6 l3t s mooc der offene online kurs uber das lernen und lehren mit technologien 2270
7 design 101 or design basics 2 2216
8 einfuhrung in das sozial und gesundheitswesen sozialraume entdecken und entwickeln 2124
9 changeprojekte planen nachhaltige entwicklung durch social entrepreneurship 2083
10 social work open online course swooc14 2059
11 understanding sustainability environmental problems collective action and institutions 1912
12 the dance of functional programming languaging with haskell and python 1730
13 zyklenbasierte grundung systematische entwicklung von geschaftskonzepten 1698
14 a virtual living lab course for sustainable housing and lifestyle 1682
15 family politics domestic life revolution and dictatorships between 1900 1950 1476
16 h2o extrem 1307
17 dark matter in galaxies the last mystery 1261
18 algorithmen und datenstrukturen 1207
19 psychology of judgment and decision making 1168
20 the future of storytelling 1164
21 web engineering 1152
22 die autoritat der wissenschaften eine einfuhrung in das wissenschaftstheoretische denken 2 1143
23 magic and logic of music a comprehensive course on the foundations of music and its place in life 1138
24 nmooc nachhaltigkeit fur alle 1130
25 sovereign bond pricing 1115
26 soziale arbeit eine einfuhrung 1034
27 mathematische denk und arbeitsweisen in geometrie und arithmetik 1016
28 social entrepreneurship wir machen gesellschaftlichen wandel moglich 1010
29 molecular gastronomy an experimental lecture about food food processing and a bit of physiology 984
30 fundamentals of remote sensing for earth observation 920
31 kompetenzkurs ernahrungswissenschaft 891
32 erfolgreich studieren 879
33 deciphering ancient texts in the digital age 868
34 qualitative methods 861
35 karl der grosse pater europae 855
36 who am i mind consciousness and body between science and philosophy 837
37 programmieren mit java 835
38 systemisches projektmanagement 811
39 lernen ist sexy 764
40 modelling and simulation using matlab one mooc more brains an interdisciplinary course not just for experts 760
41 suchmaschinen verstehen 712
42 hands on course on embedded computing systems with raspberry pi 679
43 introduction to mixed methods and doing research online 676
44 game ai 649
45 game theory and experimental economic research 633
46 cooperative innovation 613
47 blue engineering ingenieurinnen und ingenieure mit sozialer und okologischer verantwortung 612
48 my car the unkown technical being 612
49 gesundheit ein besonderes gut eine multidisziplinare erkundung des deutschen gesundheitssystems 608
50 teaching english as a foreign language tefl part i pronunciation 597
51 wie kann lesen gelernt gelehrt und gefordert werden lesesozialisation lesedidaktik und leseforderung vom grundschulunterricht bis zur erwachsenenbildung 593
52 the european dream 576
53 education of the present what is the future of education 570
54 faszination kristalle und symmetrie 561
55 italy today a girlfriend in a coma a walk through today s italy 557
56 dna from structure to therapy 556
57 grundlagen der mensch computer interaktion 549
58 malnutrition in developing countries 548
59 marketing als strategischer erfolgsfaktor von der produktinnovation bis zur kundenbindung 540
60 environmental ethics for scientists 540
61 stem cells in biology and medicine 528
62 praxiswissen fur den kunstlerischen alltagsdschungel 509
63 physikvision 506
64 high five evidence based practice 505
65 future climate water 484
66 diversity and communication challenges for integration and mobility 477
67 social entrepreneurship 469
68 die kunst des argumentierens 466
69 der hont feat mit dem farat wek wie kinder schreiben und lesen lernen 455
70 antikrastination moocen gegen chronisches aufschieben 454
71 exercise for a healthier life 454
72 the startup source code 438
73 web science 435
74 medizinische immunologie 433
75 governance in and through human rights 431
76 europe in the world law and policy aspects of the eu in global governance 419
77 komplexe welt strukturen selbstorganisation und chaos 419
78 mooc basics of surgery want to become a real surgeon 416
79 statistical data analysis for the humanities 414
80 business math r edux 406
81 analyzing behavioral dynamics non linear approaches to social and cognitive sciences 402
82 space technology 397
83 der erzahler materialitat und virtualitat vom mittelalter bis zur gegenwart 396
84 kriminologie 395
85 von e mail skype und xing kommunikation fuhrung und berufliche zusammenarbeit im netz 394
86 wissenschaft erzahlen das phanomen der grenze 392
87 nachhaltige entwicklung 389
88 die nachste gesellschaft gesellschaft unter bedingungen der elektrizitat des computers und des internets 388
89 die grundrechte 376
90 medienbildung und mediendidaktik grundbegriffe und praxis 368
91 bubbles everywhere speculative bubbles in financial markets and in everyday life 364
92 the heart of creativity 363
93 physik und weltraum 358
94 sim suchmaschinenimplementierung als mooc 354
95 order of magnitude physics from atomic nuclei to the universe 350
96 entwurfsmethodik eingebetteter systeme 343
97 monte carlo methods in finance 335
98 texte professionell mit latex erstellen 331
99 wissenschaftlich arbeiten wissenschaftlich schreiben 330
100 e x cite join the game of social research 330
101 forschungsmethoden 323
102 complex problem solving 321
103 programmieren lernen mit effekt 317
104 molecular devices and machines 317
105 wie man erfolgreich ein startup aufbaut 315
106 grundlagen der prozeduralen und objektorientierten programmierung 314
107 introduction to disability studies 314
108 eu2c the european union explained by two partners cologne and cife 313
109 the english language a linguistic introduction 2 311
110 allgemeine betriebswirtschaftslehre 293
111 interaction design open design 293
112 how we learn nowadays possibilities and difficulties 288
113 foundations of educational technology 288
114 projektmanagement und designbasiertes lernen 281
115 human rights 278
116 kompetenz des horens technische gehorbildung 278
117 it infrastructure management 276
118 a media history in 10 artefacts 274
119 introduction to the practice of statistics and regression 271
120 what is a good society introduction to social philosophy 268
121 modellierungsmethoden in der wirtschaftsinformatik 265
122 objektorientierte programmierung von web anwendungen von anfang an 262
123 intercultural diversity networking vielfalt interkulturell vernetzen 260
124 foundations of entrepreneurship 259
125 business communication for impact and results 257
126 gamification 257
127 creativity and design in innovation management 256
128 mechanik i 252
129 global virtual project management 252
130 digital signal processing for everyone 249
131 kompetenzen fur klimaschutz anpassung 248
132 digital economy and social innovation 246
133 synthetic biology 245
134 english phonetics and phonology 245
135 leibspeisen nahrung im wandel der zeiten molekule brot kase fleisch schokolade und andere lebensmittel 243
136 critical decision making in the contemporary globalized world 238
137 einfuhrung in die allgemeine betriebswirtschaftslehre schwerpunkt organisation personalmanagement und unternehmensfuhrung 236
138 didaktisches design 235
139 an invitation to complex analysis 235
140 grundlagen der programmierung teil 1 234
141 allgemein und viszeralchirurgie 233
142 mathematik 1 fur ingenieure 231
143 consumption and identity you are what you buy 231
144 vampire fictions 230
145 grundlagen der anasthesiologie 228
146 marketing strategy and brand management 227
147 political economy an introduction 225
148 gesundheit 221
149 object oriented databases 219
150 lebenswelten perspektiven fur menschen mit demenz 217
151 applications of graphs to real life problems 210
152 introduction to epidemiology epimooc 207
153 network security 207
154 global civics 207
155 wissenschaftliches arbeiten 204
156 annaherungen an zukunfte wie lassen sich mogliche wahrscheinliche und wunschbare zukunfte bestimmen 202
157 einstieg wissenschaft 200
158 engineering english 199
159 das erklaren erklaren wie infografik klart erklart und wissen vermittelt 198
160 betriebswirtschaftliche und rechtliche grundlagen fur das nonprofit management 192
161 art and mathematics 191
162 vom phanomen zum modell mathematische modellierung von natur und alltag an ausgewahlten beispielen 190
163 design interaktiver medien technische grundlagen 189
164 business englisch 187
165 erziehung sehen analysieren gestalten 184
166 basic clinical research methods 184
167 ordinary differential equations and laplace transforms 180
168 mathematische logik 179
169 die geburt der materie in der evolution des universums 179
170 innovationsmanagement von kleinen und mittelstandischen unternehmen kmu 176
171 introduction to qualitative methods in the social sciences 175
172 advert retard wirkung industrieller interessen auf rationale arzneimitteltherapie 175
173 animation beyond the bouncing ball 174
174 entropie einfuhrung in die physikalische chemie 172
175 edufutur education for a sustainable future 165
176 social network effects on everyday life 164
177 pharmaskills for africa 163
178 nachhaltige energiewirtschaft 162
179 qualitat in der fruhpadagogik auf den anfang kommt es an 158
180 dementias 157
181 beyond armed confrontation multidisciplinary approaches and challenges from colombia s conflict 154
182 investition und finanzierung 150
183 praxis des wissensmanagements 149
184 gutenberg to google the social construction of the communciations revolution 145
185 value innovation and blue oceans 145
186 kontrapunkt 144
187 shakespeare s politics 142
188 jetzt erst recht wissen schaffen uber recht 141
189 rechtliche probleme von sozialen netzwerken 138
190 augmented tuesday suppers 137
191 positive padagogik 137
192 digital storytelling mit bewegenden bildern erzahlen 136
193 wirtschaftsethik 134
194 energieeffizientes bauen 134
195 advising startups 133
196 urban design and communication 133
197 bildungsreform 2 0 132
198 mooc management basics 130
199 healthy teeth a life long course of preventive dentistry 129
200 digitales tourismus marketing 127
201 the arctic game the struggle for control over the melting ice 127
202 disease mechanisms 127
203 special operations from raids to drones 125
204 introduction to geospatial technology 120
205 social media marketing strategy smms 119
206 korpusbasierte analyse sprechsprachlichen problemlosungsverhaltens 116
207 introduction to marketing 115
208 creative coding 114
209 mooc meets 3d 110
210 unternehmenswert die einzig sinnvolle spitzenkennzahl fur unternehmen 110
211 forming behaviour gestaltung und konzeption von web applications 109
212 technology demonstration 108
213 lebensmittelmikrobiologie und hygiene 105
214 estudi erfolgreich studieren mit dem internet 105
215 moderne geldtheorie eine paische perspektive 103
216 kollektive intelligenz 103
217 geschichte der optischen medien 100
218 alter und soziale arbeit 99
219 semantik eine theorie visueller kommunikation 97
220 erziehung und beratung in familie und schule 96
221 foreign language learning in indian context 95
222 bildgebende verfahren 92
223 applied biology 92
224 bildung in der wissensgesellschaft gerechtigkeit 92
225 standortmanagement 92
226 europe a solution from history 90
227 methodology of research in international law 90
228 when african americans came to paris 90
229 contemporary architecture 89
230 past recent encounters turkey and germany 88
231 wars to end all wars 83
232 online learning management systems 82
233 software applications 81
234 business in germany 78
235 requirements engineering 77
236 anything relationship management xrm 77
237 global standards and local practices 76
238 prodima professionalisation of disaster medicine and management 75
239 cytology with a virtual correlative light and electron microscope 75
240 the organisation of innovation 75
241 sensors for all 75
242 diagnostik in der beruflichen bildung 73
243 scientific working 71
244 escience saxony lectures 71
245 internet marketing strategy how to gain influence and spread your message online 69
246 grundlagen des e business 69
247 principles of public health 64
248 methods for shear wave velocity measurements in urban areas 64
249 democracy in america 64
250 building typology studies gebaudelehre 63
251 multi media based learning environments at the interface of science and practice hamburg university of applied sciences prof dr andrea berger klein 61
252 math mooc challenge 60
253 the value of the social 58
254 dienstleistungsmanagement und informationssysteme 57
255 ict integration in education systems e readiness e integration e transformation 56
]]>
https://www.rene-pickhardt.de/analyzing-the-final-and-intermediate-results-of-the-iversity-mooc-fellowship-online-voting/feed/ 8