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.
