![]() If you want the program to stop if it finds duplicate columns, use the -fail-on-duplicate-csv-columns flag. Only the last column will be used if CSV has multiple columns with the same name. Therefore CSV columns will be treated as unique. Notion does not allow the database to have multiple columns with the same name. Try not to set it too high to avoid rate limiting by the Notion server. Use the -max-threads option to control how fast it will go. To speed things up, this tool uses multiple parallel threads. Upload speedÄue to API limitations, the upload is performed one row at a time. token_v2 cookie provides complete access to your Notion account. For information on how to get it, see this article. The tool also requires you to provide a token_v2 cookie for the Notion website through -token option. The URL must link to a database view, not a page. Optionally you can provide a URL to an existing Notion database with the -url option if not provided, the tool will create a new database named after the CSV file. The CSV file must contain at least 2 rows. ![]() You must pass a single *.csv file for upload. Otherwise those values will be replaced with default status fail-on-wrong-status-values fail if values for 'status' columns don't have matching option in DB (columns with type created_by, last_edited_by, rollup or formula) fail-on-unsettable-columns fail if DB has columns that don't support assigning value to them fail-on-missing-columns fail if columns are present in CSV but not in Notion DB fail-on-inaccessible-relations fail if any relation column points to a Notion DB that Otherwise errors will be replaced with empty strings fail-on-conversion-error fail if any column type conversion error occurs fail-on-duplicate-csv-columns fail if CSV has duplicate columns Useful when sanitizing before merge to avoid ambiguous mapping fail-on-duplicates fail if Notion DB or CSV has duplicates in key column, Will be treated as unique when looking up relations Otherwise, first entry in alphabetical order fail-on-relation-duplicates fail if any linked DBs in relation columns have duplicate entries mandatory-column COLUMN CSV column that cannot be empty (use multiple times for multiple columns) default-icon ICON Emoji, URL or image file that will be used as page icon for every row by default icon-column-keep keep icon CSV column as a Notion DB column That will be used as page icon for that row icon-column COLUMN CSV column that points to emoji, URL or image file image-caption-column-keep keep image caption CSV column as a Notion DB column image-caption-column COLUMN CSV column that points to text caption that will be added to the image block image-column-mode upload image as or insert it as (default: block) image-column-keep keep image CSV column as a Notion DB column image-column COLUMN CSV column that points to URL or image file that will be embedded for that row add-missing-relations add missing entries into linked Notion DB merge-skip-new skip new rows in CSV that are not already in Notion DB during merge (use multiple times for multiple columns) When provided, other columns will be ignored merge-only-column COLUMN CSV column that should be updated on merge merge merge CSV with existing Notion DB rows, first column will be used as a key ![]() randomize-select-colors randomize colors for added options in select and multi select columns add-missing-columns if columns are present in CSV but not in Notion DB, add them to Notion DB ![]() (can also be used with -add-missing-columns flag) If none is provided, types will be guessed from CSV values column-types TYPES comma-separated list of column types to use for non-key columns h, -help show this help message and exit version show program's version number and exit max-threads NUMBER upload threads (default: 5) url URL Notion database URL if none is provided, will create a new database token TOKEN Notion token, stored in token_v2 cookie for notion.so Import/Merge CSV file into Notion database ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |