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.
