MicroStrategy ONE

Alter File Device statement

Modifies the properties of a file device. A file device is used in Distribution Services to automatically send a MicroStrategy report or document to a folder on a computer on your network in a file format that the user chooses when subscribing to the report.

Copy 
ALTER FILEDEVICE "device_name" [NAME "new_name"] [DESCRIPTION "description"] [FILELOCATION "location"] [ALLOWUSERINFO (TRUE | FALSE)] [CREATEFOLDER 
 (TRUE | FALSE)] [APPENDTIMESTAMPTOFILENAME (TRUE | FALSE)] [OVERWRITEFILES 
 (TRUE | FALSE)] [APPENDTOFILE (TRUE | FALSE)] [USEBACKUPLOC (TRUE | FALSE)] 
 [BACKUPLOCATION "location"] [NUMBEROFRETRIES num] [TIMEBETWEENRETRY TIME] [DELIVERYTIMEOUT TIME] [FILEREADONLY (TRUE | FALSE)] [FILEARCHIVE (TRUE | 
 FALSE)] [FILEINDEX (TRUE | FALSE)] [ENCRYPTCOMPRESS (NONE | ENCRYPT | 
 COMPRESS) ] [UNIXACCESSRIGHT "accessrights"] [ENABLEUNIXTOWINDOW (TRUE | FALSE) [USERNAME 
 "username"] [PASSWORD "password"] [MOUNTROOT "mountroot"]];

where:

  • FILEDEVICE "device_name" is the name of the device to alter, of type string.

  • NAME "new_name" is the new name of the file device, of type string.

  • DESCRIPTION "description" is the description of the device, of type string.

  • FILELOCATION "location" is the path and folder where you want the file delivered, of type string.

  • ALLOWUSERINFO indicates whether you want the user to be able to specify a file location when she subscribes to a report or document. If you specify TRUE and you provide a FILELOCATION, the location you provide is used if the user does not specify one.

  • CREATEFOLDER indicates whether you want the system to automatically create folders, if the specified file path is not available.

  • APPENDTIMESTAMPTOFILENAME indicates whether you want the system to automatically the file's creation date and time to the end of the file name.

  • OVERWRITEFILES indicates whether you want the system to automatically overwrite older files of the same name, if they exist.

  • APPENDTOFILE indicates whether you want the system to automatically append the contents of the new text file to an existing text file of the same name, if one exists.

  • USEBACKUPLOC indicates whether you want to save messages to a backup location if delivery fails.

  • BACKUPLOCATION "location" is the backup location where you want messages saved, of type string.

  • NUMBEROFTRIES num is the number of times to try sending the message, of type numeric.

  • TIMEBETWEENRETRY TIME is how long, in seconds, to wait between retries.

  • DELIVERYTIMEOUT TIME is how long, in seconds, to allow for deliveries. After this time passes, any incomplete delivery is considered a failed delivery and counts toward the number of retries.

  • FILEREADONLY indicates whether the file should be read only.

  • FILEARCHIVE indicates whether the file should be archived.

  • FILEINDEX indicates whether the file should be indexed.

  • ENCRYPTCOMPRESS is the encryption/compression setting. Choose one of the following:

    • NONE indicates that the file should not be encrypted or compressed. This is the default.

    • ENCRYPT indicates that the file should be encrypted.

    • COMPRESS indicates that the file should be compressed.

  • UNIXACCESSRIGHT "accessrights" is the access set of settings for UNIX and Linux operating systems, of type string.

  • ENABLEUNIXTOWINDOW indicates whether you want to deliver files from an Intelligence Server running on UNIX to a Windows location. This process uses the Sharity (tm) software to resolve the Windows file location as a mount on the UNIX machine. To enable cross-platform delivery, Sharity must be installed on the Intelligence Server machine. For information Sharity, see the Sharity website: http://www.obdev.at/products/sharity/index.html.

  • USERNAME "username" is the user name of the Windows network login used to access the file location, of type string.

  • PASSWORD "password" is the password of the Windows network login used to access the file location, of type string.

  • MOUNTROOT "mountroot" is the location on the Intelligence Server machine where the mount is stored, of type string.

Example

Copy 
ALTER FILEDEVICE "MyFileDevice" NAME "UserSpecifiedLocation";