[scribus] Trouble importing csv files
gpittman at iglou.com
Fri Apr 19 00:21:53 UTC 2013
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
> 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
> Here are a few lines from the .csv file:
> 10 Meters,,,,,
> 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 (,,,,).
More information about the scribus