Exporting CSV Views
Hi
I am a Freelance Visualization Designer for a company. Usually, he sends me data, I create the reports and whatever else is needed, I export and email to him, and everything works perfect. We do not work on the same Yellowfin License.
I recently completed a project where I used 22 CSV Imports to create reports. When you import a CSV, you choose where to store the data. So I created a CSV Store that saves on a Microsoft SQL Server.
I exported everything in Yellowfin, as well as the SQL Database. On his side, he can connect to the database, but the views is missing. How do I get the Views to him? It's not available for Export, and I thought if he linked the SQL, that it would work, but it doesn't.
Any help would be greatly appreciated.
Thanks
Natasha
The same question
Hi Natasha,
Unforutnately CSV views work a bit differently than other view in Yellowfin and are not nearly as flexible. Typically these are designed for quick evaluation of data rather than larger production systems.
If these are all single table views, I would recommend importing the csv files into SQL server tables directly. You can then create a single table view on top of this, and import all reports from your previous csv view onto this view instead. In 7.4 you could also do this through ETL flow.
Sorry for the trouble, let me know if this will work for you.
Regards,
Nathan
Hi Natasha,
Unforutnately CSV views work a bit differently than other view in Yellowfin and are not nearly as flexible. Typically these are designed for quick evaluation of data rather than larger production systems.
If these are all single table views, I would recommend importing the csv files into SQL server tables directly. You can then create a single table view on top of this, and import all reports from your previous csv view onto this view instead. In 7.4 you could also do this through ETL flow.
Sorry for the trouble, let me know if this will work for you.
Regards,
Nathan
Replies have been locked on this page!