A couple of IDEA regex functions and some simple code snippets ►

◄ Project Zebra: Let me know when you find out...

2018-09-18 📌 Batch extracting invoice images from an Agresso system

Tags 🏷 All 🏷 Tech 🏷 Audit

If you know what Agresso is, you might want to do that. For some time we used SQL Image Viewer because Unit4 switched to storing documents as binary blobs in the database, but it's been all change since to file system storage. This scrap of VBScript should handle both newer storage mechanisms. It won't handle legacy encrypted Compello files, unfortunately. If you know how to handle those, please do get in touch.

This also assumes familiarity with tools such as https://docs.microsoft.com/en-us/sql/tools/bcp-utility

💬 Comments are off, but you can use the mail form to contact or see the about page for social media links.