Janna Contact

  • Thread starter Durwood Laughinghouse
  • Start date
Status
Not open for further replies.
D

Durwood Laughinghouse

Was gmer2k able to obtain a solution to converting Janna files to Outlook? I have been using Janna for several years and would like to convert the information to Outlook and have it just as accessible as it is in the Janna program.

gamer2k wrote:

What is the best way to import data from Janna?

11-Jul-08

The company I work for is planning to switch over to BCM after using

Janna Contact for about fifteen years. Janna has been unsupported and

unupdated for nearly a decade, so this is kind of an important data

migration. Also, we have over 60000 records, so re-entering the data

is almost completely out of the question.

Does anyone have experience with this sort of thing? Is there a simple

way to transfer all of the information, or is it a multiple step

process? I've started work with queries and VB scripts in MS Access

(Janna uses .mdb files for its databases) to consolidate everything

into two tables (accounts and contacts), but I've heard it's also

possible to import Janna data into Quicken, and then import that data

into BCM. I'm sure there are other ways as well.

Finally, I'm curious as to how various things are imported. How are

notes handled? Does BCM take into account contact/account

relationships, and if so, how? What steps are needed to do that?

Thanks in advance for any help.

Previous Posts In This Thread:

On Friday, July 11, 2008 2:26 AM

gamer2k wrote:

What is the best way to import data from Janna?

The company I work for is planning to switch over to BCM after using

Janna Contact for about fifteen years. Janna has been unsupported and

unupdated for nearly a decade, so this is kind of an important data

migration. Also, we have over 60000 records, so re-entering the data

is almost completely out of the question.

Does anyone have experience with this sort of thing? Is there a simple

way to transfer all of the information, or is it a multiple step

process? I've started work with queries and VB scripts in MS Access

(Janna uses .mdb files for its databases) to consolidate everything

into two tables (accounts and contacts), but I've heard it's also

possible to import Janna data into Quicken, and then import that data

into BCM. I'm sure there are other ways as well.

Finally, I'm curious as to how various things are imported. How are

notes handled? Does BCM take into account contact/account

relationships, and if so, how? What steps are needed to do that?

Thanks in advance for any help.

On Friday, July 11, 2008 2:26 AM

Luther wrote:

Re: What is the best way to import data from Janna?

On Jul 8, 7:18=A0am, gamer...@gmail.com wrote:

BCM will import Accounts (companies) and Business Contacts (people)

from Access. You'll need to map out which fields in an Access table

map to which fields in a BCM contact. If that doesn't work, you can

export from access to CSV files, and then import those into BCM. You

may be able to map a Janna Note column to a BCM comments field. BCM

has some relationships (Business contacts work for Accounts), but you

cannot import those from Access.

EggHeadCafe - Software Developer Portal of Choice

Professional Active Server Pages 3.0 (Wrox)

http://www.eggheadcafe.com/tutorial...4-b4ea9b62129e/professional-active-serve.aspx
 
On Nov 1, 5:32 pm, Durwood Laughinghouse wrote:
> Was gmer2k able to obtain a solution to converting Janna files to Outlook?  I have been using Janna for several years and would like to convert the information to Outlook and have it just as accessible as it is in the Janna program.


Yes, but there's no one-click way to do it. I forget the exact

procedure that I used (it was a year ago), but the steps were

something like this:

1) Open up the Janna data files in MS Access. You may need to import

them, rather than just simply opening the files. The file may work

with a different database program, but I worked in Access, so the

following instructions will assume use of that.

2) Because Janna makes no distinction between companies and people,

find a way to determine which are which (I think it's a Type field or

something like that). Then, based on that, generate a table for each

with cross-tab queries in Access. The companies will be Accounts in

BCM, and the people will be Contacts. Pull out whatever fields you

can with those (name, address, phone, email, etc.) and, for the sake

of clarity, name them exactly what they are in BCM.

3) The tables will still be incomplete; they'll be missing notes and

any unusually named fields (like Fax 3, for example; really any custom

fields that don't easily map to the fields in BCM). To rectify this,

I created another table that held the notes and additional phone

numbers, along with the contact GUIDs for each.

4) I wrote a script that combined the notes and each additional phone

number or email into a single record, then added those to the existing

tables.

5) Now that both the Contact and Account tables are all set up, it's

time to import them. This should be fairly simple if you named the

fields correctly. Do a test run with a limited set of data, and if it

looks good, import the whole thing.

Hopefully this is enough to get you started; if not, I may be able to

access my files in a few weeks and I can give you more specific

answers, such as which database tables hold which information and what

queries I ran.

Gamer_2k4
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
G Outlook 2021 Add Picture to Custom Contact Form Outlook VBA and Custom Forms 2
AndyZ Contact Custom Form Tiny Text Outlook VBA and Custom Forms 3
A How to reduce size of custom contact form? Outlook VBA and Custom Forms 3
S Custom Contact card - need help creating one Outlook VBA and Custom Forms 1
U Outlook 2021 not showing contact cards in Searches Using Outlook 1
Witzker Outlook 2019 Macro to seach in all contact Folders for marked Email Adress Outlook VBA and Custom Forms 1
Witzker How to get the button Karte ( map) in custom contact form Outlook VBA and Custom Forms 2
G Adding a contact to a specific folder Using Outlook 0
B Linking contact to an Appointment Using Outlook 1
Witzker Outlook 2019 How to get a Photo in a User Defined Contact form Outlook VBA and Custom Forms 2
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
jehan2256 "History" button in Business Contact Manager Using Outlook 1
Witzker Outlook 2019 Edit contact from email does not open the user defined contactform Using Outlook 3
Horsepower Contact phone numbers randomly change Using Outlook 0
Witzker Set Cursor & Focus from any field to the body of a user Contact form in OL 2019 Outlook VBA and Custom Forms 1
Witzker Place cursor at opening, a user defined OL contact form Outlook VBA and Custom Forms 3
M Contact deletion Using Outlook 2
R Roadrunner Email Settings | Contact Roadrunner Customer Support Outlook VBA and Custom Forms 0
M Accessing ALL Outlook contact fields Outlook VBA and Custom Forms 3
S Outlook 365 Shared mailbox contact group member numbers not matching Using Outlook 0
D Contact Group - Adding Bulk Addresses Using Outlook 2
F Outlook 365 No scroll bars in Contact Using Outlook 2
N Contact Form Notes Field Touch vs Mouse Using Outlook 0
J "Contact" button in Journal entry Using Outlook 1
Witzker How to find all emails from and to a contact in OL 2019 Using Outlook 6
D Advanced e-Mail search on from/to contact group only searches for first 20 contacts in group Using Outlook 0
G Send a greeting message to a contact on birthday Outlook VBA and Custom Forms 5
S CONTACT FIELD PRINT ORDER Outlook VBA and Custom Forms 1
I Button PDF in Outlook Contact custom form Outlook VBA and Custom Forms 1
O Outlook 365 - How to create / copy a new contact from an existing one? Using Outlook 5
N contact list seen in Contact folder but knot in Address book or when 'TO' button is clicked in new email Using Outlook 0
M Disable Contact Card Results when using "Search People" in Outlook Ribbon Using Outlook 7
M Contact suggestion Using Outlook 2
H Custom Outlook Contact Form VBA Outlook VBA and Custom Forms 1
Witzker HowTo Change message Class of contact form Outlook VBA and Custom Forms 0
Witzker Open Contact missing in Outlook 2019 Using Outlook 2
Witzker HowTo start a macro with an Button in OL contact form Outlook VBA and Custom Forms 12
Witzker Pls help to change the code for inserting date in Ol contact body Outlook VBA and Custom Forms 5
R Time for another article on contact cards? Using Outlook 0
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
C Copy Outlook contact field value to another field Outlook VBA and Custom Forms 1
W Remove specific contacts from contact list Outlook VBA and Custom Forms 3
GregS 2016 Contact List being managed by Outlook.com? Using Outlook 1
F Copy and replace not update contact in another pst Using Outlook 0
A Sending contact vcards sends older version instead of updated version Using Outlook 4
T Outlook 2010 Correct way to map multiple contact fields Using Outlook 4
Victor_50 Outlook 2013 Custom Contact Form starts with "E-mail 2" Outlook VBA and Custom Forms 2
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
L dynamic and static dates in Outlook contact "notes" ie. body Using Outlook 2

Similar threads

Back
Top