Community
Showing results for 
Search instead for 
Do you mean 
Reply

Automated/Scripted export from Act to CSV/TXT

New Member
Posts: 1
Country: United_Kingdom

Automated/Scripted export from Act to CSV/TXT

[ Edited ]

Hi there,

I'm trying to look at scripting/automating the export of data from Act into a text file as per instructions at:

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

 

Is there a way of scripting or calling the program by command-line to simply run the export routine with pre-set parameters?

 

If anyone could advise the best way of doing this it would be appreciated.

 

Thank You

 

Andy :-)

 

--edit--

Sorry forgot to mention, this is Act 2009 (11.0) running on Windows XP pro SP3

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Automated/Scripted export from Act to CSV/TXT

Bronze Contributor
Posts: 930
Country: USA

Re: Automated/Scripted export from Act to CSV/TXT

JL Technical offers an addon product called "Exporter"

http://www.jltechnical.com/exporter.htm

An excerpt from their website:

Runs manually or automatically.  Exporter can be  run without operator intervention and can be run as a scheduled after hours task. (OLE DB server or ACT! Reader server only)

 

 

Signature
Bronze Contributor
Posts: 955
Country: Australia

Re: Automated/Scripted export from Act to CSV/TXT

andy,

 

This woudl be possible using some of the scripting tool available in Windos or a (macro) type tool. I have created a couple of similar scripts for some other similar tasks.

 

Is the export the same each time - Same lookup, same fields

 

You say you are using version 11 so you woudl need to let me know which fields and and what you do to achieve the lookup.

 

Paul Buchtmann
pbuchtmann@ozemail.com.au Australia
Australia's First ACT Consultant (1989)

FREE Record History to change default to Call or To-Do for ACT! 2010-2012 versions. Custom versions also available.