Hey there,
I was wondering if it was possible to import the picasa face recognition into tags without importing the pics again?
Piwigo version: 2.6.1
PHP version: 5.4.24
MySQL version: 5.5.36
Offline
Hello,
It is not possible with Picasa2Piwigo.
If you:
1. have direct access to the piwigo database and
2. your photos are laid out in Piwigo using the same directory structure you use in Picasa
Then you can run this extension: Google Picasa Face Tag Extraction To Piwigo
That will update the tags in Piwigo without uploading the photos. Oh, I haven't tried the extension with version 2.6.x of Piwigo. I'll try to do that...
Good Luck,
KenL
Offline
I appreciate the quick reply. I'll give this a try when i get home, thank you.
Offline
It didn't work threw an error:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
MySql.Data.MySqlClient.MySqlException: Table 'MYDB.piwigo__config' doesn't exist <--*** looks like it is adding an extra _ for the prefix_config table -->
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at PicasaFindMyPhotos.Form1.GetPiwigoDBVersion(DBConnect PiwigoDBConn, String piwigo_table_prefix)
at PicasaFindMyPhotos.Form1.ExecuteBtn_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.6413 (Win8RTMGDR.050727-6400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
Picasa Face Tag Extraction
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Ken/Picasa%20Face%20Tag%20Extraction.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.6402 (Win8RTMGDR.050727-6400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.6401 (Win8RTMGDR.050727-6400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.6401 (Win8RTMGDR.050727-6400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.6411 (Win8RTMGDR.050727-6400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.6411 (Win8RTMGDR.050727-6400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
MySql.Data
Assembly Version: 6.5.5.0
Win32 Version: 6.5.5.0
CodeBase: file:///C:/Program%20Files%20(x86)/Ken/Picasa%20Face%20Tag%20Extraction/MySql.Data.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.6387 (Win8RTM.050727-6300)
CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.6387 (Win8RTM.050727-6300)
CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.6387 (Win8RTM.050727-6300)
CodeBase: file:///C:/Windows/assembly/GAC_64/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Offline
Thanks for the info. Like I said in the earlier post, I haven't tried the tool with version 2.6.x (or version 2.5.x for that matter). I'll try to get to it tonight.
KenL
Offline
So i changed the prefix to piwigo w/o the '_' under Database Table Prefix
It gave me a warning about the version, i said yes to do it anyway
[backed up my db before, no one wants to screw up a site with 5k pics]
It started processing all of the tags, fail.
Changed the path to root [/piwigo] instead of /piwigo/uploads, ran it again, processing folders, fail
I think it has something to do with which path to set or apply the tags in picasa. It looks like Piwigo stores:
Originals in: /public_html/piwigo/upload
Generated la/me/sq/th/xl/xx/sm/etc... in: /public_html/piwigo/_data/i/upload
Maybe I'm way off base.
Offline
I looked at your example again and noticed that you set it to P:\2010
So I mapped a drive to the directory, making sure the sub-folders read as 2010,2011, etc..
Set the root path to Z:\ [in my case], processing, fail
tried Z:\2014, fail
that's all I got.
Offline
Hello,
I tried the tool and it worked ok with Piwigo 2.6.1. I think you have the database settings correct now.
So:
1. is the tool reading faces ok? If you clear the "Set Tags in Piwigo" checkbox and run the tool, does it report that face tags are found?
2. Do you think the directory layout is the same between the folders that picasa uses and the categories in piwigo?
KenL
Offline
If i clear the set tags, will it clear all tags I already have on the site?
Offline
Picasa is set to scan the Z: drive, which is /public_html/piwigo/uploads
App is set to Z: drive
Offline