Simple, open-source and self-hostable store finder.
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.
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.
Learn any GitHub repo in 59 seconds. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev.
A library for bulk insertion of data into your database using ActiveRecord.
In the first step, we only validate if the information is all there and correctly formatted. For example, if a location name is missing, we highlight that error in the spreadsheet. If everything looks good, we save the locations to the database using the awesome Activerecord-Import library, but skip calling the geocoding API. Rather, we mark these locations as "to be geocoded".
Libre Endowment Fund: Sustainable Development of Free Software
1 project | news.ycombinator.com | 9 Oct 2021
How to show excel file in front end with edit and save functionality?
2 projects | /r/django | 6 Jun 2021
Show HN: DataSheetGrid, an Airtable-like React component
3 projects | news.ycombinator.com | 11 Nov 2023
How to prevent other devs from using components from UI library directly?
1 project | /r/Frontend | 11 Jun 2023
Need someone to explain why this happen regarding exporting
1 project | /r/node | 5 Jun 2023