I hate data import. How can something that is supposed to make lives so much easier, more productive, and convenient be such a hassle? I spent easily 3 hours today just working on importing data. I do understand that every i needs to be dotted and t crossed and everything needs to be exactly the way it is in the database or there will be anarchy. But really, do you need to add insult to injury by telling me that these mistakes have caused my file validation to fail? There aren’t sections I need to fix or highlighted errors, just FAIL.
The 8 steps of data importing:
1. Creation: After tireless hours of data collection and organization, reading and rereading the layout specifications, furious cutting and pasting into specific columns, you finally save the file as a .csv, because no other format will do.
2. Upload: This tense time while you try to work on other projects while your file uploads and you await the verdict. But really, you keep refreshing the page to see if your file has completed yet.
3. Amending: So there are a few errors you overlooked. Thank you, file validator, for looking over the work and finding them.
4. Anger: What do you mean ID not found?!? I copied it straight from the file layout! Repressing the urge to throw the computer against the wall and/or post unsavory comments on the company’s website.
5. Questioning: What does all this mean? Why isn’t it listed in the help on the site? Beginning to talk out loud to the computer, much to the confusion and fear of co-workers.
6. Bargaining: Do you want more ID numbers? I can find more ID numbers? I’ll get rid of all the spaces too! I’ll do anything you want, just validate the file! The co-workers are beginning to find reasons to stay far away from you now. You’re up to ten or more revisions of the file.
7. Depression: I’m a failure at life, I can’t figure out a simple spreadsheet. Openly weeping in public really solves nothing.
8. Acceptance: Either you’ve finally fixed every error imaginable and the program happily accepts your offering, after which you skip gaily through the halls at work, forcing co-workers to give you an even wider berth, or you’ve accepted the fact that something is very wrong with the file and have accepted the fact that you must call support. Meekly, you pick up the phone, listen to the hold muzak, and await the inevitably stupid little thing you forgot to include.
Today, acceptance was both fixing the file and realizing that the program wasn’t built to handle that sort of import, I’ll have to do it manually.