Forum Coordinators: RedPhantom
Poser - OFFICIAL F.A.Q (Last Updated: 2024 Dec 11 2:52 am)
Yes. its Access.
Yes It integrates with Poser, through PRPCD or it makes Collections.
and no it CAN"T hurt anything, all it does is make a list (a very complex list) of your files, in a seperate directory.
and yes, I'd love to read a review or two myself...
hth
Ben
Rocketship Software
(makers of PzDB)
Setup experience with the trial: apparently PzDB uses the Windows Scripting Runtime (wshom.ocx). When installing on an XP Pro 64 bit system, the installer tries to overwrite the existing ocx - not good!
When importing my main library (Poser Pro), the import fails with the following error message: "The expression OnClick you entered as the event property setting produced teh following error: Object variable or With block variable not set."
This happens at the icon fixing stage. I assume the icon fixing stage uses wshom.ocx in order to evaluate shortcut targets.
That's not the way to do it. The programmer should have used shell32.dll - a core system file that is present in EVERY Windows installation, from Windows 2000 to Vista 64 (haven't checked Windows 7 yet).
After dismissing the error dialog boxes, PzDB hangs.
Conclusion: nice idea, but it isn't ready for prime time yet.
The pen is mightier than the sword. But if you literally want to have some impact, use a typewriter
I'm sorry you're having trouble.
No one has reported this error before. It may be a side effect of a last-minute bug we were fixing here. We are trying now to re-create the problem.
Is it possible that you have no icons to fix?
and
Would you please uncheck "Fix missing PNG icons" and try again.
Ben
Rocketship Software
I'm an experienced VBA and .NET programmer myself, so I know what those errors mean.
Installing wshom.ocx (the control that provides the Scripting Runtime, the one that provides the FileSystemObject and its dependent objects), well, it shouldn't be an unconditional install. Many Windows systems already have this control, and Windowx XP and higher do not permit installing over an existing system file. This is something that should be fixed in the installer.
There's probably code like
Dim FSO As New FileSystemObject
in the application. This code means that the application is hardwired to use a specific version of wshom.ocx. The code is bound to a specific GUID that is linked to a specific version of wshom.ocx. This is early binding. Easier to code and better performance than late binding, but the application is bound to a specific version of the external library.
It should be recoded as
Dim FSO As Object
Set FSO=CreateObject("Scripting.FileSystemObject").
This is late binding.
The code will look up the GUID for Scripting.FileSystemObject in the registry and load wshom.ocx - the version that is already installed on the target computer. It will work with any version of wshom.ocx.
The pen is mightier than the sword. But if you literally want to have some impact, use a typewriter
Unchecking the missing icons checkmark worked - PzDB is now loading my Poser 5 runtime.
Another little bug: the Warning - Very Large Library message cannot be closed.
The pen is mightier than the sword. But if you literally want to have some impact, use a typewriter
Thanks for your help.
It IS because you have no icons to fix. Its a bug we created about 2 days ago, while fixing something else. (unchecking the box is a functional workaround)
It has nothing to Windows Scripting which we use to make Collections. The attempt to overwrite was a default of out installer app, sorry about that too.
Both are being fixed in a new build which will be online in about an hour.
Thanks again
Ben
Rocketship Software
By the way: I'd strongly advise a rewrite of this application in Visual Studio.NET 2008 Express, with SQL Server Compact edition as the database. Why? Several reasons.
The pen is mightier than the sword. But if you literally want to have some impact, use a typewriter
Found out about that, took a couple of minutes.
The pen is mightier than the sword. But if you literally want to have some impact, use a typewriter
Don't forgot Hogsoft's PBooost II. The original replacement Poser Library Replacement. Doesn't use Access. And is a fair bit cheaper, esp. if you have a PBooost 1.4 around to upgrade.
Also allows you to create "virtual" folders in which you can place links to items in any real folder.
THE REVIEWS ARE IN:
(actual unsolicited comments from new users)
" I've downloaded Pzdb and am completely blown away by it! This is what I've been waiting for! ... the program appears to be a dream to use, and I can't wait to begin experimenting with loading stuff into poser from my DB screen! "
Doug R.
" I downloaded your PzDB program, and I'm very impressed with it"
Dave P.
" These is a software I've waited for a long time :) I've tried several other data base tools for Poser but they didn't convince me. Your tool is much faster than others, even with large runtimes ! I have over 40 runtimes (for each figure one, for hair, food, wings and so on) but meanwhile I've lost the overwiew :) And I also like the option to create my own groups."
Marion
Pakled's curse strikes again..;). Made a Poser database in Access (not nearly as nice as yours), a while back. It's of marginal use to me. But then I wasn't using Visual Basic, or SQL, or whatever it's written in. ya done a good thing there, doing it right.
Kudos.
Now, if you can find a way to browse through the menus inside Poser without being 'express booted' back to the tope every time you get out of a choice...;)
I wish I'd said that.. The Staircase Wit
anahl nathrak uth vas betude doth yel dyenvey..;)
I thought we WEREN'T to advertise in the forum. And why DOES a freestuff item cost $50. I've read about people getting threads locked and pulled ... This seems a prime candidate!
Shouldn't his thread be moved to some product development forum? Another poster was asking about a ultilty in another thread and I was afraid to give a link to something he might be interested in. I guess I don't understand this thread OR the fact it's allowed in the freestuff area.
Best Wishes and good luck with your product.
Rªnce
Well I'm giving this thing a whirl and I'll see if the wheels come off :)
I've a fairly well maintained if largish collection of runtimes (60+ gig on the current live ones, not including the currently mothballed ones) but as a content creator I have some considerations the average user may not. However, I'm going to use this for a couple of days and see what I think could be improved and what goes bang.
The install went ok, and after a false start loading library folders (didn't realise I needed to use the little arrows to start a new runtime before scanning) Currently I have a bunch of stuff erroneusly loaded into the main runtome thats lost its pngs. I'm not entirely sure how to nip out the bad data, but I'll figure it out eventually. I hope. lol
I currently use PoserExplorer by 3dUniverse to load content from windows explorer, but using windows search funciton can be ...tricky.
so in a few days I'll send the programmer a review type of thing :)
If nothing else I'm having fun seeing stuff I havent blown the dust off of in years lol
Lyrra
Clearly a lot of the heavy lifting has been done for this app., but it is by no means ready for full release, if the glitches and errors that I'm encountering are anything to go by.
With that caveat in mind... I hope they keep up the good work with this, when it's really really finished I'll happily pay $50 for it.
Windows 10 x64 Pro - Intel Xeon E5450 @ 3.00GHz (x2)
PoserPro 11 - Units: Metres
Adobe CC 2017
Quote - Setup experience with the trial: apparently PzDB uses the Windows Scripting Runtime (wshom.ocx). When installing on an XP Pro 64 bit system, the installer tries to overwrite the existing ocx - not good!
When importing my main library (Poser Pro), the import fails with the following error message: "The expression OnClick you entered as the event property setting produced teh following error: Object variable or With block variable not set."
This happens at the icon fixing stage. I assume the icon fixing stage uses wshom.ocx in order to evaluate shortcut targets.
That's not the way to do it. The programmer should have used shell32.dll - a core system file that is present in EVERY Windows installation, from Windows 2000 to Vista 64 (haven't checked Windows 7 yet).
After dismissing the error dialog boxes, PzDB hangs.Conclusion: nice idea, but it isn't ready for prime time yet.
EXACTLY the same thing happened to me. It crashed with that error fixing icons in my personal (BagginsBill) runtime. My personal runtime (stuff I make) is loaded with materials for which there is no icon. This runtime is in my desktop. I'm on XP.
I don't actually need this program. My runtimes are practically empty compared to most people. So when it crashed within the first minute of use, I deleted it immediately.
Renderosity forum reply notifications are wonky. If I read a follow-up in a thread, but I don't myself reply, then notifications no longer happen AT ALL on that thread. So if I seem to be ignoring a question, that's why. (Updated September 23, 2019)
I have had no problems installing this program. I scanned my main Poser library with 850K items and it ran fine - although it took 56 hours to complete.
The program itself seems to work OK and its search works fast and does a reasonable job of finding related items. It could be better if you could specify an isolated word as filter which does not return results in which the word is part of the name (so "car" would not return scarf of cartoon)
The scanning process influences somehow the performance of Poser in some way. During the scanning Conforming a clothing item now takes 10 seconds. Once the scanning is completed, performance returned to normal.
I will try this out a few more days, but for now I am happy enough with it to seriously consider buying it. It certainly will save me a lot of time finding things.
850,000 Items? My word!
Around here we used to talk about a mythical "Million Item Library" which we thought was impossible. But maybe not. Anyway we would recommend that you stop adding Content to that Library, PzDb works best with multiple small Libraries. see Best Practices in the Manual for more info.
If you do add more, please don't hold us to the "Later rescans of this Library will only take minutes..." part. Because later recans of this Library are likely to take a while.
About Searching; the problem with whole-word searching is that in Poser Libraries, people often don't use spaces, sometimes they use underscores, or dashes, or just run words together in CamelCase. When you search for "car" you really want to find "Sportscar" "PoliceCar" and "Dave'sNewCar5" too. (but not "scarf" or "cartoon")
That's what the "But does not contain" field is for!
Put "scarf, cartoon" in there and repeat the search, Now those Items are gone. You can continue this process to build a really good Search Pattern, add "auto" but not "automatic" add "truck" but not "struck" stuff like that. Then, name it and SAVE it!
Now you'll never have to type any of that stuff again. And you can build and save as many Search Patterns as you like.
hth
Ben
Rocketship Software
Ah, another good reason to switch to a .NET /SQL Compact edition: full text search capablilties.
The pen is mightier than the sword. But if you literally want to have some impact, use a typewriter
Quote - What i would find usefull in the search would be the ability to specify 2 terms that both must be met; as in Michael AND Coat. If that functionality is there, I missed it.
Yep you missed it.
Look up using wildcard characters in the FAQ.
To find "Michael AND Coat" you're much better off Loading the Michael Group and searching for "coat" Because not all the coats are going to say "Michael" Some will have "Mike" or "M3" or " Millennium Man" That's why PzDB uses keywords to make groups!
hth
Ben
Rocketship Software
I have no issues with large libraries in Poser. I use (many) subfolders for categories and this works fine. I used to have multiple runtimes, but that made finding stuff even more difficult and tedious. Problem is that many items fall under multiple categories.
A large library makes the tree menu functionality in the library unusable (too many items with a primitive scrollbar, too slow when starting poser) but having many runtimes makes the tree menu less useful as well. When you switch it off, navigating is just as fast in a large library as with small runtimes. The lack of a tree is not a serious problem if you can navigate within a few seconds.
So I am not ready yet to add many additional runtimes.
.
Regarding the Does Not Contain rule: You can exclude words, but with many items there just are too many words to exclude (with car that would be more than 40 in my libraries). Maybe a solution would be to allow leading or trailing spaces as signficant characters: " car" or "car ". In such as a case it would find most of the items you are looking for.
Updating with new items: Scan takes about 7 minutes (40 min first time), Identifying new items takes a few hours (2 hrs now. still running, was 4 hrs first time). I hope crossreferencing goes a bit faster.
I really wonder if dividing up into multiple runtimes will significantly speed things up since the program has to handle the same number of items - crossreferencing, identifying, etc, and the bottleneck seems to be the number of items in the database.
Maybe switching to a SQL sever like solution - as svdl suggested - would help in case of a million items.
"I hope crossreferencing goes a bit faster."
It will be.
Identifying new items will take the longest in this scenario. You have to compare every item to every other item, but only within one Library. with a 50,000 Item Library the number of comparisons is something like 3 followed by 25 zeros. (My computer is still trying to add up the number of comparisons your computer is trying to make.)
That's why many small Libraries is better. PzDB puts them all together so you can use it as one. We have users with 40+ Libraries. The Import of a small Library happens in the blink of an eye.
The timing of the rest of the Import has to do with the number of NEW items and the total number of keywords in the system. At no point do we have to compare EVERYTHING to EVERYTHING (except in your case). The only bottleneck here is the one you have made.
Feel free to use PzDB in any way you'd like, and frankly we really don't mind you "load-testing" it the way you are, but that's what you're doing. Please realize you are, at this stage, beyond the recommended usage of our program. (and for that matter the recommended usage of Poser)
PzDB will easily handle a million Items, but not easily in single Library.
Imports will take hours (if not days) the way you are doing this, and by simply adding Items to a new Library from this point forward would make them take seconds and you'd get the exact same results. Up to you.
Ben
(bty my Windows Calculator is STILL working out the factorializion of 850,000!)
Quote - I Maybe a solution would be to allow leading or trailing spaces as signficant characters: " car" or "car "
Actually those searches work too. Leave off the quote marks though. The system only trims leading and trailing spaces when you enter multiple terms (with a comma).
Ben
Rocketship Software
One more dumb question. Playing around, I created a new group. Is there a way to add the results of a search into the new group at one time? I did finally figure out how to add a folder; however, the group I created would encompass many folders. Can you select multiple folders at one time and add those items?
Also, is there a way to start fresh? I didn't see any option to clear the library and start with default settings/items.
John
Adding new items took about the same time with the update as the first time (about 4 hrs).
Crossreferencing took only a few minutes. (luckily the factorization of 3x10^25 is not the case...)
I did get two errors though - the one with the icons and another one after adding the new items. Is there a way to log these errors?
Trailing spaces do not work as a filter, it is cut off at data entry level. Preceeding space does work.
I am curious about other users with a 1M item list and the performance updating new items with multiple runtimes.
Wim
]
I have an additional question, and this concerns the EULA. I use Poser on my desktop, and on my laptop; but not at the same time. I prefer to keep everything set up the same on both the desktop and the laptop, where possible. Poser's EULA allows me to do this. From reading your EULA, I would not be able to do this unless I bought 2 copies. Is this correct?
Heres a dumb one:
how do I remove items from the listing? or reset Runtime 1? I hadnt realised I needed to add each runtime in a new slot so the first one has some bogus entries I can't shake.
A few thoughts
It would be really nice to be able to Quick search from a clicked on item. right now if I search for hair , then I need to search again with the specific hair to find its related items. This is less helpful when the item I find (boots from a certain set) don't have a unique Library name
Does it check for removed items and not just added? I move stuff in and out of my library all the time. (as in hourly) Right now I'm having a little trouble with some 'ghost' entries.
What happens if I scan a runtime and then zip it (mothballed for storage)? I presume the data will remain in the listing but if I try to launch it into poser it will complain?
No All Off button? or a simple toggle? it's kind of clunky to turn each category type off manually when I want just poses or etc
Still puzzling out how Groups are created. It would be nice to be able to cluster items by maker or store, since for DAZ promos I need to use only DAZ store items.
Is there a way to edit keywords for specific items? I havn't figured that out yet. If not, there should be since there are some things I'd like to tag with meta data like 'converted', and 'noncommercial use' and non-obvious ones like 'fetish' that would be difficult to sift out with a keyword search using only the imported keywords
btw the predefined Hair search needs -capsces added, at least for me :)
aside from that it seems to be doing pretty much as advertised
for the chaps with the giant runtimes (something p4 forced you into) .... perhaps enabling a 'by category' scan? do just Figures, then Hair, then poses, etc. give the machine a little less to chew on at once?
Lyrra
Quote - One more dumb question. Playing around, I created a new group. Is there a way to add the results of a search into the new group at one time? I did finally figure out how to add a folder; however, the group I created would encompass many folders. Can you select multiple folders at one time and add those items?
I was waiting for someone to ask this. (not dumb at all)
We had buttons that did that at one point (it was Alpha 8, I believe). But then we realized that it was the wrong way to use PzDB.
You don’t want to save the results of a Search, you want to save the Search Pattern. You don’t want to save a bunch of Items in a Group, you want to find the Keywords that cause those Items belong in that Group, and add the Keywords, the Items will follow.
You don't want a "Coats" Group, you want a good Coats search Pattern to use in any Group. (coat, jacket, mack.) etc.
The goal in using PzDB is to build teach the database the relationships between the types of Content you want to group together, and then let it do the work,
That way, in the future, new content automatically falls into these Searches and Groups. The ability to manually add individual Items and Folders should be considered a last resort.
Ben
Rocketship Software
***How do I remove items from the listing? or reset Runtime 1? I hadnt realised I needed to add each runtime in a new slot so the first one has some bogus entries I can't shake.
***A few thoughts
It would be really nice to be able to Quick search from a clicked on item. right now if I search for hair , then I need to search again with the specific hair to find its related items.
Have you looked at (and clicked on) the RELATED FOLDERS under the SELECTED ITEM?*
*
**Does it check for removed items and not just added? I move stuff in and out of my library all the time. (as in hourly) Right now I'm having a little trouble with some 'ghost' entries.
**
That hasn't been an issue because most people don't do that. Its now on the schedule for version 1.1
What happens if I scan a runtime and then zip it (mothballed for storage)? I presume the data will remain in the listing but if I try to launch it into poser it will complain? *
Yes, and the Icons will be gone too.
**
*No All Off button? or a simple toggle? it's kind of clunky to turn each category type off manually when I want just poses or etc ***
Version 1.1 but have you noticed the ability to turn off "Auto-Go?" If you want to enter a Search Pattern and pick a Group and turn off a bunch of parameters its a lot faster.
**Still puzzling out how Groups are created. It would be nice to be able to cluster items by maker or store, since for DAZ promos I need to use only DAZ store items.
2, Go to Keyword Manager find the DAZ keyword (PzDB should have found it for you) double click to open, add it to you DAZ group.
Is there a way to edit keywords for specific items? I havn't figured that out yet. If not, there should be since there are some things I'd like to tag with meta data like 'converted', and 'noncommercial use' and non-obvious ones like 'fetish' that would be difficult to sift out with a keyword search using only the imported keywords***
There's a big difference between Keywords and Tags. Keys are automatic and Tags would require lots of typing that we figured most people didn't want to do. ***
btw the predefined Hair search needs -capsces added, at least for me :)
Add it! just type it into the Contains field (with the rest of all that) and click save!!
***aside from that it seems to be doing pretty much as advertised
We aim to please.
Let me know if you have other questions
Ben
Rocketship Software
well I don't know how its sorting relations .. but my 'related items' list is generally irrelevant stuff. I'm clearing it out and reinstalling the new version now so hopefully that will do better
I think tags would help, i would certainly like to be able to add that level of metadata to the content. there are times when I want to look for a particular era or style of clothing . I don't mind the extra typing .. I only have to do it once. AdobeBridge , which I use as an image resource database pretty much, allows me to make new metadata and select a bunch of items to apply it to at once.
And quite a few people swap content in and out frequently. You dont always need to have everything loaded all the time ... many people for example only load the holiday items once a year.
If I were to load up every single peice of poser content I have avilable to me and leave it loaded, well .. I don't know if I'd hit that million item runtime but it would be VERY big. Definately well in the 100 plus gig range . I've been collecting for quite some time lol . And my hardrive would explode. As it is right now I have only v3,v4,m4,m3,a3, animals, props and shared live. all my other runtimes are zipped up or burned off entirely. This is mostly because when working on content I tend to run out of hd space, so I only keep installed what I need on hand.
Lyrra
Quote - > Quote - One more dumb question. Playing around, I created a new group. Is there a way to add the results of a search into the new group at one time? I did finally figure out how to add a folder; however, the group I created would encompass many folders. Can you select multiple folders at one time and add those items?
I was waiting for someone to ask this. (not dumb at all)
We had buttons that did that at one point (it was Alpha 8, I believe). But then we realized that it was the wrong way to use PzDB.
You don’t want to save the results of a Search, you want to save the Search Pattern. You don’t want to save a bunch of Items in a Group, you want to find the Keywords that cause those Items belong in that Group, and add the Keywords, the Items will follow.
You don't want a "Coats" Group, you want a good Coats search Pattern to use in any Group. (coat, jacket, mack.) etc.
The goal in using PzDB is to build teach the database the relationships between the types of Content you want to group together, and then let it do the work,
That way, in the future, new content automatically falls into these Searches and Groups. The ability to manually add individual Items and Folders should be considered a last resort.
Ben
Rocketship Software
A real worl example: I have the dream home project from DAZ. On my system, it contains 552 items. Hopefully that is all there is to it. I can save the search, and have done so. Now, I want to search for all sofas and textures for the sofas inside that group. As it is now, I have to modify the search again to just include that. Now after i do that, i could save the search for that; but since i wouldn't use that search very often it would be a waste. Maybe next time i would search for chairs, or lamps, or whatever. Pretty soon, i would have an unmanagable search list.
How many search terms can one save, and still access the saves? Will a scroll bar appear after a while?
And I do not particularly want to have to add 552 individual items to a new group.
One option that would work for me in this example, would be a "search within results" box. Then I wouldn't have to add everything to a group.
Overall, i am impressed with the program, and will be purchasing. i just wish it was a little easier to use.
Just my .02 worth.
John
Good.
Real world solution:
I just looked and all these Dream Home items seem to have a couple of common Keywords in their Folder names: "DH_" and "Dream Home" So:
Make a Dream Home Group,
You'll have to create custom Keywords: DH_ (WITH the the underscore) and "Dream Home" WITH the Space. Add them to the Dream Home Group, open that Group.
You should find all your Dream Home stuff. (Maybe there is another keyword or two I missed.)
Search away.
hth
Ben
Rocketship Software
Thanks. It did find all items. i did have to add another keyword to get them, but that worked, at least 99% worked. Unfortunately, there is another product with DH_ in it that is not part of Dream Home. Easy to ignore though. Also, I could read better and see how to delete the items from the group. :-)
Good. Now you're using PzDB!
The "Remove Folder" button is your best best for getting those False Positives out.
99% is about as good as we're going to get with something like a Poser Library.
In the future, you'll find that you add more Dream Home stuff than whatever that other thing is. And all that stuff will just "fall" into your Dream Home Group by itself! That's how PzDB is supposed to work.
Hope you enjoy it.
Ben
Rocketship Software.
I've been lurking on these boards for quite a while and this is the first thing in years that has made me want to post a comment.
Unlike some of you I had no problem installing it. (Although I've been told - by a friend, ahem - that changing your system date to fool the trial period doesn't work and botches the install. But I only heard that from a friend ;)
The program performs as advertised and I couldn't be happier with it.
LIke Renderholic above, I also found stuff I hadn't seen in ages. I've got about 150 gigs of stuff and it handles it just fine. It's amazing how crappy poser's library is and this is just the fix I've [you've] been looking for.
I've already bought and paid for it even though there's 30 days free. Why delay the inevitable? There's no way I'm gonna live without this now.
Oh and to the guys complaining that its in Free Stuff. I'm pretty sure the folks at Rosity have to approve things before they're put up there, so what's the problem? If they're prepared to call it Free Stuff doesn't that sort of mean the thread Nazis can relax?
z
Please also see my post here:
http://www.renderosity.com/mod/forumpro/showthread.php?thread_id=2763090
Eternal Hobbyist
"I thought we WEREN'T to advertise in the forum. " No Rance - the rules are that we are allowed to answe questions about a product -we just aren'y allowed to say : hey have you seren the blah blah at bkah" in the initial post
love esther
I aim to update it about once a month. Oh, and it's free!
This site uses cookies to deliver the best experience. Our own cookies make user accounts and other features possible. Third-party cookies are used to display relevant ads and to analyze how Renderosity is used. By using our site, you acknowledge that you have read and understood our Terms of Service, including our Cookie Policy and our Privacy Policy.
Has anyone tried the PzDB (poser database) program in freestuff for replacing, IMO poser's archaic library management system ? The only caveat is it's only free for 30 days, but if it provides a better library with enhanced features, maybe it's worth it. I saw 'advanced library' in another thread some time ago, but haven't tried it as yet.