The XLSX method provides the ability to make the following changes to CloudFiler via a spreadsheet:

  1. Create locations
  2. Delete locations 
  3. Edit location names or paths
  4. Upload emails


TIP: You will only be able to complete the steps below if you have entered your tenant key in the Tenant Key: field.

Creating locations


To create locations via a spreadsheet first create a simple spreadsheet in Excel with two columns where the first column lists the names of the locations and the second one lists their paths as in this example:



Save the file. 


TIP: By default, Excel will create an XLSX file which is what the Bulk Uploader can import, so if you are using an alternative spreadsheet be sure to export to XLSX format.



In the Bulk Uploader use the Browse button to select the folder that contains your XLSX file, change the Import source to Create/Update via XLSX, then select the file from the list. This will update the details in the right-hand panel to show the contents of the spreadsheet. Check the Locations you wish to process, then click the Create/Update Locations button.






The locations will be created if they don't already exist. If you have already created any of the locations via the Bulk Uploader it will skip them and show the details in the progress view. 


NOTE: Both the Bulk Uploader and the CloudFiler servers check for duplicate locations and will not allow you to inadvertently create duplicates. Any duplicate locations are skipped.


Deleting locations


To delete locations via a spreadsheet first create a simple spreadsheet in Excel with two columns where the first column lists the names of the locations and the second one lists their paths as in this example:



Save the file. 


NOTE: Whilst this method requires you to provide two columns of data and hence a path, when deleting locations the path is ignored, so you could provide the same path for each one.



TIP: By default, Excel will create an XLSX file which is what the Bulk Uploader can import, so if you are using an alternative spreadsheet be sure to export to XLSX format.



In the Bulk Uploader use the Browse button to select the folder that contains your XLSX file, change the Import source to Create/Update via XLSX, then select the file from the list. This will update the details in the right-hand panel to show the contents of the spreadsheet. Check the Locations that you wish to delete, then click the Delete Locations button.





If the locations exist they will be deleted from CloudFiler. 


WARNING: This will only delete locations from the CloudFiler servers. If you are using one of the sync methods to make copies onto your own storage, you may need to deleted them from there too.



Editing the location names or the paths of existing locations

To edit locations via a spreadsheet first create a simple spreadsheet in Excel with four columns where the first two columns are the new names and paths and the last two are the old location names and paths as in this example:



In this example we want to change both the names of the locations and their paths, you can however just change one and not the other.


Notice that the last 5 locations are unchanged. The Bulk Uploader will skip these.


Save the file. 


TIP: By default, Excel will create an XLSX file which is what the Bulk Uploader can import, so if you are using an alternative spreadsheet be sure to export to XLSX format.



In the Bulk Uploader use the Browse button to select the folder that contains your XLSX file, change the Import source to Create/Update via XLSX, then select the file from the list. This will update the details in the right-hand panel to show the contents of the spreadsheet. Check the Locations that you wish to process, then click the Create/Update Locations button.


If your spreadsheet has four columns, the Bulk Uploader will assume that the first two columns contain the new location names and paths, whereas the last two contain the old names and paths.





The Bulk Uploader will update the locations that have changed and skip any that haven't.


Upload emails

To upload emails via a spreadsheet first create a simple spreadsheet in Excel with two columns where the first column lists the names of the locations and the second one lists their paths as in this example:



Save the file. 


TIP: By default, Excel will create an XLSX file which is what the Bulk Uploader can import, so if you are using an alternative spreadsheet be sure to export to XLSX format.


TIP: Here's an easy way to get Windows to create most of the spreadsheet for you.

The following script will create a CSV file of all the folders that contain MSG files. All you then need to do is open the CSV in Excel and edit it to create two columns, where the first contains the names of locations and the second contains their paths.

Step 1
Create a file named:

 Create_list_of_folders_containing_MSG_files.bat

Edit the file in Notepad, then paste the following code into it and save the file.

  @echo off
  setlocal enabledelayedexpansion

  echo Searching for .MSG files...
  (for /f "tokens=*" %%a in ('DIR /s /b *.msg') do (
     set "folder=%%~dpa"
     if "!folder!" neq "!prevfolder!" (
       echo "!folder!"
       set "prevfolder=!folder!"
     )
  )) > msg_folders_list.csv

  echo List of folders containing .MSG files has been saved to msg_folders_list.csv
  pause

Step 2
Copy the file into the top level folder that you wish to create a list from, and then double-click it to run it.
Now edit the CSV file that it generated. Create two columns where the first contains the names of locations and the second contains their paths, then save it as an XLSX file.
You can now open the file in the Bulk Uploader.



In the Bulk Uploader use the Browse button to select the folder that contains your XLSX file, change the Import source to Create/Update via XLSX, then select the file from the list. This will update the details in the right-hand panel to show the contents of the spreadsheet. Check the Locations that you wish to import, then click the Import Emails button.





The Bulk Uploader will create the locations if they don't already exist and will upload any MSG files it finds at the location's path. If a path is not accessible it will be listed in a failures report that will be displayed once the batch has finished.


The tool maintains a record of the locations and emails it has already uploaded, so if you need to correct some paths you can safely re-run the whole batch as it will skip those that have already been processed.