Club 2364 – 2010-04-22 09:01:56
Club 3235 – 2010-05-11 11:32:48
Club 6301 – 2010-05-02 08:26:59
Club 6413 – 2010-05-05 10:04:47
Club 8182 – 2010-05-30 21:23:15
Club 596735 – 2010-04-22 09:05:00
Club 1048321 – 2010-05-17 11:12:06
Club 1189695 – 2010-05-23 17:29:43
Club 1234456 – 2010-05-31 15:05:11
Club 1347465 – 2010-05-31 14:59:58
Club 1411678 – 2010-05-01 14:53:26
Club 1426329 – 2010-05-31 14:52:27
Club 1460223 – 2010-05-31 14:44:53
Club 1466953 – 2010-05-31 14:38:41
Club 1469108 – 2010-05-31 14:31:46
Club 1475827 – 2010-05-01 14:59:09
Club 1482258 – 2010-05-31 14:25:22
Club 1492668 – 2010-05-31 14:14:18
Latest User Submissions
June 18th, 2010Latest User Submissions
April 22nd, 2010Club 1590 – 2010-04-18 13:15:34
Club 2232 – 2010-04-18 13:50:47
Club 2274 – 2010-04-10 20:23:00
Club 2410 – 2010-04-12 11:31:26
Club 2410 – 2010-04-14 18:45:24
Club 3346 – 2010-04-14 18:47:19
Club 3540 – 2010-04-20 22:08:10
Club 3642 – 2010-04-18 13:57:40
Club 4031 – 2010-04-20 15:00:12
Club 4263 – 2010-04-08 01:12:33
Club 4263 – 2010-04-22 01:03:12
Club 4923 – 2010-04-20 22:11:17
Club 5067 – 2010-04-14 11:11:07
Club 5389 – 2010-04-08 01:13:58
Club 5389 – 2010-04-22 01:04:30
Club 5588 – 2010-04-14 18:48:26
Club 5624 – 2010-04-18 13:51:52
Club 5906 – 2010-04-18 13:05:16
Club 6769 – 2010-04-11 01:40:50
Club 791463 – 2010-03-29 18:02:59
Club 1042092 – 2010-04-03 08:46:23
Club 1042092 – 2010-04-03 09:03:57
Club 1287651 – 2010-04-18 13:19:24
Club 1338437 – 2010-04-18 13:22:28
Club 1398040 – 2010-04-18 13:27:51
Club 1444260 – 2010-04-18 13:45:44
Latest User Submissions
February 8th, 2010All approved, thank you.
Club 1908 – 2010-01-25 10:44:37
Club 2132 – 2010-01-15 21:33:40
Club 2132 – 2010-01-15 21:35:51
Club 2580 – 2010-01-28 09:31:50
Club 4722 – 2010-02-04 12:39:41
Club 6967 – 2010-01-26 14:58:26
Club 7851 – 2010-01-27 05:20:26
Club 8539 – 2010-01-27 11:32:55
Club 9297 – 2010-02-02 11:13:01
Club 665159 – 2010-01-18 00:03:02
Club 685089 – 2010-02-03 21:54:11
Club 1049826 – 2010-01-26 14:57:19
Club 1126118 – 2010-01-16 09:19:48
Latest User Submissions
January 15th, 2010All approved.
Club 823 – 2010-01-13 10:29:10
Club 2014 – 2010-01-13 08:10:13
Club 2132 – 2010-01-13 10:24:31
Club 2412 – 2010-01-13 08:08:15
Club 3888 – 2010-01-13 10:23:13
Club 4049 – 2010-01-13 10:10:47
Club 4976 – 2009-12-26 13:20:30
Club 9181 – 2010-01-13 10:03:58
Club 9912 – 2010-01-14 06:48:04
Club 655648 – 2010-01-12 11:29:11
Club 1142185 – 2010-01-13 09:50:05
WHQ messes me around…again!
December 21st, 2009Running a website that pulls data from another is full of adventures. I logged in the other day to find that they have completely changed the format of the club lists. In fact, the page I was using no longer exists so I had to resort to another one. Now they’ve changed it up with maps (I have a story about that!) and have javascript all over, I had to rewrite my scripts.
Well, it turned out to be easier than I thought – with the added bonus that I no longer have to parse addresses using commas. This makes the addressing much more accurate. Our friends in continental Europe would have to make changes in their club information for it to be 100% useful, For example, most of the addresses in France have the city in the 2nd rather than 3rd field – not sure if this is just how it’s displayed or something at WHQ. Anyway, a bit of fiddling later.
For now, I’ve updated my scripts and everything should be running again, and will be much, much more accurate, I think.
Please have a play around and let me know if you find any errors.
Latest User Submissions
December 21st, 2009All approved, thank you!
Club 712 – 2009-12-15 20:22:51
Club 2799 – 2009-12-20 22:55:11
Club 5086 – 2009-11-24 00:46:20
Club 5963 – 2009-12-11 10:26:29
Club 7642 – 2009-12-20 22:57:24
Club 1018147 – 2009-11-18 09:47:48
Club 1022091 – 2009-12-08 22:52:31
Club 1068212 – 2009-11-18 11:39:35
Club 1071656 – 2009-11-18 16:11:58
Club 1230933 – 2009-11-18 19:27:25
Club 1244109 – 2009-11-18 19:38:06
Club 1252478 – 2009-11-18 19:41:00
Club 1262706 – 2009-11-18 19:52:07
Club 1274419 – 2009-11-18 13:09:20
Club 1275635 – 2009-11-18 16:58:13
Club 1276907 – 2009-11-18 13:24:53
Club 1282109 – 2009-11-18 16:14:34
Club 1283150 – 2009-12-08 23:07:37
Club 1284269 – 2009-11-18 17:14:02
Club 1284277 – 2009-11-18 22:19:08
Club 1285876 – 2009-12-08 22:55:31
Club 1286356 – 2009-12-08 22:27:41
Club 1287653 – 2009-12-08 23:10:43
Club 1291893 – 2009-11-18 10:51:21
Club 1292321 – 2009-11-18 01:27:57
Club 1293068 – 2009-11-18 10:37:40
Club 1293971 – 2009-11-18 19:16:54
Club 1295592 – 2009-11-18 10:02:18
Club 1295732 – 2009-11-18 01:31:29
Club 1299256 – 2009-11-18 15:50:28
Club 1302048 – 2009-11-18 19:30:38
Club 1302977 – 2009-11-18 11:53:29
Club 1306484 – 2009-11-18 00:46:41
Club 1306548 – 2009-11-18 10:46:11
Club 1309110 – 2009-11-18 09:37:04
Club 1310688 – 2009-11-18 22:46:59
Club 1310747 – 2009-11-18 15:58:59
Club 1313356 – 2009-11-18 19:44:00
Club 1314906 – 2009-12-08 22:58:34
Club 1315066 – 2009-12-08 23:15:31
Club 1316509 – 2009-11-18 11:59:52
Club 1318218 – 2009-12-08 23:01:37
Club 1318570 – 2009-11-18 10:41:51
Club 1321246 – 2009-12-08 22:30:21
Club 1321783 – 2009-11-18 11:56:15
Club 1322444 – 2009-11-18 09:29:10
Club 1322444 – 2009-12-08 22:16:50
Club 1323949 – 2009-11-18 19:19:46
Club 1325458 – 2009-11-18 19:33:50
Club 1326960 – 2009-11-18 22:31:54
Club 1327800 – 2009-11-18 01:00:06
Club 1330772 – 2009-11-18 22:22:18
Club 1330938 – 2009-11-18 09:42:57
Club 1331172 – 2009-11-18 13:46:59
Club 1332814 – 2009-12-08 22:33:26
Club 1334184 – 2009-11-18 22:35:24
Club 1337939 – 2009-11-18 19:46:28
Club 1339001 – 2009-11-18 17:02:01
Club 1339086 – 2009-11-18 22:52:45
Club 1340401 – 2009-11-18 16:01:31
Club 1341388 – 2009-11-18 10:05:50
Club 1341461 – 2009-11-18 11:45:06
Club 1343922 – 2009-11-18 17:18:46
Club 1345063 – 2009-11-18 13:50:46
Club 1346259 – 2009-12-08 22:39:54
Club 1348808 – 2009-12-08 23:04:26
Club 1348975 – 2009-11-18 22:56:31
Club 1349520 – 2009-11-18 15:53:19
Club 1351517 – 2009-11-18 17:05:35
Club 1351980 – 2009-11-18 16:20:47
Club 1354538 – 2009-11-18 09:54:11
Club 1357999 – 2009-11-18 00:52:06
Club 1358542 – 2009-11-18 00:42:13
Club 1360121 – 2009-11-18 16:31:30
Club 1361002 – 2009-11-18 13:05:47
Club 1362687 – 2009-11-18 13:41:50
Club 1363309 – 2009-11-18 19:49:02
Club 1363524 – 2009-11-18 19:12:57
Club 1365837 – 2009-11-18 09:59:24
Club 1367453 – 2009-12-08 21:09:02
Club 1371020 – 2009-11-18 10:08:37
Club 1371020 – 2009-12-08 17:53:58
Club 1371065 – 2009-11-18 10:33:20
Club 1373428 – 2009-11-18 16:05:39
Club 1377996 – 2009-11-18 12:02:23
Club 1378847 – 2009-11-18 13:12:08
Club 1379543 – 2009-12-08 21:12:26
Club 1380241 – 2009-12-08 21:18:37
Club 1381877 – 2009-11-18 11:07:51
Club 1382407 – 2009-11-18 11:01:49
Club 1382501 – 2009-12-08 21:21:47
Club 1382511 – 2009-12-08 23:18:53
Club 1383836 – 2009-11-18 19:23:49
Club 1384457 – 2009-11-18 16:45:56
Club 1385657 – 2009-12-08 22:43:58
Club 1385769 – 2009-11-18 09:32:39
Club 1387707 – 2009-11-18 14:43:26
Club 1387707 – 2009-11-18 15:31:44
Club 1388474 – 2009-11-18 09:22:42
Club 1388474 – 2009-12-08 20:56:14
Club 1388480 – 2009-12-08 21:24:59
Club 1392974 – 2009-11-18 15:42:41
Club 1394538 – 2009-12-08 22:23:43
Club 1395590 – 2009-11-18 11:11:47
Club 1395639 – 2009-12-08 23:22:07
Club 1396080 – 2009-11-18 15:46:05
Club 1397341 – 2009-11-18 10:14:02
Club 1397341 – 2009-12-08 17:49:30
Club 1400363 – 2009-11-18 23:01:02
Club 1400864 – 2009-11-18 11:05:13
Club 1401339 – 2009-11-18 09:25:48
Club 1401339 – 2009-12-08 20:58:45
Club 1401635 – 2009-11-18 22:37:59
Club 1403224 – 2009-11-18 11:48:02
Club 1403886 – 2009-11-18 01:14:39
Club 1405482 – 2009-11-18 10:48:18
Club 1407565 – 2009-11-18 22:41:08
Club 1408278 – 2009-11-18 10:57:00
Club 1408281 – 2009-11-18 15:36:06
Club 1408288 – 2009-11-18 09:50:55
Club 1409411 – 2009-11-18 16:53:16
Club 1409881 – 2009-12-08 22:47:39
Club 1410604 – 2009-12-08 21:03:17
Club 1411166 – 2009-11-18 15:55:43
Latest User Submissions
November 17th, 2009All approved,thank you
Club 489 – 2009-10-18 14:57:05
Club 2655 – 2009-11-10 12:36:34
Club 2767 – 2009-10-21 16:48:49
Club 4974 – 2009-10-17 04:38:23
Club 5624 – 2009-11-10 00:24:45
Club 9464 – 2009-10-27 10:08:30
Club 596430 – 2009-10-21 16:50:56
Bug Fixed!
November 17th, 2009I have found the elusive bug in my scripts that was stopping some clubs from being updated. In fact, it was also contributing to clubs being deleted (which is why turned off deletion of old clubs).
For the technical types out there, I have a loop which goes through all the reports at the TI website. I was resetting a variable to 0 but outside of the loop, so each time it went through a district report, it was never starting at the top except for District 1. I’m now running and update and have checked Districts, 1, 2, 3, 4, 6, 8, and 50. Additionally, District 50 list of “to delete” clubs is what I was expecting. So it’s time to run the delete and blow some old clubs away.
A few changes!
October 8th, 2009I’ve been trying out a new process to grab the data I need to fill my database. I tested this on the DCP reports and it’s worked quite nicely. Rather than rummaging through the raw html, I parse the page as it would be displayed. Since the data is in fixed columns, it’s very easy to extract.
I needed to make a small change to the database. The DCP report, Full DCP report and Spreadsheets have been updated.
In other news, there was an issue with clubs not picking up their new location when updated from WHQ. I just checked one club that was reported and it seemed to be ok. Please let me know if you encounter any issues with updating information.
Latest User Submissions
October 6th, 2009All approved.
Club 32 – 2009-07-29 15:06:01
Club 35 – 2009-07-29 15:12:02
Club 136 – 2009-07-29 15:20:37
Club 161 – 2009-07-29 15:25:22
Club 177 – 2009-07-29 15:35:13
Club 287 – 2009-07-29 15:59:02
Club 288 – 2009-07-29 16:06:26
Club 357 – 2009-07-29 16:11:31
Club 376 – 2009-07-29 16:19:20
Club 444 – 2009-07-29 16:29:36
Club 483 – 2009-07-29 16:34:21
Club 547 – 2009-07-29 16:40:19
Club 552 – 2009-07-29 17:27:37
Club 569 – 2009-07-30 09:13:11
Club 585 – 2009-07-30 09:28:53
Club 660 – 2009-07-30 09:36:48
Club 689 – 2009-07-30 11:29:06
Club 731 – 2009-07-30 11:35:20
Club 740 – 2009-08-02 16:33:50
Club 744 – 2009-07-30 11:42:39
Club 752 – 2009-07-30 11:56:25
Club 754 – 2009-07-30 12:03:14
Club 792 – 2009-07-30 12:06:58
Club 793 – 2009-07-30 12:19:14
Club 823 – 2009-08-02 15:45:26
Club 874 – 2009-07-30 12:27:08
Club 916 – 2009-07-30 12:36:51
Club 933 – 2009-07-30 12:46:24
Club 992 – 2009-07-30 12:56:35
Club 1010 – 2009-07-30 13:36:16
Club 1045 – 2009-07-30 13:44:19
Club 1059 – 2009-07-30 13:54:14
Club 1088 – 2009-07-30 14:01:32
Club 1093 – 2009-07-30 14:09:26
Club 1093 – 2009-08-08 23:07:32
Club 1115 – 2009-07-30 14:32:30
Club 1156 – 2009-07-30 14:43:11
Club 1239 – 2009-08-30 01:06:04
Club 1425 – 2009-09-11 16:07:34
Club 1554 – 2009-07-30 09:07:30
Club 1761 – 2009-08-11 03:55:20
Club 1761 – 2009-08-11 04:02:51
Club 1828 – 2009-07-30 10:09:21
Club 1913 – 2009-09-29 10:46:35
Club 2036 – 2009-08-31 07:43:48
Club 2114 – 2009-08-11 04:10:17
Club 2118 – 2009-08-15 10:30:37
Club 2132 – 2009-08-10 07:31:44
Club 3982 – 2009-08-16 16:35:28
Club 4480 – 2009-08-16 20:21:52
Club 4500 – 2009-09-13 08:25:47
Club 4530 – 2009-09-16 22:00:20
Club 4711 – 2009-09-26 13:31:09
Club 5067 – 2009-08-13 14:28:20
Club 5067 – 2009-08-29 17:58:51
Club 5638 – 2009-07-30 09:43:19
Club 6413 – 2009-08-22 02:54:27
Club 6413 – 2009-09-04 03:10:13
Club 6447 – 2009-08-02 15:42:45
Club 7101 – 2009-08-08 09:41:27
Club 7369 – 2009-07-30 10:14:04
Club 8184 – 2009-09-01 14:38:26
Club 8372 – 2009-07-30 18:37:07
Club 8423 – 2009-07-30 09:58:27
Club 9498 – 2009-08-25 20:57:06
Club 606708 – 2009-09-02 12:44:21
Club 691684 – 2009-07-30 09:05:45
Club 747994 – 2009-08-08 10:02:03
Club 747994 – 2009-08-08 23:04:50
Club 808622 – 2009-08-08 09:50:27
Club 813457 – 2009-08-03 11:48:26
Club 813920 – 2009-08-08 09:46:08
Club 828778 – 2009-08-08 09:54:38
Club 843515 – 2009-08-02 15:34:54
Club 929602 – 2009-08-08 09:58:22
Club 936781 – 2009-09-05 17:37:00
Club 1052145 – 2009-08-02 16:01:00
Club 1072905 – 2009-08-19 16:10:33
Club 1115792 – 2009-08-08 23:12:19
Club 1123553 – 2009-09-04 00:14:14
Club 1142185 – 2009-08-02 15:54:57
Club 1153360 – 2009-08-19 17:56:49
Club 1204168 – 2009-07-31 12:59:53
Club 1204168 – 2009-07-31 12:59:54
Club 1204168 – 2009-07-31 12:59:55
Club 1204168 – 2009-08-08 09:37:26
Club 1216722 – 2009-08-19 16:27:55
Club 1216722 – 2009-08-19 20:50:07
Club 1230949 – 2009-09-16 05:04:58
Club 1257830 – 2009-08-19 17:32:22
Club 1285844 – 2009-08-19 16:40:50
Club 1298198 – 2009-07-29 14:29:44
Club 1298198 – 2009-08-19 15:59:57
Club 1331435 – 2009-08-19 17:49:04
Club 1334922 – 2009-07-29 14:25:15
Club 1334922 – 2009-08-19 15:55:41
Club 1336367 – 2009-07-29 14:34:05
Club 1336367 – 2009-08-19 16:36:33
Club 1349073 – 2009-07-29 14:38:20
Club 1349073 – 2009-08-19 16:45:51
Club 1351987 – 2009-08-19 17:29:48
Club 1361634 – 2009-07-29 14:30:25
Club 1365936 – 2009-08-19 16:32:20
Club 1365947 – 2009-07-29 14:42:10
Club 1365947 – 2009-08-15 06:45:53
Club 1365947 – 2009-08-19 17:26:29
Club 1367426 – 2009-08-19 17:40:46
Club 1369861 – 2009-08-19 17:53:22
Club 1371829 – 2009-08-19 18:08:18
Club 1373532 – 2009-08-19 18:22:07
Club 1373645 – 2009-08-19 17:44:26
Club 1374428 – 2009-08-19 18:12:39
Club 1374530 – 2009-08-19 18:03:12