Loading...
> >

New computer, can I edit my Daz Studio 3 content database to work with it?

RiggswolfeRiggswolfe Posts: 905
edited December 1969 in Technical Help (nuts n bolts)

Here's what I mean. I got a new computer and pulled the harddrive out of my old computer. The new computer has an SSD for the OS drive so I put the old hard drive in as another drive. It has my Daz content for Studio 3 and 4. I use 3 to organize older content because I find its categories much easier to use than 4. I have the old content database but the paths for every single item in it show as C:/user/XXXX/documents/etc

I'd like to change that C to the new drive letter. Is there a way to change the paths within a Studio 3 content database?

Comments

  • RenpatsuRenpatsu Posts: 828
    edited September 2014

    Editing the base path should do the trick. Be sure to make a back-up of the database beforehand - just in case.

    Edit: Bah - sorry, this is DAZ Studio 4 actually, not sure if DAZ Studio 3 lets you edit the base path ... I am leaving the pictures in here, perhaps they help to find a similar feature in DS3.

    Screen_Shot_2014-09-07_at_07.31_.43_.png
    598 x 170 - 24K
    Screen_Shot_2014-09-07_at_07.30_.32_.png
    359 x 293 - 53K
    Post edited by Renpatsu on
  • RiggswolfeRiggswolfe Posts: 905
    edited September 2014

    I believe that is only doable in Daz 4.6 and not 3 correct? I'd like a way to edit the database directly if possible so I can just change the paths there.

    Post edited by Riggswolfe on
  • RenpatsuRenpatsu Posts: 828
    edited December 1969

    Yes, sorry, not sure what is all possible in DAZ Studio 3 anymore. Potentially you could export user data and then edit the paths (with search and replace) in an editor. Once on the new PC re-import after the database had been cleared there.

  • RiggswolfeRiggswolfe Posts: 905
    edited December 1969

    I've already gotten the new computer and everything is set up. That's why I wonder if there is a way to edit the paths within the content database itself. I have something made by Doctor Jellybean that lets you look and copy some stuff but it doesn't change the paths.

  • fixmypcmikefixmypcmike Posts: 19,583
    edited December 1969

    Adamr001 had a tutorial on how to do this, but it was in the old forum which is currently unavailable. What you need to do is open the DS3 content database in a SQL editor (I use the SQLite Manager plugin for Firefox), export the tables to a text file, edit the paths, and re-import them.

  • RiggswolfeRiggswolfe Posts: 905
    edited December 1969

    Does it matter what kind of SQL editor? Will MySQL work?

  • fixmypcmikefixmypcmike Posts: 19,583
    edited December 1969

    I'm not sure -- I would think any SQL editor would work, so just make sure to make a backup first and try it.

  • RiggswolfeRiggswolfe Posts: 905
    edited December 1969

    Hmmm...I downloaded firefox and that plugin. I exported it to a CSV and made the changes but am getting errors about nulls in some fields so it won't reimport....

  • RiggswolfeRiggswolfe Posts: 905
    edited December 1969

    And I exported it as a .sql file, opened it in notepad++ and a quick find/replace later and I'm good. Thank you soooo much! Recategorizing all of that stuff was going to be a nightmare!

Sign In or Register to comment.