DAZ3D Help Center

Cristina Galloway June 19, 2014 DAZ 3D Software / DAZ Studio

PostgreSQL CMS FAQ

What is CMS?
What's the difference between Valentina CMS and PostgreSQL CMS?
Why change from Valentina CMS to PostgreSQL CMS?
Do I have to switch?
Who should NOT install PostgreSQL CMS?
What are the benefits of PostgreSQL CMS?
What version of DAZ Studio is needed to use PostgreSQL?
What preparation is needed before installing PostgreSQL CMS?
What is PostgreSQL Conversion from Valentina CMS?
I didn't Export User Data before installing PostgreSQL! Is all my user data lost?
After installing PostgreSQL my Smart Content is messed up
What should I be careful of with the new PostgreSQL CMS?
What happens to Valentina CMS when I install PostgreSQL CMS?
How do I know if DIM/DS is using the PostgreSQL CMS or the Valentina CMS?

 

Q: What is CMS?
A: CMS stands for Content Management Service. It's a database which holds information about your content files. This allows DAZ Studio 4 and Carrara 8.5 to provide a number of added features to content, including:
--Smart Content, that knows what items work with other items, such as which figure clothing fits or what materials work on which items.
--Categories and Products, which lets you group content items differently without moving the actual files (which can cause content not to work if done incorrectly).
--Searching content
--Autofit between weight-mapped figures
--Labeling content as materials, shapes, actors, props, etc.
--Adding your own tags to content. 

Q: What's the difference between Valentina CMS and PostgreSQL CMS?
A: Valentina is the database server used by the original CMS. PostgreSQL is a different database server which was introduced in DAZ Studio 4.6.3.50.

Q: Why change from Valentina CMS to PostgreSQL CMS?
A: Over several years of use of Valentina by thousands of DS users, several issues have come up for many users. Database corruption has been a perennial problem for many users. Some users also dislike that Valentina CMS runs all the time, even when DIM (DAZ Install Manager), DS (DAZ Studio), and Carrara aren't running. After trying to solve these problems, DAZ 3D determined that switching to a different database server was the best solution.

Q: Do I have to switch?
A: No, you do not. If you don't install PostgreSQL CMS then DIM and DS will continue to use the Valentina CMS.

Q: Who should NOT install PostgreSQL CMS?
A: 2 groups of people should not install PostgreSQL CMS:
--Carrara 8.5 users: the current version of C 8.5 will only use the Valentina CMS.
--Zone Alarm users: Zone Alarm has a long history of not playing well with PostgreSQL, which has never been fixed.

Q: What are the benefits of PostgreSQL CMS?
A: PostgreSQL CMS has 3 advantages over Valentina CMS:
--It is far more stable.
--It only runs when DIM or DS is running.
--It is much faster if you have a 64-bit OS.

Q: What version of DAZ Studio is needed to use PostgreSQL?
A: 4.6.3.50 or higher

Q: What preparation is needed before installing PostgreSQL CMS?
A: If you have created any custom categories, metadata, or tags, and haven't Exported User Data yet, you should do so. If you only use the metadata that comes with DAZ products, you do not need to do this.

Q: What is PostgreSQL Conversion from Valentina CMS?
A: "Installing" this transfers the data from the Valentina CMS to the PostgreSQL CMS. It takes a while, as the "installation" is the actual transfer of the information. If it only takes a second, it probably didn't work. As noted, the biggest problem with the Valentina CMS was database corruption, which can cause the transfer to fail. This is why I recommended Exporting User Data before installing PostgreSQL.

Q: I didn't Export User Data before installing PostgreSQL! Is all my user data lost?
A: No, the Valentina database is left unchanged when you install PostgreSQL CMS. Just uninstall PostgreSQL CMS and you can launch DS, and it will use the Valentina CMS again so you can Export User Data.

Q: After installing PostgreSQL my Smart Content is messed up -- there's nothing there, or there's 2 of everything, or everything has a yellow triangle with an exclamation point and doesn't work.
A: These can all be caused by trying to convert a corrupt Valentina database. The easiest way to fix it is to reset the database and re-import metadata.
To Reset the Database Right click on the Content Library pane, choose Content DB Maintenance, tick Reset Database, click Accept.
To Reimport Metadata Right click on the Content Library pane, choose Content DB Maintenance, tick Re-Import Metadata, click Accept. Tick User Data and All Products and click Accept.

Q: What should I be careful of with the new PostgreSQL CMS?
A: Since PostgreSQL CMS only runs when DIM (DAZ Install Manager) or DS (DAZ Studio) is running, if either of them is running and you shut it down, it will tell PostgreSQL CMS to shut down also. If you start the other before that step is complete, it's possible for PostgreSQL to be shut down. You'll have no Smart Content and Categories and Products won't appear at all in the Content Library. If this happens, shut down DIM and DS and wait a minute to make sure the "stop PostgreSQL" step is complete.

Q: What happens to Valentina CMS when I install PostgreSQL CMS?
A: Valentina CMS will not be uninstalled and its database will be left untouched. This won't cause problems -- if PostgreSQL CMS is installed, DIM and DS will use it even if Valentina CMS is also running at the same time. Therefore any new content you install or new user data you create will be added to the PostgreSQL database and not to the Valentina database. If you wish to uninstall Valentina CMS you may do so, but it is not required.

Q: How do I know if DIM/DS is using the PostgreSQL CMS or the Valentina CMS?
A: In the log file for both DS and DIM there will be a line that says:
"Connected to CMS: PostgreSQL 9.3.4" if PostgreSQL is being used, or
"Connected to CMS: 4.8" if Valentina is being used.
To view the DAZ Studio log, go to Help -> Troubleshooting -> View Log
In addition, Windows Task Manager will show about 7 instances of postgres.exe under Processes when DIM or DS is running. 

-- Written by Michael Miller

Cristina Galloway May 28, 2014 DAZ 3D Software / DAZ Studio

Installing PostgreSQL for DAZ Studio 4.6.3.50

Open DAZ Studio

Export User Data
To do this, right click on the Content Library pane, choose Content DB Maintenance, tick Export User Data, click Accept.

Close DAZ Studio

Open Install Manager

Download and install the version of PostGreSQL appropriate for your OS 

Download and install the Conversion product "PostgreSQL CMS From Valentina CMS Conversion". (If it takes less than a couple of seconds it didn't work, likely due to a corrupt Valentina Database.)

You are done! You should now be able to use DAZ Studio as you have in the past. 

 

If your Database was corrupt so the Conversion did not work correctly, and you open DAZ Studio and your smart content pane is not properly set up after following the above steps.  

Reset the Database
To do this, right click on the Content Library pane, choose Content DB Maintenance, tick Reset Database, click Accept.

Reimport Metadata with the box checked that userdata overwrites product data.
To do this, right click on the Content Library pane, choose Content DB Maintenance, tick Re-Import Metadata, click Accept. Tick User Data and All Products and click Accept.

This article can also instruct you on how to re-import metadata:

https://helpdaz.zendesk.com/entries/22523891-Trouble-shooting-the-S...

 

Please see this forum thread for more information:
http://www.daz3d.com/forums/viewthread/41482/

Cristina Galloway May 22, 2014 DAZ 3D Software / DAZ Install Manager

 

How do I download my purchased items from my account?

001.jpgThis image shows you a “Ready to Download” screen populated with the files waiting in our account.

You are able to see the Product Name and can tell immediately if the file is new and waiting for Download, or if it is an Update as seen with “Ethnicity” and “Evolution” morphs in our example.

If you are logged in, and have no files listed, this means you have nothing new to download. If you are sure you have new files, make sure you are logged in to the correct account, and that you are not “Working Offline”. Also make sure you are showing any files you may have hidden. The “Display Hidden” box should be checked if you have hidden files and wish to see them.

NOTE: There are several advanced options for viewing and managing files in the Right-click context menus. Please refer to the Reference Guide for more information on these features.

You now have the following choices:
Download All Files - Check the “Product Updates” or “Products” boxes and all your files will be selected under each header. Click “Start Queue”.
Download Selected Files - This is the same, but instead, individually select the files you want to download. This is good if you run multiple programs and want to download to separate locations. Again, click the “Start Queue” once you have made your choices.
Download One File at a Time - To download a single file in the list, you can click the “Download” button to the right of the file you want to download.
Install after Download - If this check box is ticked, anything you download will install immediately after download. The files will install to the location you have set in “Settings”, so if you have multiple locations, make sure you have the correct one selected before choosing this option.
View the Product Documentation - You can view a product's online documentation at any time by clicking the “i” to the far right of the Product Name.
Clear Queue - You can clear your selections at any time by clicking the Clear Queue button.
Show Details - If this check box is ticked, you can see the installation paths of your content, plugins and software.

 

NOTE: Checking the “Install After Download” box will do exactly that. As soon as the Zip is downloaded it will install to the currently selected location. This goes on even if you are still downloading other files. If you want to install files to different locations, make sure to uncheck this box.

 

Why is my screen not showing my most recent stuff?
002.pngClicking the Refresh Button causes the lists on the Ready to Download PageReady to Install Page and Installed Page, in the Product Status area, to be rebuilt from the information available at that moment in time. For the average user, this is useful for causing the list on the Ready to Download Page to refresh when a new purchase has been made on the DAZ 3D store, after you have already signed in to your account with Install Manager. For the advanced user, this is also useful if you have made changes to the downloads folder or configuration files while the application is running.


Parent Elements

Below is a list of interface elements that the Refresh Button can exist within:
Main Window – The main window of the application.


How and where do I set up my download locations?
Step 1
003.pngOnce you have logged into Install Manager you will see this screen.

In the top right corner is a small Gear icon. This is where you access your settings.

Click the “Gear icon” now.

 

Step 2
004.pngYour Settings window has several Page and options:

Accounts - This will list the account(s) you have added - These can be edited by right-clicking the account name. You can not edit the account you are currently logged into.
Downloads - Allows you to set the location to save your downloaded files
Installation - Allows you to set and add Content (Runtime) install paths
Applications - Lists the location (paths) of your supported applications
+/- - Add/Remove Accounts on the Accounts Page, or Install Locations on the Installation Page
Show Log - Click this any time you need to review the log file
Help - Link to online documentation like this User Guide
Show Tool Tips - Toggle Tool Tips on and off

 
NOTE: You can click the ” + ” in the bottom left corner of the Accounts or Installation pages to add accounts/locations at any time, as needed. Remember, each account can have different download locations and preferences.

For more advanced information on these Features, please see: User Interface (UI)

We will now move to the Downloads Page to begin telling IM where we want things to go…

 

Step 3
005.pngThe Downloads and Installation pages are where most of your customization will take place. In Downloads, you tell the application where to save the files you download from your store account.

Download To Where - Click the ” … ” browse button and choose the location you want the application to save any content installers it downloads from your account. This can be on your local drive, or an external location. For help on downloading files from your account, please see Downloading With Install Manager (WIP)

Using the application Show filter - Sometimes finding what you want in your account can be a bit daunting. Especially if you have a large catalog of purchases. In this section, you can filter the products by the application(s) you choose. Different combinations will give different results. If you are expecting a file you do not see, try adding another filter to your selection. Older files are backwards compatible, with some exceptions. This means if you have DAZ Studio 4.5 selected you will see more content than if you select DAZ Studio 3. DS 3 will not read .DSF (DS 4) or .DUF (DS 4.5) files so any of this type content would be filtered out. DS 4.5 will read all files extension, so you would see a great deal more products listed.


Once you have your location added, switch over to the Installation Page…

 

Step 4
006.jpg64 bit Software – This is the location your 64 bit software installs to.
32 bit Software - This is the location your 32 bit software installs to.
Unless you install Program Files to a different drive than the defaults, you should not change these.

Allow Shortcuts – If you want shortcuts to show up on your desktop or in your Start menu, then tick these check boxes.

Content Updates – You can choose to install content updates to Respective “Installed” Paths (original installation path) or to Selected Path.

Current - If you use one program and have a single location set for content installation, you will see “Recommended DAZ Studio/Poser Content Folder”. If you use multiple programs such as DAZ Studio, Poser and Carrara on the same machine, you may have multiple content locations mapped. If you add your various folder paths, you will be able to choose where you want your content to be installed at any given time. For more on this please see Installing With Install Manager (WIP).

To change the Recommended DAZ Studio/Poser Content Folder location, you need to add a new path. Click on the "+" at the bottom left of the screen and browse to the installation path and click "Accept".

Now you should see both paths listed. If you no longer need the Recommended DAZ Studio/Poser Content Folder installation path, you can delete it by clicking "-" with the path selected.

To add another location, click the ” + ” button in the lower left corner and browse to the folder location you want to add. Once it is added, you can now select it from the drop down list below.

Any added locations will now be available in the Current: drop-down selection below.


NOTE: It is highly recommended that you choose an install location that is different than you currently installed content.

Step 5
007.jpgThe Applications tab simply shows a list of paths where recognized software is located.

To add an installation path for your software, click on the "+" at the bottom left of the screen, choose the application name, version and bit; click the "..." button and browse to the installation path of your application and click "Accept".


When you are done, select “Accept” and the settings window will save your changes and close. You will now be back in the main interface.

 


How do I sort and filter my content?

Sorting
008.png

You can quickly sort your files by “A to Z” or by several other options. The “Sort Order” drop-down contains the following selections:

Name: A to Z - Sorts the list by descending alphabetical order.

Name: Z to A - Sorts the list by ascending alphabetical order.

Product ID: Highest First - Highest ID, in descending order.

Product ID: Highest First - Lowest ID, in ascending order.

Download Size: Largest First - Largest Zip size, in descending order.

Download Size: Smallest First - Smallest Zip size, in ascending order.

Download Date: Recent First - Newest downloaded, in descending order.

Download Date: Oldest First - Oldest downloaded, in ascending order.

Order Date: Recent First - Newest purchases, in descending order.

Order Date: Oldest First - Oldest purchases, in ascending order.

Status: Busy First - Active Zips in Queue, in descending order.

Status: Idle First - Idle Zips in Queue, in ascending order.

Selection: Selected First - Selected Zips in Queue in descending order.

Selection: Non-Selected First - Non-Selected Zips in Queue in ascending order.


Filtering
009.png
Filtering in Install Manager is very easy, but also has very advanced filtering modifiers available. We will cover the basic keyword filtering below. Please refer to the Reference Guide section on Advanced Filtering for more ways to view the products you want to see, and how you want to see them.

If you want to filter your file view to show only specific files, you can type your chosen keyword in the “Filter Field” as shown in the left-hand image below. We used 'Genesis'. Only products with the keyword 'Genesis' in the name, are showing. You can also use phrases. If you know all or part of a product name, type it in and the filter will show any products with that particular 'phrase'.

The nice thing about this feature is that is keeps your checked selections as you change filter words. Here, we are going to check the selection boxes for 'Genesis'.

In the right-hand image below, we left our “Genesis” filtered products checked, and then filtered by 'Victoria' and checked these products as well. When we return to our full list of products, you can see both filtered selections we made remain checked. The “Genesis” products remained checked, even when we ran a new filter and added the other product for “Victoria”.

The filtering feature works across all the status windows. By this, we mean if we have 1 product with “Genesis” in its name already “Installed”, and 6 waiting in “Ready to Install”, we will see all 7 products. You can see this in our “Genesis” example here. We installed the Gorilla product from our previous filtering exercise. You can now see we only have 6 left in Ready To Install, and 1 is now listed in Installed.


NOTE: You can do the same thing using the SKU number to find a particular product. Just put the number, for example, sku::12356 (or a range of numbers sku::12350-14350 in the Filter Field. Please see: Advanced Filtering for more advanced filtering options.



Cristina Galloway May 16, 2014 DAZ 3D Software / DAZ Install Manager

If you are unable to log in to your account in the DAZ Install Manager, here are some things you can try:

Create a new account in the Install Manager. Use a different name but the same email and password. You can do this by choosing "Add Account" from the Account drop down.

If this does not resolve the issue, please review these troubleshooting tips:

TROUBLE-SHOOTING LOGGING IN WITH DAZ INSTALL MANAGER

♦ Accept EULA 
If you have not yet accepted the EULA, you will not be able to log into DIM. The EULA is here: https://www.daz3d.com/eula

♦ Correct Login Information
Make sure you use the correct e-mail address and password. If you have two DAZ 3D user accounts, make sure you use the one that have your account history. You can configure DAZ Install Manager to access more than one account. You must provide the correct e-mail address and password for each one.
**PLEASE NOTE: The email and password on the website in your account must match exactly to the email and password in the Install Manager. For example: If you have a capital letter in your DAZ account email (Name@url.com), but not in your Install Manager (name@url.com), the log in will fail.

♦ Third-party Software (uncommon)
Some third-party software can potentially interfere with DAZ Install Manager. The most likely kinds are firewalls and antivirus software. You may need to disable or configure this kind of software to prevent it from blocking DAZ Install Manager. This is reason is uncommon compared to the first two above.

♦ If you are still not able to log in, reset your password in your main account (www.daz3d.com) and then try again to log into Install Manager, using the new password.

♦ If you are *still* not able to log in, contact customer support to reset your password and look into the issue further. 

Kraig Hausmann December 30, 2013 DAZ 3D Software / DAZ Install Manager

Some users want or need to choose a different path from the default content path. This article provides support for choosing a valid path.

 

You can find and edit the path to which Install Manager installs content here in Install Manager:  Configuration Settings --> Installation --> Label/Path.  Do not confuse this with the paths given for application software (64-bit Software, 32-bit Software) in the same window.  These paths should *not* be changed as they are based upon your actual application folder.

 

The path to which Install Manager installs DAZ Studio and Poser format content is shown below in the purple bounding box.

 

IM_Default_Content_Path.png

By default, DAZ Install Manager (DIM or IM) will install content to this path:

 

WINDOWS

C:\Users\Public\Documents\My DAZ 3D Library

MAC

Users\Public\Documents\My DAZ 3D Library

 

Unless you have a special need for a different path, you should use the above one.  Some users, however, may need to change the path. For example, they may need to have content installed on a different hard drive or volume than the root drive.  Here are some guidelines to help you choose a valid path.

 

Don't Mix Content with an existing content directory

Users may want to have all their content installed to the same directory.  There are some good reasons for this.  However, it is not recommended to have content installed by IM installed to the same path as content installed by another method, such as the Bitrock installers or manual installation of content.  Here's the reason why.  Install Manager can only uninstall content which it has installed.  If you used a different method, such as Bitrock or a manual unzip, Install Manager will not be able to uninstall that content.  Once you have the two methods mixed together, you are sure to have issues.  By keeping the content separate, you can keep track of whether you used install manager to install that given content product.  Worse, if you have a content product installed by two methods to the same path, then you could have conflicting file versions. For this reason, we strongly advise users to keep Install Manager content confined to its own path and not to use the same path or share the same path as content installed by a different method.

 

Avoid Embedded Paths

Do not choose a content path that is inside of another path.  If you already have this as your content path:

WINDOWS
c:\My Content Folder

MAC
\MacHD\My Content Folder

Then you must not choose any folder inside of it.  For example, any of these:

WINDOWS
c:\My Content Folder\[subfolder]

MAC
\MacHD\My Content Folder\[subfolder]

 

Windows Users should not install to the Program Files Folder

Starting with Windows Vista, Microsoft introduced Windows File Protection.  Files inside of the Program Files folders (32-bit and 64-bit) are meant to be reserved for applications files.  This means that content files should *not* be installed inside of either of these folders.  This is true regardless of the method of installation used. This is why the default path is outside of the Program Files folders.

 

How to change the content path

Several things are configurable in Install Manager. This is how to change the path that it installs content to. This is just for content, not for plugins. In Install Manager, click the configuration button in the top right. It looks like a gear.  In here, click on 'Installation.'  In the 'Installation' Tab, look at the lower half of the tab.  Under Label and Path, you'll see the current path for content installed by Install Manager.

Click the Plus (+) button on the bottom left. You'll have two fields. The first is your label for the path you are adding and the second is the actual path itself.  The label you give is your choice and only needs to make sense to you. The path below needs to correspond to the path you have chosen. After you have both fields completed, click 'Accept.'  You should now see the path appear below Label and Path. The last thing to do is to designate this as the active path.  See 'Current' on the bottom. Click the drop-down arrow and make sure the path you've added is selected.  Now press 'Accept.'  Now Install Manager will install content to the new path you set up.

 

Mapped Content and added Runtimes

Keep in mind that the path that you install content to must be added in your application.  This means in Studio, the path needs to be mapped. In Poser, the runtime needs to be added. This enables your chosen application to see and use the installed content.

 

ADDITIONAL HELP

If you need more help with this issue from DAZ 3D Technical support, please be sure to include the following information with your request:

♦ The platform and version you are using (For example: Mac 10.7, Windows 7, 64-bit, etc.)
♦ The application and version you are using (Poser Pro 2012, DAZ Studio 4.6.1.39, etc.)
♦ The path that you have content installed to. A screen shot is often very helpful:

How to Make A Screen Shot of the Content Path in DAZ Install Manager

https://helpdaz.zendesk.com/entries/23679232-How-to-Make-a-Screen-S...

♦ The paths you have mapped in Studio (or the runtimes you have added in Poser):

How to Make a Screen Shot of Mapped Content in DAZ Studio 4

https://helpdaz.zendesk.com/entries/22979732-how-to-make-a-screen-s...