Support » Plugin: Link Library » 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

Viewing 5 replies - 1 through 5 (of 5 total)
  • There are few line break types …

    Plugin Author Yannick Lefebvre

    (@jackdewey)

    My goal with the link export is not to get a perfect export that can work with all tools. I have tested it with LibreOffice Calc and it works very well in that tool. It can also be edited with a straight text editor.

    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 &quot;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.

    • This reply was modified 1 year, 4 months ago by  darekk2.
    • This reply was modified 1 year, 4 months ago by  darekk2.
    • This reply was modified 1 year, 4 months ago by  darekk2.
    • This reply was modified 1 year, 4 months ago by  darekk2.

    or \” and \n could be used. This is probably consistent with csv format. But maybe you have reason to not add any additional text.

    phpMyAdmin replaces ” by \”, at least in Excel mode.
    But such markes would look strangely.

    • This reply was modified 1 year, 4 months ago by  darekk2.

    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.

    • This reply was modified 1 year, 3 months ago by  darekk2.
    • This reply was modified 1 year, 3 months ago by  darekk2.
    • This reply was modified 1 year, 3 months ago by  darekk2.
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘The CSV file with exported links – some of lines can’t be correctly imported’ is closed to new replies.