Exporting a memento database as CSV from Memento Desktop with image url

615 views
Skip to first unread message

Bear lord

unread,
Sep 14, 2017, 2:18:40 AM9/14/17
to mementodatabase
Hello!

I am trying to export a memento database as CSV. So far so good. The problem comes with an image field. When I export the database to Google Sheets, the image field gets exported as "http://mementoserver.appspot.com/blob/get?blob=...etc"
But when I export it as CSV from the desktop app, it gets exported as: "file:///storage/emulated/0/memento/files/123453...etc"

Is there a way to get the http version exported in the CSV instead of the "file:///storage version? 

Thanks in advance! =) 

Have a nice day.

Bill Crews

unread,
Sep 14, 2017, 10:20:35 AM9/14/17
to mementodatabase
Interesting. Your _desktop_ so uses a _mobile_ storage address; that should be a huge clue. That string is likely being set on a mobile device, and the export just uses it (inappropriately). I guess the trouble is in syncing with the cloud, probably from the mobile device, but possibly from the cloud to the desktop.

Bear lord

unread,
Sep 14, 2017, 10:32:21 AM9/14/17
to mementodatabase
My guess is that it is an exporting issue, since the images show on the desktop app and there's no way it would show if that was the only path available in the cloud. That's just my guess though. I'm guessing the http value is also stored somewhere inside the desktop app, that's how it is able to show  the pictures.

Bill Crews

unread,
Sep 14, 2017, 10:56:48 AM9/14/17
to mementodatabase
Yeah, if the export is dove _from_ the desktop. Apparently both strings are available. I agree that an export from a clouded library should use the cloud path. Only on a mobile-only library should the device party be used.

I don't use the desktop edition much at all, so I suppose there could also be a device-only path on the desktop, but I'm not sure the desktop edition can even have an unclouded library. If not, then no device-specific path should be exported.

Bear lord

unread,
Sep 14, 2017, 1:51:25 PM9/14/17
to mementodatabase
I can't seem to find an option to change the image field to show the URL instead of the file path on the mobile device. 

Does anyone know if it is possible to do this? Or is there a way to build de URL from the mobile device path?

Bear lord

unread,
Sep 19, 2017, 1:22:23 AM9/19/17
to mementodatabase
Good night. Was wondering if there's a way to get the http version of the image field via a script instead of the default export to csv? 

George Botsaris

unread,
Oct 4, 2017, 4:23:47 AM10/4/17
to mementodatabase
Hi

I had the same issue but I think is solved now. We will have it solved in the new version.

Gerorge

Xavier Boisseau

unread,
Oct 23, 2017, 5:52:17 PM10/23/17
to mementodatabase
Hello, 
Do you know WHEN it will be solved please?

Xavier
Reply all
Reply to author
Forward
0 new messages