<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Belug,<br>
<br>
+1<br>
<br>
I agree with the workaround your proposed : an option (Defaults to
false) that, when turned on, converts now lines in to spaced double
slashes. That'd do the trick until someone ends up finding a
solution to the initial issue.<br>
<br>
Regards,<br>
<br>
Alexandre<br>
<br>
<br>
On 12-04-19 11:56 AM, Lessard Alexandre wrote:
<blockquote cite="mid:4F9035B5.3080806@solutionglobale.com"
type="cite">Hi you all,
<br>
<br>
I have a problem with the WFS_Fillter_Builder and it's about the
CSV export.
<br>
<br>
I already made a ticket about it, but now I'd like your help for
the solution.
<br>
ticket : <a class="moz-txt-link-freetext" href="http://trac.osgeo.org/geoprisma/ticket/383">http://trac.osgeo.org/geoprisma/ticket/383</a>
<br>
<br>
The problem is multilined text in CSV when you import data into
Excel. When you "import"
<br>
id from the file the newline caracter will cause a newline in the
worksheet breaking the order
<br>
of the columns.
<br>
<br>
The encoding does not change anything about that it's a bug that I
wasn't able to pass.
<br>
<br>
It doesn't append when you "open" the CSV file with Excel, but it
might break dates and some
<br>
strings or numbers.
<br>
<br>
So for this I'd like to propose an option to convert new line into
something else
<br>
(i.e. Converting new lines into spaced double slashes " // ").
<br>
<br>
So if you set the option in the widget it would replace the
newlines by what you write there.
<br>
<br>
What do you think about that?
<br>
<br>
Belug
<br>
<br>
P.S. I've joined a sample Try opening it and then try importing
it.
<br>
<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Geoprisma-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Geoprisma-dev@lists.osgeo.org">Geoprisma-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/geoprisma-dev">http://lists.osgeo.org/mailman/listinfo/geoprisma-dev</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Alexandre Dubé
Mapgears
<a class="moz-txt-link-abbreviated" href="http://www.mapgears.com">www.mapgears.com</a>
</pre>
</body>
</html>