INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...At last there is indeed a website/forum that deals with professional and serious matters. Keep up with the good work!!"

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Enterprise Applications > Vertical Industry solutions > Sage: ACT! contact managment solutions Forum

ACT 11.0 Exports to Excel; Link Opportunity to Contact

Read More Threads Like This One

jlb55 (IS/IT--Management)

20 Mar 09 13:37

I have exported both ACT Contacts and Contact Opportunties to Excel through an ODBC connection. My problem; how do I relate the Opportunity to the Contact? There does not seem to be a foreign key or Contact Name in the Opportunity entries downloaded.

Anyone have helpful tips here?

GLComputing (IS/IT--Management)

20 Mar 09 15:39

Opportunities can link to multiple contacts, multiple companies and multiple groups... you need to get the additional tables.

I usually find it easiest to do exporting with itExport, which puts it all together for you.
http://www.glcomputing.com.au/main/64/1

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust
www.GLComputing.com.au
http://blog.glcomputing.com.au
Join the LinkedIN ACT! Fanatics Group
http://www.linkedin.com/e/gis/49896

http://www.glcomputing.com.au/main/64/1

p15650 (IS/IT--Management)

2 Jul 09 14:36

Hi,

Looking to upgrade to 2009 from 2007.

During install, most computers did ok except for sever [xp pro] where the sql install gave an error in the last few seconds of the install [based on what i saw with the other computers that worked] with the error saying something about an instance of the user existed!!! All theses computers had act 2007 installed previouslty.

Noticed that sql manager only shows act7 as database on server.

1.  does act 2009 use the same database server as 2007 and therefore shows Server/ACT7 on sql server service manager screen [same as 2007 name]?

2.  eventghough the install of sql failed, act installed ok and all database functions on the server work fine with a database i created.  If everything is working, do i need to worry about problems happening later?

3.  Is there anyway to install the server on microsoft server 2000?

4.  i noticed 2009 now allows you to do automated backups and relationships.  Do you think 2009 is much superior to 2007?

thank you for your help

GLComputing (IS/IT--Management)

2 Jul 09 16:51

First, you should have posted a new thread. However:

1. ACT7 has been the instance name since ACT! 2005 (7.0)

2. Difficult to say... if there's no problems in use, it's probably OK

3. Windows server 2000 hasn't been supported by Microsoft or Sage for a few years.

4. Yes, in many ways. It's faster, more reliable and better in pretty much every way

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust
www.GLComputing.com.au
http://blog.glcomputing.com.au
Join the LinkedIN ACT! Fanatics Group
http://www.linkedin.com/e/gis/49896

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Sage: ACT! contact managment solutions