I have this recurring problem at my startup that I'd like to solve.
Our clients give us an Excel/file and I need to
1) match the columns
2) clean up the data
3) return errors (if any)
4) import each row into my database
It's very difficult given that so many things could go wrong. I have already invested a lot of time in building a file parser with column matcher but the results aren't there yet.
Do you know of any API / widget that would allow me to offer this on my website with minimal code?
Our clients give us an Excel/file and I need to 1) match the columns 2) clean up the data 3) return errors (if any) 4) import each row into my database
It's very difficult given that so many things could go wrong. I have already invested a lot of time in building a file parser with column matcher but the results aren't there yet.
Do you know of any API / widget that would allow me to offer this on my website with minimal code?