How to populate missing extensions

asked on October 17, 2018

Hi All,

Recently a migration was done for our customer into Laserfiche.

The file extension is missing from the properties dialog, this is causing the icon to be displayed incorrectly in Laserfiche.

The document will open fine on double click, and if you drag and drop to the desktop it will open from there (this is an MSG in this example). What doesn't work, is the OCR, it shows the error:-

I see the correct SDK method is mentioned here - https://answers.laserfiche.com/questions/102467/Extension-not-saved-after-writeEDoc-and-setExtension however the migration has already been completed of some 2 million documents.

Is there a way to retrospectively go back and populate the extension? (I'm assuming this will have to be done in SQL?)

Cheers!

0 0

replied on October 17, 2018

Do they still have the old system available? Is there enough in the document metadata to look it up in the old system and get the extension/mime type?

0 0

replied on October 17, 2018

This has crossed my mind, however the old system was FileSite. Not sure how that's structured, or even if it's even possible to query on that level, what I'm more bothered about is how you would then insert it into Laserfiche.

I'm guessing in SQL there is a column where that extension information is held, is this the only way to assiciate the file extensions?

I guess what you could do, is run a search, get all the entry ID's for each file types, write those to a table and have WF iterate through it on a 'For Each Row' activity and update the corresponding entry ID in the LF SQL database. Pretty long winded, but I'm guessing at this stage that's the only option.

I'm hoping for a magic wand solution from Laserfiche!

0 0

Question

Question

How to populate missing extensions

Replies

Sign in to reply to this post.