We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.
Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.
Firstly, apologies if this is in the wrong section but wasn't sure where best to put it.
Basically, I'm looking for a way to import media items in bulk to RE, insetad of manually entering one item at a time. I'm looking to write an application that does this rather than purchase any third-party software. Now, my understanding is that current;y it is not possible to do this using the API. So, I have tried writing directly to the RE database. I have no trouble doing this, and adding media items to the 'object' field in binary format. However, when I do this I am unable to view that media item in RE. The record exists but nothing appears when you try and open the item. I am not bothered whether the actual item gets imported or if it's only a link instead. Either will suffice.
So does anyone know if this actually possible and some suggestion of how to achieve it?
I am wondering if Blackbaud have got this locked down somehow by using some algorithm when writing to the 'object' field in the 'MEDIA' table hence when I write only the item in binary format it cantht be seen from RE. I know there is nothing wrong with what I'm writing as I can manually read it out again. The following response seems to suggesto this to me, if anyone can give any further advice and opinion I'd be really grateful.
Thanks.
I have checked into this and can advise that currently, the only way to add media objects through VBA or API is through the use of the CMediaForm. When you add a media object, there is a process that converts the media object to a binary string that is stored in the OBJECT field and the code that performs that action is proprietary. The functionality you are requesting has been filed with our developers as a suggestion for a future release. The knowledgebase solution that documents this suggestion is: