Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

How can I fully export all contact, notes, activities, and history data from ACT7 to Microsoft Access 2007 without paying any money for add-ons / utilities?

I can't seem to get my notes, activities, and history data out of ACT7.  I have tried everything SQL and ACT7 has completely shut down any hope of that happening.  I am able to extract the data through OLE DB, but it doesn't give me any IDs that will match the contact data with the notes, activities, and history belong to.  HELP!
0
iseekyoda2
Asked:
iseekyoda2
  • 4
  • 4
  • 4
2 Solutions
 
iseekyoda2Author Commented:
I have used OLE DB to extract data into Excel using the following information for the Contacts, Notes, and History tables.

OLEDB - http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=14023

But the data I get for the Notes and History tables do not contain and IDs that allow me to match the data to the contacts in the Contacts table.  This is my issue.  I am running out of hair, please help :)
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
You probably need to do a SQL Join between the tables. OLEDB is primarily designed for reporting through Crystal which has the links between the tables.

The simplest way to get the data to Access is via itExport - http://www.glcomputing.com.au/main/64/1
0
 
Jeffrey CoachmanMIS LiasonCommented:
iseekyoda2,

This product claims to do this as well.
http://www.acecrm.com/pwrcon.htm
Price $139.00USD

JeffCoachman
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Jeff,

actcrm site talks about ACT! 2000... are you sure it will do ACT! 2005 (7.0) and later?

It certainly doesn't list the additional tables in the later SQL versions

ACT! 2000 was a CodeBase variant of Foxpro... ACT! 2005 and later are SQL
0
 
iseekyoda2Author Commented:
I don't want to pay hundreds of dollars to SAGE and their affiliates / partners for proprietary fixes to claim functionality that should have been available in the first place.  I have tried every type of SQL method to extract the data.  It keeps telling me that I am not the admin or can't access the server for one reason or another.  SAGE has crippled my SQL capabilities to the point that without thier SA username and password, I don't think anything SQL is possible.

Please do not post any proposed solutions that contain a recommendation of a purchase of an add-on or other software tools, unless it costs $20 or less and works with software other than ACT7 exclusively.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Remember, the sub-table items can be attached to multiple (up to 250) contacts for each item... this is why it's much more complex.
It's not a simple one history line connect to one contact as you seem to expect with a flat-file data link.

I find it odd that you rate your own labour charge at $20 for the few hours of work it will take you to properly do the links. I wish I could get staff at that price.
0
 
Jeffrey CoachmanMIS LiasonCommented:
GLComputing,

Not sure, I posted the link for informational purposes only.
So the asker could investigate things on thire own.
;-)

Jeff
0
 
Jeffrey CoachmanMIS LiasonCommented:
iseekyoda2,

In all fariness, what you are asking for is not a $20 solution.

As GLC states ,it may be much mor complex than just exporting the data from SQL, or ODBC.

FWIW, I have not seen a product that will do what you are asking for free or less than $20.00

JeffCoachman
0
 
iseekyoda2Author Commented:
Look, you are not helping.  And, I find it irritating that you are on here pumping your wares.  I shouldn't be on here asking for help exporting "MY" data from a CRM that locks down access on "MY" system.  So, if you don't have the answer, I don't want to hear your comments/advertisements from someone who is sleeping with the enemy.  I think I have made myself clear.

The ACT7 software is coded to delete any new SQL Server admin accounts everytime it is run.  I find that criminal!  I am at the point of considering starting a class action lawsuit against SAGE.
0
 
iseekyoda2Author Commented:
VICTORY!  I got access to all of my data and successfully exported it.  Total cost: $0.00 :)  Hmmm, I see a business opportunity here.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
How long did it take you? Did you cost that into your $0?
0
 
Jeffrey CoachmanMIS LiasonCommented:
iseekyoda2,

Congratulations,
;-)

Also, if you are going to accept your own post as the Accepted solution, you must post the actual solution.

Thanks

JeffCoachman
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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