Community
Showing results for 
Search instead for 
Do you mean 
Reply

Export Act company and address data field to Qlik View

Copper Contributor
Posts: 84
Country: Singapore

Export Act company and address data field to Qlik View

Hi All ,

 

I like to do the above , as i just start to using ACT 10 , not sure how to do it , hope some one give me hints how to export following field of variable as text data file for my Qlikview software :-

 

company name

contact person

address

 

Hope some one can advise me

 

Paul Yeo

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Export Act company and address data field to Qlik View

To export to a txt file, you might try this ACT! Knowledge Base article - http://tinyurl.com/432q2k

 

Or you could use the Contact List and Export to Excel as per http://tinyurl.com/3lj2rh

 

What sort of reports are you thinking of using Qlik for? Some might be done in easier ways.... or, it might be possible to create a link from Qlik View to directly read the ACT! data, but don't know how many users would want it?

Copper Contributor
Posts: 84
Country: Singapore

Re: Export Act company and address data field to Qlik View

Hi Mike ,

 

Thank you for your reply . ( sorry i just read your reply , as i still not so familiar with forum ) . i will try to both apporach you offer me , and it will solve my problem.

 

In fact i am try to using Qlikview of access ACT10 contact information on address and name and company. If ACT can have ODBC it will be best , so i can automatic update or sync act with qlikview.

 

any idea ACT can install ODBC ? 

 

Paul Yeo

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Export Act company and address data field to Qlik View

ACT! 10 can be accessed via OLEDB as per this ACT! Knowledge Base article - http://tinyurl.com/5hezym

 

I don't think ODBC is an option

Copper Contributor
Posts: 84
Country: Singapore

Re: Export Act company and address data field to Qlik View

Hi Sir , thank you veyr much for your information , it will help me a lot as i can try to figure out how to access act contact now. ( I notice that knowledge base is very helpful. ) this is the best knowledge base in the world.

 

Paul Yeo

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Export Act company and address data field to Qlik View

While I agree the KB is very useful, the one they had till last year was much easier to search and faster... I've just become very good at knowing how to search this one.

Copper Contributor
Posts: 84
Country: Singapore

Re: Export Act company and address data field to Qlik View

Hi sir , may i know the KB it is develop by ACT ?

 

Paul 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Export Act company and address data field to Qlik View

I don't think anyone would admit doing the code for the search engine of the current KB
Copper Contributor
Posts: 84
Country: Singapore

Re: Export Act company and address data field to Qlik View

Hi GL , I don't understand what you mean ? can you explan one more time.

 

Paul

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Export Act company and address data field to Qlik View