Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Import Address Book contacts into a new Verizon phone Apps
Here's the scenario:

You have a phone with Verizon, and you have 1,000 contacts in your Mac's Address Book. Perhaps you've had a previous Verizon phone, but you've never backed up your contacts from that phone -- but you do have your contacts on your computer and want to get them into your phone. I'm here to tell you that yes, it can be done, I promise. What this does is turn your Firefox web browser into an input robot that fills out the stupid little manual input forms on Verizon's website automatically, over and over, using a CSV file as the input source.

Read on for the step-by-step...

Here are the steps:
  1. First, you need to activate Verizon's Backup Service -- this allows you to download contacts from (yes from) your phone, as well as manually type in contacts to your phone (don't panic, just keep reading).
  2. You'll need to make a text file list of your contacts or Address Book. It must be saved in CSV (comma separated values) format. I found that Address Book Exporter does the best job of creating a file -- but it's tab-delimited, so you need to import it into something like Excel and then re-save it. Windows people need to get from their address book to CSV on their own.
  3. Now, for the magic. You'll need to use Firefox for this part. You need to install the iMacros for Firefox add-on.
  4. Open the side window that iMacros offers. You'll see a list of sample scripts. Pick one; it doesn't matter which. Right-click on the chosen script and rename it Verizon Auto Phone Import.iim.
  5. With that script selected, click the Edit tab at the bottom, and click the button Edit Macro.
  6. Highlight the entire screen that pops up and delete the contents. Then put the following text in:
    '=======Start here, cut this line=========
    
    VERSION BUILD=3700331 
    
    'Uses a Windows script to submit several datasets to a website, e. g. for filling an online database
    'Adapted from original sample code -- now logs into Verizon Backup Assistant and imports a spreadsheet
    
    TAB T=1
    TAB CLOSEALLOTHERS
    URL GOTO=https://backupassistant.vzw.com/mb/do/privileged/addressbook/prepare?skininfo=110
    
    ' Specify input file (if !COL variables are used, IIM automatically assume a CSV format of the input file
    'CSV = Comma Separated Values in each line of the file
    CMDLINE !DATASOURCE addressbookforverizon.csv
    
    'Number of columns in the CSV file. This must be accurate!
    '====================
    ' SET THIS TO THE NUMBER OF COLUMNS IN YOUR CSV FILE
    '====================
    SET !DATASOURCE_COLUMNS 13
    
    'Increase the current position in the file with each loop
    SET !DATASOURCE_LINE {{!LOOP}}
    
    'Fill web form
    'Click the "Add Contact" Link
    TAG POS=1 TYPE=A ATTR=TXT:AddContact
    
    '===============================================
    ' EDIT THE FOLLOWING LINES ONLY IF YOU HAVE TO
    ' Change the "COL" values to correspond to your CSV file. For example, if
    ' the first COLUMN of your CSV is Last Name, and the second COLUMN is First Name
    ' then change the first line to end with {{!COL2}}
    ' and the second line to {{!COL1}}
    '===============================================
    
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:firstName CONTENT={{!COL1}}
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:lastName CONTENT={{!COL2}}
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:mobile CONTENT={{!COL9}}
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:mobile2 CONTENT={{!COL10}}
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:home CONTENT={{!COL7}}
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:work CONTENT={{!COL6}}
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:fax CONTENT={{!COL11}}
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:email CONTENT={{!COL3}}
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:email2 CONTENT={{!COL4}}
    TAG POS=1 TYPE=INPUT:IMAGE FORM=NAME:contactForm ATTR=NAME:_save_&&SRC:https://backupassistant.vzw.com/mb/images/skin.110/buttons/save.gif
    '========= end here, cut this line ======================
  7. Now, you need to understand that your CSV may not line up its columns like mine -- so you may need to edit the script. First, find the place where you edit the number of columns and change that to the number of columns that have data in your spreadsheet. Next, edit the last lines so each field lines up with the right column.

    So, for example, if your CSV is Last Name, First Name, then you'll need to change the firstname line to end with {{!COL2}}, and change the lastname to {{!COL1}}, and so on.
  8. Save the file and click the Options button in the iOpus window.
  9. Click Paths and make note of where Datasources are saved. In your Finder or File Explorer, save your CSV into that directory -- but save it with the name addressbookforverizon.csv in that directory. My advice would be to test this with a one or two line CSV file first, to ensure that all the data is going into the right fields. Once you've seen it working, put in the real file with 1,000 contacts in it.
  10. Cick the Play tab, and click Play (Loop) -- you might need to set the Max value to your line count in the CSV file (e.g. 1000). Now watch the robot upload data into your Verizon account.
  11. Once it's complete, go to the applet on your phone, select Update, and presto, you now have 1,000 contacts on your Verizon phone!
Notes:
  • You may run the script, get one entry, and then see nothing else. That's because your CSV was saved by Microsoft Excel with extra newlines and hidden characters in it. Try saving it as MS-DOS Comma-Separated (.csv) instead -- that will keep the output clean.
  • You have to be logged into your Verizon account before you trigger the script (it needs to be able to navigate to the page over and over).
If you need more details, I have a full write-up of this process on my personal blog.

[robg adds: I haven't tested this one.]
    •    
  • Currently 1.00 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (2 votes cast)
 
[23,493 views]  

Import Address Book contacts into a new Verizon phone | 7 comments | Create New Account
Click here to return to the 'Import Address Book contacts into a new Verizon phone' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Import Address Book contacts into a new Verizon phone
Authored by: redfood on Aug 29, '08 08:27:00AM

Its too bad Verizon cripples their phones and then requires you to pay for a "service" to get data in and out of you phone.



[ Reply to This | # ]
Import Address Book contacts into a new Verizon phone
Authored by: slswift on Aug 29, '08 09:40:55AM

Hmmmm.... I know Verizon cripples their phones pretty badly, especially with respect to bluetooth. But I have never had any problem syncing my older, original Moto V3c Razr from Verizon with my Mac, iSync and Address Book.

Do have a new phone that isn't supported by iSync? Did you look at a third party iSync conduit?

Just wondering, as I am about to upgrade phones and was assuming I would just iSync again to get all my contacts in my new phone from Verizon.



[ Reply to This | # ]
Import Address Book contacts into a new Verizon phone
Authored by: pgb0517 on Aug 29, '08 10:02:35AM

This sounds quite involved. I just use OnSync from OnMadeSoft for my Verizon phones. It's easy, reliable and inexpensive. I got tired of Apple's syncing because you can't readily see what is going on, especially when there are problems. OnSync shows you both your chosen Address Book content (I created a group called Cellphone Syncs so I only sync those, not the whole thing) and the contents of your phone. It grants granular control over the appearance of all entries, lets you assign keypad shortcuts (press 1 to dial home, for instance), and shows you exactly what matches or doesn't match between the Mac and the phone, so you can fine-tune the sync to your needs.



[ Reply to This | # ]
Import Address Book contacts into a new Verizon phone
Authored by: Aeschylus on Aug 29, '08 08:02:40PM
You can synch data with LG, Samsung, Sanyo and other manufacturers phones using Verizon with Bitpim (http://www.versiontracker.com/dyn/moreinfo/macosx/27137). It is a workaround for Verizon's ultra-user-friendly phone operating system.

Maybe one day Apple will enter the cell phone market and do a better job of it, you think?

[ Reply to This | # ]
Import Address Book contacts into a new Verizon phone
Authored by: imageworx on Sep 01, '08 06:02:49AM

I also used BitPim (latest build 1.0.6) with my new LG and was able to make CSV files of each contact, export as the older format (vcard 2.1) then import into the LG with Bitpim. It helps to have the USB cable.
And I agree that (sarcasm) Verizon and LG are the most ultra-friendly phones.

---
To BeOS or Not to BeOS



[ Reply to This | # ]
Import Address Book contacts into a new Verizon phone
Authored by: loucarey62 on Jan 05, '09 11:21:35PM
The following line in the macro:
    TAG POS=1 TYPE=A ATTR=TXT:AddContact
should read:
    TAG POS=1 TYPE=A ATTR=TXT:Add<SP>Contact
Also, my Add Contact screen has the first and last names combined into 1 field. If yours has this too, the macro change for this would be from:
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:firstName CONTENT={{!COL1}}
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:lastName CONTENT={{!COL2}}
to:
    TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:name CONTENT={{!COL1}}
CPUnk, thanks for the code and for introducing me to iMacros - invaluable!

[ Reply to This | # ]
Import Address Book contacts into a new Verizon phone
Authored by: robleach on May 19, '09 11:34:35AM

I have contacts on my phone that are more current than the ones in Address Book. Anyone have a reliable way to go the reverse direction (download the entries from verizon and update the appropriate address book entries)? Note: Bitpim does not work with my phone, nor does any sync utility.

Rob



[ Reply to This | # ]