Loading...
> >

Categories disappeared / deleted by daz :-(

Lonesome CowboyLonesome Cowboy Posts: 158
edited April 2023 in Daz Studio Discussion

Hi there,

suddenly some of my categories are deleted, but not all. What happened and how do I get it back? Does anyone know where the categories are stored?
I've already tried restoring the userdata, but if that's the userdata, then that could explain some categories being there and some not.
Does anyone know how i can repair this?
Thanks

empty_categories.jpg
341 x 769 - 68K
Post edited by Lonesome Cowboy on

Comments

  • Richard HaseltineRichard Haseltine Posts: 101,051

    I would expect temp to be all Userdata, but I am not clear what is happening or what you expect to see there.

  • Lonesome CowboyLonesome Cowboy Posts: 158
    edited April 2023

    i created a lot of categories during last months.

    Now suddenly lot of them disappeared and these entrys are empty now :-(

     

    Post edited by Lonesome Cowboy on
  • barbultbarbult Posts: 24,257

    Reimporting user data is only useful if you explicitly exported it before the problem occurred.

  • crosswindcrosswind Posts: 7,004
    edited April 2023

    The user-defined categories and assignment are stored in cms database. You have to Export User Data right after you make mass change to them. In case you loss your categories / assignment, you may Re-Import User Data as above-mentioned.

    But be noted that re-importing User Data will bring you some 'wrong data'  i.e. the 'user defined categories' will turn into 'vendor categories' . You're not able to rename them if you wanna do so.... I think it's a 'little bug'...

    In this case, use a PostgreSQL management software to connect to cms database and make field value change of your categories:

     

    Post edited by crosswind on
  • Richard HaseltineRichard Haseltine Posts: 101,051

    crosswind said:

    The user-defined categories and assignment are stored in cms database. You have to Export User Data right after you make mass change to them. In case you loss your categories / assignment, you may Re-Import User Data as above-mentioned.

    But be noted that re-importing User Data will bring you some 'wrong data'  i.e. the 'user defined categories' will turn into 'vendor categories' . You're not able to rename them if you wanna do so.... I think it's a 'little bug'...

    All non- Local user metadata is Vendor data, with the exception of Usernotes and Userwords https://www.daz3d.com/forums/discussion/comment/1000831/#Comment_1000831 .

    In this case, use a PostgreSQL management software to connect to cms database and make field value change of your categories:

    Manual editing of the database is not supported - "on your head be it."

  • crosswindcrosswind Posts: 7,004

    Richard Haseltine said:

    crosswind said:

    The user-defined categories and assignment are stored in cms database. You have to Export User Data right after you make mass change to them. In case you loss your categories / assignment, you may Re-Import User Data as above-mentioned.

    But be noted that re-importing User Data will bring you some 'wrong data'  i.e. the 'user defined categories' will turn into 'vendor categories' . You're not able to rename them if you wanna do so.... I think it's a 'little bug'...

    All non- Local user metadata is Vendor data, with the exception of Usernotes and Userwords https://www.daz3d.com/forums/discussion/comment/1000831/#Comment_1000831 .

    In this case, use a PostgreSQL management software to connect to cms database and make field value change of your categories:

    Manual editing of the database is not supported - "on your head be it."

    Thanks for the clarification! I learnt some 'tricks' from this old thread ~ I just tried replacing guid with the string of zeros in dsx file, however, it did not work. The imported metadata was still 'Vendor Data'... will further test it.

  • Lonesome CowboyLonesome Cowboy Posts: 158
    edited April 2023

    thanks. I have saved them a long time ago ... so i was able to reimport a part of it.

    @crosswind: i cannot enlarge your images. The screenshot of your sql-editor a bit and the small image is not possible to enlarge it :-(

    What  SQL-Editor are you using and how can i connect to my database?
    I know only phpmyadmin, but it is for the web.

    Post edited by Lonesome Cowboy on
  • crosswindcrosswind Posts: 7,004
    edited April 2023

    Lonesome Cowboy said:

    thanks. I have saved them a long time ago ... so i was able to reimport a part of it.

    @crosswind: i cannot enlarge your images. The screenshot of your sql-editor a bit and the small image is not possible to enlarge it :-(

    What  SQL-Editor are you using and how can i connect to my database?
    I know only phpmyadmin, but it is for the web.

    Just right click on the pics and open the big screenshot from the popup menu... As for the connection to cms, pls check this: https://www.daz3d.com/forums/discussion/431056/postgresql-question-solved. I use Navicat for PostgreSQL.

    Post edited by crosswind on
  • Richard HaseltineRichard Haseltine Posts: 101,051

    crosswind said:

    Richard Haseltine said:

    crosswind said:

    The user-defined categories and assignment are stored in cms database. You have to Export User Data right after you make mass change to them. In case you loss your categories / assignment, you may Re-Import User Data as above-mentioned.

    But be noted that re-importing User Data will bring you some 'wrong data'  i.e. the 'user defined categories' will turn into 'vendor categories' . You're not able to rename them if you wanna do so.... I think it's a 'little bug'...

    All non- Local user metadata is Vendor data, with the exception of Usernotes and Userwords https://www.daz3d.com/forums/discussion/comment/1000831/#Comment_1000831 .

    In this case, use a PostgreSQL management software to connect to cms database and make field value change of your categories:

    Manual editing of the database is not supported - "on your head be it."

    Thanks for the clarification! I learnt some 'tricks' from this old thread ~ I just tried replacing guid with the string of zeros in dsx file, however, it did not work. The imported metadata was still 'Vendor Data'... will further test it.

    The relevant sections is "... in the event of a collision between data elements defined by a user and data elements defined by a vendor, the data elements defined by a vendor will typically replace those defined by the user." If the data, as Vendor data, is already in the database then reimporting as userdata (zeroed GUID) will be ignored, the vendor data takes precedence.

  • crosswindcrosswind Posts: 7,004

    Richard Haseltine said:

    crosswind said:

    Richard Haseltine said:

    crosswind said:

    The user-defined categories and assignment are stored in cms database. You have to Export User Data right after you make mass change to them. In case you loss your categories / assignment, you may Re-Import User Data as above-mentioned.

    But be noted that re-importing User Data will bring you some 'wrong data'  i.e. the 'user defined categories' will turn into 'vendor categories' . You're not able to rename them if you wanna do so.... I think it's a 'little bug'...

    All non- Local user metadata is Vendor data, with the exception of Usernotes and Userwords https://www.daz3d.com/forums/discussion/comment/1000831/#Comment_1000831 .

    In this case, use a PostgreSQL management software to connect to cms database and make field value change of your categories:

    Manual editing of the database is not supported - "on your head be it."

    Thanks for the clarification! I learnt some 'tricks' from this old thread ~ I just tried replacing guid with the string of zeros in dsx file, however, it did not work. The imported metadata was still 'Vendor Data'... will further test it.

    The relevant sections is "... in the event of a collision between data elements defined by a user and data elements defined by a vendor, the data elements defined by a vendor will typically replace those defined by the user." If the data, as Vendor data, is already in the database then reimporting as userdata (zeroed GUID) will be ignored, the vendor data takes precedence.

    Yea, understood. Actually I did delete the categories and assignment I created before re-importing and also tried CTRL + Export Product Metadata, the results were the same... crying   will try it again tomorrow...

  • Saxa -- SDSaxa -- SD Posts: 872
    edited April 2023

    used:     Metadata Exported using "Content DB Maintenance..." : Export User Data:   Any dsx files produced by this method are considered User Data when (re-)imported.

    Still had locked category directories.   Yet supposedly this was UserData, yet you are seeing Vendor Data for all data rows?  Just looking quick, unsure if you are working with basic defaults or a your own custom data tables (categories defined).  Never looked myself.

    2 times was using the category save .dsx files (once  was to populate a new PC). 

    The fix was did "a workaround and duplicate everything to another temp folder.  Once duplicated, my ability to rename is restored.  But this is a bit of work."  Had sent this to DAZ via ticket. Response was this is currently unfortunately normal.

    So if you do find a faster way of editing PostgreSQL, would be very interested to hear about it.  For eventual next time. smiley

     

    Post edited by Saxa -- SD on
  • crosswindcrosswind Posts: 7,004
    edited April 2023

    Saxa -- SD said:

    used:     Metadata Exported using "Content DB Maintenance..." : Export User Data:   Any dsx files produced by this method are considered User Data when (re-)imported.

    Still had locked category directories.   Yet supposedly this was UserData, yet you are seeing Vendor Data for all data rows?  Just looking quick, unsure if you are working with basic defaults or a your own custom data tables (categories defined).  Never looked myself.

    2 times was using the category save .dsx files (once  was to populate a new PC). 

    The fix was did "a workaround and duplicate everything to another temp folder.  Once duplicated, my ability to rename is restored.  But this is a bit of work."  Had sent this to DAZ via ticket. Response was this is currently unfortunately normal.

    So if you do find a faster way of editing PostgreSQL, would be very interested to hear about it.  For eventual next time. smiley

     

    Still it seems that standard Ds function does not work for me. I still prefer to DB maintenance though I rarely do so... unless absolutely necessary. blush

    Post edited by crosswind on
  • Saxa -- SDSaxa -- SD Posts: 872

    crosswind said:

    Still it seems that standard Ds function does not work for me. I still prefer to DB maintenance though I rarely do so... unless absolutely necessary. blush

    You gonna file a ticket to see what CS says is normal for standard DS function?  Think its awesome you tried and posted it.  Just did that workaround as wasn't motivated enough to try and figure out  SQLmgr and if can quick change a DB record.

Sign In or Register to comment.