Cannot see URL and other meta data of evernote imported notes

[grotesque]

Operating system

• Windows

Application

• Desktop

Evernote's export contains some meta data about notes. Eg. the URL that the note was clipped from.
It should be possible for those who're migrating to this awesome project to search their notes with URL.

[laurent22]

Yes the source URL is imported but indeed not visible at the moment.

[jpgreth]

+1
Is it save, the URL exported from Evernote is saved in the Joplin data und just not showed?
Today i'm starting to migrate 6k+ notes form Evernote to Joplin and it would be a huge Problem if the URLs are gone...

[foxmask]

if you want to be sure, export one evernote note from the desktop application, import it with joplin and then have a look at the database.

sqlite3 ~/.config/joplin-desktop/database.sqlite
select * from notes; 

(I dont know if it "source" or "source_url" that store this info)

[jpgreth]

It's the col "source_url" - and it's empty. I think it's just not implemented / saved to db. I'm not that deep in React (more the "old-PHP-guy" :) ) but i think if we want to have imported, it should be done in import-enex.js#L355 and following.

Can you or @laurent22 approve that?

(I checked in Win10 and Ubuntu 18.04 with the clients linked from the homepage. )

[laurent22]

I was certain the URL was imported to source_url but apparently not. Do you have by any chance an example of ENEX note that has a URL so that I know what to map source_url to?

[foxmask]

evernote api says sourceURL or blog post says source-url. The evernote sdk I used speaks about sourceURL too

[jpgreth]

@laurent22 That's no problem. I'll upload an enex file, on monday.

[jpgreth]

Ok @laurent22 here we go. The Evernote Client (Win10) i export from is Version 6.10.3.6921 (306921) Public (CE Build ce-1.39.4387).
The code inside the file can be found at: https://gist.github.com/jgreth/bead69c0875ac3f4620987f3c874dc47 or the file itself attached here.
Testfile.zip
(Had to zip it, cause github won't let me upload enex files)

As far as i can see, the XML Node is "source-url"

<en-export export-date="20180529T132629Z" application="Evernote/Windows" version="6.x">
	<note>
		<title>The Button</title>
		<content>...</content>
		<created>20180529T102212Z</created>
		<note-attributes>
			<source>web.clip7</source>
			<source-url>http://rasterweb.net/raster/2011/05/09/the-button/</source-url>
			<source-application>WebClipper 7</source-application>
		</note-attributes>
		[...]

[jpgreth]

Info / Update: my Evernote client just updated to version 6.11.2.7027 (307027) Public (CE Build ce-43.0.4829).
I exported the same Note and Diffed it with my previous posted one - format didn't change.

[jpgreth]

@laurent22 Was that the info you wanted? Or went something wrong?

[laurent22]

@jgreth, thanks for the providing the Enex sample - the source-url parameter will be supported in the next release.

[jpgreth]

Nice! Tank you so much. Then i can finally switch away from Evernote. ;)

[jpgreth]

@laurent22 looked in v1.0.107 didn't see. Am i blind or will it come in v1.0.108? ;)

[laurent22]

What is it you didn't see in v107? The source-url parameter is still not being imported?

[jpgreth]

Yes ist was the source-url parameter. But I think it was a buggy enex. Tried now again, with a newer enex file and now it works - so everything ok. Sorry for the trouble! ;)

[onetom]

This issue can be closed, IMHO.

I can confirm too that and export with Evernote macOS Version 7.10 (457750 Direct) can be imported with Joplin Desktop 1.0.158 (prod, darwin) and source URLs are preserved.

onetom@uhu /V/D/sqlite> nix-shell -p rlwrap sqlite --run 'rlwrap sqlite3 ~/.config/joplin-desktop/database.sqlite'
SQLite version 3.28.0 2019-04-16 19:49:53
Enter ".help" for usage hints.
sqlite> select count(*) from notes;
5545
sqlite> select count(*) from notes where source_url !="";
5405

Btw, the notes.source field describes the application which created the note, eg:

sqlite> select distinct source from notes;
joplin-desktop
evernote.Clearly
evernote.web.clip
evernote.mobile.android
evernote.mail.smtp
evernote.mobile.iphone
evernote.desktop.mac
evernote.mobile.ios
evernote
evernote.web.clip7

[laurent22]

Thanks for the confirmation @onetom. The issue can indeed be closed.