CSV Connector for Xcelsius Purchase Purchase
 
Q: What is CSV Connector ?
A: CSV Connector is a simple solution for loading live data into an Xcelsius dashboard from any system. Whether you schedule a daily CSV export from a legacy system, or manually update a CSV file with numbers, CSV connector can access and load the data without any server-side scripts or web services.

Q: What version of Xcelsius or SAP Crystal Dashboard Design do I need?
A: CSV Connector will work with all versions of Xcelsius 2008 and SAP Crystal Dashboard Design, EXCLUDING the following versions:
-Xcelsius 2008 Present
-SAP Crystal Presentation Design

Q: Why doesn't CSV Connector include export web services?
A: Over the last few years we have seen a wide range of export requirements for multiple platforms. Rather than trying to cater to every possible combination, we provided basic services that perform the basic export functionality required by many customers and provide the source code free of charge to anyone who wants to extend it for specific business needs. We put any code we release to the public through quality assurance, ensuring you have a solid, reliable architecture. We will continue to maintain and contribute to this open source project.

Q: Do I need to install any server-side software?
A: To load CSV data, you do not need any server-side software. CSV Connector will load data directly from a flat file. The export capabilities now available in CSV Connector 2.0 however does require a web service to generate CSV files.

Q: How do I install the software in Xcelsius ?
A: CSV Connector is delivered as an XLX file. For step by step installation instructions, view our learning center.

Q: Where do I access the connection in Xcelsius ?
A: Once you have successfully installed CSV Connector beta, it is accessible in the "Data Manager"

Q: Can I connect to CSV files on my local computer ?
A: Though the Xcelsius development environment may enable you to test loading files on your local file system, Flash security policy settings can block you from loading data from your local file system from a published SWF. The preferred deployment scenario is when the CSV file(s) are accessible via HTTP, meaning the CSV files should be placed on a web/application server like IIS, Tomcat, etc. More detailed instructions are provided in this configuration tutorial.

Q: Does it provide the same exact refresh options like other connections ?
A: CSV Connector provides all of the refresh options as any other Xcelsius connection. There are a few Xcelsius framework integration limitations for CSV Connector. The following common connection options are currently NOT available with CSV Connector

  • Connection Refresh Button
  • Loading Icon
  • Load Status property

Q: What happens to special characters ?
Because Xcelsius can not interpret special characters as values, loaded from live data sources, CSV files should not contain special characters like %. $, or ",". If these characters are included with the data in your CSV file, Xcelsius will interpret them as text.