Jump to content
llewxam

Juno Address Book - CSV

Recommended Posts

llewxam

LOL, OK, this script may have been more useful 8 years ago, but better late than never.......

I had a client today who was still using a Juno email program and her replacement was switching over to Outlook. I did some Googling and found very little help on converting the Juno address book to CSV so banged this out real quick:

#include <Array.au3>
$Input = @ScriptDir & "\addrbook.nv"
$Import = FileRead($Input)
$Break = StringSplit($Import, "Type:Entry", 1)
$Output = @ScriptDir & "\export.csv"
$Export = FileOpen($Output, 1)
FileWriteLine($Export, Chr(34) & "First Name" & Chr(34) & "," & Chr(34) & "Last Name" & Chr(34) & "," & Chr(34) & "Company" & Chr(34) & "," & Chr(34) & "Company Main Phone" & Chr(34) & "," & Chr(34) & "Business Phone" & Chr(34) & "," & Chr(34) & "Business Phone 2" & Chr(34) & "," & Chr(34) & "E-mail Address" & Chr(34))
For $a = 1 To $Break[0]
 $Line = $Break[$a]
 $Split = StringSplit($Line, @CR)
 If $Split[0] == 14 Then
  $Name = $Split[4]
  If StringInStr($Name, ",") Then
   If StringLen($Name) > 3 Then
    $NameSplit = StringSplit($Name, ", ", 1)
    If $NameSplit[0] > 1 Then
     $FirstName = $NameSplit[2]
     $LastName = StringReplace(StringTrimLeft($NameSplit[1], 1), "Name:", "")
    Else
     $FirstName = $Name
     $LastName = ""
    EndIf
   EndIf
  Else
   $FirstName = ""
   $LastName = ""
  EndIf
  $Company = StringReplace($Split[3], "Alias:", "")
  $CompanyMainPhone = StringReplace($Split[5], "Work Phone:", "")
  $BusinessPhone = StringReplace($Split[6], "Primary Phone:", "")
  $BusinessPhone2 = StringReplace($Split[7], "Mobile Phone:", "")
  $EmailAddress = StringReplace($Split[2], "Email:", "")
  FileWriteLine($Export, Chr(34) & $FirstName & Chr(34) & "," & Chr(34) & $LastName & Chr(34) & "," & Chr(34) & $Company & Chr(34) & "," & Chr(34) & $CompanyMainPhone & Chr(34) & "," & Chr(34) & $BusinessPhone & Chr(34) & "," & Chr(34) & $BusinessPhone2 & Chr(34) & "," & Chr(34) & $EmailAddress & Chr(34))
 EndIf
Next

Note the name of the Juno address book is addrbook.nv, you may find that in the ProgramFiles or ProgramData \Juno folder depending on OS. For my purposes I just copied it to the user's desktop, so adjust accordingly. Hopefuly this will help SOMEONE else SOMEDAY! :D

Ian

  • Like 1

My projects:

  • IP Scanner - Multi-threaded ping tool to scan your available networks for used and available IP addresses, shows ping times, resolves IPs in to host names, and allows individual IPs to be pinged.
  • INFSniff - Great technicians tool - a tool which scans DriverPacks archives for INF files and parses out the HWIDs to a database file, and rapidly scans the local machine's HWIDs, searches the database for matches, and installs them.
  • PPK3 (Persistent Process Killer V3) - Another for the techs - suppress running processes that you need to keep away, helpful when fighting spyware/viruses.
  • Sync Tool - Folder sync tool with lots of real time information and several checking methods.
  • USMT Front End - Front End for Microsoft's User State Migration Tool, including all files needed for USMT 3.01 and 4.01, 32 bit and 64 bit versions.
  • Audit Tool - Computer audit tool to gather vital hardware, Windows, and Office information for IT managers and field techs. Capabilities include creating a customized site agent.
  • CSV Viewer - Displays CSV files with automatic column sizing and font selection. Lines can also be copied to the clipboard for data extraction.
  • MyDirStat - Lists number and size of files on a drive or specified path, allows for deletion within the app.
  • 2048 Game - My version of 2048, fun tile game.
  • Juice Lab - Ecigarette liquid making calculator.
  • Data Protector - Secure notes to save sensitive information.
  • VHD Footer - Add a footer to a forensic hard drive image to allow it to be mounted or used as a virtual machine hard drive.
  • Find in File - Searches files containing a specified phrase.

Share this post


Link to post
Share on other sites
ndmcq6

Ian-

Thanks for working this up.  I am a newby so I do not know what to do with the code that you created.

Could you guide me through it? I was just able to get Outlook to connect with my Juno online account and want to get my Address Book converted

Thanks 

Andy

Share this post


Link to post
Share on other sites
llewxam

Hi, all you need to do is locate the addrbook.nv file and copy it to the same folder as the above code.  When the code runs it will create a CSV file which you can then import in Outlook.

https://support.office.com/en-us/article/Import-contacts-to-Outlook-bb796340-b58a-46c1-90c7-b549b8f3c5f8

 

If the conversion doesn't work please let me know, I wrote this for a specific customer so only used it once! :)

 

Ian


My projects:

  • IP Scanner - Multi-threaded ping tool to scan your available networks for used and available IP addresses, shows ping times, resolves IPs in to host names, and allows individual IPs to be pinged.
  • INFSniff - Great technicians tool - a tool which scans DriverPacks archives for INF files and parses out the HWIDs to a database file, and rapidly scans the local machine's HWIDs, searches the database for matches, and installs them.
  • PPK3 (Persistent Process Killer V3) - Another for the techs - suppress running processes that you need to keep away, helpful when fighting spyware/viruses.
  • Sync Tool - Folder sync tool with lots of real time information and several checking methods.
  • USMT Front End - Front End for Microsoft's User State Migration Tool, including all files needed for USMT 3.01 and 4.01, 32 bit and 64 bit versions.
  • Audit Tool - Computer audit tool to gather vital hardware, Windows, and Office information for IT managers and field techs. Capabilities include creating a customized site agent.
  • CSV Viewer - Displays CSV files with automatic column sizing and font selection. Lines can also be copied to the clipboard for data extraction.
  • MyDirStat - Lists number and size of files on a drive or specified path, allows for deletion within the app.
  • 2048 Game - My version of 2048, fun tile game.
  • Juice Lab - Ecigarette liquid making calculator.
  • Data Protector - Secure notes to save sensitive information.
  • VHD Footer - Add a footer to a forensic hard drive image to allow it to be mounted or used as a virtual machine hard drive.
  • Find in File - Searches files containing a specified phrase.

Share this post


Link to post
Share on other sites
DeeH41

Getting a "Unterminated entity reference - matching ':' not found error when running script.  Really hoping to help my friend convert his Juno over.  Thanks!

Share this post


Link to post
Share on other sites
DeeH41

Figuring it out (having AutoIt installed helps : )    )...the field order in the addressbook has changed since you wrote this.

Share this post


Link to post
Share on other sites
DeeH41

Nope, still not there.  Getting First and Last Names,, and nothing more.

Share this post


Link to post
Share on other sites
llewxam

Hi DeeH41, sorry to hear that it isn't working, however like I said I only wrote it for a single use so I would not be surprised if their address book has several different versions.  In order to try to help you, feel free to PM me and include your friend's address book file and I'll have a look in the next few days.

 

Otherwise please feel free to modify the code I posted here by re-arranging the columns appropriately.  It can't hurt to try!  :)

 

Ian


My projects:

  • IP Scanner - Multi-threaded ping tool to scan your available networks for used and available IP addresses, shows ping times, resolves IPs in to host names, and allows individual IPs to be pinged.
  • INFSniff - Great technicians tool - a tool which scans DriverPacks archives for INF files and parses out the HWIDs to a database file, and rapidly scans the local machine's HWIDs, searches the database for matches, and installs them.
  • PPK3 (Persistent Process Killer V3) - Another for the techs - suppress running processes that you need to keep away, helpful when fighting spyware/viruses.
  • Sync Tool - Folder sync tool with lots of real time information and several checking methods.
  • USMT Front End - Front End for Microsoft's User State Migration Tool, including all files needed for USMT 3.01 and 4.01, 32 bit and 64 bit versions.
  • Audit Tool - Computer audit tool to gather vital hardware, Windows, and Office information for IT managers and field techs. Capabilities include creating a customized site agent.
  • CSV Viewer - Displays CSV files with automatic column sizing and font selection. Lines can also be copied to the clipboard for data extraction.
  • MyDirStat - Lists number and size of files on a drive or specified path, allows for deletion within the app.
  • 2048 Game - My version of 2048, fun tile game.
  • Juice Lab - Ecigarette liquid making calculator.
  • Data Protector - Secure notes to save sensitive information.
  • VHD Footer - Add a footer to a forensic hard drive image to allow it to be mounted or used as a virtual machine hard drive.
  • Find in File - Searches files containing a specified phrase.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×