by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Bounty2017
    @Bounty2017
    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
    CollectiveAccess
    @collectiveaccess
    Sure. Send them to me at seth@collectiveaccess.org
    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");
       set_time_limit(7200);
        ini_set("memory_limit", "1024M");
    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
    Eg. ca_entities.preferred_labels.displayname/dancer,producer:"Charles Chaplin"
    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
    Kehan Harman
    @kehh
    Well here it is, but we could probably work around it. http://clangers.collectiveaccess.org/jira/browse/PROV-1762
    CollectiveAccess
    @collectiveaccess
    Ok I'll try to look at it next week.
    This week is already cooked and it's only Thursday morning
    Kehan Harman
    @kehh
    I know what you mean (although it's Thursday night here ;)