These are chat archives for collectiveaccess/support

27th
Jun 2016
Stefan
@stefankeidel
Jun 27 2016 12:35
@kehh That option is more or less a hack I added for a very specific use case and it works well for that use case (related objects). We may want to make that available as a more generic feature but there are no plans to do so at this point.
As usual we welcome any code contributions
Bounty2017
@Bounty2017
Jun 27 2016 13:24
Hi, I'm currently creating an archive management system for a new nuclear archive being built in Wick, Scotland using collective access - on investigation of the current system and data they currently have it seems going forward the best data schema to use for this is a Data Warehouse, is this possible within the Collective Access system? Thank you
CollectiveAccess
@collectiveaccess
Jun 27 2016 13:25
What do you mean by data warehouse?
Are you thinking along the lines of star schemas?
Bounty2017
@Bounty2017
Jun 27 2016 13:27
Yes - I essentially want to be able to get all data they have and be able to push all results into one table
CollectiveAccess
@collectiveaccess
Jun 27 2016 14:12
You could export data from CollectiveAccess in that form
but internally it's structured to be a collections database, not an OLAP system
Bounty2017
@Bounty2017
Jun 27 2016 14:21
Ahhh okies, thank you
CollectiveAccess
@collectiveaccess
Jun 27 2016 14:23
If I may ask what sort of nuclear materials are you cataloguing ? :-)
Bounty2017
@Bounty2017
Jun 27 2016 14:36
Haha I could tell you, but then I would have to kill you :P
Bounty2017
@Bounty2017
Jun 27 2016 14:42
So just another question (Just to see if I can get around this a different way) say I have 5 different databases (All have different column names etc) and I created a different data map for each one and imported the data, would I not be able to alter CA to find data, based on individual and all databases? and add new data to a database they selected?
Andreas Sikkema
@ramdyne
Jun 27 2016 21:25
I've tried setting up Providence. I've succeeded once, but chose an incorrect profile. Deleted all the tables that were created in the configured database. Restarted install procedure, but now the install procedure never finishes (in the end I get a white screen), whatever profile I chose. Am I doing something wrong?
I also removed everything in the cache directory ut that also doesn't help. Deleted everything in the dir on the www server, re-cloned the repo, same thing happens
Also, what is the most basic profile to start with?
CollectiveAccess
@collectiveaccess
Jun 27 2016 22:56
@Bounty2017 You could create a schema to house all five types of data, and then filter (or not) by type. I'd have to see the data to tell you exactly how it would work, but I'd bet it can work.
I guess one database is a list of Trident D-5's. What are the other four ? :-)
@ramdyne The most basic profile is DublinCore, I'd say
Regarding the white screen, you might want to drop the database entirely and recreate, just to be sure you dropped everything cleanly
I'd also make sure that the PHP error_reporting setting is set to "On"
You can do this in php.ini, or you can stick the following line in your setup.php:
ini_set("error_reporting", "On");
It's possible there's an error but the message is being suppressed by the php.ini error_reporting setting
CollectiveAccess
@collectiveaccess
Jun 27 2016 23:01
Let me know if these suggestions help. If they don't we can continue to plan B