Articles in this section

How to Reduce the Size of a Data File for Upload to the Displayr Cloud

  • Updated
Follow

This article describes how to reduce the size of a data file that is too large to upload to the Displayr Cloud Drive directly. The current limit for upload is 16GB. Saving a .sav file as a QDat file in Q may result in reducing the file size to enable it to be successfully uploaded to the Displayr Cloud Drive.

 

Requirements

  • A Professional or Enterprise Displayr license.
  • A document with one or more loaded data sets (.sav, .xml, .sss, .mdd, .xls, .xlsx, .csv).
  • If using Q: 
    • A Windows computer.
    • An installation of Q or Q Reader. If you do not have a Q license, click here to download and install Q Reader. 

Methods

The following steps provide an summary of the approaches used to reduce an original 2.9GB .sav file down to 120MB .QDat file.

 

Using Displayr Alone (for files under 16GB):

  1. Create a new, blank Displayr document
  2. Upload the data file as a new data set. See: Get Your Data Into Displayr
  3. Publish the data set to the Cloud Drive: How to Publish Data to the Displayr Cloud Drive

See Create a Separate Data Preparation Document for discussion on how to set up a workflow around this.

 

Using Q and Displayr (for files of all sizes):

  1. Open the .sav file in Q (or the free Q Reader will also work)
  2. Go to Tools > Save Data As SPSS/CSV File and click OK
  3. In the dialogue box, in the save as type drop down select QDat Files
  4. Name the file and click Save.
  5. Go to Displayr
  6. Open up a new document
  7. At the top right hand side click on the user icon (a black circle with person inside)
  8. Click on Displayr cloud drive and click mceclip0.png
  9. Drag the QDat file from Windows explorer onto the Select Files to Upload box and click the Upload button
  10. Go back to Displayr by clicking on the back button in your web browser.
  11. In the data sets tree  click on Add a data set and select Displayr Cloud Drive.
  12. Choose the QDat file from the list and click OK

Technical Notes

A QDat file is a compressed version of your data set that combines the raw variables with any additional constructed variables (filters, recoded, restructured etc) and calculations (from Calculation menu or custom JavaScript and R variables). These dynamic variables will effectively become hard-coded in this new data set which in turn improves performance, see more info in Create a Separate Data Preparation Document.

 

Next

How to Use the Displayr Cloud Drive

How to Import Data from the Displayr Cloud Drive

 

Related articles