After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 412023 - Wordpress Blog Export
Wordpress Blog Export
Status: RESOLVED WONTFIX
Product: f-spot
Classification: Other
Component: General
0.3.x
Other All
: Normal enhancement
: ---
Assigned To: F-spot maintainers
F-spot maintainers
gnome[unmaintained]
Depends on:
Blocks:
 
 
Reported: 2007-02-25 20:58 UTC by Jason Switzer
Modified: 2018-07-12 00:04 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Jason Switzer 2007-02-25 20:58:50 UTC
I have a feature suggestion for the export. I found that I would really love to export the f-spot database to my Wordpress blog. I don't know if there is any desire to do this or not, but there is a potential to expand this greatly to include other blog support.

First, the export feature in f-spot would be very similar to the stand-alone gallery export. However, only the hq, mq, and thumbs folders would be needed. It could also present the user with some options as to customize the interface, but those could all be tackled later. The photos.db would have to be copied elsewhere and have the photos table modified to include the path from the document root (specified in a dialog).

The Wordpress part would need a PHP library to query the database as to make expansion and inclusion easier. I mocked up a sample page that pulled in the Wordpress content and added the photos to display. In this example, it has basic lightbox support if available and tries to follow the layout of the already existing folder export. I didn't have time to have it link the thumbnails but it would be the same as how they are used in the stand-alone version (reference by same name under thumbs/). Clearly this is just an example but it shows how f-spot database access can be added to a blog in the same manner of PennAve. Also, the concept where each folder is a gallery would be more than sufficient for this interface.

Note that this does not technically need to be a full-fledged Wordpress plugin. It could be to manage the available options, such as lightbox support or document root (etc), but in my example, it was just a PHP page under the Wordpress root. This is similar to how the fGallery plugin works (can use mod_rewrite for short URLs).

There are a ton of features that could be added in the future, such as a widget that acts similar to the Flickr tags.

Below is the Wordpress example (http://s1n.dyndns.org/wordpress/wp-content/plugins/f-spot.php):

<?php include("../../wp-blog-header.php "); ?>
<?php get_header(); ?>

<div id="content" class="narrowcolumn">

                <div class="entry">
                        <?php
                           $db = new PDO('sqlite: photos.db');
                           foreach($db->query('SELECT * from photos') as $row) {
                              print "<a href= http://s1n.dyndns.org/wordpress/wp-content/pictures/".$row['name']." rel=lightbox style='text-align:center; -moz-border-radius:5px; margin:6px; display:block; border: 1px solid #727272; float:left;'><img src=" . "/wordpress/wp-content/pictures/". $row['name'] . " title='Test Title' style='width:140px; height:140px; padding:4px; border:0px'/></a>";
                           }
                        ?>
                </div>
</div>
<?php get_sidebar(); ?>

<?php get_footer(); ?>
Comment 1 Luis Villa 2008-04-30 22:19:13 UTC
This would be pretty sweet, especially now that Wordpress 2.5 has substantially better gallery functionality than previous versions of wordpress.
Comment 2 André Klapper 2018-07-12 00:04:57 UTC
F-Spot has moved to https://github.com/f-spot/f-spot/issues

If this Bugzilla ticket is still valid in a recent version of F-Spot, please feel free to post this topic as a ticket in the F-Spot project on GitHub.

Closing this report as WONTFIX as part of Bugzilla Housekeeping as we are planning to shut down GNOME Bugzilla in favor of GNOME Gitlab.