How to import notes containing Excel and PDF from Evernote and display them inline

I Try importing data from Evernote to DEVONThink3.
Import a note containing Excel data and PDF Document from Evernote Legacy (Fig. 1 below), there will be 3 files on DEVONThink3 as shown in Fig. 2 below, and the note body will be only text.
Is it possible to import Excel and PDF while displaying them inline?

Fig1

Fig2

In both Evernote and Devonthink
. These are not notes “containing” Excel and PDF
. These are notes containing links to Excel and PDF records (3 records)

display them inline

Evernote did an excellent job of rendering the links as inline display
edit: Evernote Legacy

2 Likes

Thank you for your reply.

The Legacy version was great.
In Evernote Ver.10, Excel can only display links.
Isn’t it possible to realize the functions of the Legacy version with DEVON Think?

Not as it stands now

It is a pity.
However, at present, only the image data is displayed inline by importing from Evernote.
I feel that PDF Document can be created even if Excel is not good, but how about it?

I doubt that anybody would want to embed either a PDF interpreter or an Excel processor (why even stop there? There are word files out there, audio/video, AutoCAD, Photoshop PSD…) into something that is meant to show a note.

Personally, I don’t think that’s a pity. It is a reasonable limitation, in my opinion. Why display something that requires an external program anyway to work with?

Having said that, you can use a table in markdown, RTF and HTML (albeit without formulae). And you can embed an image of your PDF, too. Or a link to it which opens the document when clicked on (hopefully).

1 Like

Also, Devonthink stores image file attachments differenly
The PDF and Excel files are stored as separate files
Image files are embedded within the note record

Certainly, all data can be viewed and managed using the current DEVON Think function.
However, if you want to intuitively select past data, not just keyword search, it is important that it is displayed on one screen. Like the image, I would like you to be able to embed the PDF alone.
I think it is possible if it is a rich text document.

I can understand it.
I think it would be great if the PDF document could be embedded in the memo and a link to the file could be created.

Did you try it? Just create a RTF using Text Editor and embed a PDF file. What do you get?

1 Like

I tried it.
The image above is a PDF document with a screenshot of “DEVONtechnologes”'s WEB page pasted and text added, and the image below is a screenshot of DEVON Think.

I support the request for inline display of links, but not for embedding files
I’m not even happy with images being embedded in the note file

2 Likes

I don’t think it is necessary to embed it in a memo file and make it one file.
As a rendering engine function, it would be better to “embed” the linked data on the screen.
I’m not saying it right now, but I hope it will be realized in the next version (4?).

OK, since you baited me… I hacked something together in JXA-ObjC that takes the path of a DT record, generates a Quicklook preview from it, converts that into a Base64 coded data URL and could write the latter to another or the same DT record.

ObjC.import("Cocoa");
ObjC.import("Foundation");
ObjC.import('CoreFoundation');
ObjC.import('QuickLook');
ObjC.import('AppKit');

const app = Application("DEVONthink 3");
const rec = app.getRecordWithUUID("some UUID")

const path = rec.path();
const pathURL = $.NSURL.fileURLWithPath(path);

const cgimageRef = $.QLThumbnailImageCreate($.kCFAllocatorDefault, pathURL, $.CGSizeMake(600,800), {});
const nsimage = $.NSImage.alloc.initWithCGImageSize(cgimageRef, $.NSZeroSize);
const newRep = $.NSBitmapImageRep.alloc.initWithCGImage(cgimageRef);
newRep.setSize(nsimage.size);
const pngData = newRep.representationUsingTypeProperties($.NSPNGFileType,{});
const b64 = 'data:image/png;base64,' + ObjC.unwrap(pngData.base64EncodedStringWithOptions(0));
/* b64 is a data URL 
you can insert it into an MD file like
![](b64)
*/

This is noting more than a proof of concept. It shows that you can add a preview of any file accessible to Quicklook as an image to a MD file. And I’m not even sure if everything in this script is even necessary.

If you should do that is a completely different question. My sample Numbers table generated a PNG of about 60 KB, so the Base64 encoded data URL is about 90K – of gibberish, just to have a nice picture. I’m not going down this road, since at the end lies madness. But if anybody else feels intrigued … be my guest.

2 Likes

Thank you for your interesting verification report.
I can’t take advantage of this because I don’t have coding skills, but I hope it will happen in the near future.