Can you Refresh Data imported from a CSV file?

Ian Thompson shared this question 1 year ago
Answered

In YellowFinBI 7.2 you can import data from a CSV file to a writable datasource.

Can you import data from a CSV file to overwrite or append to the previously imported data?

You can create reports for the imported data but how do you update the data?

Ian

Comments (2)

photo
1

Hi Ian,

No CSVs are static imports. If you are looking at setting up a long term reporting solution, we highly recommend that you use a standard database (MySQL, SQL Server, Postgres) rather than the csv importer.

In 7.4 we have introduced data transformations that allow you to schedule the transfer of databetween csvs and databases (though there are other ways to do this).

Regards,

Nathan

photo
1

Thank you I will investigate the data transformations in 7.4