Hey yall, I'm looking for some feedback on a project I'm thinking about doing. I want to start a raspberry pi project and I think I found one that I can monetize to my work. We currently keep inventory/production sheets on pencil&paper before they go to data entry, eventually the process is going to get digitized but I think I can undertake this myself.
It should be reasonably simple to use a Pi + touchscreen (looking at a kit from
http://www.chalk-elec.com) to do the data entry and then have it wirelessly transmit to our servers. What I'd need to do is write a basic database entry form/spreadsheet for the input variables then write two scripts to have it send off to servers and then another to incorporate the data into the enterprise software we use.
It seems like Pi can handle SQLite fine so the database shouldnt be an issue. I havent looked into what our enterprise software uses yet so I dont know what issues that will cause but im certain licensing is by terminal so I know I wont be able to just install it on the Pi (if there even is linux build for it). I know this is all general, but are there any issues I should be expecting here, it all seems reasonably basic.