<?xml version="1.0"?><?xml-stylesheet type="text/xsl" href="http://www.codeplex.com/rss.xsl"?><rss version="2.0"><channel><title>pix2gallery2 Forum Rss Feed</title><link>http://www.codeplex.com/pix2gallery2/Thread/List.aspx</link><description>pix2gallery2 Forum Rss Description</description><item><title>New Post: can't login</title><link>http://pix2gallery2.codeplex.com/Thread/View.aspx?ThreadId=63828</link><description>&lt;div style="line-height: normal;"&gt;&lt;p&gt;No matter which account I use, set up in Gallery2, I can not log in using this plugin. Any ideas?&lt;/p&gt;&lt;/div&gt;</description><author>chipw</author><pubDate>Wed, 29 Jul 2009 03:37:18 GMT</pubDate><guid isPermaLink="false">New Post: can't login 20090729033718A</guid></item><item><title>New Post: Could not load file or assembly 'EXIFextractor, Version=0.9.2.0</title><link>http://pix2gallery2.codeplex.com/Thread/View.aspx?ThreadId=44515</link><description>&lt;div style="line-height: normal;"&gt;&lt;p&gt;Saddly, I'm getting the same error message. &amp;nbsp;However, uploading them without a resize doesn't work for me as an alternative.&lt;/p&gt;
&lt;p&gt;I used this glorious program for awhile now, and it's made uploading photos to my site a breeze, but now I'm lost without it! &amp;nbsp;After my harddrive crashed last week, I'm running Windows7 64bit RC1... thinking that it should run fine since you've designed it for Vista 64... but so far no luck. &amp;nbsp;I get the popup dialogue error message when I try to resize on upload, but no error when I upload at original size (but it does tell me that it fails as a status bar message, so my guess is it's my web server's limitations at that point.)&lt;/p&gt;
&lt;p&gt;help?&lt;/p&gt;
&lt;p&gt;thanks,&lt;/p&gt;
&lt;p&gt;Joel&lt;/p&gt;&lt;/div&gt;</description><author>joelsawyer</author><pubDate>Fri, 22 May 2009 15:09:26 GMT</pubDate><guid isPermaLink="false">New Post: Could not load file or assembly 'EXIFextractor, Version=0.9.2.0 20090522030926P</guid></item><item><title>New Post: Could not load file or assembly 'EXIFextractor, Version=0.9.2.0</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=44515</link><description>&lt;div style="line-height: normal;"&gt;The error message only appears when I am resizing the images using Pix2Gallery2.&lt;br&gt;
&lt;br&gt;
All images work ok if I upload them at original size, but so far every image I've tried fails with the above error if I try to resize them on upload.&lt;br&gt;
&lt;/div&gt;</description><author>philhart</author><pubDate>Mon, 19 Jan 2009 02:28:12 GMT</pubDate><guid isPermaLink="false">New Post: Could not load file or assembly 'EXIFextractor, Version=0.9.2.0 20090119022812A</guid></item><item><title>New Post: Could not load file or assembly 'EXIFextractor, Version=0.9.2.0</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=44515</link><description>&lt;div style="line-height: normal;"&gt;I've just installed Pix 2 Gallery 2 since Gallery Remote was again not working on my Windows Vista 64 bit Business.&lt;br&gt;
&lt;br&gt;
I've installed Pix2Gallery2 and logged into my gallery ok, but when I try to upload an image I get the &amp;quot;Unhandled exception&amp;quot;. Details below.&lt;br&gt;
&lt;br&gt;
thanks&lt;br&gt;
Phil&lt;br&gt;
&lt;br&gt;
&lt;br&gt;
&lt;br&gt;
See the end of this message for details on invoking &lt;br&gt;
just-in-time (JIT) debugging instead of this dialog box.&lt;br&gt;
&lt;br&gt;
************** Exception Text **************&lt;br&gt;
System.BadImageFormatException: Could not load file or assembly 'EXIFextractor, Version=0.9.2.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.&lt;br&gt;
File name: 'EXIFextractor, Version=0.9.2.0, Culture=neutral, PublicKeyToken=null'&lt;br&gt;
&amp;nbsp;&amp;nbsp; at Pix2Gallery2.ImageHandler.ResizePicture_ConstantAspectRatio(String filePath, Int32 maxWidth, Int32 maxHeight)&lt;br&gt;
&amp;nbsp;&amp;nbsp; at Pix2Gallery2.UploadForm.ResizePicture(String filePath, Int32 sizeIndex)&lt;br&gt;
&amp;nbsp;&amp;nbsp; at Pix2Gallery2.UploadForm.ThreadedUploadCheckedFiles()&lt;br&gt;
&amp;nbsp;&amp;nbsp; at Pix2Gallery2.UploadForm.buttonUpload_Click(Object sender, EventArgs e)&lt;br&gt;
&amp;nbsp;&amp;nbsp; at System.Windows.Forms.Control.OnClick(EventArgs e)&lt;br&gt;
&amp;nbsp;&amp;nbsp; at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)&lt;br&gt;
&amp;nbsp;&amp;nbsp; at System.Windows.Forms.Control.WmMouseUp(Message&amp;amp; m, MouseButtons button, Int32 clicks)&lt;br&gt;
&amp;nbsp;&amp;nbsp; at System.Windows.Forms.Control.WndProc(Message&amp;amp; m)&lt;br&gt;
&amp;nbsp;&amp;nbsp; at System.Windows.Forms.ButtonBase.WndProc(Message&amp;amp; m)&lt;br&gt;
&amp;nbsp;&amp;nbsp; at System.Windows.Forms.Button.WndProc(Message&amp;amp; m)&lt;br&gt;
&amp;nbsp;&amp;nbsp; at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;amp; m)&lt;br&gt;
&amp;nbsp;&amp;nbsp; at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)&lt;br&gt;
&lt;br&gt;
WRN: Assembly binding logging is turned OFF.&lt;br&gt;
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.&lt;br&gt;
Note: There is some performance penalty associated with assembly bind failure logging.&lt;br&gt;
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].&lt;br&gt;
&lt;br&gt;
&lt;br&gt;
&lt;br&gt;
************** Loaded Assemblies **************&lt;br&gt;
mscorlib&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Assembly Version: 2.0.0.0&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll&lt;br&gt;
----------------------------------------&lt;br&gt;
Pix2Gallery2&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Assembly Version: 0.9.6.0&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Win32 Version: 0.9.6.0&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; CodeBase: file:///C:/Program%20Files%20(x86)/Pix%202%20Gallery%202/Pix2Gallery2.exe&lt;br&gt;
----------------------------------------&lt;br&gt;
System.Windows.Forms&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Assembly Version: 2.0.0.0&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll&lt;br&gt;
----------------------------------------&lt;br&gt;
System&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Assembly Version: 2.0.0.0&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll&lt;br&gt;
----------------------------------------&lt;br&gt;
System.Drawing&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Assembly Version: 2.0.0.0&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll&lt;br&gt;
----------------------------------------&lt;br&gt;
System.Configuration&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Assembly Version: 2.0.0.0&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll&lt;br&gt;
----------------------------------------&lt;br&gt;
System.Xml&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Assembly Version: 2.0.0.0&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll&lt;br&gt;
----------------------------------------&lt;br&gt;
7sgqw_td&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Assembly Version: 0.9.6.0&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll&lt;br&gt;
----------------------------------------&lt;br&gt;
System.Web&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Assembly Version: 2.0.0.0&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; CodeBase: file:///C:/Windows/assembly/GAC_64/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll&lt;br&gt;
----------------------------------------&lt;br&gt;
&lt;br&gt;
************** JIT Debugging **************&lt;br&gt;
To enable just-in-time (JIT) debugging, the .config file for this&lt;br&gt;
application or computer (machine.config) must have the&lt;br&gt;
jitDebugging value set in the system.windows.forms section.&lt;br&gt;
The application must also be compiled with debugging&lt;br&gt;
enabled.&lt;br&gt;
&lt;br&gt;
For example:&lt;br&gt;
&lt;br&gt;
&amp;lt;configuration&amp;gt;&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;system.windows.forms jitDebugging=&amp;quot;true&amp;quot; /&amp;gt;&lt;br&gt;
&amp;lt;/configuration&amp;gt;&lt;br&gt;
&lt;br&gt;
When JIT debugging is enabled, any unhandled exception&lt;br&gt;
will be sent to the JIT debugger registered on the computer&lt;br&gt;
rather than be handled by this dialog box.&lt;br&gt;
&lt;br&gt;
&lt;/div&gt;</description><author>philhart</author><pubDate>Mon, 19 Jan 2009 01:31:50 GMT</pubDate><guid isPermaLink="false">New Post: Could not load file or assembly 'EXIFextractor, Version=0.9.2.0 20090119013150A</guid></item><item><title>New Post: TFS: account does not have permission to connect</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=44303</link><description>&lt;div style="line-height: normal;"&gt;Well, I'm a contributer, but have never really worried about that. I just download the latest source code version, make my changes, upload the patch, and hassle the admin guy to make a new build.&lt;/div&gt;</description><author>Shaggs</author><pubDate>Thu, 15 Jan 2009 20:38:00 GMT</pubDate><guid isPermaLink="false">New Post: TFS: account does not have permission to connect 20090115083800P</guid></item><item><title>New Post: TFS: account does not have permission to connect</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=44303</link><description>&lt;div style="line-height: normal;"&gt;I'm wondering if someone has to be a project contributor to get TFS access.&lt;br&gt;
Currently I got error message &amp;quot;account does not have permission to connect&amp;quot;.&lt;br&gt;
&lt;br&gt;
I'd be grateful for those having TSF access to share their experiences.
&lt;/div&gt;</description><author>vladromanenko</author><pubDate>Thu, 15 Jan 2009 19:00:09 GMT</pubDate><guid isPermaLink="false">New Post: TFS: account does not have permission to connect 20090115070009P</guid></item><item><title>New Post: Uploading from PS6 from a 64bit operating system</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=39138</link><description>&lt;div style="line-height: normal;"&gt;Pix2Gallery2 has a bug when uploading from a Photoshop Elements 6 database on a 64 bit operating system. This is because the SQLite.dll is compiled for 32 bit environments only.&lt;br&gt;
&lt;br&gt;
Fortunatly, there is a workaround:&lt;br&gt;
&lt;br&gt;
1) Download and install Pix2Gallery as per normal.&lt;br&gt;
2) Go to the SQLite webpage (http://sqlite.phxsoftware.com/), navigate to the download page (http://sourceforge.net/project/showfiles.php?group_id=132486&amp;amp;package_id=145568), and download the 1.0.46.0 setup.exe file. Install this.&lt;br&gt;
3) GO into the 64 bit SQLite directory on your HDD (something like C:\Program Files (x86)\SQLite.NET\bin\x64), grab the System.Data.SQLite.DLL file from that directory, and copy it into the pix2gallery2 directory (C:\Program Files (x86)\Pix 2 Gallery 2). It should overwrite the existing version.&lt;br&gt;
&lt;br&gt;
That should solve the problem.
&lt;/div&gt;</description><author>Shaggs</author><pubDate>Tue, 04 Nov 2008 00:18:41 GMT</pubDate><guid isPermaLink="false">New Post: Uploading from PS6 from a 64bit operating system 20081104121841A</guid></item><item><title>New Post: Select Statement in PopulateDtMediaAlbumInfo()</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=35685</link><description>&lt;div style="line-height: normal;"&gt;Ahh ok. I guess I keep using codeplex cause that was the recommended client when I started on this.&lt;br&gt;
&lt;br&gt;
It may take a while for a new build to get made - I dont build the releases - another guy (Ted) does that.&lt;br&gt;
&lt;/div&gt;</description><author>Shaggs</author><pubDate>Tue, 16 Sep 2008 21:52:45 GMT</pubDate><guid isPermaLink="false">New Post: Select Statement in PopulateDtMediaAlbumInfo() 20080916095245P</guid></item><item><title>New Post: Select Statement in PopulateDtMediaAlbumInfo()</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=35685</link><description>&lt;div style="line-height: normal;"&gt;Thanks for the info.&amp;nbsp; I notice that the codeplex client you reference is no longer being supported and it was suggested using the Tortoisesvn client&amp;nbsp; which I am trying with Visualsvn.&amp;nbsp; I have uploaded the simple patch to the select clause as a test (and discovered that I had referenced the wrong select in my first post- should be the one at line 668 not 683).&amp;nbsp; I mistakenly thought that the &amp;quot;Add&amp;quot; button next to the Workitem dialog box was to add a second&amp;nbsp; reference there, so I didn't reference that correctly.&amp;nbsp; &lt;br&gt;
&lt;br&gt;
Please let me know if there are any problems before I attempt the more involved patches.&lt;br&gt;
Thanks.&lt;br&gt;
&lt;/div&gt;</description><author>winful</author><pubDate>Tue, 16 Sep 2008 18:45:56 GMT</pubDate><guid isPermaLink="false">New Post: Select Statement in PopulateDtMediaAlbumInfo() 20080916064556P</guid></item><item><title>New Post: Dealing with Smart Albums in PSE6</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=35694</link><description>&lt;div style="line-height: normal;"&gt;Great. I'm thinking after all these changes, it is probably best you make the patch yourself. I'm looking forward to using these fixes/features now.&lt;br&gt;
&lt;br&gt;
-- Edited (Google Chrome made a mess of my origianl reply) --&lt;br&gt;
&lt;/div&gt;</description><author>Shaggs</author><pubDate>Mon, 15 Sep 2008 22:31:16 GMT</pubDate><guid isPermaLink="false">New Post: Dealing with Smart Albums in PSE6 20080915103116P</guid></item><item><title>New Post: Select Statement in PopulateDtMediaAlbumInfo()</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=35685</link><description>&lt;div style="line-height: normal;"&gt;Hi again,$0$0$0$0Well, as your curring doing more development on this then I am, it may be easier if you join the project and do a patch yourself. The basic steps for this are:$0$01) Join project (I'm not 100% sure this is necessary though). I have asked the project head guy to auth you if you try.$0$02) Install the codeplex client (http://www.codeplex.com/CodePlexClient)$0$03) Download the Pix2Gallery2 project via codeplex (I think the command is &lt;span style="font-family:'Courier New';font-size:13px;white-space:pre"&gt;cpc checkout Pix2Gallery2)&lt;span style="font-family:'Times New Roman';font-size:16px;white-space:normal"&gt; . Further instructions for this can be found at &lt;a href="http://www.codeplex.com/CodePlexClient/Wiki/View.aspx?title=Workflow&amp;referringTitle=Home"&gt;http://www.codeplex.com/CodePlexClient/Wiki/View.aspx?title=Workflow&amp;amp;referringTitle=Home&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;$0$04) Modify/add files in visual studio$0$05) Use the &amp;quot;&lt;span style="font-family:'Segoe UI';font-size:13px"&gt;cpc syncup&amp;quot; &lt;/span&gt;command so codeplex can find your new/modified files. (this is outlined on this page - &lt;a href="http://www.codeplex.com/CodePlexClient/Wiki/View.aspx?title=HowToContribute&amp;referringTitle=Home"&gt;http://www.codeplex.com/CodePlexClient/Wiki/View.aspx?title=HowToContribute&amp;amp;referringTitle=Home)&lt;/a&gt;$0$06) Use the makepatch command to create the patch (&lt;span style="font-family:'Courier New';font-size:13px;white-space:pre"&gt;cpc makepatch C:\MyPatch.xml&lt;span style="font-family:'Times New Roman';font-size:16px;white-space:normal"&gt;).&lt;/span&gt;&lt;/span&gt;$0$07) Upload patch.$0$0$0$0$0I'm glad someone else has taken an interest updating Pix2Gallery2 (PSE component), as work/study commitments leaves me with little time for this at the moment).$0&lt;/div&gt;</description><author>Shaggs</author><pubDate>Mon, 15 Sep 2008 22:26:19 GMT</pubDate><guid isPermaLink="false">New Post: Select Statement in PopulateDtMediaAlbumInfo() 20080915102619P</guid></item><item><title>New Post: Gallery2 Upload permissions</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=35699</link><description>&lt;div style="line-height: normal;"&gt;My gallery2 users can have their own album(s) so their uploads would have to hang off their &amp;quot;root&amp;quot; gallery, not the Gallery root.&lt;br&gt;
&lt;br&gt;
&amp;nbsp;I am trying to figure out how to implement this.&amp;nbsp; The Gallery2Interface currently does not support a starting location per user and I see that the gallery command version which shows only paths available to a user based on their permissions&amp;nbsp; (fetch-albums-prune) has been commented out&amp;nbsp; in favor of the more general &amp;quot;fetch-albums).&amp;nbsp; &lt;br&gt;
&lt;br&gt;
Any insight into how to approach this would be greatly appreciated.&lt;br&gt;
&lt;/div&gt;</description><author>winful</author><pubDate>Mon, 15 Sep 2008 18:17:58 GMT</pubDate><guid isPermaLink="false">New Post: Gallery2 Upload permissions 20080915061758P</guid></item><item><title>New Post: Dealing with Smart Albums in PSE6</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=35694</link><description>&lt;div style="line-height: normal;"&gt;I like the idea of the &amp;quot;Last 6 Months &amp;quot; Smart Album In PSE6 but the time frame is too long for me.&amp;nbsp; I see where you can change the name of this &amp;quot;Album&amp;quot; but not where one can change the select that creates it.&amp;nbsp; I Know I can create a smart album in PSE6 to Select, for example the &amp;quot;Last 6 Days&amp;quot; but I don't know how to parse the blob that holds the info about the select.&amp;nbsp; As a compromise, my intent is to populate the &amp;quot;Last 6 Months&amp;quot; album in P2G2 and then add a filter in the UI to let the user set the time frame for the upload.&lt;br&gt;
&lt;br&gt;
The first part I have done by executing a second select on the catalog.psedb and appending the resulting datatable&amp;nbsp; to the one created from&amp;nbsp; primary select in PopulateDtMediaAlbumInfo() (Which I have also modified to include the &amp;quot;search_date_begin&amp;quot; field-&amp;nbsp; see my previous post) before populating the tree and checking for previous upload.&amp;nbsp;&amp;nbsp; &lt;br&gt;
First, I initialized more variables near the top of PopulateCollectionTree(&lt;br&gt;
&amp;nbsp;&lt;strong&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; intHiddenTagId = GetTagId(strTNHidden, strTagTypeNameHidden);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; intRatingMetadataId = getMetadataId(strRatingMetadataIdentifier);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; intNotesMetadataid = getMetadataId(strNotesMetadataIdentifier);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; intCaptionMetadataId = getMetadataId(strCaptionMetadataIdentifier);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; intSmartCollTopLevelId = GetTagId(strTNSmartColl, 0);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; intSmartCollFirstLevelId = GetTagId(intSmartCollTopLevelId, 0);// the &amp;quot;Last 6 Months&amp;quot; node&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; /*&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 20080912 wcf Note that the name &amp;quot;Last 6 Months&amp;quot; can be changed in PSE6, but I don't see anywhere to change the Select that creates it&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; so I have left the treatment here to 6 months&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; */&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; intCollTopLevelId = GetTagId(strTNColl, 0);&lt;/strong&gt;&lt;br&gt;
&amp;nbsp;&lt;br&gt;
&lt;br&gt;
ThenI added this procedure (mostly from the P2G2 distro)&lt;br&gt;
&lt;br&gt;
&amp;nbsp;&lt;strong&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; public void GetMostRecentAlbum(ref DataTable dtMostRecent)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; //20080906 wcf Add itemt to the smart album Last 6 Months, then in form, allow user to filter that&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; string strEarliestDate = DateTime.Now.AddMonths(-6).ToString(&amp;quot;yyyyMMdd&amp;quot;) + &amp;quot;T000000&amp;quot;;&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; string sqlStatement = string.Format(&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;SELECT distinct mt.id as id, filename_search_index, volume_id, media_id, {0} as tag_id, 0 as media_index,&amp;nbsp; 'Last 6 Months' as name, 'smartcollect' as type_name, &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;(select&amp;nbsp; drive_path_if_builtin as drive_location from volume_table where id = mt.volume_id AND drive_path_if_builtin &amp;gt; ''&amp;nbsp; union select&amp;nbsp; serial || '/' as drive_location from volume_table where id = mt.volume_id AND drive_path_if_builtin = '' &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;) || mt.full_filepath as location, &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;( SELECT metadata_integer_table.value FROM media_to_metadata_table INNER JOIN metadata_integer_table ON media_to_metadata_table.metadata_id = metadata_integer_table.id WHERE media_to_metadata_table.media_id = mt.id AND metadata_integer_table.description_id = {1}) as rating , &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;(SELECT mst.value FROM media_to_metadata_table&amp;nbsp; mtm INNER JOIN metadata_string_table mst ON mtm.metadata_id=mst.id WHERE mtm.media_id = mt.id AND mst.description_id = {2}) as notes, &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;(SELECT mst.value FROM media_to_metadata_table&amp;nbsp; mtm INNER JOIN metadata_string_table mst ON mtm.metadata_id=mst.id WHERE mtm.media_id = mt.id AND mst.description_id = {3}) as caption, search_date_begin &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;FROM media_table mt&amp;nbsp; &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;INNER JOIN tag_to_media_table t2m on mt.id=t2m.media_id &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;INNER JOIN tag_table tt on t2m.tag_id=tt.id &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;where (tt.type_name = 'collection'&amp;nbsp; &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;OR tt.type_name = 'user'&amp;nbsp; &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;OR tt.type_name = 'collection_ns'&amp;nbsp; &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;OR tt.type_name like 'user_p%'&amp;nbsp; &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;OR tt.type_name like 'user_event%'&amp;nbsp; &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;OR tt.type_name like 'user_misc%'&amp;nbsp; &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;OR tt.type_name = 'smartcollect' ) &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;AND (SELECT&amp;nbsp; media_id FROM tag_to_media_table WHERE&amp;nbsp; media_id = mt.id&amp;nbsp; AND tag_id = {4}) is null&amp;nbsp; &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;AND ((SELECT media_index&amp;nbsp; FROM version_stack_to_media_table WHERE media_id = mt.id) is&amp;nbsp; null OR &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;(SELECT media_index&amp;nbsp; FROM version_stack_to_media_table WHERE media_id = mt.id) = 0) &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;AND mt.search_date_begin &amp;gt; '{5}' &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;order by mt.search_date_begin desc&amp;quot;, intSmartCollFirstLevelId, intRatingMetadataId, intNotesMetadataid, intCaptionMetadataId, intHiddenTagId, strEarliestDate);&lt;br&gt;
&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; try&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SQLiteDataAdapter daAlbumImage = new SQLiteDataAdapter(sqlStatement, PSEConn);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; daAlbumImage.Fill(dtMostRecent);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; catch (Exception exc)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; MessageBox.Show(&amp;quot;Error while excecuting SQL statement: &amp;quot; + sqlStatement +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot;&amp;nbsp; Exception: &amp;quot; + exc.Message);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Trace.WriteLine(&amp;quot;Error in PopulateMostRecentAlbum while excecuting SQL Statement: &amp;gt;&amp;quot; + sqlStatement + &amp;quot;&amp;lt; &amp;quot; +&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;quot; Exception: &amp;quot; + exc.Message);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br&gt;
&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;/strong&gt;&lt;br&gt;
&lt;br&gt;
Finally , just before the line :&lt;br&gt;
&lt;strong&gt;&amp;nbsp;int albumImageCount = dtAlbumImage.Rows.Count;&lt;/strong&gt;&lt;br&gt;
&amp;nbsp;in PopulateDtMediaAlbumInfo()&lt;br&gt;
&lt;br&gt;
I added this:&lt;br&gt;
&lt;strong&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; //////////20080911 wcf&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DataTable dtMostRecent = new DataTable();&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; GetMostRecentAlbum(ref dtMostRecent);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; // DataTable dtAlbumImage = new DataTable();&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; foreach (DataRow rows in dtMostRecent.Rows)&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; dtAlbumImage.NewRow();&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; dtAlbumImage.ImportRow(rows);&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ////////////&lt;/strong&gt;&lt;br&gt;
&lt;br&gt;
And the &amp;quot;Last 6 Months&amp;quot; album seems to work like the rest.&lt;br&gt;
&lt;br&gt;
&lt;/div&gt;</description><author>winful</author><pubDate>Mon, 15 Sep 2008 17:41:48 GMT</pubDate><guid isPermaLink="false">New Post: Dealing with Smart Albums in PSE6 20080915054148P</guid></item><item><title>New Post: Select Statement in PopulateDtMediaAlbumInfo()</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=35685</link><description>&lt;div style="line-height: normal;"&gt;I had considered trying to write an interface between PSE and Gallery2 and was so pleased to find Pix2Gallery2.&amp;nbsp; Thanks so much for the great work!&lt;br&gt;
I previously posted a suggested change to the select statement to find all albums and have read your (Shaggs) comment.&amp;nbsp; I am afraid I don't know how to upload a patch, but if you can point me to a How To I will attempt to do so ( ir you can make the simple change required).&lt;br&gt;
&lt;br&gt;
This post has to do with the Select used to read all of the media info.&lt;br&gt;
The Select in the distro returns about 65000 lines from my catalog.psedb including many entries which are unwanted because they are hidden or not the selected item in a version set or they refer to an upload event.&amp;nbsp; The following select returns only the lines we are interested in (34000 lines in my case), including the correct drive id (or URI if the files are on a shared network drive).&lt;br&gt;
&lt;br&gt;
&lt;strong&gt;SELECT mt.id, mt.filename_search_index, mt.volume_id, t2m.media_id, t2m.tag_id, t2m.media_index, tt.name, tt.type_name,&lt;br&gt;
(select&amp;nbsp; drive_path_if_builtin as drive_location from volume_table where id = mt.volume_id AND drive_path_if_builtin &amp;gt; ''&amp;nbsp; union select&amp;nbsp; serial || '/' as drive_location from volume_table where id = mt.volume_id AND drive_path_if_builtin = ''&lt;br&gt;
) || mt.full_filepath as location,&lt;br&gt;
( SELECT metadata_integer_table.value FROM media_to_metadata_table INNER JOIN metadata_integer_table ON media_to_metadata_table.metadata_id = metadata_integer_table.id WHERE media_to_metadata_table.media_id = mt.id AND metadata_integer_table.description_id = 91634) as rating ,&lt;br&gt;
(SELECT mst.value FROM media_to_metadata_table&amp;nbsp; mtm INNER JOIN metadata_string_table mst ON mtm.metadata_id=mst.id WHERE mtm.media_id = mt.id AND mst.description_id = 91633) as notes,&lt;br&gt;
(SELECT mst.value FROM media_to_metadata_table&amp;nbsp; mtm INNER JOIN metadata_string_table mst ON mtm.metadata_id=mst.id WHERE mtm.media_id = mt.id AND mst.description_id = 9963) as caption,mt.search_date_begin&lt;br&gt;
FROM media_table mt &lt;br&gt;
INNER JOIN tag_to_media_table t2m on mt.id=t2m.media_id&lt;br&gt;
INNER JOIN tag_table tt on t2m.tag_id=tt.id&lt;br&gt;
where (tt.type_name = 'collection' &lt;br&gt;
OR tt.type_name = 'user' &lt;br&gt;
OR tt.type_name = 'collection_ns' &lt;br&gt;
OR tt.type_name like 'user_p%' &lt;br&gt;
OR tt.type_name like 'user_event%' &lt;br&gt;
OR tt.type_name like 'user_misc%' &lt;br&gt;
OR tt.type_name = 'smartcollect' )&lt;br&gt;
AND (SELECT&amp;nbsp; media_id FROM tag_to_media_table WHERE&amp;nbsp; media_id = mt.id&amp;nbsp; AND tag_id = 20) is null &lt;br&gt;
AND ((SELECT media_index&amp;nbsp; FROM version_stack_to_media_table WHERE media_id = mt.id) is&amp;nbsp; null OR&lt;br&gt;
(SELECT media_index&amp;nbsp; FROM version_stack_to_media_table WHERE media_id = mt.id) = 0)&lt;br&gt;
order by tag_id, media_index&lt;/strong&gt;&lt;br&gt;
&lt;br&gt;
This allows some serious&amp;nbsp; simplification of the code in PSE6Interface.cs&lt;br&gt;
&lt;br&gt;
&lt;/div&gt;</description><author>winful</author><pubDate>Mon, 15 Sep 2008 15:46:58 GMT</pubDate><guid isPermaLink="false">New Post: Select Statement in PopulateDtMediaAlbumInfo() 20080915034658P</guid></item><item><title>New Post: Possibility of supporting .png uploads?</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=34782</link><description>&lt;div style="line-height: normal;"&gt;I think the discussion name says it all ;)&lt;br&gt;
&lt;/div&gt;</description><author>calyx</author><pubDate>Tue, 02 Sep 2008 22:29:18 GMT</pubDate><guid isPermaLink="false">New Post: Possibility of supporting .png uploads? 20080902102918P</guid></item><item><title>New Post: Vote for Elements friendly API</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=11069</link><description>&lt;div style="line-height: normal;"&gt;Alexei,&lt;br&gt;
&lt;br&gt;
I must say I am impressed. With a 4 your old kid, you still find the time to play with 4 different apps to manage your photos!&lt;br&gt;
&lt;br&gt;
I should stress, that currently the whole PSE -&amp;gt; Gallery2 functionality does not work the way I want it to - I am quite limited by the differences in the way each organises photos, and the limitations of the Gallery2 API. As the Gallery2 API improves, so shall the synching functionality. Keep in mind that Pix2Gallery2 is designed to work both locally and remotely. So while you have local access to your Gallery2 installation and can do all sorts of stuff, we are assuming that the user doesnt have local access to Gallery2, and henced are limited to what the API can do.&lt;br&gt;
&lt;br&gt;
A few years back I developed a dynamic website which was exactly what I wanted (written in php, with a mysql backend, which automatically synched itself with photoshop elements). The problem with it was that it was as ugly as hell, it was difficult to maintain, and most people could not work out how to use the tags (which was my sole method of organising photos at the time). While I thought it was fantastic that I could search for any combination of person/place/event on the website, most people didnt see the point - they just wanted to look at the photos from christmas day, or grandma's birthday. This is why I switch over to using Collections/Albums in PSE, and Gallery2 - it is easier to maintain, and the layout/usage of the website closely matches how family and friends expect it to be.&lt;br&gt;
&lt;br&gt;
Yes, I am aware of the tags module (this discussion was created in order to encourage people to vote for an API for it). I'm also aware that tags can be populated via exif information (rorrison also pointed this out), and I'm toying with the idea using this to upload tags, should the tag API not arrive, and I find the time to implement it. (I dont want to globally write tags to my photo's via photoshop).&lt;br&gt;
&lt;/div&gt;</description><author>Shaggs</author><pubDate>Sat, 21 Jun 2008 23:50:20 GMT</pubDate><guid isPermaLink="false">New Post: Vote for Elements friendly API 20080621115020P</guid></item><item><title>New Post: Vote for Elements friendly API</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=11069</link><description>&lt;div style="line-height: normal;"&gt;Hi Shanon,&lt;br&gt;
Thanks for writing back.&lt;br&gt;
The way that you categorize/arrange your pictures into albums is interesting.&amp;nbsp; I have seen that before, but I never really considered doing it that way.&amp;nbsp; I will think about putting my pictures into albums that way.&lt;br&gt;
&lt;br&gt;
I really like not having to depend on any one app for their method of organizing/categorizing pictures/albums.&amp;nbsp; I like to use the best software for each type of stuff, this often leads to me using multiple sw pkgs, ie. PictureProject for rotating pictures, Picasa for separating pictures into new albums/folders, and Photoshop Elements Express 6 for tagging, and Gallery2 for posting pictures online. &lt;br&gt;
&lt;br&gt;
I having not found one sw package that does everything well enough.&amp;nbsp; Since the different sw packages don't read the db/catalog of other applications, I want to store all of the info in the pictures and folders themselves.&amp;nbsp; This way, it's more available to me via the filesystem and exif data.&lt;br&gt;
&lt;br&gt;
So, I guess I'm still figuring out how I want to handle creating albums and getting Gallery2 to import the albums and pictures with the tags, descriptions that go along with the folders/albums.&amp;nbsp; I like the Gallery2 &amp;quot;From Local Server&amp;quot; import coupled with exif/iptc module for the pictures.&amp;nbsp; However, it is lacking for importing/creating albums, or at least I haven't found a way that I like.&lt;br&gt;
&lt;br&gt;
Also, have you discovered the tags plugin in Gallery2.&amp;nbsp; It's new to me and I just implemented it and I like it.&amp;nbsp; I made a post about it at: &lt;a href="http://gallery.menalto.com/node/60370"&gt;http://gallery.menalto.com/node/60370&lt;/a&gt;&lt;br&gt;
The plugin details are at &lt;a href="http://codex.gallery2.org/Gallery2:Modules:tags" rel=nofollow&gt;http://codex.gallery2.org/Gallery2:Modules:tags&lt;/a&gt;&lt;br&gt;
&lt;br&gt;
Thanks for your feedback, and if you discover a way to import/create album details while importing, or synchronizing albums and/or picures/videos please feel free to post here or email me at alexei2001@yahoo.com.&lt;br&gt;
Good luck with your projects.&lt;br&gt;
&lt;br&gt;
&lt;br&gt;
&lt;br&gt;
&lt;/div&gt;</description><author>alexei2001</author><pubDate>Sat, 21 Jun 2008 18:38:59 GMT</pubDate><guid isPermaLink="false">New Post: Vote for Elements friendly API 20080621063859P</guid></item><item><title>New Post: Vote for Elements friendly API</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=11069</link><description>&lt;div style="line-height: normal;"&gt;alexei2001,&lt;br&gt;
&lt;br&gt;
Firstly, thanks for the feedback. &lt;br&gt;
&lt;br&gt;
I feel your frustration. The limitations of the Gallery2 API, and the differences in the structure of Gallery2 and Photoshop Elements (PSE), means that synching between PSE and Gallery2 is not perfect. I have changed the way I use PSE to suit the limitations. (before I started synching with Gallery2, I never used the collections/albums functionality - I only use tags).&lt;br&gt;
&lt;br&gt;
If I am correct, you saying you want to upload all these details (Name, Title, summary, keywords, etc) against a whole album (not the indivdiual photos). To tell the truth, I never thought about that. I guess it might be possible to upload the &amp;quot;Notes&amp;quot; that are associated with with an album (if you click on &amp;quot;Edit Album&amp;quot; in PSE6). I suspect the Gallery2 API does not allow this though. Also, i cant see myself adding functionality which looks at an additional file though (like an .ini file) outside of photoshop elements for this information however.&lt;br&gt;
&lt;br&gt;
The API does not allow me to select a name for a new album - only the caption. (I forget the finer points of it offhand). So you getting &amp;quot;Album&amp;quot; is what Gallery populates by default.&lt;br&gt;
&lt;br&gt;
Yes, your filenames end up being removed and replaced by a number. I do this on purpose. The number used is actually the picture ID inside PSE. I use this to prevent the same photo being uploaded twice (It checks if another photo with that filename already exists).&lt;br&gt;
&lt;br&gt;
I'm not quite sure what you intend on doing with the exif module and pixasa.ini. The exif information wont help get your album details into Gallery2, as exif data is stored against a specific photo. And to my knowledge, the Gallery2 API has very limited functionality to populate this information for albums.&lt;br&gt;
&lt;br&gt;
Hmmmm. This hasnt been a very helpful post - I have just explained why nothing will work the way you want it too.&lt;br&gt;
&lt;br&gt;
Like I said before, I have changed how I use PSE to suit the limitations of synching to Gallery2. Nowdays I:&lt;br&gt;
1) Make heavy use of tags (even though I dont upload them to Gallery2 at the moment, I am sure I will in time)&lt;br&gt;
2) Use Albums/collections exentensivly, as this is the only way I am able to effectivly catagorize pictures in Gallery2. I'll create an Album Group for each year (2006, 2007, etc) and put &amp;quot;Dads Birthday&amp;quot; &amp;quot;Christmas&amp;quot; etc as events within it. This makes it easy to upload a specific event to my Gallery2 site, and send links to those who might be interested.&lt;br&gt;
3) Make use of the &amp;quot;Ratings&amp;quot; system in PSE. I dont necessarily want to upload every photo, so I will tag the favourates with 5 stars, and leave the rest at zero starts. Then when uploading, I only upload the five stars.&lt;br&gt;
4) Caption photos. This is a pain I know, but until I get decent tag API (I dont want to put them in the exif information of my photos), it is the best way for me.&lt;br&gt;
&lt;br&gt;
Hope this helps a bit. Feel free to ask more questions...&lt;br&gt;
&lt;br&gt;
Shanon.&lt;br&gt;
&lt;/div&gt;</description><author>Shaggs</author><pubDate>Sat, 21 Jun 2008 07:42:07 GMT</pubDate><guid isPermaLink="false">New Post: Vote for Elements friendly API 20080621074207A</guid></item><item><title>New Post: Vote for Elements friendly API</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=11069</link><description>&lt;div style="line-height: normal;"&gt;Hi,&lt;br&gt;
I'm hoping to use the Pix2Gallery2 utility in conjunction with the Exif plugin.&amp;nbsp; In Photoshop Elements 6, I tag pictures and then use the File-&amp;gt;Save tags to files command to write the tags as exif keywords to the EXIF data.&lt;br&gt;
The only thing that I can't put in the jpeg file is the album name.&amp;nbsp; I was using Picasa to create folders for for albums.&amp;nbsp; I also put a description in Picasa for the folder/album.&amp;nbsp; This is saved into a picasa.ini file in the directory.&lt;br&gt;
&lt;br&gt;
So, I'm looking for a way to save the following album settings in a file, Picasa.ini file, Photoshop Elements album, or another spot, so that it will be put in the correct Gallery2 fields when the album is uploaded.&lt;br&gt;
Name&lt;br&gt;
Title&lt;br&gt;
Summary&lt;br&gt;
Keywords&lt;br&gt;
Description&lt;br&gt;
Album date and time&lt;br&gt;
&lt;br&gt;
Pix2Gallery2 populates the Title of the Album in Gallery2 for me, the way that I like.&amp;nbsp; However, it chose &amp;quot;album&amp;quot; for the album Name field.&lt;br&gt;
Also, my filenames are not being kept for the Gallery2 name for the picture.&amp;nbsp; I get filenames like 19277.JPG instead of my Img2008-02-10_20-15-54.JPG filename.&lt;br&gt;
I see that there are settings that I can change for the Elements 6.0 Pix 2 Gallery2 (Beta) 0.9.5.0, but these settings don't match the settings in the Exif module.&lt;br&gt;
&lt;br&gt;
Any ideas on how to achieve putting the album settings into Gallery2?&lt;br&gt;
&lt;br&gt;
One thing that complicates things is that I have about 20,000 pictures.&amp;nbsp; I have busy in the last 4 years since the birth of my son. :-)&lt;br&gt;
On the plus side, I have everything setup on my own pc.&lt;br&gt;
You can check my gallery out at &lt;a href="http://alexei.idleplay.net/gallery/main.php"&gt;http://alexei.idleplay.net/gallery/main.php&lt;/a&gt;&lt;br&gt;
&lt;br&gt;
I'm tempted to hack the exif module to look at the picasa.ini file to get the album settings from this file, but I don't know PHP well enough.&amp;nbsp; And I would love the ability to synchronize albums on my pc with albums in Gallery2.&lt;br&gt;
&lt;br&gt;
I would love any feedback.&lt;br&gt;
Thanks,&lt;br&gt;
-Alexei&lt;br&gt;
&lt;br&gt;
&lt;/div&gt;</description><author>alexei2001</author><pubDate>Sat, 21 Jun 2008 04:00:38 GMT</pubDate><guid isPermaLink="false">New Post: Vote for Elements friendly API 20080621040038A</guid></item><item><title>NEW POST: Vote for Elements friendly API</title><link>http://www.codeplex.com/pix2gallery2/Thread/View.aspx?ThreadId=11069</link><description>&lt;div style="line-height: normal;"&gt;Thanks. I was actually aware of this work around, but I dont use it myself, as it doesnt offer the control I wanted. For most photos in PSE, I have people, places and event tags on them. But when I upload, I only really want the people tags going up.&lt;br&gt;
&lt;br&gt;
Pix2Gallery2 cant make PSE do anything (it isnt a plugin - it just reads the PSE database). What it could do, however, is write the tags to the IPTC keywords field for you. That is, before uploading a photo, make a copy somewhere, edit the photo (add tags to IPTC keywords of photo), and then upload this copy. This would have the advantage of being able to decide what keywords get uploaded.&lt;br&gt;
&lt;br&gt;
I didnt do this though, as I thought the Gallery2 team must be about to add keyword API functionality that I can use (I had read a few posts on the gallery2 forum which suggested this), so I thought I'd wait. From my original post (above), you can see that was about a year ago. I think I might accept the fact that it isnt going to happen, and write in a work around (sometime soonish).&lt;br&gt;
&lt;br&gt;
Thanks for your feedback - its nice to know that I'm not the only one using the PSE functionality in Pix2Gallery2.&lt;br&gt;
&lt;/div&gt;</description><author>Shaggs</author><pubDate>Sun, 18 May 2008 22:10:52 GMT</pubDate><guid isPermaLink="false">NEW POST: Vote for Elements friendly API 20080518101052P</guid></item></channel></rss>