Polish letters in CSV export and issue with calculations

[procajlok]

Hi!
Doh... when I export filtered list to CSV or ExcellCSV, no matter what encoding I choose in List>Publishing>CSV, I dont have polish letters. In MySQL i have encode utf8_general_ci.
That's first problem.

Second - when i chose "Include calculations", in excell i have small monster code above the table. How i can repair it?

I send screenshots and csv.... Please help
I have Fabrik 3.7..

 

[troester]

Polish letters are exporting ok on my site with ExcelCSV and UTF-8 (ok if opening in Excel or in Notepad++)
Make sure that not only your DB is utf8 but also the table and column)

Calculation:
Confirmed.
It seems if setting Count with Split on it's inserting some json data.
But I don't know what format to expect for a splitOnCalc in an Excel/CSV export.

 

[procajlok]

Polish letters are exporting ok on my site with ExcelCSV and UTF-8 (ok if opening in Excel or in Notepad++)
Make sure that not only your DB is utf8 but also the table and column)

OK, i check it and tomorrow and i will let you know.

Calculation:
Confirmed.
It seems if setting Count with Split on it's inserting some json data.
But I don't know what format to expect for a splitOnCalc in an Excel/CSV export.

It's not sounds good What are the chances that anyone will improve?

 

[cheesegrits]

It's not sounds good What are the chances that anyone will improve?

When someone in a paid support forum raises the issue, or someone funds the work in a custom project.

-- hugh

 

[procajlok]

When someone in a paid support....

OK, i paid Maybe someone will be so polite and help And can I ask to transfer the thread to paid forum? Thx

 

[cheesegrits]

I've moved the thread to Standard, I'll take a look within the next day or two.

What format would you like to see for the split calculations?

-- hugh

 

[procajlok]

What format would you like to see for the split calculations?

Hmm... only simple Like view in list...

Count:
Aaaa: 10
Bbbb: 23
Cccc: 50
....

 

[procajlok]

Friendly bump....

 

[cheesegrits]

Thanks for bumping. I knew I owed you this work, but couldn't find the thread to remind myself what was needed.

Looking at it now.

-- hugh

 

[cheesegrits]

OK, as of this commit:

https://github.com/Fabrik/fabrik/commit/fab784a7c8dd6f329715220b8a1a9247434038a3

... we should export formatted calculations (as displayed in the list, with HTML tags stripped) for "non raw" data. If you include "raw" data, we'll JSON encode the calculations for that.

-- hugh

 

[procajlok]

It's working now only for CSV format. When i change export as ExcelCSV i dont have any calculations...

 

[procajlok]

Any chances to implement this to ExcelCSV format?

 

[cheesegrits]

I can't replicate that problem. Works OK for me in either mode.

Sent from my HTC6545LVW using Tapatalk

 

[procajlok]

hmm... I still cant see calculations on ExcellCSV mode, even after update the whole file from Github... how we can repair it?