ScanSnap saved the day

I have had an experience that felt like it came right out of a ScanSnap add spot and so I thought I would share it.

We are about to go live with a new field management system at one of the businesses I work for, and I am in charge of doing the data migration, standard stuff, I take a CSV file convert it to a JSON payload and hit the API to have the system load the data and do validation for me.

After running the test datasets to make sure everything is working I call up the business unit responsible for getting me the production data and ask to see how long until it will be ready.

Well I am blown away, they say that they have been at it, getting the data ready for the last month but that it’s still at least a week away! Which is bad news because go-live is next Friday. So I suggest that maybe I should take a look at the process, see if I can’t automate some of it to speed things up.

The guy does not seem to think I would be able to do much because most of the data is stuck in these paper forms, I assure him that I have ways of dealing with paper.

So like any sensible MacPowerUser I head over and bring my trusty ScanSnap ix500 over, and proceeded to blow this guys mind as in a matter on minutes I turn a pile of papers, into a PDF, and then simply copy paste the rows out, and into his spreadsheet.

The end outcome was that I got my csv’s to do my data load, look like the office hero later for getting this back on track, and I don’t think that guy will ever want to do data entry from a paper form again without a Scanner like the ScanSnap to speed things up.

The best bit, it was casual Friday so I did it all in a MPU battery t-shirt .


Please tell me it was dark when you arrived so you really glowed!

That’s a great tale - there’s lots of things I’ve learnt from MPU which astound others when I share the knowledge :slight_smile:

I wish it was, since summer is about to start here it’s getting much too hot and bright all the time.

Sharing knowledge is my favourite part of gaining it. I just wish I had found out sooner that they had this problem, I could have saved them loads of time and effort

1 Like