Archive Biodiversity Projects and Networks databases

[CynthiaParr-USDA]

Old front end tools no longer work, but Stan has gotten databases dumps. Need to set up a Typo3 page and explain and provide links.

[CynthiaParr-USDA]

Or better yet, add the files to a new GitHub project and if someone wants to pick up on it that's great.

[peterdesmet]

I would put them as 3 files/directories in one repository on GitHub, but best to have others vote on this as well.

[mdoering]

+1 for github. The less typo3 we use the better

[pmergen]

+1 agreed. Github proved convenient to use.

[peterdesmet]

How should we (short)name that repo? In what format can the exported data be delivered (3 flat csvs)?

[CynthiaParr-USDA]

Stan, can you provide the exported data to Peter to set up the repo? the long names are Biodiversity Information Projects of the World and Biodiversity Information Networks Database so short name for the combined repo could be Biodiv-projects-networks

[sblum]

Yes, I can provide those. They were actually just tables in the MySQL DB that underpins our site, and they've been migrated over to the DB on the new site. I think both CSV and SQL inserts should be deposited. (I have had much less trouble getting SQL to work if values contain commas and quotes.) Might be good to also include a separate metadata file for each table.

[peterdesmet]

@sblum, how flat are those tables? I'd prefer CSV as you can actually maintain these on GitHub, but it only makes sense if the data is rather flat. I can quite quickly just dump anything on GitHub, but it would be nice to clean it up a bit (though I'd only be able to do that early October). @mdoering care to help at that point?

[sblum]

The data underlying each "DB" is just one table.

[peterdesmet]

Ok, a CSV file would be great then (you can use a tabbed one to avoid problems with comma, but a good export program should escape with "quotes" anyway). You can email it to me.

[peterdesmet]

@sblum can you email me the CSV files?

[peterdesmet]

Got the files, planning to call the repository biodiversity-information-initiatives

[tucotuco]

None of the links on http://www.tdwg.org/biodiv-projects/projects-database work. Is that related?

[sblum]

John, I'm not sure what you're referring to here. All the individual project links I see listed at the URL you pasted DO work -- i.e., they display the record for the project. Were you just getting broken links?

[peterdesmet]

@tucotuco: links work for me as well. All content of that DB is now archived at: https://github.com/tdwg/bii/tree/master/projects

[CynthiaParr-USDA]

Don't forget redirects.

[tucotuco]

I still the same problem, and was reporting it for others who had seen it as well. Here is a partial screen shot.

[sblum]

I can replicate the problem with Firefox, but I get the expected results Chrome. I'm not logged in with Chrome, so I'm puzzled. I don't think this is a high priority for us at the moment, but I'll try not to let it fall off the radar entirely.

-Stan

On Sun, Jan 3, 2016 at 5:30 PM, John Wieczorek notifications@github.com wrote:

I still the same problem, and was reporting it for others who had seen it as well. Here is a partial screen shot. [image: image] https://cloud.githubusercontent.com/assets/462827/12082014/83d79c78-b269-11e5-9618-1748c54e34e2.png

— Reply to this email directly or view it on GitHub https://github.com/tdwg/infrastructure/issues/19#issuecomment-168562991.

[peterdesmet]

I cannot replicate the problem in Firefox. Since we plan to redirect anyway, we should maybe just do that? Is there a reason not to redirect for the moment?

[CynthiaParr-USDA]

I don't see any reason not to redirect. Who can set those up?