Spreadsheet and all creature listings RFC

[Teliak]

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)

[Nytar]

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.

[Xanth]

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.

[Xanth]

As a follow up, I too would prefer a csv or excel extract of the website. It'll make things so much easier. :D

[xiriss]

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

[xiriss]

I will be trying to add more info to the spread sheet such as the planet, meat type, hide type and so on. however I only have the tameable species so far.