Digital Art Zone

 
   
2 of 2
2
Freebie tutorials
Posted: 26 May 2012 02:44 PM   [ Ignore ]   [ # 16 ]
Power Member
Avatar
RankRankRank
Total Posts:  1281
Joined  2008-03-30
AidanaWillowRaven - 26 May 2012 02:36 PM

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

oh, wow, that’s cool and definitely worth knowing, I’ll be resetting all my downloads when we move to the new platform independent zips as at the moment I have to download PC and MAC versions for each product which is a pain, having the links to the zips in the sheet will defo be a time saver grin

 Signature 

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

Profile
 
 
Posted: 29 May 2012 02:22 AM   [ Ignore ]   [ # 17 ]
Power Member
Avatar
RankRankRank
Total Posts:  1452
Joined  2006-09-09

i was thinking….the extra columns could be used for adding notes, instead of deleting them. Like, if a file name doesn’t specify which figure it was for, you could put M4 or Generation 4 in a column next to it…..or if it’s a texture add on, write the name of the original base outfit next to it….or even write “total crap, why did i buy this/??” *heh*

Profile
 
 
Posted: 29 May 2012 03:02 PM   [ Ignore ]   [ # 18 ]
Addict
RankRankRankRank
Total Posts:  5662
Joined  2005-04-16
IanzThingz - 26 May 2012 01:48 PM
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


Really?  I don’t have any trouble sorting by date in my spreadsheet.  I do notice that I have to change the formatting after I paste. 
Generally:
change the alignment to general

uncheck wrap text
change the format to date, and specify the display style you want


That works for me.  I’ve done a bit more.  I have a cell that is for a search word, and a column that is numeric and receives a 1 if there is a match and a 9 if there is not.  Then I highlight the entire block (except the colum that has the search cell) and order by that column (asc) and all the matches are at the top.  Otherwise I sort by order date (desc) and then title.


Dana

 Signature 

Old post count: 7511

Profile
 
 
Posted: 29 May 2012 04:16 PM   [ Ignore ]   [ # 19 ]
Power Member
Avatar
RankRankRank
Total Posts:  1452
Joined  2006-09-09

i can’t sort by date order either. (I’m using LibreOffice). But then,I am an absolute newb at spreadsheets, having never used them before, so I have NO idea if you can search for a product there, or how to do anything. LOL.

Is it possible to change the dates? They’re written in American format - month/day/year - we use day/month/year here in Oz, short of retyping them, can you do something that will change the formatting on them? Also some of the dates in the purchase history read as two digits for a single day/month, and some are one digit - IE 3rd is sometimes written as 03 and sometimes as 3. I prefer the zero in front. I went to formating and changed it to DD/MM/YY but nothing seemed to change.

Profile
 
 
Posted: 29 May 2012 04:28 PM   [ Ignore ]   [ # 20 ]
Addict
RankRankRankRank
Total Posts:  5662
Joined  2005-04-16

I’m not familiar with Libre Office.  I use MS Office 2007, which means I use Excel 2007.  It sounds like maybe it’s not importing as a date.  You can’t change the format of the column to a date format?  It should change from a string or character to a date format.  After that, you should be able to use the date formatting specifier that you desire/need.


I understand that OpenOffice supports MS Office documents, so the formatting options should be the same, or at least similar.  That is also a free product.


Dana

 Signature 

Old post count: 7511

Profile
 
 
Posted: 29 May 2012 04:37 PM   [ Ignore ]   [ # 21 ]
Power Member
Avatar
RankRankRank
Total Posts:  1452
Joined  2006-09-09
DanaTA - 29 May 2012 04:28 PM

I’m not familiar with Libre Office.  I use MS Office 2007, which means I use Excel 2007.  It sounds like maybe it’s not importing as a date.  You can’t change the format of the column to a date format?  It should change from a string or character to a date format.  After that, you should be able to use the date formatting specifier that you desire/need.


I understand that OpenOffice supports MS Office documents, so the formatting options should be the same, or at least similar.  That is also a free product.


Dana

the column is in date format. I click on the top of the column which highlights everything in it, right click and choose “format”. I go to the “numbers” tab, check “date”, and in format I choose “31/12/99” which shows in the format code as “DD/MM/YY”. Then click ok. but the dates are still written as MM/DD/YY. And I can’t work out how to sort everythign by date, isntead of alphabetically as it is now. Maybe it’s a quirk of Libre? I also have openoffice. (libre is EXACTLY the same as openoffice i have noticed)

Profile
 
 
Posted: 29 May 2012 04:59 PM   [ Ignore ]   [ # 22 ]
Addict
RankRankRankRank
Total Posts:  5662
Joined  2005-04-16

Have you checked the status of “Wrap”?  I found it was checked…in that special 3rd state.  I had to click it twice to totally un-check it.  I then changed the display format and sorted by that column and it worked for me.


Dana

Image Attachments
SortByDate.jpg
 Signature 

Old post count: 7511

Profile
 
 
Posted: 29 May 2012 05:03 PM   [ Ignore ]   [ # 23 ]
Addict
RankRankRankRank
Total Posts:  5662
Joined  2005-04-16

Of course, now I find another issue…it no longer has the Product ID column!  This system is just making things harder and harder to deal with!  confused


Dana

 Signature 

Old post count: 7511

Profile
 
 
Posted: 29 May 2012 05:34 PM   [ Ignore ]   [ # 24 ]
Power Member
Avatar
RankRankRank
Total Posts:  1452
Joined  2006-09-09

but at least with the spreadsheet, we can find things easier rather than having to go through page after page looking for a product grin
i was looking at the fun with bundles page last night, wondering if i could get up a spreadsheet with that one, but i think i’d have to past and copy each separate bit, instead of the whole thing

Profile
 
 
Posted: 03 June 2012 07:19 PM   [ Ignore ]   [ # 25 ]
Active Member
Avatar
RankRank
Total Posts:  268
Joined  2006-05-09

I had been doing spreadsheets from the old method.  Now I find the new system pretty useless.  If you order say 5 new items, they show up in their magical title sorted list.  Its useless when you get new products to add to your spreadsheet without a lot of work.  The old system sorting by order date made it rather easy to update your spreadsheet as you wanted.  The new site nullified Orca’s scripts which made using programs like 3dLibrary a snap.  I wonder if I could get through to the president of Daz to talk to him.  This isn’t growing pains or ‘new’ site issues.  This is poor management and thought process.

 Signature 

Carrara Cafe

Profile
 
 
   
2 of 2
2