How can I import all data from Act! 6 to OpenERP?

We want to migrate to OpenERP, but don't know how to import data in it from Act! with the contacts but also with their email, notes, history and joined email.
Erwin PombettAsked:
Who is Participating?
Mike LazarusConnect With a Mentor Act! Evangelist - CRM ConsultantCommented:
I gave a link to export the data from ACT! 6, and another to import into OpenERP... shouldn't the two have answered the question
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
I don't know what format OpenERP needs, but if it can handle importing notes, histories, etc... you can export them from ACT! with itExport for ACT! 6.0 -
Erwin PombettAuthor Commented:
We can't use itExport for ACT! as it is a Trial limited edition (10 records exported only!). Do you have any keygen or Serial? We couldn't find it for free.
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
There isn't a free one and it's not allowed to discuss things like Keygens on Experts Exchange.

You'd need to buy one from
Erwin PombettAuthor Commented:

- we didn't want to pay for the soft as we are not sure of being able to import
every thing in openerp - GLComputing, for sure when a soft help me on a job i buy it,
here  i couldn't test .....i had to pay first, that's why i ask for a sn to experts,
i shoud have been more precise with my question.
as a conclusion , it won't happen anymore ;o)
Our act reseller lend us another program inorder to export db from act.
so now i have
- an access database with my act values,
- the folder refered from tables like email, documents attached,

next step : import values into openerp db.
how do i import my values into my openerp db.
what do i have to be carefull about?

all links are hardcoded in my new access db, i have values like this : "N:/email" (act is on win)

i installed openerp on an ubutu. what would be the best place to set folders related by postgres
as windows does to "N:/email"  ?
should i put my related folders to /usr/share/openerp_repository/ ? something like that,  in a different part in the tree?

All infos are wellcome,
when an anwer needs a thread, i ll open one with 500pts to give for.

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
You'd change the path to whatever the location you put the files in.

N:\email\filename would be the path to a file that contain a particular email
Erwin PombettAuthor Commented:
ok, but what would be a good path to set it in?
/usr/share/openerp_repository ?

and if anyone has experience with this change , i mean ACT -> OpenERP,
i would be thankfull,

i'm looking to replace that ACT that work now and then, for openerp that i suppose work better ?
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Wherever you put the files that you had in n:\email in Windows.

OpenERP is an ERP system. ACT! is a CRM system. One isn't better than the other, they aren't there to do the same things.

The CRM module in Open ERP is more designed for management and enterprise reporting purposes.
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Was just having a look again... OpenERP can only import CSV according to

See if the tool your ACT! reseller used can create CSV instead of Access - although Notes often won't work in a CSV
Erwin PombettAuthor Commented:

excuse me not to have come back to the thread,
i was so disappointed after you help me  with the info of csv files,
indeed, i controled my import , i shoud have succeed, i receive no error,
just a page declaring that i should pay for help because what i was doing
was dangerous for my data,.......

thank you for your help, heere are the points ;o)

i will try later on again,  i 'll post new questions with the matter,

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
You might try asking the OpenERP guys if they have a means to bring in the other data... I couldn't any on their site, but their support guys might know something better
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.