Hi Chun,
In addition to Adam's helpful comments, I'd just like to add that it looks
like each row in your spreadsheet contains information for multiple Arches
resources. For example, your "Architect" and "Developer" columns imply
Actor Resources.
As you start processing your spreadsheet with the SQL patterns Adam
provide, you may want to think about creating separate resources for
Heritage Buildings and Actors, then linking the resources with an Arches
.relations file. You can find much more information about this in the
Arches documentation.
Hope this helps,
Cheers,
Dennis
On Thursday, October 22, 2015 at 8:26:12 AM UTC-7, Adam Cox wrote:
>
> 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.
