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.
