Export flexicontent data in a csv file

More
7 years 8 months ago #66392 by ggppdk
Hello

This is currently not configurable

The CSV export is made to be read by Microsoft Excel and similar,
why do you want to change the separator ?


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
7 years 8 months ago #66394 by Chabi01
Hi Georges,
I would like to put in example :
%% to separate the field
^^ as text separator
Like this, i'm quite sure to be ok for the export and don't have "mixed" columns in results.
Thanks Georges :)
Xavier

Please Log in or Create an account to join the conversation.

More
7 years 2 weeks ago - 7 years 2 weeks ago #70552 by bendeb
Hello,

I export items with FC (see attachment).
I have the same bug than Chabi01 for some reason, with only few lines.
Try to import the document in Excel, Access or Open office calc, and you see that many lines are broken (4 lines exactly).
It was caused by the Description core field.
If we disable it to the export, all is working good.

If I change the order of Description core field in administration, it seems the result of csv file is different : the broken lines aren't the same.

For now, I can correct this bug with few search and replace with Notepad++ (extend mode) :

\r\r" => replaced by => "
\r\r, => replaced by => ",
,,<p> => replaced by => ,,"<p>

So, maybe it will be nice if we can choose the delimiter of field and item. (%%, ^^, &&, °°, and all that we want.
Unless that this bug with description field may be corrected. :)

Thank in advance for your answer. ;)

Flexicontent 4.1.0b1
Joomla 3.9.18
Attachments:
Last edit: 7 years 2 weeks ago by bendeb.

Please Log in or Create an account to join the conversation.

More
7 years 1 week ago #70570 by ggppdk
Hello

you need to define custom seperators for export too

the thing is that the original purpose of the CSV export was not to re-import it to FLEXIContent
but only to open it in excel or via other import tool


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
7 years 1 week ago #70573 by bendeb
And it is not possible to implement a full Export function in order to import/export data on FC at will ?
I pretty much sure that many people wish this function :)
It can really simplifiate the webmaster work.

Flexicontent 4.1.0b1
Joomla 3.9.18

Please Log in or Create an account to join the conversation.

More
7 years 1 week ago #70575 by micker
yes we will do this but it difficult to create all features ... with only one man and without pro version ...
that is in todo

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.417 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline