Hackernews upvoted submissions

export_hackernews_upvotes_bookmarks.js

(function () {
    const popup = createPopup('HN upvoted');
    if (location.host != 'news.ycombinator.com' || !(location.pathname == '/user' || location.pathname == '/upvoted'))  {
        popup.innerHTML = 'ERROR: Go to your user or upvoted page on HN and then try again.';
        return;
    }
    const id = location.search.split('=')[1];
    const types = {
        csv: {
            header: 'Name,URL',
            filename: id + "'s HN upvoted",
            totype: f => toCSV(f.name, f.url)
        },
        html: {
            header: '<title>' + id + "'s HN upvoted</title><style>body {font-family: sans-serif;}</style><h1>" + id + "'s HN upvoted</h1>",
            filename: id + "'s-HN-upvoted",
            totype: f => '<p>' + link(f.url, f.name)
        }
    };
    const upvoted = [];
    const form = popup.appendChild(document.createElement('form'));
    form.innerHTML = 
        '<input id=query> <button type=submit>Search</button> ' + 
        'Export to <button id=exportToCSV data-filetype=csv>CSV</button> ' + 
        '<button id=exportToHTML data-filetype=html>HTML</button><br><br>' +
        '<div id=results></div>';
    query.focus();
    form.onsubmit = async function (event) {
        event.preventDefault();
        const re = new RegExp(query.value, 'i');
        await getupvoted();
        const found = upvoted
            .filter(f => f.name.match(re) || f.url.match(re))
            .map(f => '<tr><td>' + link(f.url, f.name) + '<td>' + link(f.url, f.url));
        results.innerHTML = found.length ? '<table>' + found.join('') + '</table>' : 'not found';
    };
    exportToCSV.onclick = exportToHTML.onclick = async function (event) {
        event.preventDefault();
        const filetype = this.dataset.filetype;
        await getupvoted();
        downloadFile(types[filetype].header, upvoted.map(types[filetype].totype), types[filetype].filename, filetype);
        results.innerHTML = 'Finished exporting.';
    };
    async function getupvoted() {
        if (upvoted.length > 0) return;
        var url = `upvoted?id=${id}`;
        var page = 1;
        while (url) {
            results.innerHTML = `Fetching page ${page++} ...<br><br>`;
            const response = await fetch(url);
            const html = await response.text();
            const parser = new DOMParser();
            const doc = parser.parseFromString(html, 'text/html');
            doc.querySelectorAll('span.titleline > a').forEach(a => upvoted.push({name: a.innerText, url: a.href}));
            const more = doc.querySelector('a.morelink');
            url = more?.href;
            if (more) {
                await sleep(850);
            }
        }
    }

    function createPopup(title) {
        const div = document.body.appendChild(document.createElement('div'));
        div.innerHTML = title + " <a onclick='document.body.removeChild(this.parentNode)' style='cursor: pointer; padding: 4px'>X</a><br><br>";
        div.style.cssText = 'position: absolute; padding: 8px; top: 4px; color: black; background-color: white; z-index: 1001; border: 1px solid #ddd;';
        return div.appendChild(document.createElement('div'));
    }
    function toCSV(...fields) {
        return fields.map(field => `"${field == undefined ? "" : field.toString().replace(/"/g, '""')}"`).join(',');
    }
    function downloadFile(header, lines, filename, filetype) {
        const a = document.body.appendChild(document.createElement('a'));
        a.href = URL.createObjectURL(new Blob([header + '\n' + lines.join('\n')], {type: 'text/' + filetype}));
        const date = new Date().toISOString().replace(/[T:]/g, '-').slice(0, 19);
        a.download = `${filename}-${date}.${filetype}`;
        a.click();
    }
    async function sleep(time) {
        return new Promise(resolve => setTimeout(resolve, time));
    }
    function link(url, text) {
        return `<a href="${url}" target=_blank>${text}</a>`;
    }
})();

export_hackernews_upvotes_bookmarks.md

Download HackerNews (HN) Upvotes as CSV and import into google sheets. This works as of January 2, 2025.

Instructions:

1. Open HN upvotes page by pasting this link https://news.ycombinator.com/upvoted?id={put your username} in chrome or clicking on "upvoted submissions in your HN profile page.
2. Paste above script in console and click CSV button to get the CSV.

Credit goes to Gabriel Sroka's repository https://github.com/gabrielsroka/gabrielsroka.github.io. He has a getHNFavorites.js file: https://github.com/gabrielsroka/gabrielsroka.github.io/blob/master/getHNFavorites.js from which inspiration was taken with some minor changes. This is the HN discussion related to the Favorites script https://news.ycombinator.com/item?id=22788236.