Refactor CSV Import Controller

[pedrocarmona]

Describe the feature

Refactor the csv import clean step: to allow updating cells via turbo.

Why is this feature important?

Improves usability and responsiveness on the clean step of importing. Also use a json column instead of a normalized csv for faster updates.

Additional context, screenshots, and relevant links

• Create a new database import_rows:
  • that references import_id,
  • has an index row index within import,
  • contains a json column fields.
• Add a new model (Import::Row).
  • use active record store to programatically set any number of columns (:date, :name, :category, :tags, :amount)
  • set validations: should validate required fields, and data types (dates, bigdecimal)
• Move updating a cell into own controller (Import::RowsController)
  • change views to call new controller using turbo stream format
  • on update, run validations on the cell, and update cell validation status
  • on update, if all validations are passing, then should present a next button, to allow to step into the confirmation step

[zachgoll]

Hey @pedrocarmona, thanks for the request!

I agree that this could be an improvement on the existing design and could also help with future extension of this feature.

I've got a pretty big overhaul of the CSV imports that I'll be working on next week:

• Removal of "Confirm" step
• Some UI and mapping improvements (shown below):

Given these upcoming changes, I can't promise that we'll be able to merge this refactor right now, but I'd be more than happy to review a PR and see if we can get this in for our v0.2.0-alpha release!

---

Below I've posted the Figma designs for the "overhaul" that I'll be doing next week to help you see the end state that we'll be looking for here:

https://www.figma.com/design/lonJmVk3HYkwZoIO7xYP2w/Maybe-App-(Community)?node-id=4788-87&node-type=canvas&t=oIKBx73tkLmWf0VF-0