# Discussion **URL:** https://www.finalbuilder.com/forums/c/automise/discussion/18.md?page=12 [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:** 13 --- ## [Basic Math Functions?](https://www.finalbuilder.com/forums/t/basic-math-functions/4324)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 1\ **Last updated:** [September 13, 2008, 2:53am UTC](https://www.finalbuilder.com/forums/t/basic-math-functions/4324 "2008-09-13T02:53:49Z")
How do I do simply math functions like adding/subtracting two numbers? I know I can do this in script, but thats just a silly requirement if thats the case. I was expecting to be able to use Set Variable with a new value… --- ## [Deletion of Old File](https://www.finalbuilder.com/forums/t/deletion-of-old-file/4323)
**Author:** [@onyxintellect](https://www.finalbuilder.com/forums/u/onyxintellect)\ **Replies:** 1\ **Last updated:** [September 12, 2008, 1:00am UTC](https://www.finalbuilder.com/forums/t/deletion-of-old-file/4323 "2008-09-12T01:00:09Z")
I'm trying to find a method within Automize to delete files within a given directory that are older than X days. In trying to build a FileSet I don't see a way to filter the search to only get the files I want. I'm new t… --- ## [Renaming files](https://www.finalbuilder.com/forums/t/renaming-files/4322)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 1\ **Last updated:** [August 19, 2008, 3:23am UTC](https://www.finalbuilder.com/forums/t/renaming-files/4322 "2008-08-19T03:23:54Z")
Hello several files are daily generated like MiXBest2208\_18\_08\_12345678.txt. The common of all files ist they name starting with MiXbest. I wold like to rename them all to a mixbest\_1.txt. The first file will get the end… --- ## [ADO Execute SQL - Oracle](https://www.finalbuilder.com/forums/t/ado-execute-sql-oracle/4321)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 3\ **Last updated:** [July 23, 2008, 8:18am UTC](https://www.finalbuilder.com/forums/t/ado-execute-sql-oracle/4321 "2008-07-23T08:18:40Z")
Hi All, I have tried to execute an update SQL to an Oracle using the ADO Execute SQL tool.... I have tried with all possible providers fro Oracle, but the result is the same. I have checked the SQL string in Toad, and th… --- ## [Examples of scripting send mail](https://www.finalbuilder.com/forums/t/examples-of-scripting-send-mail/4319)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 1\ **Last updated:** [July 21, 2008, 3:24am UTC](https://www.finalbuilder.com/forums/t/examples-of-scripting-send-mail/4319 "2008-07-21T03:24:37Z")
Hi, I am looking for examples on how to add recipients (both To and CC) via scripting... as these will be defined in a database.. I can see that it is possible somehow, but would like to be able to do it.. :-) HH --- ## [Problem with ADO iterator](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 11\ **Last updated:** [July 7, 2008, 8:53am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315 "2008-07-07T08:53:38Z")
Hi, I am experiencing an anoying little problem with an ADO iterator... I am selecting values from an Access query, and just iterating trough it.. something that has worked well until today..now it throws an error as sho… --- ## [POP3/IMAP Mailbox Reading?](https://www.finalbuilder.com/forums/t/pop3-imap-mailbox-reading/4316)
**Author:** [@sexy-trousers](https://www.finalbuilder.com/forums/u/sexy-trousers)\ **Replies:** 6\ **Last updated:** [July 7, 2008, 3:58am UTC](https://www.finalbuilder.com/forums/t/pop3-imap-mailbox-reading/4316 "2008-07-07T03:58:28Z")
I'm evaluating Automise and I can't believe I've only just noticed there is no action to read the contents of a mailbox over POP3 or IMAP! How does eveyone else handle this? I can't be the only one that would want to rea… --- ## [How to compare two integers?](https://www.finalbuilder.com/forums/t/how-to-compare-two-integers/4317)
**Author:** [@matthiaskramer](https://www.finalbuilder.com/forums/u/matthiaskramer)\ **Replies:** 2\ **Last updated:** [July 4, 2008, 9:50am UTC](https://www.finalbuilder.com/forums/t/how-to-compare-two-integers/4317 "2008-07-04T09:50:22Z")
Hi, i try to compare two integers. I have to run a part of a script if the current time is later than 11pm and i do i that way: Variable "DatumStunde" is set with "GetDateTime" and "hh" so its "08" for example. Then i us… --- ## [FTP Download](https://www.finalbuilder.com/forums/t/ftp-download/4313)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 1\ **Last updated:** [June 30, 2008, 3:47am UTC](https://www.finalbuilder.com/forums/t/ftp-download/4313 "2008-06-30T03:47:03Z")
Guys I have a question regarding file pickup... I have a cron task that generates a file daily file; the filename stays the same and has a sequence number attached to it... for example yesterdays file was "MyComptoTHEIR\_… --- ## [Wait for Hyperterminal Window](https://www.finalbuilder.com/forums/t/wait-for-hyperterminal-window/4314)
**Author:** [@mholbert](https://www.finalbuilder.com/forums/u/mholbert)\ **Replies:** 1\ **Last updated:** [June 30, 2008, 3:41am UTC](https://www.finalbuilder.com/forums/t/wait-for-hyperterminal-window/4314 "2008-06-30T03:41:25Z")
I am building a project to automate the process of dialing into a bulletin board with hyperterminal. I should mention i'm a newbie. After a good bit of work, i finally got it to launch hyperterminal, open the appropriat… --- ## [Public Folder - attachments](https://www.finalbuilder.com/forums/t/public-folder-attachments/4311)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 2\ **Last updated:** [June 25, 2008, 9:28am UTC](https://www.finalbuilder.com/forums/t/public-folder-attachments/4311 "2008-06-25T09:28:44Z")
Hi, I am starting a project here, where I need to extract attached Excel files from emails stored in public folders. I am not quite sure how to work this, and even if it is possible in Automise? HH --- ## [VSS History action](https://www.finalbuilder.com/forums/t/vss-history-action/4310)
**Author:** [@amoshkovich](https://www.finalbuilder.com/forums/u/amoshkovich)\ **Replies:** 1\ **Last updated:** [June 18, 2008, 1:27am UTC](https://www.finalbuilder.com/forums/t/vss-history-action/4310 "2008-06-18T01:27:59Z")
Hi, Is there a VSS History action in FInalBuilder? Thanks, Alex --- ## [Controlling Automise script execution from a web server](https://www.finalbuilder.com/forums/t/controlling-automise-script-execution-from-a-web-server/4309)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 2\ **Last updated:** [June 12, 2008, 10:40am UTC](https://www.finalbuilder.com/forums/t/controlling-automise-script-execution-from-a-web-server/4309 "2008-06-12T10:40:19Z")
I am trying to automate an Automise-script from a web server running on the same machine. What I am trying to do is to control our entrance door from a button on the intranet page. The computer is running the access card… --- ## [How To Remove SQL Block Comments (/\* \*/)](https://www.finalbuilder.com/forums/t/how-to-remove-sql-block-comments/4308)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 0\ **Last updated:** [May 27, 2008, 9:43am UTC](https://www.finalbuilder.com/forums/t/how-to-remove-sql-block-comments/4308 "2008-05-27T09:43:29Z")
I would like to remove SQL Block Comments. Currently I'm using File Contents Iterator. Is there a way to bypass the tag starting with /\* and ending with \*/? Thanks --- ## [Variables dont produce the expected result](https://www.finalbuilder.com/forums/t/variables-dont-produce-the-expected-result/4307)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 3\ **Last updated:** [May 27, 2008, 1:29am UTC](https://www.finalbuilder.com/forums/t/variables-dont-produce-the-expected-result/4307 "2008-05-27T01:29:23Z")
Hi, over the last week, every time I run my automise task i am not getting the result i want for the task. I have discovered one error so far attached below. Can someone pelase assist me in fixing this issue? I am very … --- ## [Powershell Variable Access](https://www.finalbuilder.com/forums/t/powershell-variable-access/4305)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 1\ **Last updated:** [April 14, 2008, 6:52am UTC](https://www.finalbuilder.com/forums/t/powershell-variable-access/4305 "2008-04-14T06:52:54Z")
Hello Gents, I was wondering if it's possible to access (read/write) Automise variables within a Powershell script (in the Powershell action), and if so, what the syntax is. If I log to variable, I get an additional ret… --- ## [Really enhanced prompting for variables](https://www.finalbuilder.com/forums/t/really-enhanced-prompting-for-variables/4306)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 1\ **Last updated:** [April 14, 2008, 6:51am UTC](https://www.finalbuilder.com/forums/t/really-enhanced-prompting-for-variables/4306 "2008-04-14T06:51:44Z")
I've got a number of options in one of my build scripts, that are in some cases interdependant. For example, if the user enables one optional build feature, they can or must also set certain other parameters. If the us… --- ## [VBScript Problem Again](https://www.finalbuilder.com/forums/t/vbscript-problem-again/4304)
**Author:** [@ipfservicedelivery](https://www.finalbuilder.com/forums/u/ipfservicedelivery)\ **Replies:** 2\ **Last updated:** [March 31, 2008, 9:11am UTC](https://www.finalbuilder.com/forums/t/vbscript-problem-again/4304 "2008-03-31T09:11:16Z")
Hi Guys, I have another issue with trying to run a VBScript from within Automise, I know I am probably missing something simple again but I have tried various ways of trying to get it to work but i'm lost o… --- ## [Change MSI ProductVersion in MSI Nested in Setup.exe?](https://www.finalbuilder.com/forums/t/change-msi-productversion-in-msi-nested-in-setup-exe/4303)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 0\ **Last updated:** [March 20, 2008, 9:00am UTC](https://www.finalbuilder.com/forums/t/change-msi-productversion-in-msi-nested-in-setup-exe/4303 "2008-03-20T09:00:24Z")
I've created a build script to build a Setup.exe using InstallShield. The Setup.exe has the .msi embedded within it so I can deploy a single file. In the build script, I'd like to be able to update the ProductVersion … --- ## [Running VBScript code in Run Script using OnExecute](https://www.finalbuilder.com/forums/t/running-vbscript-code-in-run-script-using-onexecute/4302)
**Author:** [@ipfservicedelivery](https://www.finalbuilder.com/forums/u/ipfservicedelivery)\ **Replies:** 2\ **Last updated:** [March 20, 2008, 6:40am UTC](https://www.finalbuilder.com/forums/t/running-vbscript-code-in-run-script-using-onexecute/4302 "2008-03-20T06:40:23Z")
Hi Guys, I am trying to run the following code (See Below) in Automise2 using the 'Run Script' action from the OnExecute but it fails compilation with the following VBScript error, however if I run it fro… --- ## [Sending email with log in the body of message](https://www.finalbuilder.com/forums/t/sending-email-with-log-in-the-body-of-message/4301)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 1\ **Last updated:** [March 17, 2008, 12:31pm UTC](https://www.finalbuilder.com/forums/t/sending-email-with-log-in-the-body-of-message/4301 "2008-03-17T12:31:57Z")
I would like to get the HTML output of the logging file's XSL transform and include it as the BODY (not attachment) of an email. Is there a way to do this? Right now, I'm having a hard time finding the logging file at … --- ## [FTP outgoing connection blocked by windows firewall](https://www.finalbuilder.com/forums/t/ftp-outgoing-connection-blocked-by-windows-firewall/4300)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 2\ **Last updated:** [March 10, 2008, 4:23am UTC](https://www.finalbuilder.com/forums/t/ftp-outgoing-connection-blocked-by-windows-firewall/4300 "2008-03-10T04:23:56Z")
Hi, I am using Automise 1.5. I have an ftp connection going out and grabbing a file. It works fine if the windows firewall is disabled, but if the windows firewall is enabled the process just goes on and on for days. … --- ## [Something of a newbie question](https://www.finalbuilder.com/forums/t/something-of-a-newbie-question/4298)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 1\ **Last updated:** [March 6, 2008, 11:11am UTC](https://www.finalbuilder.com/forums/t/something-of-a-newbie-question/4298 "2008-03-06T11:11:34Z")
Hi I'm not a coder, and not generally a PC user. I use Automator on a Mac a lot to make actions - FTP, file moving etc. I want to do the same with Automise... so I've built a set of actions that do all my copying and fil… --- ## [Release with transactional queue support?](https://www.finalbuilder.com/forums/t/release-with-transactional-queue-support/4299)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 0\ **Last updated:** [March 6, 2008, 7:21am UTC](https://www.finalbuilder.com/forums/t/release-with-transactional-queue-support/4299 "2008-03-06T07:21:24Z")
When will there be an official release with support for transactional queues? We are currently using build 164 (see http://www.automise.com/Default.aspx?tabid=53&forumid=11&tpage=1&view=topic&postid=5837&language=en-… --- ## [Automise Error running DTExec](https://www.finalbuilder.com/forums/t/automise-error-running-dtexec/4297)
**Author:** [@ipfservicedelivery](https://www.finalbuilder.com/forums/u/ipfservicedelivery)\ **Replies:** 2\ **Last updated:** [February 27, 2008, 12:06pm UTC](https://www.finalbuilder.com/forums/t/automise-error-running-dtexec/4297 "2008-02-27T12:06:44Z")
Hi Fella's, I have been running an automise project which calls MSSQL DTExec as a program and passing the parameters, everything has been working fine until today. The Automise project failed indicating… --- ## [Schedule macro](https://www.finalbuilder.com/forums/t/schedule-macro/4295)
**Author:** [@dwebb](https://www.finalbuilder.com/forums/u/dwebb)\ **Replies:** 3\ **Last updated:** [February 22, 2008, 12:06pm UTC](https://www.finalbuilder.com/forums/t/schedule-macro/4295 "2008-02-22T12:06:21Z")
Hi, I am new to Automise as of this morning, I would like to know how to schedule open excel document, wait 10min, run excel macro close excel Thanks --- ## [Gmail Notification is it possible with finalbuilder 5?](https://www.finalbuilder.com/forums/t/gmail-notification-is-it-possible-with-finalbuilder-5/4296)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 1\ **Last updated:** [February 21, 2008, 11:57am UTC](https://www.finalbuilder.com/forums/t/gmail-notification-is-it-possible-with-finalbuilder-5/4296 "2008-02-21T11:57:15Z")
Does any one know how to activate gmail notification instead of outlook ? of course if it is possible ? Tx --- ## [Sending message to transactional MSMQ queue](https://www.finalbuilder.com/forums/t/sending-message-to-transactional-msmq-queue/4293)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 7\ **Last updated:** [February 18, 2008, 4:40am UTC](https://www.finalbuilder.com/forums/t/sending-message-to-transactional-msmq-queue/4293 "2008-02-18T04:40:41Z")
I am having problems sending an MSMQ message to the transactional queue. If the queue is non-transactional, everything is fine, but for the transactional ones, seems like the action does not fail, but the message does no… --- ## [Automise2 loop until](https://www.finalbuilder.com/forums/t/automise2-loop-until/4294)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 1\ **Last updated:** [January 24, 2008, 11:07am UTC](https://www.finalbuilder.com/forums/t/automise2-loop-until/4294 "2008-01-24T11:07:05Z")
Hi, I hope you can help me with this it's baffling me. I want to put a loop into a project that will keep running until a certain condition is met (like a do until in rexx). Can anyone think of a way to do this? Thanks, D… --- ## [Automate dev/uat sever builds](https://www.finalbuilder.com/forums/t/automate-dev-uat-sever-builds/4291)
**Author:** [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\ **Replies:** 1\ **Last updated:** [November 20, 2007, 5:37am UTC](https://www.finalbuilder.com/forums/t/automate-dev-uat-sever-builds/4291 "2007-11-20T05:37:01Z")
We are looking at spending some money next year on a new Dev/UAT server environment. Current we have a number of physical servers on which SQL Server is installed to match what is in production. As an option, we're c… [Previous page](https://www.finalbuilder.com/forums/c/automise/discussion/18.md?page=11) [Next page](https://www.finalbuilder.com/forums/c/automise/discussion/18.md?page=13)