AutoMate URC Home

  • Home
  • •
  • Blog
  • •
  • Tutorials
  • •
  • Sample Tasks
  • •
  • Knowledgebase
  • •
  • Support & Documentation
  • •
  • Versions
Support > Sample Tasks > View Sample Task

File Path, Name, Date, Time and Size

added on May 26, 2006 by Marjo Martinez (marjo ~dot~ martinez ~at~ networkautomation ~dot~ com)
Applies To: AutoMate 6, AutoMate 5

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!
Tweet



More Sample Tasks

Using the split function to parse a text file 12/19/11 • David Hubbard

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 12/8/11 • David Hubbard

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 12/2/11 • David Hubbard

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 11/7/11 • Network Automation

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 8/22/11 • Network Automation

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 8/16/11 • Network Automation

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 8/4/11 • Edward Hulleman

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 7/18/11 • Network Automation

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 5/24/11 • Network Automation

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 4/8/11 • Network Automation

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.

 

Comments (4)

What are you thinking?
  1. 10/24/07 by Abbas S
    if 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'
  2. 10/29/07 by Marjo Martinez
    Abbas 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.
  3. 4/6/09 by Abbas S
    is there a way I can strip only the filename?
  4. 4/6/09 by Leonard Amabile
    Abbas, You can use the following: File Path %ExtractFilePath(variable)% File Name %ExtractFileName(variable)%

Search the URC

Subscribe to Version History via RSS
Subscribe to Version History via RSS
Version Watcher

9.0.0.0 changelog
9.0.0.0 changelog
other versions downloads

Contribute

Upload a Sample Task Post to our Discussion Forums
in our blog: Ask an ASE, AutoMate News, Automation Strategy, CEO Corner, Founder's Corner, In the News, Inside Development, Meet Our Team, Success Story, Task of the Month, Tech Talk, Thread of the Month, Webinar Schedule

Subscribe to Latest Resources via RSS
Subscribe to Latest Resources via RSS
Latest Resources

Resources to include:
Save Changes
show filter options
  • blog
    post
    Be Nice to Nerds
  • blog
    post
    Share your Best IT Story on Spiceworks for a Chance to Win a Kindle Fire
  • blog
    post
    AutoMate Online Classroom Training for March
  • blog
    post
    Network Automation Announces Q2 FY12 Results, Revenues up 13.6% Over Previous Quarter
  • video
    tutorial
    Getting Started With AutoMate 9
  • blog
    post
    Automating Stored Procedures
  • sample
    task
    Using the split function to parse a text file
  • blog
    post
    AutoMate Online Classroom Training
  • blog
    post
    AutoMate Now on Google+
  • blog
    post
    Automate SharePoint Uploads
  • blog
    post
    AutoMate 8 Named Best Task Automation Product for 2011 Windows IT Pro Awards
  • sample
    task
    Executing a DOS command and saving the output
  • blog
    post
    AutoMate--The Same in Every Language
  • blog
    post
    Network Automation Launches AutoMate 9
  • sample
    task
    Creating a Radio Button List from an Array

Subscribe to Forum Posts via RSS
Subscribe to Forum Posts via RSS
Forum Posts

  • 2/1/12 3:36pm Auto Logon with security pop-up Windows 7
  • 1/24/12 11:53pm Reading first line of file
  • 1/23/12 7:32am Clean out directories
  • 1/23/12 1:14am Restart service on remote machine?
  • 1/20/12 3:00pm TN5250 {PGUP} and {PGDN} not working (#3529)
  • 1/19/12 2:28pm Task could not start because the specified interactive session (session "7") could not be located.
  • 1/19/12 8:49am Deleting Folders by date
 
A BBB Accredited business since 05/11/1999 Find Network Automation on Facebook Follow Network Automation on Twitter Find Network Automation on Linked In
© 2004-2012 Network Automation, Inc. All worldwide rights reserved
  • Blog |
  • Privacy Statement |
  • Contact Us |
  • Sitemap
Welcome to Network Automation, developers of AutoMate and AutoMate BPA Server
Sign In  •  My Account  •   Contact Us  •     
Network Automation Software Home full menu
  • Overview
    • Why Business Process Automation?
    • An Introduction to Business & IT Process Automation
    • Business Process Automation Solutions by Industry
    • Business Processes That Are Commonly Automated
    • Business Process Automation Solutions for People
  • Products
    • AutoMate 9
    • BPA Server 9
    • Features
    • Demo Videos & Recorded Webinars
    • AutoMate in the News
    • Literature & White Papers
  • Services
    • Online Classroom Training
    • Personalized Training
    • Product Implementation
  • Downloads
  • Purchase
    • AutoMate & BPA Server
    • Product Maintenance
    • Product Training
    • Implementation
    • Product Support
    • Purchase From a Reseller
  • Partners
    • Find a Partner
    • Partnership Overview
    • Partnership Benefits
    • Apply for Partnership
    • Partner Portal
    • Contact
  • Support
    • Blog
    • Tutorials
    • Sample Tasks
    • Knowledgebase
    • Online Technical Support
    • Version History
    • Forums
  • News
    • AutoMate in the News
    • Blog
    • Press Releases
    • Case Studies
    • Automation Webinar
  • Company
    • About NAI
    • Management Team
    • Careers
    • Contact
    • Logo Downloads
Questions? email | (888) 786-4796