Jump to content

Latest content update messed with my data


Tor Gundersen
 Share

Recommended Posts

I ran the latest content update and somehow it gained $60 million in value over the past week. In the enclosed pics you can see one line item (Between $5 and $9.99) where there are supposedly 6.7 million entries but when you open the details it only shows 14,025, which is probably the real number. Help?

CB-screen3.png

CB-screen1.png

CB-screen2.png

Link to comment
Share on other sites

Have you done a search to see which comics you have that are Quantity In Stock > 1 or even > 10 ?

In the *old* days, an accidental entry of a UPC number in the Quantity field would result in this sort of situation.  I am pretty sure that Pete set up some code in ComicBase to prevent that kind of error, but something else may have happened to give you a similar effect.  

Link to comment
Share on other sites

52 minutes ago, Tor Gundersen said:

I haven't tried that search but I'm not even sure how to do it. 

Click on the Find button to activate the dropdown menu, select Other.

In the pop-up window, click on the box next to "Find" (in the general upper left region) to get a long dropdown menu.  Select "Qty In Stock."  That should update the window to give you options related to the number of items in stock. 

You might start out by selecting "Is Greater Than" and putting in something in the text box like "2" or "10" or something like that.  Then click on the "Find" button in the lower right corner to get your results.  

 

Link to comment
Share on other sites

Thanks for the instructions. I just did a search for "is great than or equal to 1" so it would find everything, and it says 69,061, which seems right. Then I run stats again and it's still 6,779,379, so it doesn't appears to have worked. Should I exit out and open up the app again? I've been hesitant to try that for fear it will be locked in or more messed up upon reopening.

Link to comment
Share on other sites

If your Find returned about the correct number, then there (probably) isn't anything wrong with your database.

You can try running File->File Tools, Rebuild Lists (List of Owned series looks like he best option but it won't hurt to run the first 3 (or 4) items.

If you still have wildly out range numbers, there is probably a but in the process/find that populates the large number you are seeing.

Link to comment
Share on other sites

2 hours ago, Steven L. Dasinger said:

If your Find returned about the correct number, then there (probably) isn't anything wrong with your database.

He looked to see how many items were in stock with Qty greater than or equal to 1. 

He really needs to look to see how many items are in stock with Qty greater than 1 to see if that is the cause of his problem.  

But I agree, Rebuild Lists may help him out.  

Link to comment
Share on other sites

Correct. Finding that incorrect value is needed. With a number like 6,716, 879, there is probably just 1 (or a few) issues with a bad value.
Running a Find for Qty In Stock > 100 should find any with a very large number for Qty.

Having said that, I have been looking in to the number Collection Statistics returns and I not getting correct values for most of the dollar ranges. No where near 6 million but anywhere from a few to a few hundred.

Also, while doing this I found 10 issues with a Qty of 4 (I only have 1 of each). If it was just one or two issues, I would blame 'user error'. When it gets to 10, I start to wonder what is going on.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...