Frustration vs. Persistence – Give It A Thought
Today’s task was to transfer my email list from one provider to another. It sounded simple enough, I mean the instructions were clear and it was easy to get the list from my current provider. I clicked on the drop down and selected export list. Another box appeared, it stated that the list file would be mailed to my email address, all I had to do was click confirm.
The First Issue:
I clicked confirm and went to my mailbox, and sure enough, there was my list of email contacts. Only one little problem, it was sent in Microsoft Excel. I use Open Office, which means it’s not going to open properly. I opened the file with Open Office and sure enough, there was my data and a lot of trash.
A Quick Call to Technical Support:
I knew that this was going to be a problem, so I made a call to technical support. I got connected right away and the help was spot on. We decided that I would have to delete all the junk data and just use what I needed, Email and Full Name. Support even had a sample list that I could look at and use as a pattern for my data. All I needed to do was download and open it. So, I opened it with Open Office.
The Sample File:
The file was clean of extra characters. It had specific column titles but strangely they were all under column “A”. Email and Full Name in column “A”. It did not take me too long. I deleted all unnecessary characters and changed the titles to the appropriate heading. I then downloaded this file to the “add members” wizard in the new data base and received an“Error” message.
I Made A Second Quick Call To Technical Support!
I was quickly connected to support and I told them this story. Immediately the tech guy said, “you have to separate the Email address in one column, the Name into another column, convert the file to CSV and then our system will take it. “I understand, what you’re saying makes sense, but your sample file has all the data in column “A” I exclaimed. The tech guy says “let me look at it” and then it dawns on me, “I opened this file with Open Office. I mentioned this to tech support and he said that Open office would open the file differently that Microsoft Excel. We decided that I should use two columns with proper headings and then save as in a CSV format.
I Need A Break!
The first episode of frustration had set in. I realized that I needed to calm down and relax. I did a few minutes of Breathing Exercises and then a session of Progressive Muscle Relaxation. I felt refreshed. My mind was clear and I was ready to start again.