03. Update Converted File Titles

Introduction

While converting attachments to files using the Magic Mover application the file extension is lost. Therefore we have packaged a process that will re-add them using our "TaroWorks File Converter" managed package extension.  For example, an attachment named 'cascadingSelect.csv'  will become a file named 'cascadingSelect'. The steps in this article would restore the extension in the file name to 'cascadingSelect.csv'.

The following high level topics will be covered in this article:

• A. Install TaroWorks File Conversion Package - install this managed package extension for the upgrade.
• B. Schedule the Job to Update Files - schedule the Job to run on the same day in the next hour.
• C. Delete Job - After the batch is executed successfully, delete the scheduled job to prevent the batch to be scheduled again as it needs to be executed only once.

  A. Install TaroWorks File Conversion Package

1. Click on the TaroWorks File Conversion installation link here.
   
   • Note: To Install in Sandbox, click on this installation link here.
2. Select Install for Admins Only.
3. Check acknowledgement.
   • Note: this managed package extension is not available on the AppExchange and will be uninstalled at the end of the upgrade.
4. Click Install.

  B. Schedule the Job to Update Files

1. Click your profile and Settings.
2. Click Language & Time Zone.
3. Confirm/correct your Time Zone.
4. Click Save.

5. Click Setup.

6. Type "Apex Classes" in the quick find above the menu and click Apex Classes. 

7. Click Schedule Apex. 

8. Fill in the required information using the table below and click Save.

Job Name	ProcessToUpdateFilesTitlesJob
Apex Class	ProcessToUpdateFilesTitlesSchedule
Frequency	Weekly
Recurs every week on	<Today's day>
Start	<Today's date>
End	<Today's date>
Preferred Start Time	The next hour

 

 

  C. Delete Job

1. Click Setup.
2. Type "Apex Jobs" in the Quick Find and click Apex Jobs.  
3. Confirm the Job completed successfully.
   • Note: If failures are present, please submit a ticket. 
4. Type "Scheduled Jobs" in the Quick Find and click Scheduled Jobs.
5. Click Del next to ProcessToUpdateFilesTitlesJob.
6. Click OK to confirm. 

Conclusion

If any failure occurs, you will get a failure email with attached CSV file detailing failures. Please submit a support ticket with the failure attachment here.

Now that you have updated the file titles, you can continue to 04. Update Links in Forms Response Count.