正道沧桑

正道沧桑

Don't lost yourself.
HomeArchives

Google Book Sign-In Custom CSV: AI Processing Workflow

#bookmark#CSV#cursor37
AI Translation
This post is translated from Chinese into English through AI.View Original
AI-generated summary
The document outlines the process of converting bookmarks to CSV format using Google tools and plugins. It suggests using the "Export History/Bookmarks to JSON/CSV/XLS" Chrome extension to export bookmarks, but notes that the built-in JSON to CSV format is not user-friendly. It recommends using tools like Json to CSV or tableconvert for conversion, allowing for the removal of unnecessary columns and formatting dates as DD.MM.YYYY. The converted CSV file should then be placed in a cursor project, where a specific command is used to reorganize the data from the source CSV file to match the target CSV file's header format. The conversion requires that the order and names of the columns in the source file align with those in the target file, and any missing columns should be filled with appropriate values. The document emphasizes the need for intelligent matching of column names that may differ in case but have the same meaning.

Bookmarks to CSV Format#

  1. Use Google to Export Files#
  2. Google Plugin "Export History/Bookmarks to JSON/CSV/XLS"#
    1. After launching, use "Chrome bookmarks.json"
    2. The built-in json->csv format is not very useful
  3. Use Json to CSV Tool or tableconvert (you can delete unwanted columns)#
    1. Convert the date to DD.MM.YYYY (seems not very useful)
  4. Place the file exported from JSON to CSV tool into the cursor project#
  5. Use cursor agent, input the statement:#
    • Reorganize the @waiting_to_convert_csv.csv file according to the first row title of @target_file.csv, and match the titles of the @template file (let's get to work)
    • I have a source CSV file @waiting_to_convert_csv.csv, and I want to convert it into a format that conforms to @target_file.csv, the title row of target_file.csv is: title,note,excerpt,url,tags,created
    • Please reorganize the data of @waiting_to_convert_csv.csv according to the title row of @target_file.csv.
    • Conversion Requirements:
      • The order and names of the columns must match the title row of @target_file.csv.
      • Columns that do not exist in @waiting_to_convert_csv.csv (such as tags and note, etc.) should be intelligently filled with values that match the website content.
      • The title names in @waiting_to_convert_csv.csv and @target_file.csv may not be exactly the same in case, but have the same meaning (e.g., dateAddedLocal and created). Please intelligently recognize and match.
Loading...
Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.