# Discussion **URL:** https://www.finalbuilder.com/forums/c/automise/discussion/18.md?page=3 [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:** 4 --- ## [Automise 4.0.0.852 Released](https://www.finalbuilder.com/forums/t/automise-4-0-0-852-released/4596)
**Author:** [@nevar](https://www.finalbuilder.com/forums/u/nevar)\ **Replies:** 0\ **Last updated:** [May 20, 2015, 8:25am UTC](https://www.finalbuilder.com/forums/t/automise-4-0-0-852-released/4596 "2015-05-20T08:25:59Z")
Hi All Automise 4.0.0.852 official update is available from the downloads page. To see what has changed in this build see the version history page --- ## [Can you iterate over a line of data?](https://www.finalbuilder.com/forums/t/can-you-iterate-over-a-line-of-data/4595)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [March 5, 2015, 5:13am UTC](https://www.finalbuilder.com/forums/t/can-you-iterate-over-a-line-of-data/4595 "2015-03-05T05:13:25Z")
Greetings! I have a List variable that I am adding to at various points. Each line of the list looks something like: 1234567,Smith,John,W,Jones,Robert,L I can obviously use the List Iterator to get each line, but how… --- ## [Object reference error](https://www.finalbuilder.com/forums/t/object-reference-error/4594)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 4\ **Last updated:** [March 2, 2015, 10:51am UTC](https://www.finalbuilder.com/forums/t/object-reference-error/4594 "2015-03-02T10:51:05Z")
I want check a Delphi XE5 application. On a form are some TsEdit controls. But i can't send a text to this. Why? The Log: Finding process SAS, No. 1 Evaluating description to find control... Retrieved control : Window Ha… --- ## [What exactly does "Exit Loop" do?](https://www.finalbuilder.com/forums/t/what-exactly-does-exit-loop-do/4593)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [February 24, 2015, 11:05am UTC](https://www.finalbuilder.com/forums/t/what-exactly-does-exit-loop-do/4593 "2015-02-24T11:05:02Z")
I cannot find any Help docs on the “Exit Loop” action. I am trying to use it in a CSV File iterator, where if the right number of rows is found (I am looking for three particular rows in the file, and incrementing a cou… --- ## [Upgrading V1 projects](https://www.finalbuilder.com/forums/t/upgrading-v1-projects/4591)
**Author:** [@martythescot](https://www.finalbuilder.com/forums/u/martythescot)\ **Replies:** 2\ **Last updated:** [January 28, 2015, 4:46am UTC](https://www.finalbuilder.com/forums/t/upgrading-v1-projects/4591 "2015-01-28T04:46:42Z")
I’ve never had a compelling reason to move from V1 until now. Just purchased V4 but now I need to know if there’s any way to upgrade V1 projects (.atpz extension)? Batch Upgrade doesn’t recognise these as being Automise … --- ## [List of projects?](https://www.finalbuilder.com/forums/t/list-of-projects/4590)
**Author:** [@sig.itsupport](https://www.finalbuilder.com/forums/u/sig.itsupport)\ **Replies:** 1\ **Last updated:** [January 7, 2015, 12:17pm UTC](https://www.finalbuilder.com/forums/t/list-of-projects/4590 "2015-01-07T12:17:49Z")
Hello all, we used to work with Automate and have now stepped over to Automise but I can’t find a way to show a list of projects in the Home screen, is that feature not implemented ? --- ## [ADO connection string to hit SQL Server msdb database?](https://www.finalbuilder.com/forums/t/ado-connection-string-to-hit-sql-server-msdb-database/4589)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 4\ **Last updated:** [December 11, 2014, 4:41am UTC](https://www.finalbuilder.com/forums/t/ado-connection-string-to-hit-sql-server-msdb-database/4589 "2014-12-11T04:41:01Z")
Greetings! I have a Perl script that selects from the SQL Server msdb database, and I am attempting to port the logic of that script into Automise. The Perl script does not need a user ID and a password to select from … --- ## [How to format a Variant type variable when displaying it as a string?](https://www.finalbuilder.com/forums/t/how-to-format-a-variant-type-variable-when-displaying-it-as-a-string/4587)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 1\ **Last updated:** [October 24, 2014, 3:13am UTC](https://www.finalbuilder.com/forums/t/how-to-format-a-variant-type-variable-when-displaying-it-as-a-string/4587 "2014-10-24T03:13:31Z")
I am doing a Simple Maths action to calculate a percentage (actually 2 - I multiply the numerator by 100, then divide it by the denominator). The resulting variable is a Variant, and ends up with 12 digits after the dec… --- ## [How to best deal with "Unspecified Error" happening (seemingly) randomly](https://www.finalbuilder.com/forums/t/how-to-best-deal-with-unspecified-error-happening-seemingly-randomly/4586)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [October 9, 2014, 8:21am UTC](https://www.finalbuilder.com/forums/t/how-to-best-deal-with-unspecified-error-happening-seemingly-randomly/4586 "2014-10-09T08:21:27Z")
I have a project that runs an MSSQL Execute action repeatedly as part of an iterated process. Most nights the process runs fine. Last night it failed on the 170th iterations, after 169 successes. The UPDATE statement … --- ## [Extracting data from XML to use as a variable](https://www.finalbuilder.com/forums/t/extracting-data-from-xml-to-use-as-a-variable/4585)
**Author:** [@tinytycoon](https://www.finalbuilder.com/forums/u/tinytycoon)\ **Replies:** 1\ **Last updated:** [October 1, 2014, 1:20am UTC](https://www.finalbuilder.com/forums/t/extracting-data-from-xml-to-use-as-a-variable/4585 "2014-10-01T01:20:16Z")
I have a simple XML (below) that holds the build information for servers. I am struggling to extract the information I need.I’m not sure where I am going wrong. Any help would be appreciated.I can’t attach the project fi… --- ## [Cinnecting to SFTP site using Public Key](https://www.finalbuilder.com/forums/t/cinnecting-to-sftp-site-using-public-key/4583)
**Author:** [@poldham](https://www.finalbuilder.com/forums/u/poldham)\ **Replies:** 1\ **Last updated:** [September 22, 2014, 1:12am UTC](https://www.finalbuilder.com/forums/t/cinnecting-to-sftp-site-using-public-key/4583 "2014-09-22T01:12:39Z")
Dear All, I would like to use Automise to download files on a regular basis from an SFTP site. At present I access the SFTP site through Filezilla and there is a .PPK public key file that is used in conjunction with th… --- ## [Require Job log contained in body of EMail Notification](https://www.finalbuilder.com/forums/t/require-job-log-contained-in-body-of-email-notification/4584)
**Author:** [@poldham](https://www.finalbuilder.com/forums/u/poldham)\ **Replies:** 1\ **Last updated:** [September 20, 2014, 7:13am UTC](https://www.finalbuilder.com/forums/t/require-job-log-contained-in-body-of-email-notification/4584 "2014-09-20T07:13:35Z")
Hi , I am running an Automise job that creates an HTML log report upon completion. Currently the .html log is emailed out to a support group as an email attachment which is causing problems for people to see it on thei… --- ## [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… --- ## [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… [Previous page](https://www.finalbuilder.com/forums/c/automise/discussion/18.md?page=2) [Next page](https://www.finalbuilder.com/forums/c/automise/discussion/18.md?page=4)