File Path, Name, Date, Time and Size
This task will loop through a folder of files and display each file's path, name, date, time and size. In order for this task to work properly, please create a folder named 'temp' in your c:\ drive and copy some files into it or modify the specified folder in the 'Loop Files' action.
A variable is first created (theFileName) using the 'Create Variable' action which will hold the value of a file's name when it is passed and used in a 'Loop Files' action. The 'Loop Files' action loops through the files contained in the folder chosen. The previously created variable (theFileName) is specified in the 'Populate variable with filename' field and is updated with the current filename. With each successive loop, the next filename is retrieved. The loop ends after all the filenames have been retrieved or when a Break is encountered.
Within the loop a 'Message Box' action displays a dialog which shows the path, name, size, date and time of the current file it has retrieved using the functions FileDateTime() and FileLen(). FileDateTime() is being used to get the files date and time. The FileDateTime() function can tell when a specific file was first created or last modified. FileDateTime returns both the date and time information as a string variable. The FileLen() function returns the length of a file in bytes. If the specified file is open when FileLen() is called, the value returned represents the size of the file immediately before it was opened.
Note: Both of these functions can be found in the AutoMate 6 'Expression Builder' which is accessible within any available action. Help on these functions (as well as many other functions) can be found in the AutoMate Help File at AutoMate -> Reference -> Basic Scripting -> Functions.
| Download This Task (0.7kb) File Path, Name, Date, Time and Size.aml |
Would you like to upload a Sample Task to the User Resource Center? Click here!
|
More Sample Tasks
|
Using the split function to parse a text file
The sample program writes out a table text file to be used as input. Normally this would be created using a text editor such as Wordpad or Textpad. Excel could be used for table-driven processing as well. Excel is more powerful and versatile while text is faster and uses less memory. The text file of parameters is read in and separated by the character '#'. In the example it just displays the table parameters as they are read, but in general the parameters would be used to perform some table-driven process. Each line is split into three words using the Split() function and puts each word into a separate variable. |
Executing a DOS command and saving the output
This example executes the DOS 'dir' command on the C: drive and puts output into a text file for further processing. It is based on the blog "Executing Command-line Applications Using The Run Action". The C:\ drive in this example could be substituted with any mapped drive or folder. The 'dir' command has many options to obtain a variety of directory/file information. Any DOS command can be substituted for the 'dir' command in this example to capture the output of the command in a file. |
Creating a Radio Button List from an Array
A radio button list is an example of how to display a menu of options. One way to populate the list is by using an array. This is a simple example of creating the menu with an array of values. After the prompt, the program displays the selection. |
Sample Workflow: Memory, Disk Space Monitoring
This sample workflow for Business Process Automation (BPA) will demonstrate how to solve a computer and/or server problem by adding resolution automation management, system gathering and reporting for troubleshooting and speedy recovery. |
Update Your Tweets with AutoMate
Are you diehard twitter-er? If you are one of them, you most likely tweet using one of the many different ways to post updates: from the web in the update box, from your phone, from your mobile web browser, or from a third party application. This sample task allows you to tweet at the comfort of your computer without logging on to your personal or business twitter account. In fact, use a hot key trigger (e.g., Alt + A) to open a dialog box, enter your tweet, and press Enter. |
Get @Mentions Tweets and Populate to Excel
A mention is any Twitter update that contains @username anywhere in the body of the Tweet. This means that replies are also considered mentions. Twitter collects these messages, as well as all replies, and stores them in the @Mentions tab on your twitter homepage. This sample task connects to your personal or company twitter account, reads all tweets in the @Mentions tab, populates them in an Excel spreadsheet by Date Created, Twitter Message, and Twitter User, and sends an email notification with an Excel attachment. This task allows you to automate the monitoring of all activities related to your twitter account on a regular basis without having to logon to Twitter or manually parse through large volumes of data. |
Create a dynamic selection list of month and years
It can be handy sometimes to give the user a selection list of month and year, for example to generate a report for that certain period. This task generates the list and considering the current month it adds a year for months that have passed already. So when you run this in March 2012 it will show January 2013 Februari 2013 March 2012 April 2012 etc The selection shows next month as default. Edward Hulleman, Aug 4 2011 |
Create/Send Encrypted AS2 Message
AS2 (Applicability Statement 2) is a standard that defines security requirements for sending and receiving EDI over the internet (EDIINT) using certificates and encryption. This sample task demonstrates how AutoMate creates an AS2 message containing an XML file attachment called book.xml, encrypts the message using a certificate native to AS2 and digitally signs the message using a certificate and key. The AS2 message is then transmitted over the internet (EDIINT). |
WMI Trigger for Notepad Process
Use of WMI has become an essential way to facilitate system and network administration. This sample task demonstrates how to use the WMI Trigger to identify if Notepad is running. If true, the user will be asked if they want the notepad.exe process closed. |
Send Email To SMS
This sample task will demonstrate how AutoMate can use the Send Email action to send a short email and have it delivered to a mobile phone as SMS. Most mobile carriers offer free Email To SMS gateways which can be used to forward simple text emails to a mobile phone. And the good news, the majority of those gateways are free and available to the general public. Carriers included in this sample task: AT&T Sprint T-Mobile Verizon The task can be updated to include any mobile carrier that offers Email To SMS gateways. |
-
10/24/07 by Abbas Sif you check 'Do not include path information (filename only)' in the file loop property window, this script would not work. The error is 'Syntax Error: Script error: "(10051) Could not open file." at script line 2'
-
10/29/07 by Marjo MartinezAbbas S, Correct. This is mainly due to the fact that the FileDateTime() and FileLen() functions need the full path and name of the file in order to work properly. Checking "Do not include path information" will not return the path, only the filename, therefore, failing the task.
-
4/6/09 by Abbas Sis there a way I can strip only the filename?
-
4/6/09 by Leonard AmabileAbbas, You can use the following: File Path %ExtractFilePath(variable)% File Name %ExtractFileName(variable)%
Comments (4)