46 replies to this topic

[Pilot]

Works like a charm.

[Contrasai]

I can't wait to try this. Thank you, Slink.

[teapacks]

I think my problem is that I just have too many items... it's still getting stuck on querying

[ShadowLink64]

I think my problem is that I just have too many items... it's still getting stuck on querying

That shouldn't be a problem for our systems.

I think I can get to patching all of these bugs up, and releasing a better version soon. Research has just been very busy lately. Hydro's also been super busy with work, so I've been taking on a couple things that he normally does.

[nothereorthere]

get this fancy error 70+ pages

Attached Files

•  lawl.jpg   43.45KB   71 downloads

Edited by nothereorthere, 04 November 2012 - 05:24 PM.

[4u9qsp]

I get the same error. I have 69 pages. The program stops price checking on my 28th item, a piece of treasure map. I'm new and can't figure out how to attach, but the image would be the same as above except it says "Thread-32" instead of "Thread 804". But that's like a process, right?

[Strategist]

With items like treasure maps, they seem to bug out when the pricer gets to them. Just try removing all map pieces you have and take note of which items cause it to fail.

[4u9qsp]

It took over six hours, but I finally managed to move every offending item out of my SDB. After a while, I noticed that the bulk of the items were localized to the last 5-10 pages of my SDB. Since I was already searching for the items to remove, I copied their names down for data purposes. Some items had duplicate forms, while others weren't in the database.

Spoiler

:Same Names
All Treasure Maps
Pirate Flag (has a Habitarium version)

:Not in Database
The Way to Adventure Sign Post
Hubrid Nox Moustache
Forgotten Shore Background
Ancient Peophin Maractite Coin
Earrings of the Deep
Necklace of the Deep
Very Long First Day of Celebrating
Sweet Dreams Sleeping Cap
Seagrass Tea
Seasonal Kiko Ocarina
Sand Sled
Sand-Away Hair Gel
Holiday Yooyu Gobstoppers
Christmas Yooyu
Holidays on the Space Station Background
Holiday Tree Necklace
Chocolate Chunk Krawk Island Cake
Governors Mansion Playset
Trident of Chestnuts
Underwater Fire
Ghostly Gift
Bigsby Shadington Plushie
Half-Filled Box of Holiday Decorations
Plate of Wintery Caramel Apples
Soggy Sewer Gift
Sewage Surfer Wocky Holiday Action Figure
Feather Wig
Dreaming of Candy
Ornate Faerie Pottery
Faerieland at Christmas Postcard
S.M.E.L.T. Holiday Garland
Count von Roo Stocking
Pinchit Beanie
Stuck in the Lost Isle Background
Polar Chucks
Inside a Sandcastle Foreground
Kreludor Snowglobe
Snow Wars II - The Board Game
Who is Number 2?
Super Size Borovan
Holiday Hanso Plushie
Plain Fruitcake
8-Bit Moehog Plushie
Miniature Gingerbread City
Grarrl Repellant
Regurgitated Gift
The Big Book of Boochi
Baby Ogrin Rattle
Lord Faerigan Plushie
Thief-in-a-Box
Scourgies Covered Ixi Plushie
Blastoids Plushie
Spy Apple
Dappled Apple
Customized Apple
Franken Apple
Vampire Apple
Golden Apple
Apple Apple
Dopple Dapple Apple
Pile of Spooky Laundry
Scariest Neopian
Gargaroxs Lunchbox
Apple Mitts
Apple Bobbing Cane
Cup of Stagnant Water
Cobweb Cake
Apple Bobbing Bart Bark
Broken Hourglass
Have Fun! Card
Hero Hot Dog
Gem Roll-Ups
Fuzzle and Moon Mobile
Hasee in a Bubble Racer
Quill Sword
Fabulous Paper Cone Hat
Bigsby Shadingtons Wrench
Snowmuncher Snowglobe
Destruct-O-Match Watercolours
Petpetpet Slippers
Hasee Cake
I Made it Past the Loading Screen!
Suteks Tomb Rubber Stamp Set
Shoe Full of Sand
Roo Island Pier Playset
Chest of Neggs
The Negg Collection
Orig Plushie
Moltaran Charm
Haunted Coffee
Blurtle Adventure
Tarlas Staff
Wheel of Misfortune Trick-or-Treat Bag
Haunted Weaponry Trick-or-Treat Bag
Prigpants Trick-or-Treat Bag
Magax Trick-or-Treat Bag
Castle Nox Trick-or-Treat Bag
Spooky Forest Path Background
Bigsby Shadingtons Hat

I ended up with an inventory of over 300 items, making shop stocking difficult since I couldn't differentiate between items I wanted to sell and items I didn't want to (at least not without doing it manually).

A second glitch popped up after the pricing was complete. I clicked the Item Value tab (presumably to sort the items by price), and received a "list index out of range" error as well as a traceback error "File "Programs/1038/SDBPricer.py.nc", line 364, in GridLabelClick".

Hope this helps.

[nothereorthere]

i now have well over 100 pages and for me i'm going to have to wait until an update comes out to bypass the errors because i have neocash and a lot of random items that are not in the database

[angel412ster]

I only have 31 pages and it bugged on pg 1 because there was a map piece. I will remove it and try again. So odd.

[ShadowLink64]

I only have 31 pages and it bugged on pg 1 because there was a map piece. I will remove it and try again. So odd.

What was the message you received?

EDIT: This was a really stupid error. It should be fixed now... please retry.

[desiqtie]

The pricer slowly goes through my 250+ page SDB and the "Loading SDB Items...(page xyz of xyz)" part seems to be fine all the way through. Then it gets to the "Querying Neocodex database for prices..." and I keep getting this error:
Traceback (most recent call last):
File "/cdx/svn/checkout/core/trunk/Program Manager/ProgramManager.py", line 1306, in run_with_except_hook
File "Programs/1038/SDBPricer.py.nc", line 122, in run
File "Programs/1038/SDBPricer.py.nc", line 329, in api_call
File "/cdx/svn/checkout/core/trunk/Program Manager/Lib/Encryption/__init__.py", line 34, in __new__
File "encodings/hex_codec.pyc", line 42, in hex_decode
TypeError: Odd-length string
Oh and this was after I removed all Map pieces (Secret, Treasure, Space, Underwater, Petpet, and Forgotten Shore) and the Pirate Flag...

This is especially weird because I just ran it on a two page SDB on another account - that had a bunch of no-trade items, NC items and the new GMC items still in the SDB...and the Pricer worked fine - priced everything that has a price in the Codex item db but just put a simple question mark next to the items that didn't have prices - but MOST importantly for my purposes...it listed the stock/quantities of every item, even the items without prices. The pricer ALSO worked perfectly when I ran it on a five page SDB on another account that had a whole bunch of map pieces still IN the SDB.

Sooo...since the maps, nc items, no trade items, and not in db items don't seem to break the pricer on the other accounts...is it just the massive size of my SDB breaking it?!

Edit: Also, I've tried to run it on both a brand new PC and brand new Mac...same error both times.

Edited by desiqtie, 10 December 2012 - 08:00 PM.

[GustavoH]

Would be very useful if the neocodex Item database had information of new (r101) itens prices...

Edited by GustavoH, 01 December 2012 - 03:57 AM.

[Devoid]

After the items start appearing, it crashes along with the program manager.

[nothereorthere]

is there any way you can make it sortable by profit?

also i just got this error

Traceback (most recent call last):
  File "/cdx/svn/checkout/core/trunk/Program Manager/ProgramManager.py", line 1211, in run_with_except_hook
  File "Programs/1038/SDBPricer.py.nc", line 122, in run
  File "Programs/1038/SDBPricer.py.nc", line 329, in api_call
  File "/cdx/svn/checkout/core/trunk/Program Manager/Lib/Encryption/__init__.py", line 34, in __new__
  File "encodings\hex_codec.pyc", line 42, in hex_decode
TypeError: Odd-length string

[ShadowLink64]

We can definitely add that feature in the new version. We also want to add a way to export the prices to a *.csv or *.txt format so people can load them up in Excel or something. Just been a bit busy with other things in the meantime.

As for that bug, I think it had a problem reading the result from our API. It could have been a small downtime on our end. Are you using a slow internet connection by any chance? Does the error come up every time, or just the once?

[nothereorthere]

just tried it once and i have 22Mbits down

and again

Traceback (most recent call last):
  File "/cdx/svn/checkout/core/trunk/Program Manager/ProgramManager.py", line 1211, in run_with_except_hook
  File "Programs/1038/SDBPricer.py.nc", line 122, in run
  File "Programs/1038/SDBPricer.py.nc", line 329, in api_call
  File "/cdx/svn/checkout/core/trunk/Program Manager/Lib/Encryption/__init__.py", line 34, in __new__
  File "encodings\hex_codec.pyc", line 42, in hex_decode
TypeError: Odd-length string

[desiqtie]

We can definitely add that feature in the new version. We also want to add a way to export the prices to a *.csv or *.txt format so people can load them up in Excel or something. Just been a bit busy with other things in the meantime.

As for that bug, I think it had a problem reading the result from our API. It could have been a small downtime on our end. Are you using a slow internet connection by any chance? Does the error come up every time, or just the once?

Those features sound awesome, especially the export idea

BTW, that's the same bug I got (and have been getting) - and I have a fairly decent internet connection.

[nothereorthere]

Any update on that error?

[rierie]

I know this post is old, and I'm new here... But this program is ingenious! My packratting has seemed to pay off over time. 

[Bane]

I'm also late...but I used this on my 50 page SDB and it worked perfectly, and boy did I like the result or what! o.o

Thanks for this program! 

[rebsca]

Just found out that I've got 1,5M in SDB *YAAY*

But the "Move Selected Itens to Inventory" is not working fo me