by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    tsitsibau
    @tsitsibau
            Repres = <unit relativeTo="ca_object_representations" filterNonPrimaryRepresentations="0" delimiter="," returnAsArray="1"><unit>^ca_object_representations.media.original%returnURL=true</unit>|<unit>^ca_object_representations.media.preview170%returnURL=true</unit></unit>,
    i also want to find related collections with public access
    and i use the following without success
            Collection = <unit relativeTo="ca_collections" delimiter="," returnAsArray="1"  checkAccess="[1]"><unit>^ca_collections.preferred_labels.name</unit>|<unit>^ca_collections.collection_id</unit></unit>,
    tsitsibau
    @tsitsibau
    (it returns all of them)
    sterlingjenson
    @sterlingjenson
    Greetings all. I am running two different C/A instances, one of which is a recent copy of the production system. When I run a mapping on the testbed one, it seems to run just fine; however on the production system, I am getting an error. (i.e. cannot create add or update . . . foreign key constraint.) Any suggestions on how to figure out what the difference is?
    I basically created a new mysql db for the testbed database, copied the providence files over to a new folder and updated the setup file
    Stefan
    @stefankeidel
    @sterlingjenson what's the FK error? @tsitsibau Some of these options won't work on units. You don't need to put checkAccess for each individual unit. Just put it in the service definition of the simpleAPI endpoint
    There are working examples here: http://docs.collectiveaccess.org/wiki/SimpleAPI
    sterlingjenson
    @sterlingjenson
    via copy and paste: (2016-06- 24 09:12:09) [2004-0049- 0001] Could not add related storage location with
    relationship location: Cannot add or update a child row: a foreign key constraint fails
    fk_ca_objects_x_storage_locations_type_id FOREIGN KEY (type_id)
    (providence.ca_objects_x_storage_locations, CONSTRAINT
    REFERENCES ca_relationship_types (type_id)) [250]
    Stefan
    @stefankeidel
    Looks like the relationship type you're trying to use is missing
    sterlingjenson
    @sterlingjenson
    ah, I see. for object and collection storage relationships, it will be "related," correct?
    Stefan
    @stefankeidel
    That depends on your profile, but yeah -- that's the default type from base.xml
    sterlingjenson
    @sterlingjenson
    thanks.
    Jesse
    @blackadder78
    I'm running a data import, and I'm trying to use the option applyRegularExpressions to convert a file name to an object idno. I can't get the regular expression to apply - it is simply importing the file name as the idno. Here's the text of my applyRegularExpressions statement:
    {"applyRegularExpressions": [{"match": "(NYSA_A1810-78_V15_[0-9]{4})_.+", "replaceWith": "\\1"}]}
    Can you tell what I'm doing wrong?
    ericwm
    @eriwm
    @collectiveaccess Hi, I have just run git pull again and now when I try to preview a pdf document I get the tool bar at the top of the screen, the thumbnails of the pages on the left hand side of the screen but only the small rotating block in the main screen so some improvement from my previous post.
    Kehan Harman
    @kehh
    @stefankeidel @tsitsibau I had no luck with multiple representations on objects. This is the latest master-fix. Do you want me to file a bug?
    tsitsibau
    @tsitsibau
    @kehh it's really a problem for me.... i'll probably have to use the other api (not simple) just for this... which gives all representations...
    Stefan
    @stefankeidel
    @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
    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