CSV Upload Strategy

  • Resolved wolfenr

    (@wolfenr)


    7 years ago

    Hi just asking for some clarification of the CSV Upload process.

    I recently had to edit the records in my database because I wanted all the hyperlinks in the database to open up in a new tab i.e. add target=”_blank” to every hyperlink.

    I thought about doing this by downloading the CSV file, editing it in Excel and then re-uploading the CSV file. However, when I read your article on uploading a CSV file, I thought that this would add records to the database rather than replace them and I would end up in a muddle because half my records would have the amendment and the other half not.

    Could you clarify please on uploading a CSV file when you already have records in the database.
    My thanks,
    Rog

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author xnau webdesign

    (@xnau)

    When you upload a CSV to your site, you can choose to update existing records, you just need to make sure you have included the ID of the records in the export so that it can match the record and update it when you upload.

    However, that won’t allow you to put a target=”_blank” in the links, because only the URL and the link text is stored, not the full HTML of the link.

    To do this, you can use a custom template or a filter. The use of a filter is described in this article…you’ll need to alter it somewhat as it is for a slightly different purpose.

    Make External Links Open in a New Tab or Window

    Thread Starter wolfenr

    (@wolfenr)

    Thank you @xnau. Excellent support as ever.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘CSV Upload Strategy’ is closed to new replies.

Tags