Daz Library Content Export (maybe into Excel?)

sentientblob

Hey everyone,

I just was wondering whether there was a way in which I could download my library listing into a spreadsheet of some kind?  I know DAZ uses a database to catalog our belongings, so I wanted to know if there was a way to export those values into an Excel table or something similar.

Thanks.

barbult

You can export to CSV from DIM very easily. Select the products you want to export and right click select Export Selected to CSV. A window pops up to let you select the fields you want to export.

sentientblob

Thank you so much for the information--it worked like a charm!

Here's a follow-up question.  I noticed in DAZ that some items have useful tags (e.g. "clothing" or "poses") and similar identifiers (e.g. product creator); are these values that can be exported somehow as well?

Thanks again.

barbult

As far as I know, DIM can only export the fields on the list it provides. The tags are metadata. I bet someone could write a script to export data base metadata, but I don't know. I think usar Taoz has created some content management tools, but I am not sure if they can do it.

PerttiA

Excel can connect to databases, I have done it with a non-MS database but it needed a plugin... What database is  DAZ using?

Omniflux

Metadata is stored in PostgreSQL (connection details here). DIM updates the information in the database, and that is what shows up in Studio, but the information you see in DIM is directly from the product XML files (.dsx) in the package archive (%PUBLIC%\Documents\DAZ 3D\InstallManager\Downloads by default on Windows).

PerttiA

Found a lot of stuff about connecting to PostgreSQL database with Excel, this was just one of them https://www.cdata.com/kb/tech/postgresql-odbc-excel-query.rst