CSV Connector can consume CSV data from a file located on your server and desktop. For both server and desktop deployments you will need to ensure that you and your user's follow Adobe Flash player security policies to ensure a smooth and error free end user experience.
| Connect to CSV files that reside on your web/application server |
| |
Relative Path example: data/xyz.csv |
When connecting your Xcelsius SWF to a CSV file, where the SWF exists on the same server as the CSV, you can utilize a relative URL without any additional configuration. In the example above the "xyz.csv" file is located in a sub-directory called "data." If the SWF and CSV file were in the same directory, you could use "xyz.csv."
* Relative will NOT work inside of Xcelsius development environment or in Preview mode because preview SWFs are generated in the TEMP directory, which is not relative to the CSV file. |
| |
| Absolute Path example: http://servername/data/xyz.csv |
When connecting your Xcelsius SWF to a CSV file, where the SWF exists on the local PC or on a different server, you can utilize an absolute URL. This configuration requires a cross domain policy file, which grants access for the flash player to load data into the SWF. The crossdomain.xml file should be loaded into the root directory of the web/application server where you CSV file exists.
Example IIS root: /intetpub/wwwroot
Example Tomcat root: /webapps/ROOT
Download sample crossdomain.xml policy file for use with Xcelsius
View online Adobe tech notes on crossdomain.xml
|
| Connect to CSV files that reside on your desktop or file share |
| |
| |
Step 1. Configure your PC to load CSV data from your local PC file system
Click Here to Open the Global Flash Player Security dialogue
Upon opening the Flash Player Security settings, you will add the directory or network location where your CSV file is located. In the example shown below, the flash player can access any directory on the C: drive to load data into a SWF.
Upon making changes, you can close your browser window and re-launch your Xcelsius generated SWF. Now you are ready to load local CSV data into your Xcelsius dashboard.
|
| |
Relative Path example: data/xyz.csv |
| |
When connecting your Xcelsius SWF to a CSV file, where the SWF exists on the same site or local PC directory structure as the CSV, you can utilize a relative URL without any additional configuration. In the example above the "xyz.csv" file is located in a sub-directory called "data." If the SWF and CSV file were in the same directory, you could use "xyz.csv."
* Relative will NOT work inside of Xcelsius development environment or in Preview mode because preview SWFs are generated in the TEMP directory, which is not relative to the CSV file. |
| |
| Absolute Path example: file://c:/data/xyz.csv |
When connecting your Xcelsius SWF to a CSV file, where the SWF exists on the local PC but in a different directory, you can use a "file://" prefix to define an absolute path to the file.
*A SWF that is accessed from a web/application server cannot access CSV files on the local file system due to flash security settings.
To load CSV data from the local file system using an absolute URL you will first modify your Flash Player Global Security Settings and grant access to the local drive where your CSV data is located. See instructions below for detailed instructions. |
| |
|
