I have a much larger >500k OpenAlex API-exported json file that I converted programmatically to RIS AND to bibtex (and which I'd be happy to share with anaybody who'd want to check as - maybe - an 'edge case'). When I try to import them into Zotero, I get the following (report ID 666617473 - 1,118 records import correctly, the rest not). :Oh and also - does importing bibtex vs ris make a difference (in terms of speed/probability of correct importing)
Not the same issue. The original issue occurs after a successful import. For you, it's somewhat hard to say from the above, but I'd guess either your database is corrupted or (and that would be my guess) you are just hitting performance limits. 500k items are at the outer limits of what Zotero can handle, it's definitely at the outer limits of what it can handle for a single import, so for a start I'd split the file up into 10 or so, which is easy withv ether format.
I'd guess RIS uses a bit less resources on import. The quality should be similar
Upgrade Storage
I have a much larger >500k OpenAlex API-exported json file that I converted programmatically to RIS AND to bibtex (and which I'd be happy to share with anaybody who'd want to check as - maybe - an 'edge case'). When I try to import them into Zotero, I get the following (report ID 666617473 - 1,118 records import correctly, the rest not). :Oh and also - does importing bibtex vs ris make a difference (in terms of speed/probability of correct importing)
[JavaScript Error: "XML Parsing Error: syntax error
Location: moz-nullprincipal:{cc6a82c2-0fb2-4b6a-afb6-3de040983f64}
Line Number 1, Column 1:" {file: "moz-nullprincipal:{cc6a82c2-0fb2-4b6a-afb6-3de040983f64}" line: 1 column: 1 source: "Provider: OpenAlex"}]
[JavaScript Error: "XML Parsing Error: syntax error
Location: moz-nullprincipal:{4e0de979-7593-425a-9a4c-d11a45ca154e}
Line Number 1, Column 1:" {file: "moz-nullprincipal:{4e0de979-7593-425a-9a4c-d11a45ca154e}" line: 1 column: 1 source: "Provider: OpenAlex"}]
[JavaScript Error: "XML Parsing Error: syntax error
Location: moz-nullprincipal:{00a2a60f-cdc5-432d-9f2b-99fb2c9f214b}
Line Number 1, Column 1:" {file: "moz-nullprincipal:{00a2a60f-cdc5-432d-9f2b-99fb2c9f214b}" line: 1 column: 1 source: "Provider: OpenAlex"}]
[JavaScript Error: "XML Parsing Error: syntax error
Location: moz-nullprincipal:{42c0d1ab-5c3a-44a6-aa2a-484a74b846cc}
Line Number 1, Column 1:" {file: "moz-nullprincipal:{42c0d1ab-5c3a-44a6-aa2a-484a74b846cc}" line: 1 column: 1 source: "Provider: OpenAlex"}]
[JavaScript Error: "The connection to wss://stream.zotero.org/ has terminated unexpectedly. Some data may have been transferred."]
[JavaScript Error: "WebSocket connection closed: 1006 "]
[JavaScript Error: "Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.sys.mjs" line: 1140}]
[JavaScript Error: "The connection to wss://stream.zotero.org/ has terminated unexpectedly. Some data may have been transferred."]
[JavaScript Error: "item.isRegularItem is not a function" {file: "chrome://zotero/content/xpcom/retractions.js" line: 841}]
[JavaScript Error: "WebSocket connection closed: 1006 "]
[JavaScript Error: "Error: Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.sys.mjs" line: 1140}]
[JavaScript Error: "Error(s) encountered during statement execution: FOREIGN KEY constraint failed [QUERY: INSERT INTO itemNotes (itemID, parentItemID, note, title) VALUES (?,?,?,?)] [PARAMS: 294490, 294489, "
OpenAlex type: article → RIS: JOUR
[JavaScript Error: "Error: Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.sys.mjs" line: 1140}]
[JavaScript Error: "Error: Failed to load resource://gre/modules/PlacesDBUtils.sys.mjs" {file: "chrome://zotero/content/fileInterface.js" line: 397}]
Zotero_File_Interface Zotero, version => 7.0.24 (x64), os => Windows 11 26100, locale => en-US, extensions =>
I'd guess RIS uses a bit less resources on import. The quality should be similar