The CSV file with exported links – some of lines can’t be correctly imported
-
to Microsoft Access, because of:
– quotation marks in descriptions, treated as endings of csv fields
– line braeaks in descriptions splitting one csv line to two or more, sometimes blank
-
Quotation marks braek fields, because they are text qualifiers:
“Field1”, “Field12”, “Field13 containing “qutation” marks”, “Field14″
” before q is not followed by coma, but it breaks the field, makes chaos since this point.
Line breaks are not allowe in csv too. A line break ends an entire line (record).Implementing of replacing ” and line breaks (Windows, Unix) by HTML like
"or"and<br />would be very easy. But maybe you don’t want to insert HTML into text for some reason. Because for example if csv would not be used to create HTML, such characters could spoil the text. Maybe two kinds of csv files ? phpMyAdmin for example can produce csv or csv for excel. I don’t know what is difference between those csv types.So far I replaced manually in descriptions, notes, titles and textfields:
"..."by„...”
[a href="..."]..[/a]by[a href='...']..[/a]
line braks (\n in the search sql)by[br /]
using the phpMyAdmin database.
And created later csv file was imported smoothly to the Microsoft Access table.
- The topic ‘The CSV file with exported links – some of lines can’t be correctly imported’ is closed to new replies.
