Hi Adam, Finally I am back testing out creating an .Arches file (but I am not able to load them yet and see the results) and I do have further questions about adding alternative names and several resource classifications.
Just to be clear that I understood you correctly, the group ID keeps records that are related within a heritage resource together, and the resource ID ensures that all data for a particular resource is kept together? Therefore, each alternative name/nametype would have a separate Group ID from the preferred name/nametype, but the same Resource ID? Secondly, I am not very familiar with Microsoft query, but it seems that the original Excel file for creating the query from, can only have one 'row' per record or archaeological site in our case. So as you suggested, we would need to put in a new column for each alternative name we have and for each site type classification and of course modify the query to add more statements for the extra names etc. I am looking for a method of reading the Excel file in the way we have set up with all the alternative name being in *one* column, as it would be more efficient for us - sometimes we have 10 alternative names but I don't think Microsoft Query can handle this. I don't know if you have any further thoughts on this or know how others have handles this. Thank you very much for your help, which is always appreciated! Lucy On Monday, January 18, 2016 at 7:27:24 PM UTC+2, Adam Cox wrote: > > Hi Lucy, I'm happy to hear the documentation was helpful. > > To add more attributes to your .arches file, you'll just need to add more > statements to the SQL query. First, because the SQL window is pretty > cramped in Excel, I'd recommend pasting your query into Notepad ++ so it's > easier to work with. > > If you look at the two statements that define Name and Name_Type, you'll > see that they both reference "group1". What you want to do is make more > groups, so I'd recommend copying and pasting the Name_Type statement from > the existing query (because it is the most standard) and pasting it below, > as many times as you need--one time per new attribute that you need to add. > Then just make sure to set the group value appropriately: if you have an > alternate name, you'll have to make a new column for that name, and make a > column with the correct conceptid (or hard-code the conceptid into the new > statement), and then put "group3" into each statement. Or, if you just have > a single column for a standalone attribute like "Site Type", make sure it > has its own unique group ID. > > I hope that makes sense. I have to run now, but if you have more > questions don't hesitate to ask them! > > Adam > > On Sunday, January 17, 2016 at 12:17:31 PM UTC-6, Lucinda Fletcher-Jones > wrote: >> >> >> <https://lh3.googleusercontent.com/-Qu9c0GYT4ig/VpvaZj1w5yI/AAAAAAAAFXo/aMjV0c5GLJg/s1600/Dabanarti.JPG> >> >> Hi all, >> >> I have worked through the example in Adam Cox's excellent guide to >> creating a .Arches file from a Microsoft Excel file which is where we have >> all our archaeological site data at present, and it worked very well. Now I >> have a question. Our data, as everyone else's is a little more complicated >> than the example. How do you deal with a site that has more than one name >> and more than one classification etc? for example: Dabanarti with three >> names and three site types. >> >> >> <https://lh3.googleusercontent.com/-Qu9c0GYT4ig/VpvaZj1w5yI/AAAAAAAAFXo/aMjV0c5GLJg/s1600/Dabanarti.JPG> >> >> >> >> Thank you very much, Lucy >> >> >> -- -- 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.
