Hi All, I hope you are well and Happy New Year! I am in the process of modifying our Arches database and would like some help please. We created a version around two months ago which is on a server and in production mode with many records entered. In the meantime, I have made some design changes (concurrently in a separate offline version) in which I have added some new resource nodes, which means from my understanding means that we need to re-drop the database to apply the changes. This will overwrite the existing data so I need to export this data out first. I have now finished the modifications and am ready to begin this phase.
The following tasks are ahead as I see it: 1. Export the data out of the live database on the server (.csv file using json) 2. Overwrite the database on the sever (once the data is safely exported) by installing the most recent Arches and HIP updates on to the server (I've not done this yet while I have been in the middle of the changes) 3. Drop the new version of the database on the server 4. Copy over the new resource graphs, authority files and template changes etc that I've made on the offline version on to the clean new Arches database on the server 5. Reconfigure the exported data into .arches format 6. Batch upload into the new database Problems that I welcome that your advice: 1. Data export. Is it possible to retain groupings made during data entry? For example in the Measurement form, if there are multiple measurements taken of a given resource, such as length, width and height, each with different associated units and values, when I export the values in the json file, it gives one row per ArchesID, and separates the values in the different variables numerically or alphabetically via semicolons. The problem we have is that the relationship is not shown between them. For instance, we don't know which unit corresponds to which measurement value. (Forgive me if you set this out more clearly in the latest upgrades). It has me wondering as well, when you have multiple nodes that are linked by the single Add button, such as for Measurements or Components, name and name type, how are these relationships saved in the database if there is more than one set of values added? Is there a group ID assigned to them in the same way that we use a Group ID when we do the batch uploads? 2. To explore these queries further I thought I would consult the backend of the database via pgAdmin III. However, while I can locate the arches database that I dropped, I am unsure whereabouts within this database that our data is stored. Many thanks in advance and thanks for all your hard work. Best wishes Richard -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
