[scribus] Trouble importing csv files

[John Ghormley KJ4UFG]

On Thu, Apr 18, 2013 at 8:21 PM, Gregory Pittman <gpittman at iglou.com> wrote:

> On 04/18/2013 07:58 PM, John Ghormley KJ4UFG wrote:
>
>> When trying to get a csv file into a text frame using the method, right
>> click in the frame and select Get Text, then selecting the proper .csv
>> file, using the Comma Separated Value Files importer and the System
>> encoding and not selecting the Import Text Only box, my file was imported
>> correctly with the exception of a tabulator at the very beginning of each
>> line.  There are six fields in each row of the spreadsheet.  I have looked
>> at the sheet with a text editor and no comma or tab character exist at the
>> beginning of the line.  I have saved the file from the text editor
>> (Bluefish) which should remove any spaces at the end of line and insure a
>> valid EOL character is there.  However, the first character of each line
>> is
>> indented to the first tabulator setting, throwing off the entire column
>> format.
>>
>> Each line should be at the left side of the text box as shown below and
>> the
>> other data fields in the listing should be tabbed to form columns down the
>> page.
>>
>> Here are a few lines from the .csv file:
>>
>> ,,,,,
>> GEORGIA,,,,,
>> 10 Meters,,,,,
>> N4BZJ,29.68,+,Dalton,141.3,☺
>> KQ4XL,29.62,+,Monroe,0,☺
>> WR4MG,29.66,+,Warner Robins,0,☺
>> ,,,,,
>>
>> Any ideas what to look for or how to fix the problem using Scribus?  I
>> cannot figure out how to remove the space at each line beginning short of
>> deleting the space on each of the 3300+ lines.
>>
>>
>>  What I have found is that you have to have what we might call a "dummy"
> tab at the beginning of your tabulator settings. I don't know why, but when
> I have put that extra one in there, everything comes out all right.
>
> I'm currently using Scribus with csv files to keep track of my patients,
> and make lists for various purposes, so I use Scribus with csv import every
> day (multiple times a day). I have even made a script that loads the files
> into the pre-formatted document with styles with tabs already created. A
> great timesaver.
>
> I would also add that you don't need these empty fields and commas at the
> end (,,,,).
>
> Greg
>
>
Thanks, Greg.

I'll work with a dummy tab at the beginning of each line.  Since I did not
expand the cells in LO Calc, I got the multiple commas on blank lines and
short title lines.  I just figured I'd delete them since there were not so
many and I have to replace the titles with some title boxes, anyway.  It
will be interesting to see how the first character comma works out.

John Ghormley  KJ4UFG
Editor, SERA *Repeater Journal*
Walkertown, NC  USA
editor at sera.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scribus.net/pipermail/scribus/attachments/20130418/6778caa3/attachment.html>