CSV to JSON Bookmark

[soaresden]

I encounter myself in a tricky situation where I would had like to export my search and import it into bookmark.

The format are differents !

So I had to make a python script to convert it:

import csv
import json

# Chemin du répertoire contenant les fichiers CSV
csv_folder = 'D:\FINISHED\RALibretro-x64\Saves\Savestats\Cool Boarders 2\csvfolder'

# Loop all the csv's
for filename in os.listdir(csv_folder):
    if filename.endswith('.csv'):
        csv_file = os.path.join(csv_folder, filename)
        
        # Build JSON output file
        json_file = os.path.splitext(csv_file)[0] + '.json'

        # List to stock memory
        bookmarks = []

        # Read CSV
        with open(csv_file, 'r') as file:
            reader = csv.reader(file)
            next(reader)  # Ignorer l'en-tête
            for row in reader:
                address = row[0]  # Only take 1st column
                formatted_address = "0x " + address.strip()[-6:]  # Format adresse with 6 last cars and add a space
                bookmarks.append({"MemAddr": formatted_address})

        # Create dictionnary with adresses
        data = {"Bookmarks": bookmarks}

        # Write down into JSON
        with open(json_file, 'w') as file:
            json.dump(data, file, indent=4)

        print(f"{json_file} created")

Two solutions then :

• Accept to import CSV + JSON to bookmarks
• Add this little script with a popup warning about processing