How do I use "Files & Folders" Custom Tasks in MARS?

With Files & Folders tasks you can automatically move and delete files, merge PDF or Excel files, even upload files to SharePoint.

Custom Tasks - Files & Folders

  • In the Schedule Wizard, go to Custom Tasks.
MS Access: Custom Tasks Wizard in Schedule in MARS.

File & Folders Tasks

MS Access: File & Folders Tasks in MARS.
  • With these tasks you can automatically move and delete files, merge PDF or Excel files, even upload files to SharePoint.

Copy File

General

  • Use this task to copy one or more files from one location to another.
MS Access. Custom Tasks: Copy File in MARS.
  • Task Name: Enter a name for the task.
  • Files: Click (+) to browse and select files.
  • Destination Folder: Browse to select the destination folder.
Tip: You can use Insert Menu to dynamically choose the destination folder.
  • Replace existing files at destination: Check this option if the file being copied is to replace an existing file at the specified destination.
MS Access. Custom Tasks: Copy File in MARS.
  • Task Name: Enter a name for the task.
  • Files: Use (…) to browse and select files.
  • Recursive: Copy all folder and/or documents in that path.
  • Recreate Folder Structure: Recreate the folder structure.
  • Destination Folder: Browse to select the destination folder.
Tip: You can use Insert Menu to dynamically choose the destination folder.
  • Replace existing files at destination: Check this option if the file being copied is to replace an existing file at the specified destination.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Rename/Move File

General

  • Use this task to move a file. Keep the old name, or rename it by simply typing in a new name. Check to overwrite existing.
MS Access. Custom Tasks: Rename/Move File in MARS.
  • Task Name: Give the task a name
  • Original File Name: Use (…) to browse to the file that needs to be moved or renamed
  • New File Name: Use (…) to navigate to the location where the new file will be moved to. Here is where you would also enter the new name for the file.
Tip: Use Insert Menu to rename the file or navigate to a folder destination
  • Overwrite Existing: Check this option if the new file is going to overwrite an existing file at the specified location.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Delete Files

General

  • Use this task to delete old files. This may be used as an alternative to folder housekeeping.
MS Access. Custom Tasks: Delete Files in MARS.
  • Task Name: Give the task a name.
  • Files: Use (+) button to navigate to the required file.
Tip: You can use Insert Menu for the file name if required.
MS Access. Custom Tasks: Delete Files in MARS.
  • Task Name: Give the task a name.
  • Files: Use (+) button to navigate to the required file.
Tip: You can use Insert Menu for the file name if required.
  • Recursive: Delete all folder and/or documents in that path.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Write Text File

General

  • Use this task to create or write to existing text files, or append information and create your own log file.
MS Access. Custom Tasks: Write Text File in MARS.
  • Task Name: Give the task a name.
  • File Name: Use (…) button to navigate to the file that is going to be written to.
  • Text: Create the text that you want to write to the desired file.
Tip: Use Insert Menu to insert constants or database values.
  • If the File exists…
  • Overwrite: If this option is selected then the desired file will be overwritten with the text file and content above.
  • Append: Select this option to add the text to an existing file.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Folder Housekeeping

General

Local Directory

  • Use this task to regularly clear our folders. Sometimes folders used for report outputs can get very large.
MS Access. Custom Tasks: Folder Housekeeping in MARS.
  • Task Name: Give the task a name.
  • Local Directory: Use (…) to navigate to the folder containing the files that need to be purged.
  • Delete files older than: Select the desire file life span that will be deleted.
  • Include Subfolders: Clean any subfolders that contain files older than the specified amount of time.

Remote (FTP) Directory

MS Access. Custom Tasks: Folder Housekeeping in MARS.
  • Task Name: Give the task a name.
  • FTP Server: Enter your FTP Server details and authentication credentials.
  • Remote Directory: Browse or enter the folder path for the directory that will be purged.
  • Delete files older than: Select the desire file life span that will be deleted.
  • Include Subfolders: Clean any subfolders that contain files older than the specified amount of time.
MS Access. Custom Tasks: Folder Housekeeping in MARS.
  • You can set Certificate Settings where applicable.
MS Access. Custom Tasks: Folder Housekeeping in MARS.
  • You can also set Proxy Server details where required. Please make sure to contact you Network Administrator to verify if these are needed.

For more on Folder Housekeeping, click here.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Create Folder

General

  • Use this task to create a new folder. Simply browse for the parent folder, and then tell MARS what the new folder name should be.
MS Access. Custom Tasks: Create Folder in MARS.
  • Task Name: Give the task a name.
  • Parent Folder: Use (…) button to browse to the parent folder.
  • Folder Name: Enter the name of the new folder that will be created.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Rename/Move Folder

General

MS Access. Custom Tasks: Rename/Move Folder in MARS.

MS Access. Custom Tasks: Rename/Move Folder in MARS.
  • Task Name: Give the task a name.
  • Move: Click this option to move the folder.
  • Rename: Click this option to rename a folder.
  • Select Folder: Use (…) button to browse to the folder you want to move.
  • Destination Folder: Use (…) button to browse to the location of the new folder.
  • New Name: Type the new name for the folder.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Zip Files

General

Simple

  • Use this option if you need to zip single files from multiple locations.
MS Access. Custom Tasks: Zip Files in MARS.
  • Task Name: Give the task a name.
  • Files: Use (+) button to select the required files. You can either select a file or specify a path including wildcards e.g. *.* to select all files.
  • Output Zip File: Give the outputted zip file a name.
Tip: Use Insert Menu in the file name
  • Zip File Encryption: Enter the desired Encryption details.

Advanced

  • Use this option if you need to zip files in the same folder.
MS Access. Custom Tasks: Zip Files in MARS.
  • Task Name: Give the task a name.
  • Files: Use (+) button to select the required files. You can either select a file or specify a path including wildcards e.g. *.* to select all files.
  • Recursive: This will search the folder and all sub folders.
  • Maintain Folder Structure: Select this to ensure files of the same name are not overwritten and have the folder structure maintained. This is useful when using wildcards.
  • Output Zip File: Give the outputted zip file a name.
Tip: Use Insert Menu in the file name.
  • Zip File Encryption: Enter the desired Encryption details.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Unzip File

General

  • Use this task to unzip a selected zip file to a specified folder.
MS Access. Custom Tasks: Unzip File in MARS.
  • Task Name: Give the task a name.
  • Select Zipped File: Use (…) button to select the required zip file that is to be extracted out.
  • Password: If your file requires a password enter it here. If your .zip file requires a password, you can enter the password into the Password field.
  • Destination Folder: Use (…) button to navigate to the required folder where the extracted files will be stored.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Merge PDF Files

General

  • Use this task to merge PDF files. You can select individual PDF files or a folder containing multiple PDF files.
MS Access. Custom Tasks: Merge PDF Files in MARS.

MS Access. Custom Tasks: Merge PDF Files in MARS.
  • Task Name: Give the task a name.
  • Merge Multiple Files/Folders: Select this option to merge files located in different folders.
  • Merge all files in a single folder: Use this option to merge all files stored in the same folder.
  • Destination File: Select a destination file that the merged file will be saved to.
  • Replace existing files at destination: Check this option will delete any existing files at the specified location and replace them with these ones.

PDF Security

MS Access. Custom Tasks: Merge PDF Files in MARS.
  • Enable PDF Options: Check this option to be able to set Passwords and user permissions.
  • Include the following watermark: Type the required watermark here, for example: confidential.

PDF File Summary

MS Access. Custom Tasks: Merge PDF Files in MARS.
  • PDF File Summary: Any information written here will overwrite the existing file summary

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Manipulate PDF

General

  • Use this task to change the PDF Security and File Summary of a PDF file.

PDF Security

MS Access. Custom Tasks: Manipulate PDF in MARS.
  • Task Name: Give the task a name.
  • PDF File: Use (…) button to browse to the PDF file that you want to manipulate.
  • Enable PDF Options: Check this option to be able to set Passwords and user permissions.
  • Include the following watermark: Type the required watermark here, for example: confidential.

File Summary

MS Access. Custom Tasks: Manipulate PDF in MARS.
  • PDF File Summary: Any information written here will overwrite the existing file summary.

Build Excel Workbook

General

MS Access. Custom Tasks: Build Excel Workbook in MARS.
  • Task Name: Give the task a name.
  • Save File As: Use (…) button to navigate to the folder where the workbook will be stored.
  • Replace if File exists: Check this option if this workbook is going to be replacing one that already exists.
  • Edit: Edit a Data set for a workbook.
  • Delete: Deletes a data set from the workbook.
  • Add a Database:
    • Click Add.
MS Access. Custom Tasks: Build Excel Workbook in MARS.
  • Click OK.
  • Name the Data set.
MS Access: Get Values from database interface in MARS.
  • Use the Query Tool to pull the data from your data source.
  • Click Parse to review your query results.
  • Click Yes.
  • Continue to add data sets until you have completed your workbook.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Merge Excel Files

General

MS Access. Custom Tasks: Merge Excel Files in MARS.
  • With this task, you can merge multiple Excel files into a single workbook.
  • Add Files: Use (+) button to add Excel files that need to be merged.
  • Delete Files: Use (X) button to remove any Excel files that you don’t want to be merged.
  • Destination File: Use (…) button to browse to the destination folder where the merged files will be stored.
  • Replace existing files at destination: Check this option to replace the file at the destination if it already exists.

Excel Security

MS Access. Custom Tasks: Merge Excel Files in MARS.
  • Password Protect Workbook: Check this option to enable to password field.
  • Owner Password: Enter a password for the Excel file.

Excel File Summary

MS Access. Custom Tasks: Merge Excel Files in MARS.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Manipulate Excel

General

  • Use this task to edit the file security and the file summary of an excel file.

Excel Security

MS Access. Custom Tasks: Manipulate Excel in MARS.
  • Password: Enter a Password for the Excel File.
  • Read Only: Check this option if the Excel file will be read only.

File Summary

MS Access. Custom Tasks: Manipulate Excel in MARS.
  • File Summary: Any information written here will overwrite the existing file summary of the excel file.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Upload to SharePoint

General

MS Access. Custom Tasks: Upload to SharePoint in MARS.
  • Task Name: give the task a name.
  • Files: Use (…) button to navigate to the files that you want to export to the SharePoint Server.
  • SharePoint Server Library: It will appear the SharePoint Site.
  • SharePoint hosted on Office 365: Check this option if the SharePoint Server is hosted on office 365.
  • Document Library: Use (…) button to open the SharePoint Connection Window.
MS Access. SharePoint Browser in MARS.
  • SharePoint Server Browser: Complete the SharePoint Information and navigate to the required Document library.
  • Metadata: File Metadata Can be uploaded as well. Simply add the column names and values as needed.
MS Access. Custom Tasks: Upload to SharePoint in MARS.

Options

MS Access. Custom Tasks: Options in MARS.
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.