# Automise **URL:** https://www.finalbuilder.com/forums/c/automise/7.md?page=1 [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:** 2 --- ## [Options for reducing maintenance of credentials used for Map Network Drive action](https://www.finalbuilder.com/forums/t/options-for-reducing-maintenance-of-credentials-used-for-map-network-drive-action/7281)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [September 28, 2022, 2:05pm UTC](https://www.finalbuilder.com/forums/t/options-for-reducing-maintenance-of-credentials-used-for-map-network-drive-action/7281 "2022-09-28T14:05:46Z")
I recently had to change the password associated with the account that most of our Automise Projects run under. In the process of changing the credentials used for the Windows Task Scheduler tasks (not your problem :)),… --- ## [Getting return value from MSSQL Execute Action?](https://www.finalbuilder.com/forums/t/getting-return-value-from-mssql-execute-action/7247)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 1\ **Last updated:** [June 30, 2022, 7:52pm UTC](https://www.finalbuilder.com/forums/t/getting-return-value-from-mssql-execute-action/7247 "2022-06-30T19:52:49Z")
If you run something in the MSSQL Execute action, is there a way to capture values returned by the SQL that is run? If you run a Stored Procedure or a Function in MS SQL, there can be a return value…but the Output in th… --- ## [Thread safety of variables and queues etc when using ASync groups](https://www.finalbuilder.com/forums/t/thread-safety-of-variables-and-queues-etc-when-using-async-groups/4515)
**Author:** [@simon\_page](https://www.finalbuilder.com/forums/u/simon_page)\ **Replies:** 5\ **Last updated:** [April 8, 2022, 5:23am UTC](https://www.finalbuilder.com/forums/t/thread-safety-of-variables-and-queues-etc-when-using-async-groups/4515 "2022-04-08T05:23:38Z")
Where can I find details of what is safe to use when running multiple threads in ASync groups? As a developer I appreciate the issues of multi-threaded access, but I cannot find anywhere in the help that gives specific… --- ## [SFTP download of CSV file does not seem to be UTF-8 encoded - is there an option for this?](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 27\ **Last updated:** [March 29, 2022, 1:35pm UTC](https://www.finalbuilder.com/forums/t/sftp-download-of-csv-file-does-not-seem-to-be-utf-8-encoded-is-there-an-option-for-this/7193 "2022-03-29T13:35:45Z")
We have a project which connects via SFTP and downloads a CSV file. The file gets downloaded without a problem, but I then have several Text Replace actions using the downloaded file. Those actions are all failing with… --- ## [CSV Iterator and IF Statement bug](https://www.finalbuilder.com/forums/t/csv-iterator-and-if-statement-bug/7168)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 7\ **Last updated:** [February 2, 2022, 11:13pm UTC](https://www.finalbuilder.com/forums/t/csv-iterator-and-if-statement-bug/7168 "2022-02-02T23:13:15Z")
I am using Automise 5.0.0.1327, and I am iterating through a CSV file, and I am seeing two things that do not seem right. The first line of the file is the header, and it contains the following: ServerName,DatabaseName… --- ## [Http Get File - Use Server Filename](https://www.finalbuilder.com/forums/t/http-get-file-use-server-filename/7152)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 1\ **Last updated:** [December 10, 2021, 12:58am UTC](https://www.finalbuilder.com/forums/t/http-get-file-use-server-filename/7152 "2021-12-10T00:58:05Z")
Hi guys, when using the Http Get File with the User Server Filename option - how do I determine what the filename is (without saving it to an empty folder)? There doesn’t appear to be any property in the Action object… E… --- ## [How to tell what is causing Automise to get stuck?](https://www.finalbuilder.com/forums/t/how-to-tell-what-is-causing-automise-to-get-stuck/7022)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 32\ **Last updated:** [December 6, 2021, 9:42pm UTC](https://www.finalbuilder.com/forums/t/how-to-tell-what-is-causing-automise-to-get-stuck/7022 "2021-12-06T21:42:20Z")
Very occasionally, our Automise batch processes will hang up and just not complete. When I go to see what action it gets stuck on, it is something that should not be an issue. I would expect that when it does happen, i… --- ## [Possible for others to renew licenses?](https://www.finalbuilder.com/forums/t/possible-for-others-to-renew-licenses/7142)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 3\ **Last updated:** [November 29, 2021, 9:50pm UTC](https://www.finalbuilder.com/forums/t/possible-for-others-to-renew-licenses/7142 "2021-11-29T21:50:58Z")
I am the only one at my company that has access to this site. I want to give my colleagues a doc explaining how to ask questions on the forum and how to renew the licenses if needed. If someone else creates a login on … --- ## [Email/SSL/TLS issues - not sure if it is a bug or not](https://www.finalbuilder.com/forums/t/email-ssl-tls-issues-not-sure-if-it-is-a-bug-or-not/7136)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 4\ **Last updated:** [November 11, 2021, 5:14pm UTC](https://www.finalbuilder.com/forums/t/email-ssl-tls-issues-not-sure-if-it-is-a-bug-or-not/7136 "2021-11-11T17:14:53Z")
Trying to send an email through Office365 SMTP (smtp.office365.com). When I use port 25 without SSL or TLS, I get an error that STARTTLS is required to send mail, and the email fails. When I try the same port with Impl… --- ## [Best way to find latest file having filename pattern?](https://www.finalbuilder.com/forums/t/best-way-to-find-latest-file-having-filename-pattern/7118)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [September 23, 2021, 11:46am UTC](https://www.finalbuilder.com/forums/t/best-way-to-find-latest-file-having-filename-pattern/7118 "2021-09-23T11:46:32Z")
I have several action lists that start by finding files with a certain pattern (like ‘FilePatternYYYYMMDD.csv’, where YYYYMMDD is the date when the file was created). I want to work with the latest file. I have been cr… --- ## [Poucentage Character](https://www.finalbuilder.com/forums/t/poucentage-character/7101)
**Author:** [@exploit-aq](https://www.finalbuilder.com/forums/u/exploit-aq)\ **Replies:** 2\ **Last updated:** [August 18, 2021, 9:23am UTC](https://www.finalbuilder.com/forums/t/poucentage-character/7101 "2021-08-18T09:23:36Z")
Hello Everybody, I use automise from many years to manage all IT flow and i’m very satisfy. Thank for your job. I post here because i have a problem with pourcentage character. Automise use it for variable so it’s comp… --- ## [How to find/delete files older than x days?](https://www.finalbuilder.com/forums/t/how-to-find-delete-files-older-than-x-days/7087)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 5\ **Last updated:** [August 4, 2021, 3:15pm UTC](https://www.finalbuilder.com/forums/t/how-to-find-delete-files-older-than-x-days/7087 "2021-08-04T15:15:24Z")
Looking to find and delete all files older than X days (could be create date or modify date - does not really matter which). I looked at the Find Files and Delete Files actions, and there does not seem to be a way to fi… --- ## [Query Timeout Expired when no timeout is specified](https://www.finalbuilder.com/forums/t/query-timeout-expired-when-no-timeout-is-specified/7077)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 5\ **Last updated:** [July 13, 2021, 10:30pm UTC](https://www.finalbuilder.com/forums/t/query-timeout-expired-when-no-timeout-is-specified/7077 "2021-07-13T22:30:15Z")
I have an ADO DataSet Iterator that is giving Error: Query timeout expired The iterator could not be initialised. However, this is a) a copy of another ADO Dataset Iterator action that is running fine under the same … --- ## [automise.exe is being detected as Malware by Trend AV during installation.](https://www.finalbuilder.com/forums/t/automise-exe-is-being-detected-as-malware-by-trend-av-during-installation/7074)
**Author:** [@ChalkyNZ](https://www.finalbuilder.com/forums/u/ChalkyNZ)\ **Replies:** 4\ **Last updated:** [July 9, 2021, 11:59pm UTC](https://www.finalbuilder.com/forums/t/automise-exe-is-being-detected-as-malware-by-trend-av-during-installation/7074 "2021-07-09T23:59:32Z")
Hi there, the installer runs fine, but when it writes automise.exe to disk, Trend AV on-access scanner is detecting the Automise EXE as malware and blocking the write to disk. End result is installer finished without er… --- ## [Automise 4 not starting](https://www.finalbuilder.com/forums/t/automise-4-not-starting/7052)
**Author:** [@katia61](https://www.finalbuilder.com/forums/u/katia61)\ **Replies:** 1\ **Last updated:** [June 1, 2021, 10:25pm UTC](https://www.finalbuilder.com/forums/t/automise-4-not-starting/7052 "2021-06-01T22:25:54Z")
Hi, We have tons of Automise jobs and we are using TWS scheduler to kick-off command file which starts Automise. Two months ago (probably after some patches in our servers) random Automise jobs are not starting. Random … --- ## [OnFailure Action List Removed?](https://www.finalbuilder.com/forums/t/onfailure-action-list-removed/7030)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 5\ **Last updated:** [April 26, 2021, 11:17pm UTC](https://www.finalbuilder.com/forums/t/onfailure-action-list-removed/7030 "2021-04-26T23:17:32Z")
Hi guys, maybe I’m having a brain fart here, but it seems like the OnFailure action list has been removed from Automise (I’m running v5 b1258)… Please tell me that’s not true! It will be a right pain in the butt to wrap… --- ## [Where does Search/Replace window go when minimized?](https://www.finalbuilder.com/forums/t/where-does-search-replace-window-go-when-minimized/7000)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [March 12, 2021, 1:01am UTC](https://www.finalbuilder.com/forums/t/where-does-search-replace-window-go-when-minimized/7000 "2021-03-12T01:01:56Z")
While working in a project, I minimized the Search/Replace window. I closed that project, and opened another one. I could not figure out how to get back the Search/Replace window without exiting the application and ope… --- ## [Possible to get a temp license for testing a new machine?](https://www.finalbuilder.com/forums/t/possible-to-get-a-temp-license-for-testing-a-new-machine/6968)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 9\ **Last updated:** [March 2, 2021, 12:52pm UTC](https://www.finalbuilder.com/forums/t/possible-to-get-a-temp-license-for-testing-a-new-machine/6968 "2021-03-02T12:52:24Z")
We are moving Automise from a very old machine (called CT1) to a much newer machine (CT2). CT1 is currently running all of our production processes. I would like to test some of the processes on CT2 using the latest ve… --- ## [Filter Log By Action does not work when log is not the latest](https://www.finalbuilder.com/forums/t/filter-log-by-action-does-not-work-when-log-is-not-the-latest/6991)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [February 23, 2021, 11:19pm UTC](https://www.finalbuilder.com/forums/t/filter-log-by-action-does-not-work-when-log-is-not-the-latest/6991 "2021-02-23T23:19:50Z")
Steps to replicate: Click on Run History to view the available logs Open a previous log (i.e. not the latest run) Right-click on an action, and choose “Filter Log by Action” The viewed log switches to the latest run, … --- ## [Password change in Automise Map Network Drive action when project copied to new machine?](https://www.finalbuilder.com/forums/t/password-change-in-automise-map-network-drive-action-when-project-copied-to-new-machine/6973)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 4\ **Last updated:** [February 1, 2021, 9:47pm UTC](https://www.finalbuilder.com/forums/t/password-change-in-automise-map-network-drive-action-when-project-copied-to-new-machine/6973 "2021-02-01T21:47:24Z")
This is a weird one. As mentioned in another thread, we are moving our projects from an old VM (CT1) to a new VM (CT2). We have copied over our project files, and some of them are running fine on CT2 without any change… --- ## [Password prompt](https://www.finalbuilder.com/forums/t/password-prompt/6961)
**Author:** [@clint.garrison](https://www.finalbuilder.com/forums/u/clint.garrison)\ **Replies:** 1\ **Last updated:** [January 21, 2021, 1:36am UTC](https://www.finalbuilder.com/forums/t/password-prompt/6961 "2021-01-21T01:36:04Z")
Is there any way to store and re-use the password from the “Prompt for Password” action in a secure manner? Right now, it seems the only option is to store the password in variable that could then easily be read. Thank… --- ## [Not/Negate Option in FileSet Filters](https://www.finalbuilder.com/forums/t/not-negate-option-in-fileset-filters/6951)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 0\ **Last updated:** [January 4, 2021, 9:30pm UTC](https://www.finalbuilder.com/forums/t/not-negate-option-in-fileset-filters/6951 "2021-01-04T21:30:07Z")
You can add a helpful Filter as part of the FileSet define action like a “Path Contains” filter which allows you to only select files in a certain names folder, but it would be helpful to have the reverse of that in thes… --- ## [More IF Operators](https://www.finalbuilder.com/forums/t/more-if-operators/6933)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 1\ **Last updated:** [November 21, 2020, 11:51am UTC](https://www.finalbuilder.com/forums/t/more-if-operators/6933 "2020-11-21T11:51:01Z")
For AT6, it would be nice to have a few more string oriented operators on the IF action, such as “Starts With”, “Ends With”, “Is a member of a CSV List - Starts With”, “Is a member of a CSV List - Ends With” Thanks, TJ --- ## [Feature to Remove Un-referenced Variables](https://www.finalbuilder.com/forums/t/feature-to-remove-un-referenced-variables/6848)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 1\ **Last updated:** [September 10, 2020, 4:51am UTC](https://www.finalbuilder.com/forums/t/feature-to-remove-un-referenced-variables/6848 "2020-09-10T04:51:30Z")
I often copy an existing project to become the basis of a new project (it may have error emailing routines etc.), if would be nice to be able to click a button under the variable window to remove any defined variables th… --- ## [CSV iterator does not seem to work with CR (vs CRLF) at end of each line](https://www.finalbuilder.com/forums/t/csv-iterator-does-not-seem-to-work-with-cr-vs-crlf-at-end-of-each-line/6846)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 2\ **Last updated:** [September 9, 2020, 4:13pm UTC](https://www.finalbuilder.com/forums/t/csv-iterator-does-not-seem-to-work-with-cr-vs-crlf-at-end-of-each-line/6846 "2020-09-09T16:13:51Z")
I have a data file that I receive each week and process with Automise using the CSV iterator. The week of 8/27 (and all previous weeks), the file was processed fine. On 9/3 I received the same file (as far as I could t… --- ## [Checkbox on actions to run elevated](https://www.finalbuilder.com/forums/t/checkbox-on-actions-to-run-elevated/6832)
**Author:** [@clint.garrison](https://www.finalbuilder.com/forums/u/clint.garrison)\ **Replies:** 2\ **Last updated:** [September 2, 2020, 9:27pm UTC](https://www.finalbuilder.com/forums/t/checkbox-on-actions-to-run-elevated/6832 "2020-09-02T21:27:23Z")
I know it is possible to execute the entire project elevated, but it would sometimes be helpful to have the ability to execute some actions elevated while leaving the others to run as a normal user. Adding a checkbox to… --- ## [Automise process starts and hangs and there is no log I can find](https://www.finalbuilder.com/forums/t/automise-process-starts-and-hangs-and-there-is-no-log-i-can-find/6823)
**Author:** [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\ **Replies:** 5\ **Last updated:** [August 11, 2020, 2:00am UTC](https://www.finalbuilder.com/forums/t/automise-process-starts-and-hangs-and-there-is-no-log-i-can-find/6823 "2020-08-11T02:00:35Z")
We have a batch overnight process that stopped working correctly about 5 days ago. I thought it was because a set of credentials had expired and needed to be reset, but even after that was taken care of, the batch proce… --- ## [Version of PowerShell in Automise](https://www.finalbuilder.com/forums/t/version-of-powershell-in-automise/6782)
**Author:** [@clint.garrison](https://www.finalbuilder.com/forums/u/clint.garrison)\ **Replies:** 1\ **Last updated:** [May 20, 2020, 11:25pm UTC](https://www.finalbuilder.com/forums/t/version-of-powershell-in-automise/6782 "2020-05-20T23:25:41Z")
What version of PowerShell is supported in Automise? I see that the installer requires version 3, but does Automise support whatever version above that is installed on the machine where it runs? --- ## [VB Format](https://www.finalbuilder.com/forums/t/vb-format/4588)
**Author:** [@cgockel](https://www.finalbuilder.com/forums/u/cgockel)\ **Replies:** 5\ **Last updated:** [February 18, 2020, 9:17pm UTC](https://www.finalbuilder.com/forums/t/vb-format/4588 "2020-02-18T21:17:19Z")
Hi, I need to do some scripting to analyse dates. After some calculation I have a date in format dd.mm.yyyy hh:nn:ss. I need to change this to format yyyymmdd\_hhnn. So I tried “format” which will do very fine in excel V… --- ## [Operating on datetime variables natively](https://www.finalbuilder.com/forums/t/operating-on-datetime-variables-natively/6570)
**Author:** [@mrrimmer](https://www.finalbuilder.com/forums/u/mrrimmer)\ **Replies:** 6\ **Last updated:** [February 17, 2020, 3:11am UTC](https://www.finalbuilder.com/forums/t/operating-on-datetime-variables-natively/6570 "2020-02-17T03:11:29Z")
I am trying to use datetime variables but the limitations of Automise are becoming frustrating. Two variables, both datetime If compared using If…, they are converted to string before comparison. The online help says … [Previous page](https://www.finalbuilder.com/forums/c/automise/7.md) [Next page](https://www.finalbuilder.com/forums/c/automise/7.md?page=2)