I made a libre-office function to generate a link to daz store from the rendo csv.
What you need to do:
1/ open the ods file in the enclosed zip. This is a spreadsheet with only one cell set (I1).
2/ download the csv from your account at rendo and open it
3/ copy the I1 cell in table 1 and paste it to column I in your csv
4/ now you have at column I a link that will lead you directly to the daz product page (it it exists).
The link is based on the name of the product and the conversion seems to be robust enough. I have a big bunch of Lilflame products and all the links of transferred products where correct.
This way, tt is now possible to rapidly "hide this product from listings" by clicking on the product link.
Note 1: Should also work with excel and open office, but I have no way to test it.
Note 2: Depending of your spreadsheet config, you may have to "ctrl-click" to open the link
Note 3: Untested for Fabiana, wolfie (and the next is probably Lully that has emptied her products at rendo)
The function that I posted a few days ago to process rendo csv files was partly broken.
Basically, to create the daz link, so that you can hide already owned products, one needs to converts punctuation-like characters in the product name to a unique dash. And it happens that 3D-Arena had in the names of her products characters that were not considered by the conversion...
So here is a new corrected version that should be more robust, even if new migrating artists arrive with weirder chars in their product names.
=HYPERLINK(CONCATENATE("
You must be registered to see the links
";LOWER(REGEX(SUBSTITUTE(C1;"(s)";"-s");"[ -._/:!~^'#|&=?]+";"-";"g"))))
Paste it at line 1 in the column that your want, for instance i. Then copy it and paste it in the line where you want to create the potential daz link.
I also noticed some other situations where the converted link was incorrect. For instance, from time to time, daz adds a trailing dash to the link (probably to avoid duplicate links), but it is very rare and there is no way to generate it automatically.
Otherwise all the conversions that I tested were correct.