Refresh my Memory...how to export/import my library into a spreadsheet?

Subtropic Pixel

I'm thinking of trying the RRRR challenge this month, but can't for the life of me remember how to create a list from my product library (either from my account or from DIM) and then get it imported into a numbered list or spreadsheet for preparation for a randomizer run.

Can somebody run this down for me?

Lissa_xyz

In DIM, select everything you want to export, then right click > export to CSV. You may need to do each tab separately, I don't remember off hand.

Subtropic Pixel

Thanks!

I am thinking of maintaining it in a spreadsheet so that I can assign a normal number range and a special number range for those items that don't apply for RRRR contests. The biggest challenge will be how to quickly refresh the list after I make purchases. Without having to reprocess the whole numbering scheme.

Subtropic Pixel

Follow up question:

I have some ancient stuff in my library such as Millennium Man Michael 1/Victoria 1, Girl 2, and so forth. But I never use them. NEVER. So an RRRR challenge would not be fun for me if I got a pull that included one of those old models. And it wouldn't even be good practice for me to force myself to struggle with those fingers, toes, elbows, and knees of the older figures. I prefer to stick with Genesis 1 or Genesis 2 figures because they are simply more interesting and better practice for me.

When pulling for an RRRR, how do other people deal with their legacy products that don't really apply anymore and/or have been replaced by newer, more relevant version 5 or version 6 figures?

fixmypcmike

Subtropic Pixel said:

The biggest challenge will be how to quickly refresh the list after I make purchases. Without having to reprocess the whole numbering scheme.

You could add a separate column in your spreadsheet for numbering. When you make a new purchase you generate the spreadsheet from the Ready to Download or Ready to Install tab, and just copy those entries to your main spreadsheet.

As for skipping those items you never use, assuming you don't install them, delete the zips from the downloads folder, then on the Ready to Download tab you can hide them.

ZarconDeeGrissom

Because this is from DIM, it dose not include stuff from elsewhere. I had to manually enter all my Wilmap stuff by hand into that csv, and it is now about a month out of date. lol.

Subtropic Pixel

Heh, this is turning out very well!

I have a two-sheet XLSX spreadsheet, in Excel 2013 format.

On Sheet 1 I have a simple table of up to 10 numbers that came from the randomizer.
On Sheet 2 I have my whole library as exported from DIM.

I've employed some conditional formatting to help with the usage and maintenance of the spreadsheet. The former for quickly identifying products that were pulled, and the latter for keeping it current with my DIM library, and for avoiding unnecessary pulls of products not applicable for an RRRR.

This is just the way I did it to help me deal with my current library of over 1,300 items, about 25% of which are not applicable for RRRR. Here's a series of graphics to show what I did; should make my randomizer list easier to maintain and very fast to use.

zawarkal

karibousboutique created spreadsheets for the RRRR which include a built-in random generator...
you can find the particulars by reading from this thread post on...

http://www.daz3d.com/forums/discussion/19109/P150/#294313

I use the open office org version and it works great.

I have a tab created for each store that I wish to include. Each tab has 3 columns. Store name, Item Name, RRRR Y/N include flag -- I can decide if I wish to include an item or not. I do not include any item that I refuse to use.

I then have a tab in which I copy/paste each individual store's items all into one page. At this point I sort the items by RRRR flag in Descending and Item Name in Ascending.

Next I simply copy/paste the list of names onto the first RRRR page created by Karibousboutique and provide the numbering sequence required to use the spreadsheet at that point. Simply identify how many items and click for the pull.

Once the initial setup is done then it is only necessary to add new items as you go along.

Ken OBanion

I built my original spreadsheet by just copying-and-pasting from my products library.

Then I slapped together a little program (in VB.NET, if anyone is interested), to read that spreadsheet into a SQL Server database, which I built to sit under a content-management application I'm constructing. (After almost a decade of accumulating content for both Poser and DAZ Studio, I really had to do something to keep track of it all!) As I work with it, I'm fleshing out the details -- purchase date, artist, content type (figure, character, prop, scene, and such), the product's Readme file, and other stuff.

I'm also working on a system of 'tags' that I can use to search for specific items, or content associated with a particular figure, genre, or whatever.

Finally, I threw in an RRRR utility that does the random pulls. I even included the "lucky bastard" option!

As they say, anything worth doing, is worth over-doing....

Miss B

Thanks for this. I don't usually participate in the RRRR challenges, but something like this always piques my interest. :coolsmile:

Zawarkal said:

karibousboutique created spreadsheets for the RRRR which include a built-in random generator...
you can find the particulars by reading from this thread post on...

http://www.daz3d.com/forums/discussion/19109/P150/#294313

Subtropic Pixel

This is really cool to see how other people are doing it. Thank you all for your input!