如何将CSV中的书签读取到HTML书签输入文件中? [英] How to read Bookmarks from CSV into an HTML Bookmarks input file?

问题描述

我需要将书签批量导入到不同的Web浏览器中.书签最初将存储在CSV文件中，并且经过处理后，应将其转换为可以上传到任何Web浏览器的HTML文件. 我的解决方案必须与平台无关.

I have a need to bulk import bookmarks into different web browsers. Bookmarks will originally by stored in a CSV file and upon processing, they should be turned into an HTML file that can be uploaded to any web browser. My solution needs to be platform agnostic.

一个示例csv文件如下:

A sample csv file is as follows:

friendly,url,folder
CUCM - North,cucm-n.acme.com,ACME/CUCM/North
CUCM - PUB,cucm-pub.acme.com,ACME/CUCM
UCCX - South,uccx-south.acme.com,ACME/UCCX/South
UCCX - North,uccx-north.acme.com,ACME/UCCX/North
UCCX - PUB,uccx-pub.acme.com,ACME/UCCX
Database,db.acme.com,ACME
CUCM - North2,cucm-n2.acme.com,ACME/CUCM/North

生成的HTML文件如下所示:

The resulting HTML file would look like so:

HTML
<!DOCTYPE NETSCAPE-Bookmark-file-1>
<!-- This is an automatically generated file.
     It will be read and overwritten.
     DO NOT EDIT! -->
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
<TITLE>Bookmarks</TITLE>
<H1>Bookmarks</H1>
<DL><p>
    <DT><H3 PERSONAL_TOOLBAR_FOLDER="true">Bookmarks bar</H3>
    <DL><p>
        <DT><H3>ACME</H3>
        <DL><p>
            <DT><H3>CUCM</H3>
            <DL><p>
                <DT><H3>North</H3>
                <DL><p>
                    <DT><A HREF="http://cucm-n.acme.com/">CUCM - North</A>
                    <DT><A HREF="http://cucm-n2.acme.com/">CUCM - North2</A>
                </DL><p>
                <DT><A HREF="http://cucm-pub.acme.com/">CUCM - PUB</A>
            </DL><p>
            <DT><H3>UCCX</H3>
            <DL><p>
                <DT><H3>South</H3>
                <DL><p>
                    <DT><A HREF="http://uccx-south.acme/">UCCX - South</A>
                </DL><p>
                <DT><H3>North</H3>
                <DL><p>
                    <DT><A HREF="http://uccx-north.acme/">UCCX - North</A>
                </DL><p>
                <DT><A HREF="http://uccx-pub.acme.com/">UCCX - PUB</A>
            </DL><p>
            <DT><A HREF="http://db.acme.com/">Database</A>
        </DL><p>
    </DL><p>
</DL><p>

到目前为止，我的脚本如下:

My script so far is as follows:

import csv

bookmarks_spreadsheet = filedialog.askopenfilename()

reader = csv.DictReader(open(bookmarks_spreadsheet, 'r', encoding="utf-8-sig"))
for row in reader:
    bookmarks.append(row)
    url = row['url']
    friendly = row['friendly']
    folder = row['folder']

请帮助生成我期望的HTML文件所需的其余代码.

Please help with the remaining code needed to generate my expected HTML file.

推荐答案

，您可以尝试使用此工具: https://sometools.netlify.com/我确实使用了它，并且可以很好地满足我的需求.

you can try using this tool: https://sometools.netlify.com/ I did use it and works fine for what I wanted.

这篇关于如何将CSV中的书签读取到HTML书签输入文件中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！