This would work great for importing stuff from instagram too. The format is tricky, just because nostr events have a million formats. There are also multiple formats for listings, Coracle's listings were actually NIP 99 classifieds (which are much simpler than nip 15).
To answer your question about created_at, they are second-resolution unix timestamps, which just means the number of seconds since Jan 1 1970. You should be able to format dates as timestamps in a normal spreadsheet program, for example Sheets: https://mixedanalytics.com/blog/convert-unix-timestamps-to-google-sheets-dates/ (just be sure to set it to seconds, not milliseconds, which is more common). Expiration is just an example, it's totally optional.
Here's another example that would work for classifieds:
kind,content,created_at,tags
30402,Look at my cool stuff,,"title,My Title","summary,A short summary","location,My Shop","price,30,USD"
Just copy that into a csv file and open it in numbers or whatever to edit, then export to csv before uploading. If you leave created_at empty, the importer will just use the current time.
hodlbod /
npub1jl…jynqn
2024-12-30 20:36:15
in reply to nevent1q…ukgr
Author Public Key
npub1jlrs53pkdfjnts29kveljul2sm0actt6n8dxrrzqcersttvcuv3qdjynqnPublished at
2024-12-30 20:36:15Event JSON
{
"id": "c8220ee0613e44dea3145e948c78cb8ee66683d024f51bac3377d665ec4f5601",
"pubkey": "97c70a44366a6535c145b333f973ea86dfdc2d7a99da618c40c64705ad98e322",
"created_at": 1735590975,
"kind": 1,
"tags": [
[
"p",
"de75eb1d7a6627807a8dff0fb337cfcf189e7e9af8ab6229f688f664710c3014",
"wss://relay.nostrplebs.com/",
"Yojimble"
],
[
"p",
"de75eb1d7a6627807a8dff0fb337cfcf189e7e9af8ab6229f688f664710c3014",
"wss://nostr.mom/",
"Yojimble"
],
[
"e",
"37f7b9274e4c9ca23fec924b808f6109cd0abe15034bcbbfa609b3ae3a9967b4",
"wss://21ideas.nostr1.com/",
"root"
],
[
"e",
"26ed327581b4892a7843df80429fd58eb6c343987951a1674a61bb0eaac8bb6b",
"",
"mention"
],
[
"e",
"e78a592762b2362c7092b96ce05be8b67ba40445553bad103638295aaba0fdf2",
"wss://relay.primal.net/",
"mention"
],
[
"e",
"4de8f26adf4306366317d20743cf311439bb88cf0e0f9a7dd25e8e02b0c30341",
"wss://hodlbod.coracle.tools/",
"mention"
],
[
"e",
"f27dc7c02cfdf7b4d0912bbb84bddfbdea059ba1c94316a230c29ffe9ff60899",
"wss://wot.nostr.party/",
"reply",
"de75eb1d7a6627807a8dff0fb337cfcf189e7e9af8ab6229f688f664710c3014"
],
[
"client",
"Coracle",
"31990:97c70a44366a6535c145b333f973ea86dfdc2d7a99da618c40c64705ad98e322:1685968093690"
]
],
"content": "This would work great for importing stuff from instagram too. The format is tricky, just because nostr events have a million formats. There are also multiple formats for listings, Coracle's listings were actually NIP 99 classifieds (which are much simpler than nip 15).\n\nTo answer your question about created_at, they are second-resolution unix timestamps, which just means the number of seconds since Jan 1 1970. You should be able to format dates as timestamps in a normal spreadsheet program, for example Sheets: https://mixedanalytics.com/blog/convert-unix-timestamps-to-google-sheets-dates/ (just be sure to set it to seconds, not milliseconds, which is more common). Expiration is just an example, it's totally optional.\n\nHere's another example that would work for classifieds:\n\nkind,content,created_at,tags\n30402,Look at my cool stuff,,\"title,My Title\",\"summary,A short summary\",\"location,My Shop\",\"price,30,USD\"\n\nJust copy that into a csv file and open it in numbers or whatever to edit, then export to csv before uploading. If you leave created_at empty, the importer will just use the current time.",
"sig": "a59e9bfbeb3f3ea9229941d09c2b070f7becf2e64b1edaee4f8bcf804a9a105773957f07565c61577a7a8cbd71b92dbc560912256c25814b74f5deecc3a2e756"
}