Can someone please recommend a searchable by keyword database for Daz assets?

Like many, I'm sure, I now have literally thousands of pounds worth of Daz Studio assets. Keeping track of them is a nightmare. None of the pre-existing options are 100% ideal. I do like Daz Central but the search facility, although the best I've found so far, is still very limited. Often one knows that one has a specific asset somewhere like, say, a wine bottle, and it's probably in a kitchen or dining room or restaurant, but one can't find it by searching for 'wine' or 'bottle.' So I've been thinking of going through my assets slowly one by one and listing all the individual assets by keywords in a searchable database, so that if I then do a search for 'wine' or whatever, the system will then list all my assets which include something relating to wine in the asset/bundle, and I can then go straight to the asset that includes it.

I can't see any other way of keeping track of specific individual assets. I'm sure others have been doing this. Could anyone please recommend a database program searchable by keyword which might be suitable for this. I've looked far and wide and it's not immediately obvious. Thanks!

Comments

  • Do the search options in Smart Content (which are database queries to PostgreSQL) not work? Adding to and refining that, which at least already has some of the ground work, would be easier than starting from scratch.

  • Sci Fi FunkSci Fi Funk Posts: 1,198
    edited December 2021

    I have solved the "can't find anything" problem in the following way. (I have over 5000 Daz assets).

    1. I search via Smart Content.

    2. If I can't find what I want then I consult my low-tech do-it-yourself "database" of product screen prints.

    In this way I always find what I bought.

    How to set up your screen print database.

    1. Go through your entire product library and screen print the product page. Now some will have retired and you won't be able to get anything else than a small place holder, but it's still good enough. For the products that are still current one side benefit is that you get to keep the promo image that probably sold you on it in the first place vs the Smart content image which can sometimes not look much like what persuaded you to buy the item.

    2. File each of the items under main categories - for example people, clothes, hair, props, environments etc.

    3. Now split each main category up by era - I have medieval, victorian, 20s, 50s, 70s, contemporary, sci fi grunge and fantasy-sci fi for example.

    4. Now for something like clothes,  within those split up by character (this is less important if you have all the clones).

    5. If something like hair is for say G2 and G3 - then I have 2 copies of the picture one for each character.

    I've found this particularly useful for utilities. I have a very large collection of those and I can easily lose them in smart content as I forget the name of it.

    If you think I'm not serious then consider this:- Before this system I realised I had no less than 3 rain tools. Since this set up I've not bought any more duplicate items.

    Yes it's a pain to set up, and you'll need about 5-6GB of storage, but one other benefit - all my characters are headshots. I choose the headshot and it's always of the image that sold me the character in the first place. So when flipping through my low--tech database, I always know why that character was bought.

     

    Post edited by Sci Fi Funk on
  • jjoynerjjoyner Posts: 617
    edited December 2021

    I can't see any other way of keeping track of specific individual assets. I'm sure others have been doing this. Could anyone please recommend a database program searchable by keyword which might be suitable for this. I've looked far and wide and it's not immediately obvious. Thanks!

    I'm a recently retired dabbler in 3D CG.  I started using iClone, DS, Poser and others starting in 2007. Regarding assets in DS, I've come to appreciate the Files tab in Smart Content when I want to find a particular type of item.  For example, I just typed in the keyword "bottle" and got 209 bottle items with the keyword "bottle" in the file name as opposed to a search in the Products tab that only produces two products with the keyword "bottle" in the product name.  The search results include items from my Poser assets as well.

    Joe

     

    bottles.jpg
    499 x 597 - 90K
    Post edited by jjoyner on
  • Richard Haseltine said:

    Do the search options in Smart Content (which are database queries to PostgreSQL) not work? Adding to and refining that, which at least already has some of the ground work, would be easier than starting from scratch.

    Yes, the file search of Smart Content works great.....for those assets I have installed. I thought I'd read here in forums, however, that irrespective of how much hard disc space one has, it can get to the point that too many assets installed will dramatically slow down the system. Is that not the case? As a result I often uninstall assets I think I'm not going to use for a good while. I can then still search for them in Daz Central, but not file search of Smart Content. Unfortunately Daz Central won't pick up the assets within the asset. Do others keep ALL of their assets installed?

  • Thanks Sci Fi Punk. Some good ideas there. Perhaps a hybrid of this system focusing on those assets I don't tend to have permanently installed might be the way forward....

  • bytescapesbytescapes Posts: 1,841

    DawnStar said:

    Richard Haseltine said:

    Do the search options in Smart Content (which are database queries to PostgreSQL) not work? Adding to and refining that, which at least already has some of the ground work, would be easier than starting from scratch.

    Yes, the file search of Smart Content works great.....for those assets I have installed. I thought I'd read here in forums, however, that irrespective of how much hard disc space one has, it can get to the point that too many assets installed will dramatically slow down the system. Is that not the case? As a result I often uninstall assets I think I'm not going to use for a good while. I can then still search for them in Daz Central, but not file search of Smart Content. Unfortunately Daz Central won't pick up the assets within the asset. Do others keep ALL of their assets installed?

    Yes, having too many assets installed will result in major slowdowns when you add a character (as I understand it, the issue is with the morphs; when DAZ loads a character, it has to load all the morphs for that character family). So uninstalling them is important if you want to keep DAZ Studio responsive.

    I wish that DAZ software offered some kind of unified tagging/categorization system. DAZ Install Manager already supports search but not, as far as I know, the way to add your own keywords to content. I'd love to be able to group my content into categories by tagging it -- 'genesis-8-favorites' or 'old-stuff-do-not-install' or 'genesis-8-additional-females' would all be useful -- and then manage my installs that way. And having Install Manager categorizations carry over into DAZ Studio itself might be handy too.

  • TaozTaoz Posts: 9,940
    edited December 2021

    You could try this, there's a free version (1000 products limitation, otherwise fully functional) so you can test it for as long as you like:

    https://taosoft.dk/software/pm-daz/

    Current version does not have keywords / tagging, but it's being implemented right now, and should be in next version.  Includes both DAZ standard categories as well as user defined keywords / tags. 

    Post edited by Taoz on
  • I use Voidtools Everything 

  • contedesfeescontedesfees Posts: 254
    edited December 2021

    I keep an inventory of all the promotional images that come with the assets I buy and organize them alphabetically in ACDSee Photo Manager. Further, I use ACDSee Photo Manager to create a contact sheet of installed items, thereby making a visual catalog of installed assets. That works like charm to keep track of poses (like DM's Feeling Pretty as seen below) and expressions.

    ACDSee also enables you to assign labels and define categories. Just create a category called "wine bottle' and assign all appropriate promotional images to it. You can organize the images using either or both methods to keep track of them. I won't call this an unrivaled time saver, but I can find what I want and know how it looks before-hand. And it's certainly easier than learning SQL, Excel, or Access.

    Feeling Pretty 1.jpg
    650 x 650 - 102K
    Post edited by contedesfees on
  • That's interesting.  If the slowdowns are primarily caused by having too many characters installed, for the reasons that you say, then that would simply matters. Searching through uninstalled characters via Daz Central is easy, and if this means I can keep the bulk of my other assets installed then the search options in Smart Content work a treat. Is this a definite, or just as you "understand it"? If anyone else could confirm I would be grateful!

    bytescapes said:

    DawnStar said:

    Richard Haseltine said:

    Do the search options in Smart Content (which are database queries to PostgreSQL) not work? Adding to and refining that, which at least already has some of the ground work, would be easier than starting from scratch.

    Yes, the file search of Smart Content works great.....for those assets I have installed. I thought I'd read here in forums, however, that irrespective of how much hard disc space one has, it can get to the point that too many assets installed will dramatically slow down the system. Is that not the case? As a result I often uninstall assets I think I'm not going to use for a good while. I can then still search for them in Daz Central, but not file search of Smart Content. Unfortunately Daz Central won't pick up the assets within the asset. Do others keep ALL of their assets installed?

    Yes, having too many assets installed will result in major slowdowns when you add a character (as I understand it, the issue is with the morphs; when DAZ loads a character, it has to load all the morphs for that character family). So uninstalling them is important if you want to keep DAZ Studio responsive.

    I wish that DAZ software offered some kind of unified tagging/categorization system. DAZ Install Manager already supports search but not, as far as I know, the way to add your own keywords to content. I'd love to be able to group my content into categories by tagging it -- 'genesis-8-favorites' or 'old-stuff-do-not-install' or 'genesis-8-additional-females' would all be useful -- and then manage my installs that way. And having Install Manager categorizations carry over into DAZ Studio itself might be handy too.

  • This looks VERY interesting. I have downloaded and will explore. Thanks! 

    WendyLuvsCatz said:

    I use Voidtools Everything 

  • This also looks very interesting. Definitely going to take a look at this. Thanks! There's been some great suggestions on here overall, and I'm very grateful.

    Taoz said:

    You could try this, there's a free version (1000 products limitation, otherwise fully functional) so you can test it for as long as you like:

    https://taosoft.dk/software/pm-daz/

    Current version does not have keywords / tagging, but it's being implemented right now, and should be in next version.  Includes both DAZ standard categories as well as user defined keywords / tags. 

  • DazzleDazzle Posts: 45
    edited December 2021

    I am fairly new to Daz, but I already have 4,000+ freebie items and (now I'm starting to get the hang of what I'm doing, and understanding what I need) an increasing number of paid-for items. I avoid Daz Central like the plague - here's how I'm approaching the problem instead.

    I do all my searching in the directory which holds my archives, using File Explorer. The directory structure is logical (to me) and filenames follow a pattern 'description characters (authorname) tags', e.g., "jupe flamenco dress g8f (guy91600) daz.zip". The description is usually based on the author's own title for the product, but I augment it if the original is obtuse, inaccurate, misleading or non-english. In hindsight I could have  treated the authorname and list of characters (g3m, g8f, g81f, v4, m4, etc) the same as normal tags. I use the tool from advancedrenamer.com to automate most of the renaming process. This tool can process batches of files, to perform operations such as trimming filenames, standardising case, removing punctuation which may complicate file searches (underscores, etc), adding or removing tags, and much more.

    The tags don't automatically appear in My Library or My Poser Library, of course, but I also manage those directories manually, and so far I've never had any difficulty finding an asset whose archive-name suggests it may be of interest.

    In the case of the OP's 'bottle of wine' example, a successful search would depend upon the user having added the appropriate keywords when filing the archive. It would not matter whether it had been filed under 'eateries', 'dating', 'france' or '1980s' - if the tag 'wine' had been added, the archived file will be found by File Explorer. There is no need to build a dedicated database, IMO.

    Post edited by Dazzle on
  • paulawp (marahzen)paulawp (marahzen) Posts: 1,370
    edited December 2021

    Although probably impractical for the OP, I solved this problem by creating an Access DB (actually multiple, linked DBs). Since I created it specifically for my needs, it does all the things I wanted; downside, it's very time-consuming to populate and maintain. I can do full text search of product descriptions, I attached JPGs so I can see the product pages and I created fairly granular categorization of things I particularly need - for instance, I can find products that include, specifically, boots, or if I want to find a pose for sitting on a flat surface like the ground, I don't have to wade through hundreds or thousands of generic "sitting" poses.

    Just sharing my experience, since I was facing this exact problem a couple of months ago. Sorry, not an easy answer.

    Post edited by paulawp (marahzen) on
  • No, definitely not an easy answer, especially as I haven't properly got to grips with Access yet - but it was the direction I was originally leaning towards when I first posed the query, and I still feel it's probably the most comprehensive answer. I don't mind that it would be time consuming to populate and maintain. My experience of databases in the past has been numerous false starts only to discover that there was some other field I wish I'd added in right at the beginning, and I would have to start inputting the same data all over again! Hopefully database creation has become a bit more flexible since then. Could I trouble you to give me some idea of what fields you created for your DB? Thanks.

    paulawp (marahzen) said:

    Although probably impractical for the OP, I solved this problem by creating an Access DB (actually multiple, linked DBs). Since I created it specifically for my needs, it does all the things I wanted; downside, it's very time-consuming to populate and maintain. I can do full text search of product descriptions, I attached JPGs so I can see the product pages and I created fairly granular categorization of things I particularly need - for instance, I can find products that include, specifically, boots, or if I want to find a pose for sitting on a flat surface like the ground, I don't have to wade through hundreds or thousands of generic "sitting" poses.

    Just sharing my experience, since I was facing this exact problem a couple of months ago. Sorry, not an easy answer.

  • cridgitcridgit Posts: 1,757
    edited May 2022

    Redacted

    Post edited by cridgit on
  • cridgit said:

    It seems several respondents have resorted to manually managing their asset library. I respect the diligence but man! that's a lot of tedium.

    A database seems to be overkill IMHO. If you simply want to search through your assets for keywords (asset name, vendor, file/folder name, tags etc.) it's easy to dump your entire content library to a text file and simply search that using a text editor. Let me know if you'd be interested, as it would literally take 5 mins to rustle up a DAZ script that does this.

    While a full database might be overkill for a simple tagging system it does allow other features, such as relating items to their compatible figure(s) or targets, which is - I think - why Daz uses one.

  • almahiedraalmahiedra Posts: 1,351

    cridgit said:

    It seems several respondents have resorted to manually managing their asset library. I respect the diligence but man! that's a lot of tedium.

    A database seems to be overkill IMHO. If you simply want to search through your assets for keywords (asset name, vendor, file/folder name, tags etc.) it's easy to dump your entire content library to a text file and simply search that using a text editor. Let me know if you'd be interested, as it would literally take 5 mins to rustle up a DAZ script that does this.

     Considering that default metadata in batch writing is damaged and is worse than useless, it would be interesting to see a script of that nature.

  • WendyLuvsCatz said:

    I use Voidtools Everything 

    Ditto. It is the most important program on my computer.  

  • atoxicatoxic Posts: 141
    edited January 2022

    DS solutions are working, but I find they are limited. Found it difficult to add to a item pointers to related items (e.g. hair to hair color or maybe a prior unrelated hat) which will be visible at the same time as I get the information about the the items I was looking for (your wine bottle - there it would be the relation to liquid shaders....). And too I found no good way to booster up the description to include information I would like to add regarding the use in my scenes.
    Therefore I experiment with an Open Office Database at the moment.

    Regards

    atoxic

    Post edited by atoxic on
Sign In or Register to comment.