Backup 1P data before importing licenses from csv [Importing from LicenseKeeper]

camner

Not to worry...get your sleep!

MrC

@camner,

I've posted the new version which should improve performance.

camner

Wow! You must have coded this differently! It took all of 5 seconds....

Now my next challenge will be to figure out an easy way to get the txt files that contain html email messages to render as html. But that shouldn't be too difficult.

MrC

Hi @camner,

A little faster. :)

Attaching email messages to a program is weird. It would have been better if LicenseKeeper rendered the mail as PDF and you attached a PDF.

The problem is that the content is typically MIME encoded, and carries the HTML text and sometimes also the non-HTML text version. I'd have to MIME-decode the mail message, but this is getting way to complex for a converter (the decoding isn't hard, its just dealing with all the edge cases, etc.).

Somewhere I have a nice MIME-extraction script, if that will help you.

camner

I certainly wasn't expecting a MIME decode as part of the conversion process...you went well above and beyond as it is, and will save a lot of time in the conversion.

I'd love to play with the MIME decode script if you can make it available to me. That may save a lot of time of doing stuff by hand.

Thanks again for all of you work on this.

MrC

@camner,

It occurred to me last night... change the suffix from .txt to .eml and then double click the file. How's that?

camner

Oooh, that may be brilliant. I'll try that!

MrC

@camner, if that works, I'll update the converter to do this instead of .txt.

camner

Thanks!

What I'll also need to check out is whether ALL or most of the files without extensions are emails, for if they are a mixed bunch, this solution won't work.

I also have some third party software that I believe can batch rename files, though if this is a good technique it could work well for other migrants from LicenseKeeper.

I may have a bit of a delay in getting back to you. I am hosting an international guest for a week or so, and I don't know if I'll be able to sit at my computer very much during that time, but if I can, I'll test that out and get back to you.

MrC

Hi @camner,

I posted the update which sets the file extension for EMAILRECEIPTS types to .eml. This will cause the docs to be open with the default Mail program. It can always be changed later if anyone has issues.

I'm not setting any suffix currently for other attachments. Presumable they came in w/out a suffix, and unless I analyze the contents, can't know exactly what to do (and even then, the suffix would be a guess). Generally OS X doesn't use file suffixes - those are a fall back mechanism. The original file type should be set by LicenseKeeper when it restores the archived file.

camner

I think this is a good solution. I tried opening (via double clicking) a file whose extension I changed to .eml and it opened right up in Postbox.

Thanks again for all of your help!

camner

This is a real small thing, and not worth spending any time on, but in my LicenseKeeper database I used the < symbol from time to time, and that got translated by your converter to \u3c00. That's easy to fix manually, of course!

MrC

Hi @camner - In which field, or area does this occur?

Edit: Never mind, reproduced. Checking on a fix.

MrC

@camner,

I've update the 1.06 version to handle these. LicenseKeeper is not correctly encoding the characters < > and & in the XML document:

<attribute name="title" type="string">\u3c00email \u2600 soft\u3e00</attribute>

so I've decoded them and write out the correct sequence. Let me know if you find any more.

Thanks!

camner

Thanks much!

The only other thing that I have discovered, but that isn't anything you can control, is that there are attachments missing. That's obviously a problem in the LicenseKeeper export process.

Thanks for all of your help. This made a conversion process that would have been incredibly time-consuming and tedious and made into a manageable process.

MrC

@camner,

So you're saying the attachments are not in the LicenseKeeper export file at all?

You're welcome, btw.

camner

So you're saying the attachments are not in the LicenseKeeper export file at all?

Exactly! Sometimes when there are, say, 4 attachments showing in LK, there are only 2 or 3 in the Attachments folder created by LK. But I can export them individually from within LK, so I don't end up losing them. It's just that I have to click through the LK interface to make sure that the number of attachments in the folder equals the number in LK. It's hit or miss. Of the over 200 attachments, I've only found a few missing.

MrC

I wonder if the XML data has the true number, but for some reason the export failed. I could output the number of attachments per entry, and verify this and the attachment list against that was found in the directory, if that would help.

camner

Thanks, but I don't think that's necessary.It hasn't been all that hard just to arrow down the LK entries and visually make sure that the number of attachments in LK is the same as the # in the Attachments folder (after conversion with your neat routine!). As I said, there are only a few that didn't carry over. I suppose if I had thousands of software licenses to handle, but I have only about 300 entries in total, and about 200+ with attachments, and only a handful with more than 1 or 2, so that's a pretty small list.

littlebobbytables

Hi @camner,

MrC is a fantastic person isn't he. His willingness to help goes well beyond simply passion and I doubt any of us know how many people he's helped along the way. Did you manage to complete your conversion in the end?