Collaboration progress

[ka3jjz]

I thought some of you might like to know just how far we've come, and how far we have yet to go on our first pass through the database.

The attached spreadsheet (in the zip file - you will need an unzipper like WinZip or 7zFM) has been cleaned up a lot - the folks that are doing the work, they know who they are - and so do I

The color coding is simple - yellow means in progress, and some of these have outstanding tickets to the DBAs. Aqua means the first pass is done.

A few of the entries have 'NO FILES' - meaning there wasn't anything to be moved.

Wait a minute - 'first pass'??

Something this big, can't be expected to be done in a single pass. The first pass will be very slow to complete, as there is a huge amount of links, files and other data to be moved. The second pass will, hopefully, be far quicker, as we pick up things that were missed, or additions to the database that weren't caught by the DBAs and sent to the wiki instead. It's likely a third pass will be needed to finish up whatever was missed in the first 2 passes. At that point, I believe I can put a wrapper on it (maybe).

If you would like to help with a state (or even a county or two within a state), please yell. In addition, if there's a state or province that is done, that isn't on the spreadsheet, please yell. We're very light in the Canadian worksheet - I would expect that we wouldn't have much at all for Nunavut or Yukon, for example.

73 and thanks to everyone for pitching in Mike

[ibagli]

I can confirm that there are no files or links in Nunavut, NWT, or Yukon.

[ka3jjz]

Thanks! I can knock those 3 off the list 73 Mike

[cubn]

Don't forget to check the State level agency pages (ex. Illinois State Police, Statewide / Common / Shared, etc.) too. Files may still be attached to those pages.

Mike, is there an automated way to find the files that need to be moved over? It's a pain to click on every TRS, county and statewide agency page to find files but it's the only method I know of.

Are we to leave the Misc System Information on the trunked pages or move that to the collaboration pages as well?

If a trunked system is renamed (ex. "Decatur Trunked System" becomes "Decatur-Macon County Trunked System"), the link to the collaboration page will be broken if the wiki page existed under the former systems name.

As for Illinois, there shouldn't be any files left on the county pages. The trunked systems' related links have not been dealt with and I know there are still some files attached to the statewide agency pages that I haven't had time to take care of yet.

[ka3jjz]

Originally Posted by cubn

<snip>
Mike, is there an automated way to find the files that need to be moved over? It's a pain to click on every TRS, county and statewide agency page to find files but it's the only method I know of.

Are we to leave the Misc System Information on the trunked pages or move that to the collaboration pages as well?

If a trunked system is renamed (ex. "Decatur Trunked System" becomes "Decatur-Macon County Trunked System"), the link to the collaboration page will be broken if the wiki page existed under the former systems name. </snip>

I wish there was an automated way to scan each state; I have asked - several times, in fact - and been pretty much turned away. I would think a properly formatted join would do the job, but I guess not. It is a HUGE pain in the arse to scan everything manually, but that's what has to be done.

Yes, you're quite right about a trunked system being renamed - but fortunately moving a wiki article to a new name is a trivial matter. The only thing that would then be needed would be to re-join the new article to the correct state, but again that is a trivial matter.

Good to know that the counties are clean - that's 1/2 way done, in any case. The trunked system stuff is, as you say, another matter, but I'll take it any way I can get it, hi

If we miss the statewide agency stuff, no worries - to be honest, I didn't think there was much there, but you're right, there could be. But I would think the lion's share of the files and links will be in the county and trunked system data. And believe me, this can't be done in a single pass! We can hit the state agency stuff in the 2nd go-around; and trust me, there will be a 2nd go around, no doubt in my mind. I would concentrate on the trunked system scan next.

Leave the Misc system info on the database page for now. If Lindsay wants it moved, we can hit that on the 2nd go around. Some of that stuff is too specific to the system, and moving it to the wiki might well create more confusion.

Thanks for letting me know about the counties! Time to update the spreadsheet. And thanks for all the stuff you've put into the wiki...73 Mike

[ka3jjz]

A reminder - whatever you copy from the database must be removed. If you are an admin, please take the time to delete it. If not, please submit a ticket via the 'submit info' link. Thanks!

73 Mike