Exporting CSV Views

Natasha van Graan shared this question 6 years ago
Answered

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

Replies (1)

photo
1

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

photo
1

Hi Nathan

Thank you for your reply.

If that is what I need to do, that's what I'll do.

I appreciate the feedback!

Natasha

photo
1

Hi Natasha,

No problem. Let me know if you have any questions/problems along the way.

Regards,

Nathan

photo
Leave a Comment
 
Attach a file