TODO list for OCUS

[harrieklomp]

To better keep track of all that is needed to migrate old OCUS to -current opencaching-pl code we suggest to all to add here what has to be done and to be solved to make it to a success. If you like to add or solve something, just add it and add your name to it :-)

Some more technical details are also specified under Projects as https://github.com/opencaching/opencaching-pl/projects/5 The Project keeps track of individual issues specifically related to this "project", that is OCNA migration.

However we keep this issue for all those unfamiliar with Projects functionality in GitHub and also for further multiple details that might fit a single issue anyway.

• [X] setup DEVEL server for OCUS (andrixnet)
• [X] import old OCUS files and database (andrixnet)
• [X] migrate data from old OCUS database to new database (andrixnet, Harrie, ocpl-developers)
• [ ] convert data from old OCUS database to new database (andrixnet, Harrie, ocpl-developers)
• [x] Make top menu including some site specific articles pages. Can be done with specific links in menu. (Harrie)
• [ ] Menu links should open in new window only if link points to external site. (Harrie)
• [x] Add welcome text. This should be done with OCUS admins. (Harrie) Use http://www.opencaching.us/ as reference
• [X] Move map on mainpage to correct position. USA, Canada and Mexico visible. (Harrie)
• [x] Make Geopath work with settings desired by OCUS admins. (Harrie)
• [ ] Add mascot to system. (andrixnet & Harrie)
• [ ] Add specific US items to left menu. (Harrie)
• [x] Setup of cron jobs (andrixnet)
• [ ] French and Spanish translations. We need Spanish translator (Harrie)
• [x] Make statpics work (Harrie)
• [X] Solve differences in cache_status (Harrie)
• [ ] CACHE TYPES - duplicate ID cleanup across all nodes (ocpl-developers)
• [ ] CACHE TYPES - add new types by OCUS (ocpl-developers?)
• [x] CACHE TYPES - migrate existing OCUS caches that need ID changes (andrixnet & Harrie)
• [ ] LOG TYPES - consistency (andrixnet, mostly)
• [ ] site defaults: option to set default N/S and E/W in coordinate fields (ocpl-developers)
• [ ] game rules: OCUS counts event "attended" to total finds. (ocpl-developers) This should become a per/node configurable parameter, by default OFF, but set to ON for OCUS.
• [x] game rules: OCUS wants all new caches to be reviewed. (ocpl-developers) This should become a per/node configurable parameter, by default OFF, but set to ON for OCUS.
• [ ] USA, Canada and Mexico geo data import from old database in a compatible way to our NUTS data. (andrixnet, ocpl-developers) andrixnet: Part of it I am trying to handle myself, work in progress. Where I get stuck, I'll ask for help.
• [ ] USA, Canada and Mexico nature protected areas import from old database. I think only US data exists.
• [ ] Search by ZIPcode. (ocpl-developers) ZIPcode geo data import from old database is easy, but support for search by it (PHP code) I cannot handle.
• [ ] set website icon (see #1547 ) (Harrie, andrixnet, PHP code: ocpl-developers)
• [x] how to handle differences between british english and american english. (all developers) If these differences account only for a few cache attributes, then perhaps the attribute can be named something like this: Quick cache / One-minute cache

If there are more such differences, not only attribute name (which can be handled easily), then another solution must be designed. The only one I can think of is to maintain 2 sets english strings (en-us and en-gb).

• [x] challenge caches is a OCUS specific thing that they did upon on unknown cache type. Perhaps this deserves it's own type. (PHP code: ocpl-developers)
• [x] port the page "phone apps for OC" (from main menu) to other OC nodes, I am sure it is of interest. Can be set in config files now.
• [ ] simple online editor for articles, similar to news, available for node admins (of use for all OC nodes, see #1946 ) (ocpl-developers)
• [x] convert passwords from old cca 2009 opencaching-pl code to -current authentication scheme and the new salt and hash scheme. (ocpl-developers)

• [ ] update attribute-definitions.xml for OKAPI waiting merge here

• [x] setup of automatic updates - last task. (andrixnet)

• [x] setup and update secondary site - blog
• [x] setup and update secondary site - wiki

• [x] setup and update secondary site - forum

  Moving towards production:

• [x] discuss hosting with OCUS team
• [x] setup domain hosting
• [x] setup domain host-IP mappings
• [x] setup email subsystem
• [ ] set up SSL (server side, letsencrypt)
• [x] announce migration to users
• [x] move DEVEL to production.
• [ ] announce migration end to users.

[andrixnet]

Almost ready for production release of new site, albeit with some known issues still to work on.

[kojoty]

@andrixnet where is the complete list of issue (is this list above complete and updated?) Thanks @andrixnet for all your work in this mater :)

[andrixnet]

The list here contains many management and administrative tasks related to the migration process, in addition to the code development tasks. Most of the actual development issues are listed here: https://github.com/opencaching/opencaching-pl/projects/5 and here https://github.com/opencaching/opencaching-pl/milestone/1 and here https://github.com/opencaching/opencaching-pl/labels/OCNA%20migration (I think they partly overlap, partly complete each other.)

Main site is up and operational at http://www.opencaching.us (Aruba small VPS) Still TODO: set up SSL certificates and configuration. Email subsystem up and running. Secondary sites up and running.

Several configuration and user roles/rights still need to be configured. Some small details I managed already to sovlew directly. I am in constant contact with our american friends.

[andrixnet]

@kojoty when you have the time, please first take a look at https://github.com/opencaching/opencaching-pl/pull/2069

This paves the way for the first time unified attributes between OCPL sites (and first step to move attribute definitions to code). Also the proper updates have been prepared for OKAPI and a corresponding pull request is pending there.

Attributes are now well documented here https://wiki.opencaching.eu/index.php?title=Cache_attributes I am also in contact with c:geo developers to support the complete OC attribute set.

Next step after this PR will be to add/remove some attribs at NL, RO, UK, US according to individual requests from each OC site team.

Once completed, all OCPL based sites will have a consistent and well document set of attributes.

Thank you for your support.

[andrixnet]

Updated OCNA database contents regarding caches and cache types. Using newly designed IDs, documented (work in progress) here.

ID 8 (moving) -> ID 9 ID 9 (podcache) -> ID 1 other + MP3 attribute ID 10 (guestbook) -> ID 23 ID 11 (usb) -> ID 1 other + USB attribute ID 12 (bitcache) -> ID 24 ID 13 (letterbox) -> ID 1 + letterbox attribute.

Please note that I've used the new attribute ID assignments as documented here which are work in progress, to be deployed soon. Until then, there will be some inconsistency due to missing or wrong IDs in the database.

This is a preparation phase part of OCNA migration. The site will continue to exhibit inconsistent behaviour regarding these cache types, which will be solved when work on #2024 and #860 are finalized.

All caches turned into "other type" + attribute will need to be revised by their owners (after cache type and attribute work is complete) to assign them the correct type if different from "other".

Caches affected by these inconsistencies (at this time): ~ 400 caches total (about 260 being bitcaches).

[paulshannon]

@andrixnet I'd like to help with the OCNA instance specifically. Is there a migration still in the works to bring it up to date?

Feel free to contact by email if that is easier for you. Thanks! paul at paulshannon.ca

[andrixnet]

Interim solution for OCNA cache types. Upon agreement with North America OC-Team, caches of still undefined/unimplemented types to be redefined as type=unknown and with an attribute added.

• US Benchmark - attribute exists (attr_id=208)
• BITcache - new attribute (temporary attr_id=99301)
• Guestbook - new attribute (temporary attr_id=99302)
• Challenge - new attribute (temporary attr_id=99303)

Note: these attributes are being added to the database and corresponding images created and deployed to make them functional. No additional implementation is done (like specifics for GPX export, etc) for them.

Caches of unsupported types become "UNKNOWN" and receive an additional attribute.

[andrixnet]

Example: OU04C5 https://www.opencaching.us/viewcache.php?wp=OU04C5 Was type=guestbook. New type=other New +++attrib guestbook