Hi Adam, Thank you once again for being so helpful. This tool is exactly what we need.
Lucy On Friday, October 9, 2015 at 9:22:33 PM UTC+2, 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.
