ACT! Database scripting with vbs

working on it, have some questions

[macrost]

If anyone has done this before, please lend an ear. Here's my problem: The sdk is all fine and good, but I haven't been able to find out a way to pull out just the user defined fields and do some processing on those fields. They start at 1000, but the first one actually starts at fieldid 1085. (Record number 1 in the db.)

Is there a way to use sql statements in the query method?

Thanks

[mack]

You can use Act to output to a text file then use some form of import tool.

You could use mysql if you export from Act to excel, then use something like phpmyadmin to import from excell to mysql.

When you export from Act you are also abe to determine what fields are exported. This may also help.

Mack.

[macrost]

Basically what the company wants is a script that will go through almost 20,000 records and do a search and insert on empty contact field. I'm connecting to db just fine and finally getting fieldid's but now it's the looping and the methods of movenext, movefirst and so on.

I think I need to pull all the data in one record, loop through each field, looking for what I need, and if there matching any conditions, then update record.

Jeez! :)

Mac

[Mr Bo Jangles]

Anyone half-savy with, for example, FileMaker could do this for you in half an hour.