I was asked to start this thread due to people finding the new Itemized Order History on the new DAZ site a cumbersome tool. Someone suggested a spreadsheet, and I decided to try it. It helps me keep my sanity, and I suggested it to others. They in turn asked for a little tutorial as a PDF offered here, so others can find it later.
As a total bonus, I copied and pasted into Libre Office and it kept the links to the order number and the reset option, how cool is that!! I can click on the order number, say of a bundle and see at a glance what was in it and of course copy and paste thier individual information into the sheet!! Thanks again, this is awesome!!!!
As a total bonus, I copied and pasted into Libre Office and it kept the links to the order number and the reset option, how cool is that!! I can click on the order number, say of a bundle and see at a glance what was in it and of course copy and paste thier individual information into the sheet!! Thanks again, this is awesome!!!!
I’m glad you re finding it helpful. I mentioned the links carry over in the doc, but forgot to mention it in the post. I’ll edit the description to let people know how to record their bundles, too. Thanks for adding that tip :D
My favorite part is I can reset straight from the spreadsheet. :D No messing with that annoying IOH other than updating the spreadsheet after purchases.
As a total bonus, I copied and pasted into Libre Office and it kept the links to the order number and the reset option, how cool is that!! I can click on the order number, say of a bundle and see at a glance what was in it and of course copy and paste thier individual information into the sheet!! Thanks again, this is awesome!!!!
How are you seeing what’s in your bundles? Are you resetting the item, or is there something I’ll not doing in the order/invoice page?
I’m glad to see I’m not the only one who likes using spreadsheets. Fortunately, I set up my spreadsheet in Excel “before” the old store closed, so I was able to get it in descending date order, which is the way I prefer to access it. Now it’s so nice and easy to check if I’ve already purchased something, at least until they get the “you’ve already purchased this” fixed in the store.
As a total bonus, I copied and pasted into Libre Office and it kept the links to the order number and the reset option, how cool is that!! I can click on the order number, say of a bundle and see at a glance what was in it and of course copy and paste thier individual information into the sheet!! Thanks again, this is awesome!!!!
How are you seeing what’s in your bundles? Are you resetting the item, or is there something I’ll not doing in the order/invoice page?
oops i randomly clicked on a bundle order from the spreadsheet and the order page came up with lots of things on, however I had actually ordered a lot of stuff with the bundle. when i clicked on another order with a bundle it was just the bundle However the Fun with Bundles thread is here in the old forum http://forumarchive.daz3d.com/viewtopic.php?p=2721808
No worries, Ian. I figured out a way to access what files are included in a bundle. It’s around my elbow to get to my ... apples ... but so is this entire mess, which is forcing us to get creative.
I do a keyword search for bundle (or any other hot word,like extravaganza), I use the spreadsheet link to reset the bundle, which activates the list in my available downloads. I then select the row below the bundle’s row in the spreadsheet and add a new row (this places a blank row right below the bundle row).
Then, I copy/paste the files listed in my Avail Dwnlds into my spreadsheet. I the delete the undesired rows (for me, that’s the mac files). I erase an rows I don’t want, and am left with the file names and links of what I do want, and hit save.
I’ll be editing the tutorial later to show this new info. :D
No worries, Ian. I figured out a way to access what files are included in a bundle. It’s around my elbow to get to my ... apples ... but so is this entire mess, which is forcing us to get creative.
I do a keyword search for bundle (or any other hot word,like extravaganza), I use the spreadsheet link to reset the bundle, which activates the list in my available downloads. I then select the row below the bundle’s row in the spreadsheet and add a new row (this places a blank row right below the bundle row).
Then, I copy/paste the files listed in my Avail Dwnlds into my spreadsheet. I the delete the undesired rows (for me, that’s the mac files). I erase an rows I don’t want, and am left with the file names and links of what I do want, and hit save.
I’ll be editing the tutorial later to show this new info. :D
Why didn’t I think of that
But yes, it;s a pain in the butt all right. (can I say butt without a tag?)
My favorite part is I can reset straight from the spreadsheet. :D No messing with that annoying IOH other than updating the spreadsheet after purchases.
That’s a good point. In my spreadsheet, I always deleted the column with the reset links…there was no need. But now, I regret that, with the current condition of the IOH. D’oh!
My favorite part is I can reset straight from the spreadsheet. :D No messing with that annoying IOH other than updating the spreadsheet after purchases.
That’s a good point. In my spreadsheet, I always deleted the column with the reset links…there was no need. But now, I regret that, with the current condition of the IOH. D’oh!
Dana
Also I can sort by order # or alphabetical, sadly not by date because of the format used by daz and i can’t use format cells to alter it for some reason, but by order # gives me the same sort of order as date anyway
I also discovered, quite by accident, if I use the spreadsheet link to download a file, vs the link in my IOH, it not only downloads faster, but is more likely to download the full file. I have yet to have one not give me the ‘click, click, click’ window when downloaded from the spreadsheet. It’s is, however a problem I am having when downloading straight from the site. My downloads were not downloading all of the way.
Doesn’t make sense to me, but little ever does .. lol.
I also discovered, quite by accident, if I use the spreadsheet link to download a file, vs the link in my IOH, it not only downloads faster, but is more likely to download the full file. I have yet to have one not give me the ‘click, click, click’ window when downloaded from the spreadsheet. It’s is, however a problem I am having when downloading straight from the site. My downloads were not downloading all of the way.
Doesn’t make sense to me, but little ever does .. lol.
I was resetting my bundled items so I could see what files were included in my available downloads area. I couldn’t just select the column with the file names, so I just c/p the entire series of files and their info into my spreadsheet. As with the earlier series of c/p from with the IOH, the links copied hot, too.
I erased what I didn’t want, then out of curiosity, hit the file link to see if it worked, since I had to re-download the files for that bundle anyway. It opened a blank window and download started instantly. I still don’t have the foggiest idea how big the files should be, so I can’t confirm that the entire file downloads, but so far, I have not had to re-download to get it into install mode.
I noticed it was faster, too. A 50+ MB file in less than 5 minutes. Last night it was taking 40 or more minutes to download a file half that size from the AD section..
Fortunately, I set up my spreadsheet in Excel “before” the old store closed, so I was able to get it in descending date order, which is the way I prefer to access it. Now it’s so nice and easy to check if I’ve already purchased something, at least until they get the “you’ve already purchased this” fixed in the store.
i randomly clicked on a bundle order from the spreadsheet and the order page came up with lots of things on, however I had actually ordered a lot of stuff with the bundle. when i clicked on another order with a bundle it was just the bundle 