| Author |
Message |
| Registered: March 13, 2007 |  Posts: 88 |
| | Posted: | | | | Quote:
One of you will have to send me a backup. And if it's that database with just a single profile, that would be awesome! But a full backup (minus photos) is fine too. Here you can download my demo database: Quote:
I made a database with just one profile: MarieAntoinette. That one profile has custom genre Historiallinen. If genre is removed, Database Query works.. It is just 57 kB. |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 3,321 |
| | Posted: | | | | Thanks for that. The problem is fixed, but genres are still off. I'll upload a fixed version very soon. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | Ok, the new version 2.4 has no genre issues I can find. I should have changed the version number, but didn't. So if you got it before this message, grab the latest and try again. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: May 19, 2007 | Reputation:  |  Posts: 6,730 |
| | Posted: | | | | The problem with the genres is fixed!  Thanks. Still get this "Invalid OleAut-Date"-message. Any idea what might cause this?? I think it might be more a problem of my database than of your plugin. | | | It all seems so stupid, it makes me want to give up!
But why should I give up, when it all seems so stupid?
Registrant since 05/22/2003 | | | | Last edited: by Lewis_Prothero |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | Glad to hear genres are working now. As for your other issue, if you'd like, send me a backup without photos and I'd be happy to see if there's a problem on my end. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: December 13, 2008 | Reputation:  |  Posts: 334 |
| | Posted: | | | | I had the same problem with genres. All fixed now. Thanks a lot Mark! |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | Quoting Mallrat: Quote:
I had the same problem with genres. All fixed now. Thanks a lot Mark! Glad to hear it.  | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | I got bored yesterday and added a new feature I've been thinking of since day 1. So version 2.5 is now available for downloading. This version adds a new tab to the Options screen (scroll all the way to the right to find it). It's the Accepted Birth Years tab and comes pre-loaded with the full list of accepted birth years from the List of Accepted Birth Years with Documentation thread. Thanks to TheMadMartian for maintaining this list. The queries on Birth Year for the Cast & Crew now allow you to filter out any results where the person is listed in the thread mentioned above. There are 3 ways to keep this list updated. First, you can do so manually. Scroll to the bottom of the list and on the last row (which is blank) and you can start entering whatever data you want. You can also highlight a row or rows and right click to delete. Second, you can right-click and choose Reset Default Data to reload the data that comes shipped with this version of the plug-in. Finally, you can right-click and choose Read Data from Invelos. This is the recommended way to keep this list up-to-date. It will read the thread listed above and strip all the data from page one and enter it for you. It does NOT read the items highlighted in red. If you want those included, you'll have to enter them manually after grabbing the main list from the thread above. Hope others find it helpful. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: May 19, 2007 | | Reputation: | | Posts: 6,730 |
| | Posted: | | | | Yupp, find it helpful. Thanks a lot! | | | It all seems so stupid, it makes me want to give up!
But why should I give up, when it all seems so stupid?
Registrant since 05/22/2003 |
|
| Registered: May 26, 2007 | | Reputation: | | Posts: 599 |
| | Posted: | | | | Quoting Mark Harrison: Quote:
So version 2.5 is now available for downloading.
The zip file says 2.4, is this an oversight? | | | | Last edited: by Antares |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | Quoting Antares: Quote:
Quoting Mark Harrison:
Quote:
So version 2.5 is now available for downloading.
The zip file says 2.4, is this an oversight? That isn't right. My website shows 2.5, the zip file is labeled 2.5, the readme in the file is 2.5, the program sees the plug-in as 2.5. Maybe your cache needs cleared or something. Or I'm just missing the 2.4 you're seeing.  | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: May 26, 2007 | | Reputation: | | Posts: 599 |
| | Posted: | | | | Quoting Mark Harrison: Quote:
Maybe your cache needs cleared or something. That's what it was. |
|
 | Muckl | | That's my common name. |
| Registered: April 9, 2009 | | Reputation: | | Posts: 858 |
| | Posted: | | | | Quoting Mark Harrison: Quote:
The queries on Birth Year for the Cast & Crew now allow you to filter out any results where the person is listed in the thread mentioned above. This is awesome, thanks a lot!  But one question: if "Ignore Accepted Birth Years" is checked, I get 265 rows – if not, I get only 152 rows. Shouldn't it be the other way round?  | | |
 1.0.1, iPhone 3GS, iOS 4.1.0
Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff | | | | Last edited: by Muckl |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,372 |
| | Posted: | | | | Mark, you rock. Thanks!!!!!! |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | Quoting Muckl: Quote:
But one question: if "Ignore Accepted Birth Years" is checked, I get 265 rows – if not, I get only 152 rows. Shouldn't it be the other way round? I guess it depends on how you read it. The way I see it is if you check the box that says "Ignore Accepted Birth Years", then it won't filter any of those out. I would expect you would get 265. I agree that the wording isn't ideal, but it's working and that's the important part.  | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Muckl | | That's my common name. |
| Registered: April 9, 2009 | | Reputation: | | Posts: 858 |
| |