Jspreadsheet CE VS mapzy

For the spreadsheet, we use the excellent Jspreadsheet library. If there are no errors, the import happens in two steps because importing a lot of locations requires a lot of calls to the Mapbox geocoding API (geocoding is converting an address to longitude and latitude), which is rate limited.

Yeah maybe in that case you can use jspreadsheet

I haven an open-source app (it's a store finder) that also uses Docker and Redis. Have a look at the GitHub repo, maybe there's something to help you there in my setup?

Mapzy is a store finder, and like Fugu it focuses on simplicity. Again, I've created it because the store finders out there were either ugly, too complex and/or expensive, and not privacy-focused. Read more on mapzy.io

Mapzy (on GitHub)

If you're interested in the code, have a look at location_imports_controller.rb, location_import.rb, and batch_geocode_worker.rb.

When building the bulk location import feature for Mapzy, our open-source and self-hostable store finder, we wanted to provide a better import experience for our users. We wanted to spare them the pain of dealing with exporting files and choosing delimiters, and we wanted to make it simple for them to fix any import errors.

I contribute to Our World In Data [0] and some of the Rails repos. I also run my own open source projects [1][2].

I've just recently started doing it, and I only put in a few hours each week. Slow and steady wins the race. My motivation is three-fold: First, it's gratifying to give something back to software I love using for free. Second, I learn a lot. Third, if I ever want to work with one of the companies who are stewarding these repos, it gives me a leg up in the application process.

0: https://github.com/owid/owid-grapher

1: https://github.com/shafy/fugu

2: https://github.com/mapzy/mapzy