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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message