Product Library - how do you make a printable list of purchased products?

Is there a way to compile a list of the products I have purchased and then print that list out? Is there any way to sort that list prior to printing (exp: V4 items, Genesis items, etc.)?
Thanks!
Comments
If you use the DIM (Daz Install Manager) this is a semi easy process. Let me know.
Like Jad said if you use DIM it very easy. You go to the installed tab select all products by selecting the check box select all the right click and select Export Selected to CSV
Further to Frank's suggestion to export to CSV, you can then import the CSV into an Excel spreadsheet, which can then be printed.
I usually deselect the items I don't want in the CSV, so if you just wanted, for example, the product name and SKU number, you can deselect everything else before exporting to CSV, and you're all set. It takes 2 simple steps in a plain text editor, such as Notepad (or the Mac equivalent), to get the CSV in a format Excel can use so that you have separate columns for each piece of info for each item listed in the CSV. If you'd like to know how to do that, let me know.
The Free use LibreOffice will load the CSV right into its Spread Sheet Prg with the columns and rows as set by the DIM CSV and you can sort from there and print as well. No hand editing needed. LibreOffice will also then Save the file out in many formats supported by the paid for tools.
I keep forgetting about LibreOffice, or OpenOffice, which is the version I think I had on my old laptop. This one has MS office, so I'm back to using Excel again.
The reason I open the CSV with a text editor is so I can delete quote marks, and then substitute the commas DIM automatically places between each item in the exported CSV, to tabs. That way I can copy it all and paste into a new Excel spreadsheet with all the columns set up. Only have to adjust a column(s) width if the info in that column is wider than the default column width.
I know a lot of apps will allow you to pick the delimiter set for a CSV (Excel does), but I don't think DIM does. If it does, I'd sure like to know how, as that would mean one less step. :coolsmile:
I keep forgetting about LibreOffice, or OpenOffice, which is the version I think I had on my old laptop. This one has MS office, so I'm back to using Excel again.
The reason I open the CSV with a text editor is so I can delete quote marks, and then substitute the commas DIM automatically places between each item in the exported CSV, to tabs. That way I can copy it all and paste into a new Excel spreadsheet with all the columns set up. Only have to adjust a column(s) width if the info in that column is wider than the default column width.
I know a lot of apps will allow you to pick the delimiter set for a CSV (Excel does), but I don't think DIM does. If it does, I'd sure like to know how, as that would mean one less step. :coolsmile:
I never said you could set it before load in Libre from DIM, just that it did load the CSV as exported with zero need to do any edits. I then use Libre to do any corrections to width and size of columns and rows before I save the CSV out again to a standard format. My point was the CSV as from DIM was usable with zero hand editing in a text editor before loading in LibreOffice.
I never said you could set it before load in Libre from DIM, just that it did load the CSV as exported with zero need to do any edits. I then use Libre to do any corrections to width and size of columns and rows before I save the CSV out again to a standard format. My point was the CSV as from DIM was usable with zero hand editing in a text editor before loading in LibreOffice.
OK, just out of curiosity, I just "opened" my latest CSV file with Excel, which had already been edited as I mentioned above, and it all appeared in one column. I then tried saving it as an Excel spreadsheet, and it didn't ask me how I wanted to set it up as far as columns. I also tried re-saving as a CSV file, but that's a comma delimited file, so it popped up a dialog that there were features (the tabs) in the file that wouldn't transfer properly.
I guess I'll stick to the 2 steps I usually use, as it takes all of 2 or 3 minutes. Thanks for the info though, that's useful for those who do use LibreOffice.
I was simply trying to make things easier for users that may not have Excel or Office and may not understand hand editing Spread sheets. It was not once directed at you Miss B. It was a general help post for any user. Nothing more. CSV files from DIM load straight into the Free off the Net LibreOffice and it is easy to use to get a printout of a users content list from DIM. That was my only goal. To help users that may use the info I posted to do things for themselves fast easy and free of cost.
Oh I know Jade. I wasn't offended by what you said. That's why I tried out your method in Excel, mostly because I thought it would read the tabs I already had in the re-saved CSV. It didn't, so my method is the only way to do it with Excel.
For those who have LibreOffice, it's good to know they can just load it up and it'll separate information into the proper columns. If I still had my old laptop with OpenOffice, I'm sure I'd be doing it with your method. For all I know the OP is on a Mac and may not have MS Office, though there is a Mac version of it, so your method may very well be the one s/he will use.
No offense taken Jade, and none given. :coolsmile:
Oh I know Jade. I wasn't offended by what you said. That's why I tried out your method in Excel, mostly because I thought it would read the tabs I already had in the re-saved CSV. It didn't, so my method is the only way to do it with Excel.
For those who have LibreOffice, it's good to know they can just load it up and it'll separate information into the proper columns. If I still had my old laptop with OpenOffice, I'm sure I'd be doing it with your method. For all I know the OP is on a Mac and may not have MS Office, though there is a Mac version of it, so your method may very well be the one s/he will use.
No offense taken Jade, and none given. :coolsmile:
Hmm, I don't need to do any editing to get Excel 2007 to read it in separate columns.
Hmm, I don't need to do any editing to get Excel 2007 to read it in separate columns.
I'm using Excel 2010, so something might have changed in the newer version. I don't recall having to do so with older versions of Excel, so not sure why. I tried with a CSV I had already edited, so I'm going to re-export one now and try it and see what happens. It just surprised me that the version with the tabs already in it didn't just opening in Excel as I expected.
OK, I just did a quick small CSV export and opened it in Excel 2010, and the Product Name, Product Id, and Package Id all showed up in separate columns, but the tags all came in with commas in one column, which I suppose is a correct interpretation of the CSV export. I like them in separate columns, but that, of course, is just my personal preference.
Since the OP is probably just looking for the the Product Name, and possibly the SKU/Product ID, then it should work fine just opening the CSV in any version of Excel.
Honestly, my eyes glossed over around post #6. I'm getting a cup of coffee and reading that again.
I do know what "Lotis123 for DOS" is, and the OpenOffice/LibreOffice counterpart (I have Open Office v1.0.3) . I also have used CSV files with WL2K, and never elsewhere (radio traffic based topics).
What dose any of that have to do with DIM? Dim can make life easier for me figuring out what figures I do have, and not just barrage me with a list of every single thing under the sun? how?
I am in a position to somehow make a list of all the figures I do have (as there spread all over the Content library), so I have a clue as to what I have.
I would like to separate it out into three categories V4.2, Genesis1, and genesis2. Some of the figures I got were never ported to genesis, and seam to only work on V4.2 natively, thus the third category.
Must be a quiet day.
Well I tediously went threw the "Product Library" in my daz3d account, and painstakingly sifted threw and located each figure I could find in the list.
Then I saved each thumbnail to an empty folder in my documents, to make a simple name and thumbnail-card of sorts. Then I opened that directory in thumbnail view, and made a screen-cap. It took a few hours to go threw each one to see what the newest generation base it would work on was.
I know, it's a pain in the back, however I guess there is no simple way to do that?
There are a few faces there I have yet to see in daz studio, that I forgot about, lol.
Yes, I like the search field and the default filters that have been created for DIM. I've tried creating a few of my own search filters, but haven't gotten very far with it yet.
Here Zar exporting a CSV from DIM. All products you select in the Installed section at one time can be exported, or you can export all at once. The choice is up to the user.
Now that works nicely, for getting everything into a scroll list, rather then it being spread across many web pages. Thanks.
As for the search, I didn't even try it. Not all products include the base in the name (V4, G1, G2F, V6, etc). And some have a deceptive name in a list of everything. Twice I asked "Whom is Anjiru", "O" an outfit, lol.
I am aware that different spread-sheet apps have different options for 'graphic characters', and depending on the program, they can be set up to use the 'graphic characters' to represent different things in the CSV files. Supposedly, editing a CSV in a text editor is not needed, if the program can be told, this character means this or that, Supposedly. I've never had to do that my self, thanks to Lotus123 and OpenOffice (they both speak "RACES Logger" CSV format natively by default).
(Edit)
I forgot about that load options window with Open Office, I just clicked by it like the Flash-player update TOS, lol.