Ellen Million (ellenmillion) wrote,
Ellen Million
ellenmillion

Thud.

Most people - sensible people - would spend a day of sick reading, or playing video games, or watching TV. They would certainly not decide to tackle an extremely tricky, detailed, potentially very damaging database merge.

I am clearly not sensible.

I copied my tables around, and re-aligned some fields, made test copies, and wrote some rather alarmingly easy script that allowed me to compare the data, delete the spam-joins, and merge or add all the members from the EMG-Zine database to the main PA customer database (already combined with the commission-control database), all in anticipation of things that will make you go WOW.

It is done, somehow. I woke up in a daze several times, and if I lost anyone's settings or accounts, I apologize, but I wrote the script for my current mental state, so it was a very straight-forward and mostly moron-proof process. A little tedious. (I thought about grading some pieces at FP and gave up on the notion, figuring this was safer. As I said, NOT sensible!)

After spam-joins were purged out, that left about 500 accounts to merge or add, and the EMG Empire stands at a little over 1100 official accounts.

I've still got to reattach some things at EMG-Zine, so registrations there are closed for a few days. And OMG, my throat hurts and my head is pounding. Ready to try a peroxide gurgle now...
Subscribe

  • Kickstarter Update!

    There’s only ONE WEEK left to claim your Shifting Sands Resort swag!! We’ve unlocked two styles of shirt, and we’re less than $120 from unlocking two…

  • A Writer's Process.

    Write a book. Edit a book. Revise a book. Edit the revised book. Pay someone to edit the revised book. Have someone ELSE edit the book. Edit the book…

  • Wolf's Instinct release

    I wrote this book straight from my heart, because I wanted a book just like this at the time. It’s got good people who are great for each other,…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 5 comments