# Automise **URL:** https://www.finalbuilder.com/forums/c/automise/7.md?page=5 [Latest](https://www.finalbuilder.com/forums/latest.md) · [Categories](https://www.finalbuilder.com/forums/categories.md) · [Tags](https://www.finalbuilder.com/forums/tags.md) **Page:** 6 --- ## [How does Stack/Queue Contains work?](https://www.finalbuilder.com/forums/t/how-does-stack-queue-contains-work/4582)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 1\ **Last updated:** [September 15, 2014, 5:23am UTC](https://www.finalbuilder.com/forums/t/how-does-stack-queue-contains-work/4582 "2014-09-15T05:23:08Z")
There is an action called Stack/Queue Contains, but the help file does not have anything on it. It seems to act like an IF statement, i.e. if the stack contains a certain value, then a return code of some sort can be pl… --- ## [Automise 4.0.0.721 Released](https://www.finalbuilder.com/forums/t/automise-4-0-0-721-released/4581)
**Author:** [@nevar](https://www.finalbuilder.com/forums/u/nevar)\ **Replies:** 0\ **Last updated:** [September 3, 2014, 7:58am UTC](https://www.finalbuilder.com/forums/t/automise-4-0-0-721-released/4581 "2014-09-03T07:58:25Z")
Hi All Automise 4.0.0.712 official update is available from the downloads page. To see what has changed in this build see the version history page --- ## [Best data type for "Calculate File MD5" action](https://www.finalbuilder.com/forums/t/best-data-type-for-calculate-file-md5-action/4579)
**Author:** [@mrrimmer](https://www.finalbuilder.com/forums/u/mrrimmer)\ **Replies:** 3\ **Last updated:** [September 1, 2014, 12:19pm UTC](https://www.finalbuilder.com/forums/t/best-data-type-for-calculate-file-md5-action/4579 "2014-09-01T12:19:04Z")
The docs state that this action generates a 128 bit integer, however I can’t find anything that says which data type to use - presumably the “integer” type is 32 or 64 bit. At the moment I’m using a string and convertin… --- ## [Automise 4.0.0.708 Released](https://www.finalbuilder.com/forums/t/automise-4-0-0-708-released/4580)
**Author:** [@nevar](https://www.finalbuilder.com/forums/u/nevar)\ **Replies:** 0\ **Last updated:** [August 19, 2014, 1:19am UTC](https://www.finalbuilder.com/forums/t/automise-4-0-0-708-released/4580 "2014-08-19T01:19:55Z")
Hi All Automise 4.0.0.708 official update is available from the downloads page. To see what has changed in this build see the version history page --- ## [String Length?](https://www.finalbuilder.com/forums/t/string-length/4578)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [August 14, 2014, 5:12am UTC](https://www.finalbuilder.com/forums/t/string-length/4578 "2014-08-14T05:12:46Z")
Is there a way to get the length of a string? I want to get the length of a string so that I can replace the characters for that string with the equivalent number of spaces in a larger string. As an example: My have a… --- ## [Dynamic date time for schedule task](https://www.finalbuilder.com/forums/t/dynamic-date-time-for-schedule-task/4312)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 5\ **Last updated:** [August 12, 2014, 1:36am UTC](https://www.finalbuilder.com/forums/t/dynamic-date-time-for-schedule-task/4312 "2014-08-12T01:36:19Z")
Hi, My latest project with Automise, I am trying to schedule tasks, based on dates and times comming from a database. Grabbing this is ne sweat, but scheduling the task on a date and time stored in variables has turned o… --- ## [Action group variables not recognised](https://www.finalbuilder.com/forums/t/action-group-variables-not-recognised/4692)
**Author:** [@mrrimmer](https://www.finalbuilder.com/forums/u/mrrimmer)\ **Replies:** 2\ **Last updated:** [August 11, 2014, 2:57am UTC](https://www.finalbuilder.com/forums/t/action-group-variables-not-recognised/4692 "2014-08-11T02:57:02Z")
Although the code runs, in the IDE I see this error for any action group variable in the ADO Execute Stored Procedure action. Other actions seem to be OK (so far). --- ## [Crash when choosing MSN Messenger from Automise Options Window](https://www.finalbuilder.com/forums/t/crash-when-choosing-msn-messenger-from-automise-options-window/4690)
**Author:** [@mrrimmer](https://www.finalbuilder.com/forums/u/mrrimmer)\ **Replies:** 2\ **Last updated:** [August 5, 2014, 4:16am UTC](https://www.finalbuilder.com/forums/t/crash-when-choosing-msn-messenger-from-automise-options-window/4690 "2014-08-05T04:16:08Z")
Latest version, 699 on Windows Server 2008 R2. Run Automise Tools Options Categories/Internet MSN Messenger Problem signature: Problem Event Name: APPCRASH Application Name: Automise4.exe Application Ver… --- ## [Reset action group variable to default fails](https://www.finalbuilder.com/forums/t/reset-action-group-variable-to-default-fails/4691)
**Author:** [@mrrimmer](https://www.finalbuilder.com/forums/u/mrrimmer)\ **Replies:** 1\ **Last updated:** [August 5, 2014, 3:19am UTC](https://www.finalbuilder.com/forums/t/reset-action-group-variable-to-default-fails/4691 "2014-08-05T03:19:15Z")
Action group variable is of type boolean, specified with default value “true”. Getting the following error when running a reset variable action: Reset Variable to Default Reset varia… --- ## [Automise 4.0.0.699 Released](https://www.finalbuilder.com/forums/t/automise-4-0-0-699-released/4577)
**Author:** [@nevar](https://www.finalbuilder.com/forums/u/nevar)\ **Replies:** 0\ **Last updated:** [July 31, 2014, 4:18am UTC](https://www.finalbuilder.com/forums/t/automise-4-0-0-699-released/4577 "2014-07-31T04:18:14Z")
Hi All Automise 4.0.0.699 official update is available from the downloads page. To see what has changed in this build see the version history page --- ## [Values for UseTLS](https://www.finalbuilder.com/forums/t/values-for-usetls/4565)
**Author:** [@cgockel](https://www.finalbuilder.com/forums/u/cgockel)\ **Replies:** 7\ **Last updated:** [July 29, 2014, 4:37am UTC](https://www.finalbuilder.com/forums/t/values-for-usetls/4565 "2014-07-29T04:37:33Z")
Hi, I use “send mail” and now need to use SSL. What are the parameters (names of the constants) for UseTLS (TIdUseTLS)? I couldn’t find in the documentation. Thanks HHK --- ## [Connecting to a MySQL server/database to select records](https://www.finalbuilder.com/forums/t/connecting-to-a-mysql-server-database-to-select-records/4576)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 1\ **Last updated:** [July 21, 2014, 2:38am UTC](https://www.finalbuilder.com/forums/t/connecting-to-a-mysql-server-database-to-select-records/4576 "2014-07-21T02:38:57Z")
Greetings! I have managed to execute commands on a MySQL server by using a defined ODBC connection and the osql.exe program and an “Execute Program” action. However, when I try to use the same logic to SELECT rows from… --- ## [Automise 4.0.0.684 Released](https://www.finalbuilder.com/forums/t/automise-4-0-0-684-released/4575)
**Author:** [@nevar](https://www.finalbuilder.com/forums/u/nevar)\ **Replies:** 0\ **Last updated:** [July 18, 2014, 5:43am UTC](https://www.finalbuilder.com/forums/t/automise-4-0-0-684-released/4575 "2014-07-18T05:43:30Z")
Hi All Automise 4.0.0.684 official update is available from the downloads page. To see what has changed in this build see the version history page --- ## [ADO/SQL Export Option to CSV?](https://www.finalbuilder.com/forums/t/ado-sql-export-option-to-csv/4392)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 3\ **Last updated:** [July 17, 2014, 6:06am UTC](https://www.finalbuilder.com/forums/t/ado-sql-export-option-to-csv/4392 "2014-07-17T06:06:41Z")
Any ideas on how to quickly and easily export a SQL result set to CSV? There are options to dump to the log and to XML, how about a plain old CSV/Tab delimited text file? I was hoping for something a little more effcient… --- ## [Increment a date variable?](https://www.finalbuilder.com/forums/t/increment-a-date-variable/4574)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 3\ **Last updated:** [July 17, 2014, 5:58am UTC](https://www.finalbuilder.com/forums/t/increment-a-date-variable/4574 "2014-07-17T05:58:05Z")
Greetings! In my action list, I set a %nowDate% variable to (today - 1 month) using a GetDateTime action. I have a While Loop set up to do a series of actions until %nowDate% is equal to today. At the end of the While… --- ## [FTP Mirror Transer Time Error](https://www.finalbuilder.com/forums/t/ftp-mirror-transer-time-error/4573)
**Author:** [@andrewbarnard](https://www.finalbuilder.com/forums/u/andrewbarnard)\ **Replies:** 3\ **Last updated:** [July 10, 2014, 2:33am UTC](https://www.finalbuilder.com/forums/t/ftp-mirror-transer-time-error/4573 "2014-07-10T02:33:28Z")
Hi Support Is there anyway to get around FTP Mirror timing out when nothing has been transfered for 10 minutes because it takes longer than 10 minutes to generate the file list to copy? Thanks Andy --- ## [SQL Select or ADO Iterator to get output to a file, nicely formatted](https://www.finalbuilder.com/forums/t/sql-select-or-ado-iterator-to-get-output-to-a-file-nicely-formatted/4572)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [July 8, 2014, 9:04am UTC](https://www.finalbuilder.com/forums/t/sql-select-or-ado-iterator-to-get-output-to-a-file-nicely-formatted/4572 "2014-07-08T09:04:40Z")
What I am trying to do seems basic: Select a bunch of fields from a database table, and export them to a text file with a delimiter (comma, pipe, whatever). However, I cannot get this to work without doing the followin… --- ## [Running SQL statement with parameter values](https://www.finalbuilder.com/forums/t/running-sql-statement-with-parameter-values/4566)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 9\ **Last updated:** [July 3, 2014, 12:26pm UTC](https://www.finalbuilder.com/forums/t/running-sql-statement-with-parameter-values/4566 "2014-07-03T12:26:10Z")
Greetings! This is my first time using Automise. I am used to several scripting languages (Perl and TCL mainly), so that is where I am coming from. I am working on porting a Perl script to Automise logic. I am using … --- ## [Running Execute Program in a project that is being scheduled - issue?](https://www.finalbuilder.com/forums/t/running-execute-program-in-a-project-that-is-being-scheduled-issue/4571)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 3\ **Last updated:** [July 2, 2014, 2:38am UTC](https://www.finalbuilder.com/forums/t/running-execute-program-in-a-project-that-is-being-scheduled-issue/4571 "2014-07-02T02:38:36Z")
Greetings! I have a project that goes and gets some data via the ADO Iterator, and puts the data into one of two files. The project then runs Open Air Integration Manager using Execute Program. It runs the IM twice -… --- ## [ADO Dataset Iterator hangs when called via Task Scheduler?](https://www.finalbuilder.com/forums/t/ado-dataset-iterator-hangs-when-called-via-task-scheduler/4570)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [July 1, 2014, 1:28am UTC](https://www.finalbuilder.com/forums/t/ado-dataset-iterator-hangs-when-called-via-task-scheduler/4570 "2014-07-01T01:28:40Z")
I have gotten good answers from here so far, so here is another issue I have run into: I have an Automise project that calls the ADO Iterator. If I run the project within Automise, it runs fine. If I run it from a com… --- ## [ATCMD.exe running priority](https://www.finalbuilder.com/forums/t/atcmd-exe-running-priority/4569)
**Author:** [@toni.brown](https://www.finalbuilder.com/forums/u/toni.brown)\ **Replies:** 1\ **Last updated:** [June 23, 2014, 1:12am UTC](https://www.finalbuilder.com/forums/t/atcmd-exe-running-priority/4569 "2014-06-23T01:12:07Z")
Hi, Is is possible to get ATCMD to run in a lower priority state so that if it needs to do something CPU intensive (like compress zips) that it doesn’t hog all the CPU if there are other things running at the same time… --- ## [ADO Dataset iterator - timeout grayed out](https://www.finalbuilder.com/forums/t/ado-dataset-iterator-timeout-grayed-out/4517)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 3\ **Last updated:** [June 19, 2014, 11:06am UTC](https://www.finalbuilder.com/forums/t/ado-dataset-iterator-timeout-grayed-out/4517 "2014-06-19T11:06:21Z")
Hello all, When I try to extend the timeout on a ADO Dataset Iterator the timeout feature is grayed out. This is the case for Automise V3 and V4. Am I doing something wrong or is this not yet implented for this action? … --- ## [Using ODBC for SQL commands](https://www.finalbuilder.com/forums/t/using-odbc-for-sql-commands/4568)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 1\ **Last updated:** [June 18, 2014, 2:11am UTC](https://www.finalbuilder.com/forums/t/using-odbc-for-sql-commands/4568 "2014-06-18T02:11:01Z")
Greetings! I have my SQL commands set to use osql.exe, and I have set up a System DSN and a File DSN in Admin Tools for the connection I wish to use. However, I cannot figure out how to make Automise use the DSN I have… --- ## [ATCMD options - SQL Server](https://www.finalbuilder.com/forums/t/atcmd-options-sql-server/4567)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 2\ **Last updated:** [June 10, 2014, 11:31am UTC](https://www.finalbuilder.com/forums/t/atcmd-options-sql-server/4567 "2014-06-10T11:31:45Z")
Greetings! I am having a bit of trouble running script via ATCMD - getting an error “SQL tool not found: osql.exe”. I have a system where only ATCMD is installed, but have also tried installing Automise Runner next to… --- ## [Prompt for values with %](https://www.finalbuilder.com/forums/t/prompt-for-values-with/4564)
**Author:** [@cgockel](https://www.finalbuilder.com/forums/u/cgockel)\ **Replies:** 4\ **Last updated:** [June 10, 2014, 6:07am UTC](https://www.finalbuilder.com/forums/t/prompt-for-values-with/4564 "2014-06-10T06:07:49Z")
Hi, I have a little problem using strings with %. I have two projects. In the first I prompt for some values which are used in the second one. Those values are stored in an ini-file. To prompt for those values I read th… --- ## [E-mail client POP3, IMAP, MAPI?](https://www.finalbuilder.com/forums/t/e-mail-client-pop3-imap-mapi/4744)
**Author:** [@appserv](https://www.finalbuilder.com/forums/u/appserv)\ **Replies:** 7\ **Last updated:** [May 27, 2014, 5:21am UTC](https://www.finalbuilder.com/forums/t/e-mail-client-pop3-imap-mapi/4744 "2014-05-27T05:21:49Z")
That would be great. Any plans? --- ## [SFTP Preferred Protocol Version](https://www.finalbuilder.com/forums/t/sftp-preferred-protocol-version/4563)
**Author:** [@alphauno](https://www.finalbuilder.com/forums/u/alphauno)\ **Replies:** 1\ **Last updated:** [April 14, 2014, 1:10am UTC](https://www.finalbuilder.com/forums/t/sftp-preferred-protocol-version/4563 "2014-04-14T01:10:02Z")
Hello Vsoft, My company BCI is running Automise version 4. We are having trouble with one company whom we send data through SFTP. I have learned that SFTP protocol version 3 will work with their system however I do… --- ## [Automise 4.0.0.631 Released](https://www.finalbuilder.com/forums/t/automise-4-0-0-631-released/4562)
**Author:** [@nevar](https://www.finalbuilder.com/forums/u/nevar)\ **Replies:** 0\ **Last updated:** [April 10, 2014, 7:16am UTC](https://www.finalbuilder.com/forums/t/automise-4-0-0-631-released/4562 "2014-04-10T07:16:55Z")
Hi All Automise 4.0.0.631 official update is available from the downloads page. To see what has changed in this build see the version history page --- ## [String Position Action Case Sensitive?](https://www.finalbuilder.com/forums/t/string-position-action-case-sensitive/4756)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 3\ **Last updated:** [March 11, 2014, 2:12am UTC](https://www.finalbuilder.com/forums/t/string-position-action-case-sensitive/4756 "2014-03-11T02:12:03Z")
It would appear the string position action is case sensitive, can you add an option to make it insensitive? TJ --- ## [Wild Card in Source Path](https://www.finalbuilder.com/forums/t/wild-card-in-source-path/4561)
**Author:** [@kmarie630](https://www.finalbuilder.com/forums/u/kmarie630)\ **Replies:** 3\ **Last updated:** [March 6, 2014, 11:05am UTC](https://www.finalbuilder.com/forums/t/wild-card-in-source-path/4561 "2014-03-06T11:05:13Z")
How can I use an asterisk in the source for a file? Can I escape it somehow? I could use a fileset to find \*.zip, but I don’t really want to since I know it’s only going to find a single file. I could eliminate that ste… [Previous page](https://www.finalbuilder.com/forums/c/automise/7.md?page=4) [Next page](https://www.finalbuilder.com/forums/c/automise/7.md?page=6)