Generating MD5

kfrancis25

Is it possible to generate an MD5 hash of another column? It looks like I could use something like:

import hashlib
hashlib.md5("row column value".encode('utf-8')).hexdigest()

Chris.Allen

Hi- you mean with the python custom generator option? Sure, I think this will work.

kfrancis25

It doesn't seem to work using the "Python script" generator, I just get errors about hashlib:

An error occurred. ImportError: No module named hashlib - No installed python version was automatically detected; consider installing python 2.7 or adjusting the application options.

IronPython documentation also shows the example:

import md5
m = md5.new()

But I get the same type of error, just a different name:

An error occurred. ImportError: No module named md5 - No installed python version was automatically detected; consider installing python 2.7 or adjusting the application options.

Chris.Allen

I see. Sorry about this. This looks like a current limitation of our support-I'll try to find out more. please bear with me...

Chris.Allen

This works:

prepend file with:

import sys

sys.path.append(r'C:\Program Files (x86)\IronPython 2.7\Lib')