[TYPO3-project-seminars] csv

[Erich Schnepf]

Hi Oliver,

forget Excel - in Access there are no problems with that matter; in Excel 
there are no line breaks in the same cell, but checkbox-values - wich should 
be in one line in a cell - are in a new record, when the line gets too long.

For databases we should use database-programs ;-).

In my case you are better off, when you use a database-program, because I use 
the time-collision off for frame-events. So I have to connect several 
databases for one querry.

So long

Am Sonntag, 4. November 2007 21:03 schrieb Oliver Klee:
> Hi Erich,
>
> Erich Schnepf schrieb:
> > Line-break:
> > I have some (I think 4) checkboxes in the registration. They should be
> > in one line in the csv-export. Now I get a line-break. That means, that
> > f. e. one or more values from checkboxes are in a new line in a
> > excel-file, wich means that it is a data-record for itself.
>
> Actually, they are supposed to be on separate lines, but in the same
> cell (so there are line breaks in the cells).
>
> Generally, line breaks should be okay in CSV records if double quotes
> are used as field delimiters. Are you using double quotes as field
> delimiters in your CSV settings?
>
> I haven't been able to test with Excel, though, as I personally use
> OpenOffice.org. Could you please in Excel create a table that contains
> line breaks in a cell, export that as CSV and compare that format to the
> format created with the Seminar Manager CSV export?
>
> > It seems, that you cropped the line length - is that right?
>
> Um, where? What did I do? *confused*
>
> Regards,
>
>
> Oliver
> _______________________________________________
> TYPO3-project-seminars mailing list
> TYPO3-project-seminars at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-seminars