Digital Art Zone

 
   
1 of 2
1
Freebie tutorials
Posted: 26 May 2012 02:13 AM   [ Ignore ]
Power Member
Avatar
RankRankRank
Total Posts:  1302
Joined  2010-03-15

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.


IOH spreadsheet tutorial: http://www.sharecg.com/v/62219/view/3/PDF-Tutorial/IOH-spreadsheet-tutorial


I gave this thread a general name hoping other tutorials will find their way here, as well.


:D

 Signature 

Aidana WillowRaven
website: http://WillowRaven.weebly.com ~ blog: http://willowraven-illustration.blogspot.com/
I ask for so little. Just fear me, love me, do as I say and I will be your slave.

Profile
 
 
Posted: 26 May 2012 05:01 AM   [ Ignore ]   [ # 1 ]
Power Member
Avatar
RankRankRank
Total Posts:  1278
Joined  2008-03-30

Thanks so much for this :hug: grin

 Signature 

[Join the little green box collection party!]
Ianz Place
Daz 3D Documentation
Daz 3D on YouTube
Daz 3D Forum Archive

Profile
 
 
Posted: 26 May 2012 05:26 AM   [ Ignore ]   [ # 2 ]
Power Member
Avatar
RankRankRank
Total Posts:  1278
Joined  2008-03-30

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!!!!

 Signature 

[Join the little green box collection party!]
Ianz Place
Daz 3D Documentation
Daz 3D on YouTube
Daz 3D Forum Archive

Profile
 
 
Posted: 26 May 2012 08:07 AM   [ Ignore ]   [ # 3 ]
Power Member
Avatar
RankRankRank
Total Posts:  1302
Joined  2010-03-15
IanzThingz - 26 May 2012 05:26 AM

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.

 Signature 

Aidana WillowRaven
website: http://WillowRaven.weebly.com ~ blog: http://willowraven-illustration.blogspot.com/
I ask for so little. Just fear me, love me, do as I say and I will be your slave.

Profile
 
 
Posted: 26 May 2012 09:28 AM   [ Ignore ]   [ # 4 ]
Power Member
Avatar
RankRankRank
Total Posts:  1302
Joined  2010-03-15
IanzThingz - 26 May 2012 05:26 AM

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?

 Signature 

Aidana WillowRaven
website: http://WillowRaven.weebly.com ~ blog: http://willowraven-illustration.blogspot.com/
I ask for so little. Just fear me, love me, do as I say and I will be your slave.

Profile
 
 
Posted: 26 May 2012 10:26 AM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  16477
Joined  2009-01-22

I’m going to do this one also. Thank you for the info. And I also wish to know the Bundle tip.

 Signature 

Exile, Drows Walk: A Tale of Jaderail starts here. Free pulp fiction at its Fantasy best, Updated 2/3/14.
Proud Member of the Bald Wizards Club My stuff at DeviantArt

Profile
 
 
Posted: 26 May 2012 11:46 AM   [ Ignore ]   [ # 6 ]
Addict
Avatar
RankRankRankRank
Total Posts:  2827
Joined  2004-10-25

I’m glad to see I’m not the only one who likes using spreadsheets. wink  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.

 Signature 

OK . . . Where’s my chocolate?     Post Count —> 3,263 and growing!     Visit my Renderosity Gallery

It’s what you learn after you know it all that counts ~ John Wooden

Profile
 
 
Posted: 26 May 2012 12:00 PM   [ Ignore ]   [ # 7 ]
Power Member
Avatar
RankRankRank
Total Posts:  1278
Joined  2008-03-30
AidanaWillowRaven - 26 May 2012 09:28 AM
IanzThingz - 26 May 2012 05:26 AM

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 red face 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 red face However the Fun with Bundles thread is here in the old forum http://forumarchive.daz3d.com/viewtopic.php?p=2721808 wink

 Signature 

[Join the little green box collection party!]
Ianz Place
Daz 3D Documentation
Daz 3D on YouTube
Daz 3D Forum Archive

Profile
 
 
Posted: 26 May 2012 12:01 PM   [ Ignore ]   [ # 8 ]
Power Member
Avatar
RankRankRank
Total Posts:  1278
Joined  2008-03-30
Jaderail - 26 May 2012 10:26 AM

I’m going to do this one also. Thank you for the info. And I also wish to know the Bundle tip.

sorry dude, I boo boobed red face

 Signature 

[Join the little green box collection party!]
Ianz Place
Daz 3D Documentation
Daz 3D on YouTube
Daz 3D Forum Archive

Profile
 
 
Posted: 26 May 2012 12:26 PM   [ Ignore ]   [ # 9 ]
Power Member
Avatar
RankRankRank
Total Posts:  1302
Joined  2010-03-15

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

 Signature 

Aidana WillowRaven
website: http://WillowRaven.weebly.com ~ blog: http://willowraven-illustration.blogspot.com/
I ask for so little. Just fear me, love me, do as I say and I will be your slave.

Profile
 
 
Posted: 26 May 2012 12:29 PM   [ Ignore ]   [ # 10 ]
Power Member
Avatar
RankRankRank
Total Posts:  1278
Joined  2008-03-30
AidanaWillowRaven - 26 May 2012 12:26 PM

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 grin

But yes, it;s a pain in the butt all right. (can I say butt without a tag?) wink

 Signature 

[Join the little green box collection party!]
Ianz Place
Daz 3D Documentation
Daz 3D on YouTube
Daz 3D Forum Archive

Profile
 
 
Posted: 26 May 2012 01:28 PM   [ Ignore ]   [ # 11 ]
Addict
RankRankRankRank
Total Posts:  5266
Joined  2005-04-16
AidanaWillowRaven - 26 May 2012 08:07 AM

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

 Signature 

Old post count: 7511

Profile
 
 
Posted: 26 May 2012 01:48 PM   [ Ignore ]   [ # 12 ]
Power Member
Avatar
RankRankRank
Total Posts:  1278
Joined  2008-03-30
DanaTA - 26 May 2012 01:28 PM
AidanaWillowRaven - 26 May 2012 08:07 AM

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 grin

 Signature 

[Join the little green box collection party!]
Ianz Place
Daz 3D Documentation
Daz 3D on YouTube
Daz 3D Forum Archive

Profile
 
 
Posted: 26 May 2012 02:04 PM   [ Ignore ]   [ # 13 ]
Power Member
Avatar
RankRankRank
Total Posts:  1302
Joined  2010-03-15

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.

 Signature 

Aidana WillowRaven
website: http://WillowRaven.weebly.com ~ blog: http://willowraven-illustration.blogspot.com/
I ask for so little. Just fear me, love me, do as I say and I will be your slave.

Profile
 
 
Posted: 26 May 2012 02:18 PM   [ Ignore ]   [ # 14 ]
Power Member
Avatar
RankRankRank
Total Posts:  1278
Joined  2008-03-30
AidanaWillowRaven - 26 May 2012 02:04 PM

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.

How do you do that?

 Signature 

[Join the little green box collection party!]
Ianz Place
Daz 3D Documentation
Daz 3D on YouTube
Daz 3D Forum Archive

Profile
 
 
Posted: 26 May 2012 02:36 PM   [ Ignore ]   [ # 15 ]
Power Member
Avatar
RankRankRank
Total Posts:  1302
Joined  2010-03-15

Like I said, I found out by accident ... 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..

 Signature 

Aidana WillowRaven
website: http://WillowRaven.weebly.com ~ blog: http://willowraven-illustration.blogspot.com/
I ask for so little. Just fear me, love me, do as I say and I will be your slave.

Profile
 
 
   
1 of 2
1