Create a CSV File to extract email from a PST or ZIP file
The CSV file for the Extract jobs is where you define the search criteria. The file contents should be as follows
- The first row of the CSV file should have the following headers
- SUBJECT, TO, FROM, CC, DATE
NOTE: Do not change the Order of the columns in the header and make sure that the CSV has the headers
- Subsequent rows will have the records of emails to be searched. Make sure that each row has at least one non-empty column.
- The search criteria have to be given as follows :
- The values in each row have to match for the mail to be selected. For example, if From and To are specified, then all mail with the given sender AND the given recipient will match
- Each row has only one value for every field. So if you want to search for mail sent by a sender to any of the two recipients, then two rows, each having a different recipient will have to be added to the CSV
- The value given in the Subject has to be an exact match for the mail to be selected. For example, if you specify "Hello world" in the subject, only those mail that contains the full string "Hello world" will be selected.
- The date field should have the date in the DDMMMYYYY format. For example 21mar2021.
- Click here to download the sample CSV.
Source Information
| FIELD NAME | DESCRIPTION |
|---|---|
| S3 Bucket Name | The S3 bucket that has the source file to be processed. Select the S3 bucket name from the drop-down list. The list will show
|
| S3 Folder path | If the file is on the Vaultastic Open or Deep Store, then this parameter will have the name of your Vaultastic domain. Example: baya-com.vaultastic.com If the file is on your own bucket, give the folder which contains the file. Leave this value empty if the source file is on the root of the S3 bucket. NOTE: S3 folder path should not start or end with a "/" |
| File name | The source filename. The compressed file such as .zip or .pst which contains the source data NOTE: Filenames should not start or end with a "/" |
CSV
| FIELD NAME | DESCRIPTION | SAMPLE VALUE |
|---|---|---|
| CSV File | Select the CSV file with search strings from your machine which you have created as mentioned in the Create a CSV File section | search-john-jan-2021.csv |
Destination Information
| FIELD NAME | DESCRIPTION |
|---|---|
| S3 bucket name | The S3 bucket for the destination file. Select the S3 bucket name from the drop-down list. The list will show all the registered S3 buckets including the S3 buckets which host the Vaultastic Open and Deep stores. |
| S3 folder path | If the file has to be created on the Vaultastic Open or Deep Stores, then this parameter will have to start with the name of your Vaultastic domain. Example: baya-com.vaultastic.com For example, if you want to create a file on the root of the Vaultastic domain baya-com.vaultastic.com, then enter "baya-com.vaultastic.com". If the file has to be created in a sub-folder called 'Files", then enter "baya-com.vaultastic.com/Files" If the file is to be created on your own bucket, give the folder which will contain the file. Leave this value empty if the destination file has to be created on the root of the S3 bucket. NOTE: S3 folder path should not start or end with a "/" |
| Doc Type | When copying/extracting files from the source, the files can be saved in a single ZIP or as individual files on the destination. Choose ZIP file, if you want the files to be copied to a single zip file on the destination. Choose File, if all the files have to be saved as individual files on the destination bucket. NOTE: Any existing files with the same name will be over-written. |
| Zip File name | The destination ZIP filename. This option will be visible only if you choose ZIP file in the Doc Type option. NOTE: Filenames should not start or end with a "/" |
Send Report To
| FIELD NAME | DESCRIPTION | SAMPLE VALUE (TO UPLOAD TO VAULTASTIC) |
|---|---|---|
| Send report to mail id | Email address which will get the notifications | "postmaster@baya.com" |