Export flexicontent data in a csv file

Hello,

I want to know if one day you'll develop a new function to export data (items with fields values) in a csv file.
Same as Import function, but in the other way.

If we can export item from one or more categories (with many filters to export only what we want), with all the fields values separated with comma (or others) in a csv file, it will be very very nice.

I hope this function is in development.

Regards.

Hello,

I use fleximport to create xml files, but it also has a csv export function. extensions.netassopro.com/extensions/components/fleximport

Hello

yes there is CSV export button (as you may have seen already), but currently it is not the same Format as the import

To use this button (it is new in v3.1.0)
1. Enable the button in component parameters
2. In every field that you need set it to participate to the export


TODO:
- make an export directly similar to CSV import
- add more options to the CSV export and create a more powerful with option for XML format (* some work is already done here)

but this last option will not be in the free version of FLEXIcontent

after v3.1.1 (almost finished now) there will be extensive work to finish a PRO / paid of FLEXIcontent to ensure the future of the project

These will in that version most of them are more than 50% done already
- Endless scroll for all listing views
- Reviews feature
- Configuration import / export
- More powerful file options
- Calculation field that is not only "display" but it is search-indexable
- * other e.g. More powerful data export

Hello everybody and thanks for your answers.

Is Fleximport compatible with FC 3.1 ? I saw on the requirements that it supports only FC 1.5 or 2.

ggppdk wrote: Hello

yes there is CSV export button (as you may have seen already), but currently it is not the same Format as the import

To use this button (it is new in v3.1.0)
1. Enable the button in component parameters
2. In every field that you need set it to participate to the export


TODO:
- make an export directly similar to CSV import
- add more options to the CSV export and create a more powerful with option for XML format (* some work is already done here)

but this last option will not be in the free version of FLEXIcontent

Wonderful. I saw this option and it works very nice.
The only problem for me (and for now), is that the fields are separated by a comma.
Comma is a very current caracter. Is it possible to change comma by a tilde ~ or others caracters we want ?

There is a second little problem too : description field is embedded with " and ". Is it possible to remove these " " ?

But if you work on a similar export function parameters than import, I look forward this with impatience.

Thank you very much for all you've done.

Hello

Comma is a very current caracter. Is it possible to change comma by a tilde ~ or others caracters we want ?

If comma , double quote or newline is detected
- then the strings are enclosed in double quotes and the inner double quotes are doubled

Test with MS Excel and OpenOffice Calc and you will see that they open properly

Hi Georges,
As this function is something i really wait for, i have just test it.
I have detect some issues in the process : if i export in csv, i get some strange results.
- If i take 100 articles, published and not published, the export is done but the separator seems to be incorrect (shoot1)
- there is no limit in the export : i can tick or not content to export (filtered or not), the export is still the same every time.

For the record, i'm ready to get this function paid as this is something very important imho !

Thanks
Xavier

Hello


that all items are included in the export, regardless of current filtering ?

Hi Georges,
Apparently yes and if you take a look to the screenshot, you can see some mess in the export..
Xavier

Hello

the logic to export the CSV is
- same for all fields

thus you can only use single value fields, like text and and select, etc

And that is its current purpose,
to only serve / support the above case

don't the single value text , date, select, etc fields work ? (about textrea i will need to test)
i mean are they values escaped properly so the MS EXCEL and Openoffice CALC recognize them ?

Hi Georges,
I did many tests and there is something that could be usefull : change the separator in csv.
To test this, i have opened view.csv.php file and change $delim from " , " to " %%% "
It works for values but not for the titles.
I could change the csv file generated but it will be better if the delimiter for fields name was also " %%% "
I also notice an implode on line 196 but don't see any change if i modify it.

What is the line to change to change the separator also for the field names ?

Thanks
Xavier