<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=FR link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-indent:35.4pt'><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial'>As I mentioned in my
preceding message, I had difficulties to import a table with the Importcsv2Table
script.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
First, I do a mistake, because I used an old version of Excel to create the csv
file. So the file was not coded in utf-8 with the consequences for the French
accentuated characters! Doing the same with Open Office works well.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
The table I had to import had 11 columns and 6 rows. So after importing with
the script, I had to attribute a style to each cell (I do not found to do that
globally) and to define a top margin which is easy to duplicate with the copy
tool.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
So, I made a script based on the Importcsv2Table with more possibilities. Here
the description of use:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>ABOUT
THIS SCRIPT (modified by J.-P. Gendner June15 2014):<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>Import
CSV data files as tables into Scribus<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>1. You
may create a style to be aplied to all cells of the table<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>2.
Create a frame at the position (upper left corner) <o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>and of
the size (height and width) you want for your table<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>3. Make
sure it is selected<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>4.
Execute this script:<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'> You
will first be prompted for the csv data filename.<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>
-> The number of columns and row will be displayed.<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>
You will then be prompted for the width of each column in mm.<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>
-> The default value given is calculated to respect the width of the
table.<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>
Then you will be prompted for the height of each row.<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>
-> The default value is calculated to respect the height of the table.<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>
Then you may enter the style name you want to be applied to each cell.<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>
Finally, you may enter the Top distance for all text.<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>5. The
data from the csv file will be imported and a table of<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>textboxes
will be drawn on the page.<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'><o:p> </o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>LIMITATIONS:<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>
In Scribus versions 1.3.5svn, when the script ends, you cannot<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>adjust
text, colors, and line features for a group, whereas in 1.3.3.x,<o:p></o:p></span></font></i></p>
<p class=MsoNormal style='margin-left:54.0pt'><i><font size=2 face=Arial><span
lang=EN-GB style='font-size:10.0pt;font-family:Arial;font-style:italic'>all of
these can be done without ungrouping.<o:p></o:p></span></font></i></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
Of course, I am ready to share this script; however, I do not know how to do
that?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
</span></font><font size=2 face=Arial><span style='font-size:10.0pt;font-family:
Arial'>Jean-Paul<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<div>
<div>
<p class=MsoNormal style='text-align:justify'><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black'>****************</span></font><o:p></o:p></p>
<p class=MsoNormal style='text-align:justify'><U1:PERSONNAME ProductID="Jean-Paul Gendner" u2:st="on"><st1:PersonName
ProductID="Jean-Paul Gendner
" w:st="on"><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Jean-Paul Gendner</span></font></st1:PersonName><o:p></o:p></p>
<p class=MsoNormal style='text-align:justify'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Site : <a href="http://www.f5bu.fr/">f5bu.fr</a></span></font><o:p></o:p></p>
<p class=MsoNormal style='text-align:justify'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Tél: 03.88.27.03.44</span></font><o:p></o:p></p>
<p class=MsoNormal style='text-align:justify'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-align:justify'><font size=5 color=green
face=Webdings><span style='font-size:18.0pt;font-family:Webdings;color:green'>P</span></font><i><font
size=2 color=green><span style='font-size:10.0pt;color:green;font-style:italic'>
Afin de préserver notre environnement, n'imprimer ce courriel que si
nécessaire</span></font></i><o:p></o:p></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>