Broadcasting CSV to FTP – is the file encrypted/what is the encoding/limit field
2 April, 2013
I�m trying to create a scheduled FTP export of a CSV file. A couple of questions I need answered:
- Can use encryption to secure the file? (If not what other option re security do I have)
- What is the encoding format of the CSV file? UTF-8
- There is a varchar field which I need to limit to 255 characters. Can I do this just for this one report?
Hi,
Please see comments below;
Can use encryption to secure the file? (If not what other option re security do I have)
No this is not possible. It is assumed that when a report is sent to an FTP site, that it is a public report. As once the file has been created it�s outside of Yellowfin.
We are planning on implementing secure FTP in the future though not ETA has been given.
What is the encoding format of the CSV file? UTF-8
Correct, it is UTF-8.
There is a varchar field which I need to limit to 255 characters. Can I do this just for this one report?
No this is not possible to do within Yellowfin. These types of restrictions are usually done at the database level, which will affect all views/reports based that use this data source.
We have options to limit the number of rows in a report, though no option to limit the amount of data returned in a single field.
Please let us know if you have further questions on this.
Regards,
David
Please see comments below;
Can use encryption to secure the file? (If not what other option re security do I have)
No this is not possible. It is assumed that when a report is sent to an FTP site, that it is a public report. As once the file has been created it�s outside of Yellowfin.
We are planning on implementing secure FTP in the future though not ETA has been given.
What is the encoding format of the CSV file? UTF-8
Correct, it is UTF-8.
There is a varchar field which I need to limit to 255 characters. Can I do this just for this one report?
No this is not possible to do within Yellowfin. These types of restrictions are usually done at the database level, which will affect all views/reports based that use this data source.
We have options to limit the number of rows in a report, though no option to limit the amount of data returned in a single field.
Please let us know if you have further questions on this.
Regards,
David