Hi.
I have been assigned the task of importing 4000+ images from a remote service into a local Postgres database. An obvious FME task.
Fetching the images with ImageFetcher runs smoothly, but here starts my problems:
- I need to store the MIME type, but although ImageFetcher is set to auto-detect this, it never reveals it in the output. And no file extension is available, and no other transformer offers that service, so an improvement to ImageFetcher is warranted, I think.
- I need to store the image in a text column in base64 format, but a combination of GeometryExtractor (FME Binary) + TextEncoder (Base64) doesn't really seems to work.
The output should look like this: data:image/jpeg;base64,/9j/........
Is there a better way to accomplish my task ?
Cheers
Best answer by ebygomm
View original