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
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