Can computer geekery save me from data entry hell?
November 10, 2010 10:48 AM Subscribe
Can you help me automate this big data entry project? There has got to be a way to harness the power of my computer to make the process easier than entering everything line by tedious line on a website!
posted by Balonious Assault to computers & internet (18 answers total)
My company keeps its files at an off-site storage facility. Over the years each person responsible for transmitting the storage data has had their own idea about what information should go in each field, so the inventory report is a giant mess. I'm trying to normalize it but I'm at a loss as to how to do so in the least painful way.
The inventory report from the storage facility comes in csv or xls format. There are a couple thousand records, each with 12 variables. I was hoping I could just correct data in the inventory report and send it back to them for upload, but no dice. My options are to go to their website, search each record, and then correct the data line by line, or to pay them an exhorbitant fee to do the same manual process themselves (so they say).
I'm thinking there has got to be a way to write a simple program that can at least take the data from my (corrected) spreadsheet and populate the individual fields on the website after I search each record and get to the edit screen. Or something. I'm not a computer programmer but I'm also not a dummy, and it seems like this wouldn't be the most elaborate programming to learn how to do. But I just don't know where to begin. Can anyone point me in a good direction? Thanks!