[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1572
  • Last Modified:

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.
0
toshi_
Asked:
toshi_
  • 7
  • 4
1 Solution
 
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 - http://www.glcomputing.com.au/main/69/2
0
 
toshi_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.
0
 
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 http://actshop.bevhost.com/
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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




0
 
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
0
 
toshi_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 ?
0
 
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.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
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
0
 
Mike LazarusAct! 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
0
 
toshi_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
0
 
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
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now