# Automise **URL:** https://www.finalbuilder.com/forums/c/automise/7.md?page=4 [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:** 5 --- ## [Bizarre error message when doing CSV Iterator](https://www.finalbuilder.com/forums/t/bizarre-error-message-when-doing-csv-iterator/4699)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 1\ **Last updated:** [November 11, 2015, 11:41am UTC](https://www.finalbuilder.com/forums/t/bizarre-error-message-when-doing-csv-iterator/4699 "2015-11-11T11:41:11Z")
While doing a test run of some code in Automise, I received the following error message: Assertion failure (S:\\CI\_WS\\Ws\\27901\\Src\\Core\\Stepping\\FBActionListRunner.pas, line 385) I have no idea what it refers to. I ca… --- ## [Wild Card in Control from Description](https://www.finalbuilder.com/forums/t/wild-card-in-control-from-description/4606)
**Author:** [@brianjvasquez](https://www.finalbuilder.com/forums/u/brianjvasquez)\ **Replies:** 0\ **Last updated:** [October 26, 2015, 10:03am UTC](https://www.finalbuilder.com/forums/t/wild-card-in-control-from-description/4606 "2015-10-26T10:03:14Z")
Hello! I am trying to target a text box in an application. Auto-configure seems to target the window correctly, but changing the instance of the application seems to change a number in the target, breaking the script. A… --- ## [What makes the CSV Iterator stop iterating?](https://www.finalbuilder.com/forums/t/what-makes-the-csv-iterator-stop-iterating/4605)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [October 7, 2015, 5:46am UTC](https://www.finalbuilder.com/forums/t/what-makes-the-csv-iterator-stop-iterating/4605 "2015-10-07T05:46:38Z")
I have a file that I am using CSV Iterator to loop through. The first line of the file has data in every field. The second and third lines do not have data in the FIRST field, but there is data in the other fields. Th… --- ## [Possible bug with Path Manipulation](https://www.finalbuilder.com/forums/t/possible-bug-with-path-manipulation/4698)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [October 7, 2015, 3:45am UTC](https://www.finalbuilder.com/forums/t/possible-bug-with-path-manipulation/4698 "2015-10-07T03:45:13Z")
Greetings! I have a Path Manipulation action which takes a variable called %sourceFile% (in this case, set to G:\\ReportUS.txt), removes the file extension, and applies the output to a different variable (%sourceFileNoEx… --- ## [Javascript class error - not all the time](https://www.finalbuilder.com/forums/t/javascript-class-error-not-all-the-time/4697)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 3\ **Last updated:** [September 18, 2015, 5:31am UTC](https://www.finalbuilder.com/forums/t/javascript-class-error-not-all-the-time/4697 "2015-09-18T05:31:18Z")
I have a While loop that has as its syntax (Javascript): (failedCount \< 5) && (actionSuccess == ‘FALSE’) It runs an action list in the loop, and if the action list succeeds then actionSuccess is marked TRUE. If it doe… --- ## [Possible bug with CSV Iterator - blank fields getting value from previous line of data](https://www.finalbuilder.com/forums/t/possible-bug-with-csv-iterator-blank-fields-getting-value-from-previous-line-of-data/4696)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [August 26, 2015, 6:52am UTC](https://www.finalbuilder.com/forums/t/possible-bug-with-csv-iterator-blank-fields-getting-value-from-previous-line-of-data/4696 "2015-08-26T06:52:30Z")
Greetings! I have a CSV file that I am processing with the CSV iterator. When there is data in a field on a line, but no data in the field on the next line, the next line’s variable definition is getting the data from … --- ## [What's happened to the "Bug Reports" forum?](https://www.finalbuilder.com/forums/t/whats-happened-to-the-bug-reports-forum/4604)
**Author:** [@mrrimmer](https://www.finalbuilder.com/forums/u/mrrimmer)\ **Replies:** 1\ **Last updated:** [August 20, 2015, 12:48pm UTC](https://www.finalbuilder.com/forums/t/whats-happened-to-the-bug-reports-forum/4604 "2015-08-20T12:48:35Z")
Just returned after a few months to find all the bug reports forums either disabled or removed. Have I missed something? Thanks. --- ## [How to select XML Node (with XPath)](https://www.finalbuilder.com/forums/t/how-to-select-xml-node-with-xpath/4603)
**Author:** [@rbauer](https://www.finalbuilder.com/forums/u/rbauer)\ **Replies:** 3\ **Last updated:** [August 19, 2015, 12:54pm UTC](https://www.finalbuilder.com/forums/t/how-to-select-xml-node-with-xpath/4603 "2015-08-19T12:54:53Z")
Hi, In an XML Document I want to set all occurrences of below node to “Value” \Value\ (This is from the Delphi dproj file…) There are multiple occurrences in the document. What wou… --- ## [How to check if file exists, if not then wait 30 seconds and try again, if it does continue on to next action](https://www.finalbuilder.com/forums/t/how-to-check-if-file-exists-if-not-then-wait-30-seconds-and-try-again-if-it-does-continue-on-to-next-action/4602)
**Author:** [@headlandwalk](https://www.finalbuilder.com/forums/u/headlandwalk)\ **Replies:** 2\ **Last updated:** [August 13, 2015, 2:21am UTC](https://www.finalbuilder.com/forums/t/how-to-check-if-file-exists-if-not-then-wait-30-seconds-and-try-again-if-it-does-continue-on-to-next-action/4602 "2015-08-13T02:21:59Z")
Looking to check if a file exists (flag file) if it does not exist then wait 30 seconds and loop to top to check if file exists again if it does exist continue on to next action How is it best to achieve this outcome… --- ## [Cannot check for updates with Help menu selection](https://www.finalbuilder.com/forums/t/cannot-check-for-updates-with-help-menu-selection/4598)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 3\ **Last updated:** [July 14, 2015, 12:58pm UTC](https://www.finalbuilder.com/forums/t/cannot-check-for-updates-with-help-menu-selection/4598 "2015-07-14T12:58:03Z")
I have been receiving notices that my support is ending for the instance of Automise that I have on one of my machines. When I try to use Help/Check for Updates to make sure that I have the latest software version, I ge… --- ## [FTP Mirror Exclude Directory](https://www.finalbuilder.com/forums/t/ftp-mirror-exclude-directory/4600)
**Author:** [@esco](https://www.finalbuilder.com/forums/u/esco)\ **Replies:** 2\ **Last updated:** [July 14, 2015, 12:14pm UTC](https://www.finalbuilder.com/forums/t/ftp-mirror-exclude-directory/4600 "2015-07-14T12:14:07Z")
Hi Support I am trying to exclude certain folders from a backup we are doing via FTP mirror. I can’t seem to get this to work. Can you include whole folders with multiple sub folders within them? I had tried using a Fi… --- ## [Possible to run msbuild with Automise?](https://www.finalbuilder.com/forums/t/possible-to-run-msbuild-with-automise/4599)
**Author:** [@rbauer](https://www.finalbuilder.com/forums/u/rbauer)\ **Replies:** 1\ **Last updated:** [July 13, 2015, 12:42pm UTC](https://www.finalbuilder.com/forums/t/possible-to-run-msbuild-with-automise/4599 "2015-07-13T12:42:20Z")
Hi, Is it possible to run msbuild.exe with Automise in such a way that the action will fail if msbuild has an error? If not, how to get the msbuild output into the automise log? I tried a Shell Execute action. It runs… --- ## [Why no timeout on ADO DataSet Iterator?](https://www.finalbuilder.com/forums/t/why-no-timeout-on-ado-dataset-iterator/4597)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 1\ **Last updated:** [July 1, 2015, 8:53am UTC](https://www.finalbuilder.com/forums/t/why-no-timeout-on-ado-dataset-iterator/4597 "2015-07-01T08:53:07Z")
Every other SQL/ADO action has a timeout, I now have an issue with a long running SQL query that uses an iterator, but I can;t increase the timeout as it’s missing that option - is this by design or is this something tha… --- ## [Get File Size action reports 0 length for file that does not exist](https://www.finalbuilder.com/forums/t/get-file-size-action-reports-0-length-for-file-that-does-not-exist/4694)
**Author:** [@mrrimmer](https://www.finalbuilder.com/forums/u/mrrimmer)\ **Replies:** 3\ **Last updated:** [June 2, 2015, 1:04am UTC](https://www.finalbuilder.com/forums/t/get-file-size-action-reports-0-length-for-file-that-does-not-exist/4694 "2015-06-02T01:04:22Z")
This behaviour is different from e.g. Calculate File CRC32 which fails if the specified file is not found. Get File Size \[c:\\not\\really\\here.exe\] Status: Completed Date: 28/05/2015 Time: 17:36:39:721 … --- ## [Path Manipulation does not expand relative path](https://www.finalbuilder.com/forums/t/path-manipulation-does-not-expand-relative-path/4695)
**Author:** [@mrrimmer](https://www.finalbuilder.com/forums/u/mrrimmer)\ **Replies:** 1\ **Last updated:** [June 1, 2015, 1:33am UTC](https://www.finalbuilder.com/forums/t/path-manipulation-does-not-expand-relative-path/4695 "2015-06-01T01:33:32Z")
It looks like “base path” is being ignored when expanding a relative path, defaulting instead to the Automise installation folder. For some reason .atz4 and .zip files cannot be attached so I am not sure how I can attac… --- ## [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 --- ## [Unify/Make Comparable FTP Actions](https://www.finalbuilder.com/forums/t/unify-make-comparable-ftp-actions/4799)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 1\ **Last updated:** [April 17, 2015, 11:57am UTC](https://www.finalbuilder.com/forums/t/unify-make-comparable-ftp-actions/4799 "2015-04-17T11:57:07Z")
I've noticed there are quite a few actions that are represented in one collection of FTP actions (FTP, FTPS, SFTP), but not in another, e.g. Get Remote Checksum (in FTPS, not in others), Get File Date (FTPS, not in other… --- ## [SFTP Mirror](https://www.finalbuilder.com/forums/t/sftp-mirror/4802)
**Author:** [@mrrimmer](https://www.finalbuilder.com/forums/u/mrrimmer)\ **Replies:** 2\ **Last updated:** [April 15, 2015, 1:03am UTC](https://www.finalbuilder.com/forums/t/sftp-mirror/4802 "2015-04-15T01:03:08Z")
I’ve been happily using the FTP Mirror action for years now and have just received a request to add another site to the list… but the server requires sftp (port 22, ssh variant). Can FTP Mirror support SFTP connections? … --- ## [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… --- ## [Typo in Action Title](https://www.finalbuilder.com/forums/t/typo-in-action-title/4693)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 1\ **Last updated:** [September 22, 2014, 1:06am UTC](https://www.finalbuilder.com/forums/t/typo-in-action-title/4693 "2014-09-22T01:06:05Z")
The action “ADO Execute Stored Procedure” has a typo in it in my version of Automise (4.0.0.631): --- ## [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… [Previous page](https://www.finalbuilder.com/forums/c/automise/7.md?page=3) [Next page](https://www.finalbuilder.com/forums/c/automise/7.md?page=5)