07-23-2009 06:35 AM
I have waiting for ACT 2009 for about 6 month , as six month ago some one told me ACT 2008 is not possible. to using thrid party report write to access activity database table.
Now i have already install ACT 2009 , I need help on how to link the company history table with company table and contact table.
Reasons :- i need to generate sales staff visiting report. where it show how many meeting each of the sales staff have make ?
07-23-2009 06:54 AM
Related to this question . Can some one tell me :-
Report on Activities ( meeting activity ) it is exposed in the ACT! OLEDB Reporting Provider 1.0. ?
I am using ACT 2009 ver 11.
07-23-2009 03:56 PM
Thank you for yr reply.
it is possiable to give me more info how to go find the doc for how to do ?
Do i still need to link the table manually ?
07-23-2009 08:45 PM
After run the ACTREADER , i manage to access many table file name start with CTL and TBL.
Can some one tell me which is the table provide the activity ID , so that i can link the variable .
My objectives is to :-
1) Get the report on sales activity report .
2) That able to link to activity to company name and contact person.
Hope some one can help me.
07-27-2009 03:44 AM
Hi Sir, Thank you for info me ACT READER is come with ACT ver 2009.
Can some one give me more information , how to use ACT READER to access activity table ?
it is using ACT READER uility , i can see all activity file extension start with G ?
07-27-2009 08:35 AM
Hi TDavis ,
Thank you very much for reply my question , it help me a lot.
May i know that it is true that once i install the ACT READER software , i will be able to use OLE to access the TBL file you mentioned ?
just to confirm , does it mean that once i can access the TBL_Activity file and TBL_user file , meaning that i am able to export all the information like using the ACT program in the TASK TAB ( on the right ). and i can see all the task list , and when i click mouse export to excel. ( after i select the user name )?
Hope you can share with me.
Thank you for your help.
07-27-2009 08:40 AM
Yes, however all activities are stored in tbl_actvitiy whether they are cleared or not, if you only want uncleared activities you have to find the ones NOT in tbl_accessor_activity_cleared.
07-27-2009 08:56 AM
in the pass i only can export all the clear activity from act to excel , and analysis the data using QlikView.
now with the ACT READER , i can access the activity data directly using Qlik view , am i right ?
sorry for keep asking the same question, because i am very excited to comfirm this.