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

x

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

Medium Priority
1,637 Views
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.
Comment
Watch Question

Mike LazarusAct! Evangelist - CRM Consultant
CERTIFIED EXPERT

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

Author

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

Commented:
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/

Author

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

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

Author

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

Commented:
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
CERTIFIED EXPERT

Commented:
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
CERTIFIED EXPERT
Commented:
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

Author

Commented:
GLComputing,

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,

toshi
Mike LazarusAct! Evangelist - CRM Consultant
CERTIFIED EXPERT

Commented:
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.

OR

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.