I'm in the process of creating a module that I've called pgImport. It enables you to import information from other databases and submit them as new pagesetter publications. It allows to map the results of a select query to pagesetter publication fields. It stores a sha1 hash string of all the fields to be imported, and for information that is actually imported the publication id created, which enables detecting changes in the database and remember decisions about whether or not to import a specific result.
Now I need to import jpeg formatted images from a peoplesoft database. For that I need a BLOB type of raw data field in pagesetter, or I would need to build a complicated detection mechanism and either create files and use the 'any upload' field type or try to import in photoshare and store the image URL in a pagesetter field. For the purposes of this import module the first option would of course be preferable.
I'm thinking of adding a raw data field in the form of a BLOB. Jorn would you consider supporting this? Are there any other options that I am overlooking? Any other suggestions?
Thanks!
Posted: 28.10.2005, 22:29
rank:
12
registered:
March 2009
Status:
offline
last visit:
Posts:
0
I suggest using the image upload fields in Pagesetter.