Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.

If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping

Answers may be delayed for posts that do not include sufficient information.

Replace idno with values from another metadata element

We made a kind of stupid mistake when creating our collective access database and started a new identification numbering system. All objects in the database got a new "logic" number which became the idno. The old "irrational" ID's were instead placed in another metadata element called "altID". This has caused problems and I would like to replace the current idno with the values from the element "altID" and create a new element for the current idno values. I figured that this could be done directly in mysql but I don't know how. I took a look at the tables and saw that the values I want (from element altID) is stored in column "value_longtext1" in table "ca_attributes_values" on the rows which has "element_id" set to 22. But from there I don't now how to proceed. Is this possible to do somehow? Maybe I'm one the completely wrong track here.

Sign In or Register to comment.