I think it would extremely helpful if there was a spreadsheet version of the all creatures database. That way I could sort them as needed (what type of hide i wanted to hunt for and what not)
I also would find it very helpful if the creature's planet was listed on the all creatures page. I can sort by planets, ascending but since the planet isn't listed i can't tell which planet the creature is actually from.
-Teliak
ps In a perfect world there would be a link with the current (and past) spawns of the type of organic resources and their quality (from swgcrafting.com)
Attention: These forums serve as read only archive of the original and may not be modified. All user accounts and logins have been disabled. Attempting to register, login or view a users profile, which requires a login, will result in your request being blocked.
Spreadsheet and all creature listings RFC
You can change your profile so that your results show planet names.
http://www.swgcreatures.com/profile.asp
Or just go to your profile link from the left navigation bar on the front page.
Hope this helps.
http://www.swgcreatures.com/profile.asp
Or just go to your profile link from the left navigation bar on the front page.
Hope this helps.
[color=#33CCFF:b375b202e1] Nyter:Genetics[/color:b375b202e1]
[color=#33CCCC:b375b202e1] Tempest[/color:b375b202e1]
[color=#33CC99:b375b202e1] Naboo, Edoras[/color:b375b202e1]
[color=#33CC66:b375b202e1] 6228 -4316[/color:b375b202e1]
[color=#33CCCC:b375b202e1] Tempest[/color:b375b202e1]
[color=#33CC99:b375b202e1] Naboo, Edoras[/color:b375b202e1]
[color=#33CC66:b375b202e1] 6228 -4316[/color:b375b202e1]
Once you've done what Nytar suggested, you can create web queries in Excel to grab the data from the site. I used the following .iqy file
[code:1:c95738ef41]
WEB
1
http://www.swgcreatures.com/searchlisting.asp?page=[\"keyword\",\"Enter the Page:\"]
Selection=AllTables
Formatting=None
PreFormattedTextToColumns=False
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
[/code:1:c95738ef41]
copy and paste the above lines into notepad and save them as swg.iqy Now go into Excel, goto Data, then Get External data, then Run saved query. Select the swg.iqy file. Place it in Cel B1 and type 1 when asked for a page. The sheet will fill up with data from the web site. Now, type any number into cell A1 and right click on any of the cells that have data from the web page (C27 for example) You'll see an option for Parameters, select that option and check \"Get value from following cell\" and put =Sheet1!$A$1 into the empty block. Be sure to check the box for \"Refresh automatically when cell value changes\". Click ok and now, when you change cell A1 to 3, you'll see page 3 from the website, 34 will give you the last page. You'll still need to manually cut-paste from the data fields(starting in A33) but this should save some time. If juntao puts in the optin to list all the creatures on a single page, this process will be infinatly easier.
[code:1:c95738ef41]
WEB
1
http://www.swgcreatures.com/searchlisting.asp?page=[\"keyword\",\"Enter the Page:\"]
Selection=AllTables
Formatting=None
PreFormattedTextToColumns=False
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
[/code:1:c95738ef41]
copy and paste the above lines into notepad and save them as swg.iqy Now go into Excel, goto Data, then Get External data, then Run saved query. Select the swg.iqy file. Place it in Cel B1 and type 1 when asked for a page. The sheet will fill up with data from the web site. Now, type any number into cell A1 and right click on any of the cells that have data from the web page (C27 for example) You'll see an option for Parameters, select that option and check \"Get value from following cell\" and put =Sheet1!$A$1 into the empty block. Be sure to check the box for \"Refresh automatically when cell value changes\". Click ok and now, when you change cell A1 to 3, you'll see page 3 from the website, 34 will give you the last page. You'll still need to manually cut-paste from the data fields(starting in A33) but this should save some time. If juntao puts in the optin to list all the creatures on a single page, this process will be infinatly easier.
Last edited by Xanth on Tue Nov 02, 2004 12:58 pm, edited 1 time in total.
[color=#808080:2abc8f5b72]X[/color:2abc8f5b72][color=#999999:2abc8f5b72]a[/color:2abc8f5b72][color=#B2B2B2:2abc8f5b72]n[/color:2abc8f5b72][color=#CCCCCC:2abc8f5b72]�t[/color:2abc8f5b72][color=#FFFFFF:2abc8f5b72]h[/color:2abc8f5b72] Master Creature Handler - Kauri
Formerly of Kauri Galactic CH Guild [color=red:2abc8f5b72]<Beast>[/color:2abc8f5b72]
Formerly of Kauri Galactic CH Guild [color=red:2abc8f5b72]<Beast>[/color:2abc8f5b72]
As a follow up, I too would prefer a csv or excel extract of the website. It'll make things so much easier. :D
[color=#808080:2abc8f5b72]X[/color:2abc8f5b72][color=#999999:2abc8f5b72]a[/color:2abc8f5b72][color=#B2B2B2:2abc8f5b72]n[/color:2abc8f5b72][color=#CCCCCC:2abc8f5b72]�t[/color:2abc8f5b72][color=#FFFFFF:2abc8f5b72]h[/color:2abc8f5b72] Master Creature Handler - Kauri
Formerly of Kauri Galactic CH Guild [color=red:2abc8f5b72]<Beast>[/color:2abc8f5b72]
Formerly of Kauri Galactic CH Guild [color=red:2abc8f5b72]<Beast>[/color:2abc8f5b72]
I have created an excel spreadsheet of the tameable creatures that contains exactly the same info as what this site has (i.e challenge level, Armor rating, has babies, Special attack 1, special attack 2
if anyone want this spreadsheet, just pm me with an e-mail address and I will send it to you
if anyone want this spreadsheet, just pm me with an e-mail address and I will send it to you
[img:9768354473]http://img121.exs.cx/img121/7882/crittersiggy2dw.jpg[/img:9768354473]
Return to “SWG Creatures Suggestions”
Who is online
Users browsing this forum: No registered users and 56 guests