Adam, I usually do an Excel macro to convert Excel data to .arches and .relations file, but this one really looks very helpful. I surmise that you can just add additional statements on the SQL query if you have more fields in your Excel sheet. I will try this the next time we do another data import.
Thank you for taking time to add this helpful resource to the documentation! Regards, Joel On Saturday, October 10, 2015 at 3:22:33 AM 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.
