iPhone activation – Finally after 3 days

If you have been following my iPhone saga, last time was iPhone for corporate users. What a debacle

So after 3 days, my phone is finally activated, however it was no as simple even with the required hoops mentioned last time.

I started by getting my company to add iPhone as an acceptable device for *our own* company account. The response was “My rep has stated that he can not add the iphone to our corporate account. This is currently not allowed to do it by AT&T corporate. Our only option is #2 which is to release your number and port it back to a personal account. “

What the! So my number is released, and I start the process of getting my iPhone on a personal account. I take the option of calling 1.866.895.1099 rather then trying with iTunes. I explain the situation, and then I’m asked for the account number. I don’t have that, it’s a company account, then I’m asked to type in *#06# on the phone, but of course I’m calling on my phone and that doesn’t work. Then I had to prove I was the owner of the phone by providing 3 recent numbers called. Of course this is in the phone I’m presently using.

Ok we overcome this, then I’m told I may have to pay a security deposit on my phone. What the! More questions including what is your Drivers License Number. Well I don’t have a US drivers license. Anyway, a few more minutes and I’m told I would not have to pay a security deposit.

Continuing on, I was told my account was created, and then I could use iTunes to activate my phone. Wanting to ensure this all worked smoothly I was still online with the operator. I had to agree to the “Apple and Third Party Terms and Conditions” and “AT&T – Terms of Service”. I made a copy of these pages, but didn’t keep the links that they reference unfortunately.

At the end of the process, I click the final button in iTunes and the phone goes dead. Doh!. My Apple iPhone is immediately activated and my present phone is de-activated. A few minutes later I actually had the operator I was talking with call me back, so that counts as one of the few positive experiences in this entire process.

Given this has been a forgettable experience I state I specifically want to make a complaint and I want a number for complaints. I’m told there isn’t one, I have to register online at the AT&T website and then find the email for contacting them. Well, that’s just not customer service.

So finally at like 1am Tue Jul 3rd 3 days after my purchase, my useless paper weight is usable.

Tagged with: Apple IPhone

Producing IQR and Outlier statistics with SQL

The interquartile range (IQR) measures the spread of the middle 50% of a distribution — the distance between the first quartile (Q1) and the third quartile (Q3). Combined with Tukey’s 1.

Producing Mode statistics with SQL

The mode is the value or values that appear most frequently in a dataset. Unlike the mean or median, it applies naturally to categorical and ordinal data — star ratings, product codes, survey responses — and reveals what is most common, not what is average.

Extending MySQL Capabilies with UDFs, Plugins and Components - Part 2

MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install. These are: User Defined Function (UDF) MySQL Manual MySQL Plugin MySQL Manual MySQL Component MySQL Manual In my prior post I provided a new uuidv function that accepted a numeric argument to return a string of the version of UUID specified.