Populating Expression Engine data from external applications
Posted: 01 December 2008 02:33 AM   [ Ignore ]  
Summer Student
Total Posts:  4
Joined  02-01-2007

Hello,

I created an Aperture plug-in to upload photos to an Expression Engine blog using the MetaWeblog API. Aperture (and other photo cataloging software like Adobe Lightroom, iPhoto, iMatch or Microsoft Expression Media) contains lots of metadata about each photo. This includes IPTC, EXIF and rating information. Aperture has support for hierarchical keywords. I’d like to export this data to Expression Engine. Clearly the MetaWeblog API isn’t rich enough to accomplish this.

I have searched the wiki, documentation and forums and can’t find an API (such as SOAP, REST or XMLRPC-like) that I can call from a remote application.  For the plug-in to work, I need to perform CRUD on categories and entries, as well as the ability to populate custom fields of both categories and entries.

Here is what I considered and tried:
Executing MySQL statements from my plug-in.  It isn’t an option as the MySQL database is on a remote host.

Have the plug-in generate files (like CSV) that we can import into MySQL.  This isn’t an option too, because I need to update existing entries. For example, update the metadata of an existing photograph.  It turned out to be to error prone.

Any ideas will be appreciated.

Werner

 Signature 

—-
http://bloudraak.com/

Profile
 
 
Posted: 01 December 2008 04:53 AM   [ Ignore ]   [ # 1 ]  
Research Scientist
Avatar
RankRankRankRankRankRank
Total Posts:  7061
Joined  04-15-2006

Hi Werner,

Sorry to post here as I don’t really know how you would go about accomplishing what you need but was just wondering if it would be possible to get a look at the Aperture plugin at all or is it available for purchase or something?

Thanks.

Best wishes,

Mark

 Signature 

Full List Of Plugins Here!! (16)
 
Retrieve Statuses
Maximum Posts Reached
Neat Link
Redirect
Fetch URI

Profile
 
 
Posted: 01 December 2008 09:27 PM   [ Ignore ]   [ # 2 ]  
Summer Student
Total Posts:  4
Joined  02-01-2007

I’m planning to wrap up the Aperture plugin later this week and make the binaries and source freely available.  I am a bit disappointed that its so hard to get the data from Aperture into Expression Engine.

 Signature 

—-
http://bloudraak.com/

Profile
 
 
Posted: 02 December 2008 03:27 AM   [ Ignore ]   [ # 3 ]  
Research Scientist
Avatar
RankRankRankRankRankRank
Total Posts:  7061
Joined  04-15-2006

Hiya,

That is exceptionally kind of you, can’t wait to give that one a test.

Once again sorry that this has been so difficult for you and sorry that I wasn’t able to lend a hand anywhere.

Best wishes,

Mark

 Signature 

Full List Of Plugins Here!! (16)
 
Retrieve Statuses
Maximum Posts Reached
Neat Link
Redirect
Fetch URI

Profile
 
 
   
 
 
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 1149, on July 16, 2007 09:33 AM
Total Registered Members: 66389 Total Logged-in Users: 47
Total Topics: 84714 Total Anonymous Users: 17
Total Replies: 454688 Total Guests: 192
Total Posts: 539402    
Members ( View Memberlist )