Hi Chun, glad it's been helpful. Understanding your Controlled
Vocabularies is necessary because you must reference the "conceptid" from
an authority document if the value in your spreadsheet needs to correspond
to a dropdown list. For example, if you have a Name ("Adai Home") and a
name type for that name ("Primary"), you'll need to have the name type
conceptid referenced in your spreadsheet, not the preflabel (because that's
how the .arches file works). In this case, "Primary" is actually the
preflabel, and "NAME_TYPE:1" is the conceptid. So you'll need to make and
use a column that has "NAME_TYPE:1" instead of "Primary". So, do a careful
inspection of your authority documents, because that's where it all must
start.
Because you have a lot of columns, you'll have to build from the example in
the documentation, and add more select statements to your SQL query to
include more columns in your output.
Overall, if you are very familiar with the graphs and the authority
documents (a.k.a. controlled vocabularies), converting data will be much
easier.
Good luck!
On Thursday, October 22, 2015 at 3:38:18 AM UTC-5, NHB Heritage wrote:
>
> Thank you, Adam!
>
> That's really awesome stuff there. Much as I can quite understand the
> steps written in the Extra section, I wonder if you could give some hints
> or assistance as am still struggling to understand the Controlled
> Vocabularies.
>
> I have the following field types/column names:
> *Research Type, Current Name, "Address (Street Name)", Address (Block or
> House No.), Postal Code, Coordinates (X), Coordinates (Y), Year of Building
> Completion, Planning Area (URA), Sources of Info, Commemoration, Year of
> Gazette (For Nat. Monu or Conserved), Tag, Historical or Cultural
> Associations, Description of Site / Structure, Type of Protection,
> Architect, Developer, Type of Building or Structure, Time Period of
> Building or Structure*
>
> There are around 250 lines of data under these column names.
>
> Look forward to your reply.
>
> Cheers,
> Chun
>
> On Saturday, 10 October 2015 03:22:33 UTC+8, Adam Cox wrote:
>>
>> Hello all, it seems to be pretty common that legacy data will exist in
>> the form of an Excel spreadsheet. There are a few different ways to handle
>> those spreadsheets, so I've put together some documentation on one of them,
>> which uses a SQL query within Excel itself to make the conversion. (I also
>> use Notepad++ to do a find/replace.)
>>
>> The example uses a very simple table that just has columns for resource
>> id, name, nametype, and lat/long coordinates. Hopefully it's all clear and
>> easy to follow along, and you should be able to augment the process to
>> handle additional columns pretty easily, once you understand the concept.
>>
>> Ultimately, a program like MS Access is more suited to handle these
>> operations, but if you're most comfortable with Excel and that's how all
>> your data is stored already, this information should be very helpful.
>>
>> You can find it in the Arches-HIP documentation
>> <https://arches-hip.readthedocs.org/en/latest>, in the Extra section
>> (for now at least).
>>
>> Any suggestions for improvement are welcome!
>>
>> Adam
>>
>
--
-- 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.
