Cristina Galloway June 19, 2014 • DAZ 3D Software / DAZ Studio
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).
--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 126.96.36.199.
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: 188.8.131.52 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
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:
Please see this forum thread for more information:
Cristina Galloway May 22, 2014 • DAZ 3D Software / DAZ Install Manager
This 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?
Clicking the Refresh Button causes the lists on the Ready to Download Page, Ready 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.
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?
Once 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.
Your 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…
The 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…
64 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.
The 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.
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 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: