Difference between revisions of "Download files from List View"

From SmartWiki
Jump to: navigation, search
(Created page with "Users can download the files that are stored in Single File or Multiple Files custom...")
 
Line 1: Line 1:
Users can download the files that are stored in [[Custom Field Type: Link – Single File|Single File]] or [[Custom Field Type: Link – Multiple Files|Multiple Files]] custom fields from any list view that is configured with the '''Enable Download Files Option'''/
+
A major feature of SmartSimple list views is that Users can batch download the files that are stored in [[Custom Field Type: Link – Single File|Single File]] or [[Custom Field Type: Link – Multiple Files|Multiple Files]] custom.
  
 +
Once your list view has been created, take the following steps to enable exporting to Excel:
  
==Instructions==
+
# Go to the list view configuration page.
* Install the '''SmartFileRetriever''' application, following the instructions that came with the tool.
+
# Click into the list view for which you wish to enable file downloads.
* Open the '''UTA Browser''' from your Programs menu.
+
# Click on the "Properties" tab.
:''If you are logged into SmartSimple via a web browser you should log out.''
+
# Enable the '''Enable Download Files Option''' option.
* Enter your [[SmartSimple]] Server URL, Alias, User Name and Password:<br>
+
# Click the "Save" button.  
[[Image:UTABrowser1.PNG]]
+
# The '''Download Files''' tab is now exposed at the top of the list view.  
* Click to Enable SSL if you wish to encrypt the connection to SmartSimple.
+
::[[Image:DownloadFiles1.PNG]]
 +
# Select the records from the list view then click on the '''Download Files''' button.
 +
# The Selected Fields screen is displayed, and  will provide a list of all the [[Custom Field Type: Link – Single File|Single File]] and [[Custom Field Type: Link – Multiple Files|Multiple Files]] custom fields available on the record.
 +
::[[Image:DownloadFiles2.PNG]]
 +
# If you wish to download the files stored in all the fields listed click the check box at the top of the list. Otherwise select the subset of fields you wish.
 +
::[[Image:DownloadFiles2.PNG]]
 +
# There is also a Download Folder Structure with the following options:
 +
::# Full - per record per field: creates a separate folder for each record and then, within the record specific folder, a separate folder for each upload field
 +
::# Partial - per record: creates a separate folder for each record but not for each upload field
 +
::# None - single folder: one folder for all records and all files
  
* Click '''Login.'''<br />
 
:''Once the Smart File Retriever has authenticated with [[SmartSimple]] the Application pull-down list will populate with a list of the UTAs in your [[SmartSimple]] instance, and the "Launch" and "Download" buttons will become active.''
 
  
 
+
[[Category:Integration]]
* Select the desired UTA from the Applications list and click '''Launch'''. After a few seconds you will be presented with the Level 1 interface for your UTA.
 
* Using the filter options on the right-hand side of the '''SmartFileRetriever''' window you should now filter the records as desired. ''(Click "Show Search" if you do not see the search panel on the right).'' If you wish to download the files stored in [[Custom Field Type: Link – Single File|Single File]] or [[Custom Field Type: Link – Multiple Files|Multiple Files]] fields for '''all''' records you should select "Show All Level 1 Items" and ensure that all Statuses are selected. Then click on the '''Search''' button:
 
::[[Image:UTABrowser2.PNG]]
 
 
 
 
 
* '''Important:''' if you have more than one page of records be sure to click on the '''Show All''' button in the upper-right corner of the screen before proceeding to the next step:
 
:[[Image:UTABrowser3.PNG]]
 
 
 
 
 
* You should now click on the check-box in the upper left corner of the screen in order to select all records, or if you want a sub-set of the records displayed you can manually select individual records:
 
::[[Image:UTABrowser4.PNG]]
 
:''Selecting all may take a few moments if there are a large number of records.''
 
 
 
:''If you do not see the check boxes in the first column of the Level 1 list view you will need to close the '''SmartFileRetriever''', open your UTA via a Web Browser, go to Settings >> [[UTA Settings - Entity|Entity tab]] and check to '''Enable Calendar''' in the Level 1 Settings section.
 
 
* Once all the desired records have been selected click on the '''Next''' button in the lower left-hand corner of the screen:
 
::[[Image:UTABrowser5.PNG]]
 
 
 
 
 
* The following page will tell you how many records you have selected, and will provide a list of all the [[Custom Field Type: Link – Single File|Single File]] and [[Custom Field Type: Link – Multiple Files|Multiple Files]] custom fields available at Level 1.
 
* If you wish to download the files stored in all the fields listed click the check box at the top of the list. Otherwise select the subset of fields you wish.
 
::[[Image:UTABrowser6.PNG]]
 
* Click '''Next'''
 
 
 
* You will be asked to choose a location to download the files. Select a folder on your local machine and click '''OK'''.
 
:''If the file download does not start automatically, please click the '''Download''' button on the toolbar.''
 
* A window will appear to indicate the progress of the download. Any errors will be reported in this window.
 
* The '''SmartFileRetriever''' window will also show the total number of "Records", "Fields", "Files" and the "Total Size" of the download.
 
 
 
 
 
==Results==
 
Within the folder you selected for the download you will find the following:
 
* A folder will have been created for each Level 1 record. The folder will be given the same name as the Level 1 record.<br />
 
::-''If no files were present in any of the selected fields for a given record, no folder will be created for that record.''
 
::-''If you have not used the Level 1 Standard Field "Application Name", the folders will be named with the Tracking ID of the record.
 
* Within each Level 1 record folder you will find folder(s) with the same name as the [[Custom Field Type: Link – Single File|Single File]] or [[Custom Field Type: Link – Multiple Files|Multiple Files]] Custom Fields that you selected to be downloaded.
 
::''If no files were present in a given field for that record, no folder will be created for that field.''
 
* Within each of the folders you will find the files that were stored within the relevant [[SmartSimple]] Custom Fields.
 
 
 
 
 
 
 
[[Category:Applications]][[Category:Universal Tracking Application]][[Category:Integration]]
 

Revision as of 12:17, 10 July 2017

A major feature of SmartSimple list views is that Users can batch download the files that are stored in Single File or Multiple Files custom.

Once your list view has been created, take the following steps to enable exporting to Excel:

  1. Go to the list view configuration page.
  2. Click into the list view for which you wish to enable file downloads.
  3. Click on the "Properties" tab.
  4. Enable the Enable Download Files Option option.
  5. Click the "Save" button.
  6. The Download Files tab is now exposed at the top of the list view.
File:DownloadFiles1.PNG
  1. Select the records from the list view then click on the Download Files button.
  2. The Selected Fields screen is displayed, and will provide a list of all the Single File and Multiple Files custom fields available on the record.
File:DownloadFiles2.PNG
  1. If you wish to download the files stored in all the fields listed click the check box at the top of the list. Otherwise select the subset of fields you wish.
File:DownloadFiles2.PNG
  1. There is also a Download Folder Structure with the following options:
  1. Full - per record per field: creates a separate folder for each record and then, within the record specific folder, a separate folder for each upload field
  2. Partial - per record: creates a separate folder for each record but not for each upload field
  3. None - single folder: one folder for all records and all files