automation

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

akrinker
Posts: 1
Joined: Fri Jun 03, 2005 10:49 pm

automation

Postby akrinker » Fri Jun 03, 2005 11:10 pm

Hi, Simon...

congrats on a great product... Just started using it, already completed several data cleansing projects..

Question: (forgive my ignorance, i'm new to this)... I'm trying to use the data connection filter. How do I "hard code" into the filter the sql statement I need it to pass to the ODBC driver? A related question is how do I read the file or specify the input into the trial run area

I'm trying to write it in a way that it can be run from the command line interface, on a machine that won't have the full text pipe installed. What other prodcts / licences do I need to purchase to develop and distribute the applet?

Thanks for ur help

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Mon Jun 06, 2005 11:09 am

Hi there,

1. Just set the Input Filter to 'Input from Trial Run Input', and then in the Trial Run Input area, just write:

select * from mytable;

or whatever your SQL is.

You can also place this SQL into a file, and use the normal file processing option.

2. If it's just for one client, you'll probably want TextPipe Pro Run Time, which doesn't allow editing. We also have the TextPipe Engine, which is a COM object you can connect to and convert documents on the fly.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 5 guests