Sera,
Assuming you have a relatively recent version of Paradox for Windows, e.g. 5.0 or later, you'll want to:
1) Create a script that exports the table to the text file.
2) Create a shortcut that launches Paradox and runs your script.
3) Use something like the Windows Scheduled Task utility to launch your Paradox shortcut.
4) Get the text file transferred to your Unix box.
For Step 1, something like this should be sufficient:
Code:
method run(var eventInfo Event)
exportASCIIVar( "c:\\fullpath\\tablename.db",
"c:\\fullpath\\cdf_file.txt",
",", "\"", TRUE, FALSE )
exit()
endMethod
Please note the following:
1. The backslash is the escape character in ObjectPAL, so you need two backslashes to separate directory names in strings.
2. For best results, specify the complete path for the source table and the target text file.
3. Use mapped drives, not UNC paths--especially if you're using an older version of Paradox for Windows.
4. The delimiter uses the backslash to escape the double-quotation mark, which is also the delimiter for strings in ObjectPAL. (ObjectPAL doesn't support single quoted strings like Perl or other tools you're probably more familiar with.
For Step 2, copy your current Paradox shortcut, paste it into an Explorer window, right-click it, choose Properties, and then change Target to something like:
Code:
"C:\PdoxPath\pdxwin32.exe" c:\fullpath\export.ssl
For this step, please note the following:
1. You only use a single backslash to spearate directories.
2. The quotation marks only surround the file name; they do not include the name of the script you created in the previous step.
3. You need to specify the fully qualified path of your script. (Again, mapped drives are best.)
I'll leave the last two steps for you to work through. Once you've exported the data, you can use an technique you're comfortable with to get the file to your server.
Hope this helps...
-- Lance
