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
What do you mean by data warehouse?
Are you thinking along the lines of star schemas?
Bounty2017
@Bounty2017
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
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
Ahhh okies, thank you
CollectiveAccess
@collectiveaccess
If I may ask what sort of nuclear materials are you cataloguing ? :-)
Bounty2017
@Bounty2017
Haha I could tell you, but then I would have to kill you :P
Bounty2017
@Bounty2017
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
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
@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
Let me know if these suggestions help. If they don't we can continue to plan B
Bounty2017
@Bounty2017
Haha I had to go through months of security vetting just to see the data myself :D Would I only be able to filter by type? Not column names or anything?
_
Bounty2017
@Bounty2017
@collectiveaccess What if I could show you the database column names and the amount of databases I am dealing with?
CollectiveAccess
@collectiveaccess
You could filter by type or other field values, and control what columns are returned
Different types can have different columns
and columns (which aren't really columns actually) can repeat
If you send me column names, # of databases, and some indication of the structure of the data in each column I could give you a better idea
... and you're not denying that there's a list of Tridents in there are you?
Bounty2017
@Bounty2017
Is there a way of sending them to you privately? I have no idea what they are.... :P
I have to run now but will try to look at them later today
Bounty2017
@Bounty2017
Ok thank you
CollectiveAccess
@collectiveaccess
(we're in New York, 5 or 6 hours behind you I suppose)
Andreas Sikkema
@ramdyne
So i've tried a few times. Dropped the DB, created a new one. Chose Dublin Core, and then after a loong time I get "connection reset" ( I used to get a white screen). No logging, no further output.
I have the following in setup.php: ini_set("error_reporting", "On");
Nothign in apache's error log, just a regular 200 response in access.log
CollectiveAccess
@collectiveaccess
hi
a white screen if you have error_reporting on often implies a seg fault. Is there anything in the general apache error log? What sort of server is this?
Kehan Harman
@kehh
Hey all - can I use restrictToTypes and/or restrictToRelationshipTypes when defining an access point in search_indexing.conf?
CollectiveAccess
@collectiveaccess
no, I'm afraid that's not supported
what you can do is restrict to relationship types using the search syntax
You can also restrict to types programmatically ... so it's not a huge jump to making both restrictToTypes and restrictToRelationshipTypes available in search_indexing.conf for access points
Kehan Harman
@kehh
Thanks seth.
CollectiveAccess
@collectiveaccess
If this is something you really need create a JIRA and we'll see about it