NO_METADATA_ERROR, recovery failed

[j2l]

Hello, I'm trying to import an sqlite database into Grist through open. I'm getting the error:

Error opening document
You can try reloading the document, or using recovery mode. Recovery mode opens the document to be fully accessible to owners, and inaccessible to others. [NO_METADATA_ERROR: <ID> has no metadata]

Reload throws the same error and recovery mode throws in the console:

Failed to load resource: the server responded with a status of 500 (Internal Server Error)
BaseAPI.ts:113 Fetched http://0.0.0.0:8484/o/docs/api/docs/<ID>/recover
errors.ts:50 ERROR: Error: Request to http://0.0.0.0:8484/o/docs/api/docs/<ID>/recover failed with status 500: Internal Server Error (NO_METADATA_ERROR: <ID> has no metadata)
    at u (BaseAPI.ts:142)
    at d.<anonymous> (BaseAPI.ts:116)
    at Generator.next (<anonymous>)
    at s (main.bundle.js:12)
h @ knockout-latest.js:1
BaseAPI.ts:142 Uncaught (in promise) Error: Request to http://0.0.0.0:8484/o/docs/api/docs/<ID>/recover failed with status 500: Internal Server Error (NO_METADATA_ERROR: <ID> has no metadata)
    at u (BaseAPI.ts:142)
    at d.<anonymous> (BaseAPI.ts:116)
    at Generator.next (<anonymous>)
    at s (main.bundle.js:12)

With a 500 error, I'm not sure if recovery mode is failing at building metadata or expects something in metadata.

How to import a sqlite file into Grist?

[paulfitz]

Hi @j2l, I'd guess the metadata error is Grist expecting to see some tables it keeps as bookkeeping, and not finding them, because the sqlite file isn't a Grist document. We do have a plugin for importing sqlite, but it hasn't been published yet, I'll try to herd it along.

[j2l]

Great! Can't wait to be able to import this sqlite db.

[j2l]

Hello, Any news on this one?

[paulfitz]

@j2l it got blocked on an awkward architectural issue. Let me poke at it again - thanks for pinging, and sorry for the delay.