We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now


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

Medium Priority
Last Modified: 2012-06-27
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.
Watch Question

Mike LazarusAct! Evangelist - CRM Consultant

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 - http://www.glcomputing.com.au/main/69/2


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.
Mike LazarusAct! Evangelist - CRM Consultant

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 http://actshop.bevhost.com/



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

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


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 Consultant

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 Consultant

Was just having a look again... OpenERP can only import CSV according to http://doc.openerp.com/book/8/8_20_Config/8_20_Config_import_export.html

See if the tool your ACT! reseller used can create CSV instead of Access - although Notes often won't work in a CSV
Act! Evangelist - CRM Consultant
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts



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 Consultant

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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.