Base64 windows batch conversion program

Hi there

I have project that requires a very large number of jpeg image files to be converted to BASE64 to enable use in Json application
I have been searching without success to find a Windows conversion program, I found one very old reference, but on download it fails to execute.
Any assistance would be appreciated.

Regards

Hi Tral

This is 5 minutes Job

I think the pictures are self explanatory

Hi Mike

I am a "Goose"!

Too many late nights, the project from last year after a hiatus for several months looks like finally is going ahead.

I had left tackling the conversion until there was a definite commitment to going live.- there are 30+K images that vary in size from 5K to 300K .
I have resized them all to a standard height of 200 pixels, last requirement was for the conversion to Base64 - I just went looking for a batch program

As always the ETL Processor has the capability to resolve most requirement in data manipulation

Thank you once again!

Best Wishes

Hi Mike

I could not get the previous Transformation to work to extract the Base64 image for each of the selected Member records in a a batch of members to be uploaded as Json records.
It would only find a match and create the Jason record with the embedded Base64 image for the last member record of the batch, a result of the record sequencing with the retrieval.
Also because it would scan through the complete 30K images record for each member record it was taking much too long to go through a batch of member records trying to match them to the Base64 image

I thought it would be a better, faster look-up if the Base64 images were set up as a SQL database that was indexed on the image file name.
In the attached zip file there is a word doc with screen captures showing the set-up for using a SQL Lookup

I am stuck in trying to determine the format of how to structure the parameter1 to match up with the lookup of the PictureFileName that is presented to the SQL LookUp function.

In the screen captures you will see that there is now an additional field (PictureFileName) selected and part of the data retrieved from the member record that is used to populate the Jason upload record.

In the Transformation screen shot you can see the SQL LookUp at the bottom of the screen shot. Following this are screen shots of the individual tabs of the SQL LookUp process.

Is the Source Data Tab SQL script correct? If so, then it is the next Tab Parameters that I cannot see how to set it up so that Parameter1 picks up the PictureFileName that is passed into the SQL LookUp object?

The error handling is simply to have the field be a Null

Let me know if you need any further information

Thank you for your assistance.

Regards

"Also because it would scan through the complete 30K images record for each member record it was taking much too long to go through a batch of member records trying to match them to the Base64 image"

I assume that you have a folder which holds 30K+ images?
Is this correct?

Hi Mike
Yes - folder contains just the Base64 images