Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Se7en
    @Se7en-IT
    but what is this block?
    ca_entities = {
    tables = {
    entities = [ca_objects_x_entities],
    object_lots = [ca_object_lots, ca_object_lots_x_entities]
    },
    fields = {
    entity_id = { DONT_INCLUDE_IN_SEARCH_FORM },
    idno = { STORE, DONT_TOKENIZE, INDEX_AS_IDNO, BOOST = 100 },
    _count = { }
    }
    },
    tables.object_lots
    what does it mean?
    and INDEX_ANCESTORS what does it mean?
    do you have an example for simple indexing only metadata and label of object/entity/occurrence?
    Julia
    @juliaweist
    INDEX_ANCESTORS - (enables hierarchical indexing for field, assuming it is in an hierarchical table, resulting in all values for this field in records above the subject in the hierarchy being indexing against the subject)
    Removing parts of the search index may cause issues for your cataloguers if they are working with other tables, sets, list items etc.
    that being said, here's an example as you've requested:

    ca_objects = {

    # ------------------------------------
    ca_objects = {
        fields = {
            object_id = { },
            _metadata = { },                    # forces indexing of all attributes
            parent_id = {STORE, DONT_TOKENIZE, DONT_INCLUDE_IN_SEARCH_FORM },
            source_id = {},
            lot_id = { DONT_INCLUDE_IN_SEARCH_FORM },
            idno = { STORE, DONT_TOKENIZE, INDEX_AS_IDNO, BOOST = 100 },    
            type_id = { STORE, DONT_TOKENIZE },
            source_id = { STORE, DONT_TOKENIZE },
            acquisition_type_id = { STORE, DONT_TOKENIZE },
            hier_object_id = { STORE, DONT_TOKENIZE },
            access = { STORE, DONT_TOKENIZE },
            status = { STORE, DONT_TOKENIZE },
            deleted = { STORE, DONT_TOKENIZE },
            is_deaccessioned = { STORE, DONT_TOKENIZE },
            deaccession_notes = {},
            deaccession_date = {},
            circulation_status_id = { STORE, DONT_TOKENIZE }
        },
        # Index idno's of related objects 
        related = {
            fields = {
                idno = { STORE, DONT_TOKENIZE, INDEX_AS_IDNO, BOOST = 100 }
            }
        }
    },
    # ------------------------------------
    ca_object_labels = {
        key = object_id,
        fields = {
            name = { BOOST = 100, INDEX_ANCESTORS, INDEX_ANCESTORS_START_AT_LEVEL = 0, INDEX_ANCESTORS_MAX_NUMBER_OF_LEVELS = 4, INDEX_ANCESTORS_AS_PATH_WITH_DELIMITER = . },
            name_sort = { DONT_INCLUDE_IN_SEARCH_FORM },
            _count = {}
        },
        # Index names of related objects
        related = {
            fields = {
                name = { BOOST = 100, INDEX_ANCESTORS, INDEX_ANCESTORS_START_AT_LEVEL = 0, INDEX_ANCESTORS_MAX_NUMBER_OF_LEVELS = 4, INDEX_ANCESTORS_AS_PATH_WITH_DELIMITER = . }
            }
        } 
    },
    # ------------------------------------
    ca_objects_x_entities = {
        key = object_id,
        fields = {
            _count = { }
        }
    },
    # ------------------------------------
    ca_entities = {
        tables = {
            entities = [ca_objects_x_entities],
            object_lots = [ca_object_lots, ca_object_lots_x_entities]
        },
        fields = {
            entity_id = { DONT_INCLUDE_IN_SEARCH_FORM },
            idno = { STORE, DONT_TOKENIZE, INDEX_AS_IDNO, BOOST = 100 },
            _count = { }
        }
    },
    # ------------------------------------
    ca_entity_labels = {
        tables = {
            entities = {
                ca_objects_x_entities = { }, 
                ca_entities = {}
            },
            object_lots = [ca_object_lots, ca_object_lots_x_entities, ca_entities],
            annotations = [ca_objects_x_object_representations, ca_object_representations, ca_representation_annotations, ca_representation_annotations_x_entities, ca_entities]
        },
        fields = {
            entity_id = { DONT_INCLUDE_IN_SEARCH_FORM },
            displayname = { },
            forename = {},
            surname = {},
            middlename = {}
        }
    },
    # ------------------------------------
    ca_storage_locations = {
        tables = {
            places = [ca_objects_x_storage_locations],
        },
        fields = {
            location_id = { DONT_INCLUDE_IN_SEARCH_FORM },
            idno = { STORE, DONT_TOKENIZE, INDEX_AS_IDNO, BOOST = 100 }
        }
    },
    # ------------------------------------
    ca_storage_location_labels = {
        tables = {
            places = [ca_objects_x_storage_locations, ca_storage_locations]
        },
        fields = {
            location_id = { DONT_INCLUDE_IN_SEARCH_FORM },
            name = { INDEX_ANCESTORS, INDEX_ANCESTORS_START_AT_LEVEL = 0, INDEX_ANCESTORS_MAX_NUMBER_OF_LEVELS = 10, INDEX_ANCESTORS_AS_PATH_WITH_DELIMITER = .}
        }
    },
    # ------------------------------------

    }

    Se7en
    @Se7en-IT
    @juliaweist thank a lot!
    this setting indexes related ca_entities and ca_storage_locations
    is it correct?
    Julia
    @juliaweist
    yes
    Se7en
    @Se7en-IT
    Perfect
    Thanks a lot:-D
    Se7en
    @Se7en-IT
    Hi, have someone a docker image for Providence?
    CollectiveAccess
    @collectiveaccess
    Not at the moment. I'll make one after the New Year.
    Se7en
    @Se7en-IT
    Ok thanks, where do you publish It?
    In the docker hub?
    Ari
    @artturimatias
    Se7en
    @Se7en-IT
    Thanks
    Merry Christmas
    Se7en
    @Se7en-IT
    Happy new Year
    CollectiveAccess
    @collectiveaccess
    @Se7en-IT Yes, we'd put the image up on DockerHub
    Se7en
    @Se7en-IT
    @collectiveaccess What is it the best settings for mysql installation?
    CollectiveAccess
    @collectiveaccess
    And Happy New Year to you too
    This message was deleted
    Se7en
    @Se7en-IT
    Innodb settings?
    CollectiveAccess
    @collectiveaccess
    What about Innodb settings?
    Se7en
    @Se7en-IT
    mysql innodb settings
    Mysql best settings for improve collective access performance
    CollectiveAccess
    @collectiveaccess
    They're the standard mysql tuning suggestions
    I do find that setting innodb_flush_log_at_trx_commit = 2 helps a lot with writes in general
    and I've never had data corruption issues
    Se7en
    @Se7en-IT
    Perfetto thanks
    Perfect
    Rafael Henrique
    @rahenrique
    Hi, I'm having some problems trying to setup the Library-style check in/check out. The check out seems to work, but I cannot check in the item back. Some guidance? Thanks!
    Rafael Henrique
    @rahenrique
    Found something: in app/controllers/library/CheckInController.php and/or in app/models/ca_object_checkouts.php: the call to the method isOut() seems to return false when the object is currently out (some issue with checking the return_date field, perhaps. Changed the call in the CheckInController to use instead the method objectIsOut() and the issue was gone... Should I inform someone, or create a ticket somewhere?
    Sophie
    @pinkfishies
    Hi Rafael, please create a JIRA ticket for this, thanks
    Rafael Henrique
    @rahenrique
    bowbot
    @bowbot_twitter
    It is possible to add social sharing to a Pawtucket object record? I see reference to AddThis in the documentation but no specific details.
    I also see it on this site—any advice would eb appreciated: https://grpmcollections.org/Detail/collections/182
    Sophie
    @pinkfishies
    Hi @bowbot_twitter - the AddThis is no longer included in Pawtucket2 - now we include a tool for sharing a record by email
    there are a number of easy tools available for you to add the social media buttons of your choice to Pawtucket, such as https://www.sharethis.com/
    bowbot
    @bowbot_twitter
    @pinkfishies So are you saying the the GRPM example I shared is a solution from ShareThis?
    bowbot
    @bowbot_twitter
    Anyone else out there integrating social sharing with their Pawtucket instance?
    Sophie
    @pinkfishies
    Hi @bowbot_twitter Yes I believe GRPM is using embed code from ShareThis
    Usually when we implement social media with Pawtucket2 it's with a third party service so the organization can track shares/social media involvement
    Biblioteca é muito +
    @bib_mais_twitter
    Hello, does anyone know if is it possible to apply Boolean operators in the advanced search form ? I tried to apply "NOT operator" on a search item, but I have no result. Only when I use in the quick search area.
    I also need to search two terms at the same search field, something like to use ( ) parenthesis to combine terms to be searched together. Two different terms from the same controlled vocabulary list. Any tips? (Providence Application version 1.7.3)