rtorres
Member
Hi
i found out that the export button is exporting the data incorrectly in result some records have more columns than the table..
checking the content in this records i cannot find a pattern besides all the fields that have this error are text area, I think is the result of the user copying the text from somewhere and pasting it inside the text element...
I?ve already change the file encoding, but that just changes how fabrik export the special characters, but the text elements are exported with errors..
I also tryed clean_html and replace end of line with other character but the "problems" are not at the end of the lines,
I also turned on the option ( add " ) to the lines, but it randoms add " to the text..
Example: this is a text in the database
exported: "this is a text in the "database
someone can tell me what is the best practice (configuration) to export the data?
note: phpmyadmin exports correctly the database..
i found out that the export button is exporting the data incorrectly in result some records have more columns than the table..
checking the content in this records i cannot find a pattern besides all the fields that have this error are text area, I think is the result of the user copying the text from somewhere and pasting it inside the text element...
I?ve already change the file encoding, but that just changes how fabrik export the special characters, but the text elements are exported with errors..
I also tryed clean_html and replace end of line with other character but the "problems" are not at the end of the lines,
I also turned on the option ( add " ) to the lines, but it randoms add " to the text..
Example: this is a text in the database
exported: "this is a text in the "database
someone can tell me what is the best practice (configuration) to export the data?
note: phpmyadmin exports correctly the database..