-
Posts
1,530 -
Joined
-
Last visited
-
Days Won
73
Content Type
Profiles
Forums
Blogs
Downloads
Posts posted by Steven L. Dasinger
-
-
Try this in the Where of an Advanced Find:
I.Title IN (
SELECT A.Title
FROM ComicIssues A
WHERE A.QtyInStock>= 1
GROUP BY A.Title
)This is a basic query to find ALL Titles that you have at least 1 owned Issued and return ALL Issues for those Titles.
More can be added and you can Order By whatever you like.
-
One possibility is to use the Marked check box on the Title edit window and check all of your Owned Titles.
Unfortunately, you have to do this one at a time.
(If I find time, I may be able to come up with a Advanced Find that will get around this. Will need to test it.)
Once that is done, you can use Advanced Find to retrieve all the issues you need.
On the Find result grid, you can select some or all of the cells, use CTRL+C to copy the information, then CTRL+V to paste into Excel.From what I am reading from your post, you want ALL Issues from ALL Titles that you own at least 1 issue in. Is this correct?
PS for selecting the information you want, it is easier if all the columns you want are close together.
If not, you would just delete what you don't want in Excel. -
Delete or Move MMPB.jpg and TPB.jpg
From: Pictures\B\Byron Preiss\Generation X (Byron)
To: Pictures\B\Boulevard\Generation X (Byron)Delete or Move HC>jpg and TPB.jpg
From: Pictures\B\Byron Preiss\X-Men- Codename Wolverine
To: Pictures\B\Berkley\X-Men- Codename WolverineDelete or Move MMPB.jpg
From: Pictures\B\Byron\X-Men- Law of the Jungle
To: Pictures\B\Berkley\X-Men- Law of the JungleDelete or Move ALL (HC 1.jpg - MMPB 3.jpg)
From: Pictures\B\Byron Preiss\X-Men- Mutant Empire
To: Pictures\B\Berkley\X-Men- Mutant EmpireDelete or Move MMPB.jpg
From: Pictures\B\Byron Preiss\X-Men- The Jewels of Cyttorak
To: Pictures\B\Boulevard\X-Men- The Jewels of CyttorakDelete or Rename MMPB.jpg to 1.jpg
From: Pictures\F\Fawcett\Kittycat's Motor Is RunningDelete or Rename MMPB.jpg to 1.jpg
From: Pictures\S\Signet\MAD About MAD!Delete or Rename MMPB.jpg to 1.jpg
From: Pictures\W\Warner\MAD as the Devil!Delete or Rename MMPB.jpg to 1.jpg
From: Pictures\W\Warner\MAD MarginalsDelete or Rename MMPB.jpg to 1.jpg
From: Pictures\S\Signet\MAD's Don Martin Cooks Up More TalesDelete or Rename MMPB.jpg to 1.jpg
From: Pictures\W\Warner\MAD's Don Martin Steps Further OutDelete or Rename MMPB.jpg to 1.jpg
From: Pictures\S\Signet\MAD's Maddest Artist Don Martin Drops 13 StoriesDelete or Rename MMPB.jpg to 1.jpg
From: Pictures\F\Fawcett\Oops! We're Out of Juice!Delete or Rename MMPB.jpg to 1.jpg
From: Pictures\F\Fawcett\Pick Up What Things-Delete or Rename MMPB.jpg to 1.jpg
From: Pictures\S\Signet\Viva MAD!Delete or Rename MMPB.jpg to 1.jpg
From: Pictures\F\Fawcett\Wanna Be Smiled At-Delete or Rename MMPB.jpg to 1.jpg
From: Pictures\F\Fawcett\Who Invented Rain-Delete or Move 1.jpg
From: Pictures\C\Classical\Christmas Carol, A
To: Pictures\C\Classical Comics\Christmas Carol, ADelete or Move 1.jpg
From: Pictures\C\Classic\Dondi
To: Pictures\C\Classic Comics\DondiDelete or Move ALL (1.jpg - 704.jpg)
From: Pictures\#\1982-1994\Fuego
To: Pictures\E\Editora Cinco\FuegoDelete or Move ALL (Bk 1.jpg - Bk 3.jpg)
From: Pictures\C\CreateSpace\Galacticat
To: Pictures\C\CreateSpace Independent\GalacticatDelete or Move ALL (1.jpg - 3.jpg)
From: Pictures\B\Buenaventura Press\Injury Comics
To: Pictures\B\Buenaventura\Injury ComicsDelete or Move 1-HC.jpg
From: Pictures\C\Classic\Lance- The Complete Collection
To: Pictures\C\Classic Comics\Lance- The Complete CollectionDelete or Move 1.jpg
From: Pictures\C\CreateSpace\Mr. Awkward
To: Pictures\C\CreateSpace Independent\Mr. AwkwardDelete or Move 1.jpg
From: Pictures\B\Burcham Studios\Stargators
To: Pictures\B\Burcham\StargatorsDelete or Move ALL (1.jpg - 1-L.jpg)
From: Pictures\M\Marvel\A\AXE- Eve of Judgment
To: Pictures\M\Marvel\A\A.X.E.- Eve of JudgmentDelete or Move 1.jpg
From: Pictures\D\DC\B\Batman- The Penguin
To: Pictures\D\DC\B\Batman Arkham- PenguinDelete or Rename 1.jpg to 33/A.jpg then Move
From: Pictures\C\Charlton\Beetle Bailey Complimentary Copy (1970 Cerebral Palsy Giveaway)
To: Pictures\C\Charlton\Beetle Bailey (Vol. 1)Delete or Move Bk 1.jpg and Bk 1-2.jpg
From: Pictures\D\Dark Horse\C\Concrete- Short Stories 1986-1989
To: Pictures\D\Dark Horse\C\Concrete- Complete Short Stories 1986-1989Delete or Rename 1-LE.jpg to Bk 1-LE.jpg then Move
From: Pictures\D\Dark Horse\C\Concrete- The Complete Short Stories
To: Pictures\D\Dark Horse\C\Concrete- Complete Short Stories 1986-1989Delete or Move 1-HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives, The- Valor
To: Pictures\D\Dark Horse\E\EC Archives, The- ValorDelete or Move 1-HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- Aces High
To: Pictures\D\Dark Horse\E\EC Archives, The- Aces HighDelete or Rename 1-HC.jpg to HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- Crime IllustratedDelete or Move 1-HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- Impact
To: Pictures\D\Dark Horse\E\EC Archives, The- ImpactDelete or Move 1-HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- Incredible Science Fiction
To: Pictures\D\Dark Horse\E\EC Archives, The- Incredible Science FictionDelete or Move 1-HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- Modern Love
To: Pictures\D\Dark Horse\E\EC Archives, The- Modern LoveDelete or Move 1-HC.jpg and 2-HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- Panic
To: Pictures\D\Dark Horse\E\EC Archives, The- PanicDelete or Move 1-HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- Piracy
To: Pictures\D\Dark Horse\E\EC Archives, The- PiracyDelete or Move 1-HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- Psychoanalysis
To: Pictures\D\Dark Horse\E\EC Archives, The- PsychoanalysisDelete or Move 1-HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- Saddle Justice
To: Pictures\D\Dark Horse\E\EC Archives, The- Saddle JusticeDelete or Rename 1-HC.jpg to HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- Shock IllustratedDelete or Move ALL (1.jpg - 5-HC.jpg)
From: Pictures\D\Dark Horse\E\E.C. Archives- The Haunt of Fear
To: Pictures\D\Dark Horse\E\EC Archives, The- The Haunt of FearDelete or Move 1.jpg and 2.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- The Vault of Horror (2nd Series)
To: Pictures\D\Dark Horse\E\EC Archives, The- The Vault of Horror (2nd Series)Delete or Move 1-HC.jpg and 2-HC.jpg
From: Pictures\D\Dark Horse\E\E.C. Archives- War Against Crime
To: Pictures\D\Dark Horse\E\EC Archives, The- War Against CrimeDelete or Move ALL (1-HC.jpg - 4-HC.jpg)
From: Pictures\D\Dark Horse\E\E.C. Archives- Weird Fantasy
To: Pictures\D\Dark Horse\E\EC Archives, The- Weird FantasyDelete or Rename 1-HC.jpg to HC.jpg then Move
From: Pictures\D\Dark Horse\E\EC Archives, The- Confessions Illustrated
To: Pictures\D\Dark Horse\E\E.C. Archives, The- Confessions IllustratedDelete or Rename Bk 1.jpg to Bk 1-LE.jpg then Move
From: Pictures\B\Byron Preiss\Empire (Byron Preiss)
To: Pictures\B\Berkley\Empire (Berkley)Delete or Move ALL (1-HC.jpg - 3-HC.jpg)
From: Pictures\D\Dark Horse\I\Inside Moebius
To: Pictures\D\Dark Horse\M\Moebius Library- Inside MoebiusDelete or Move 1.jpg
From: Pictures\D\DC\S\Sandman Presents, The- Dead Boy Detectives (2nd Series)
To: Pictures\D\DC\S\Sandman Universe, The- Dead Boy DetectivesDelete or Move 2.jpg
From: Pictures\C\Creators\Scary Gary
To: Pictures\C\Creators\More Jokes About Violence and Food- A Scary Gary CollectionDelete or Move 1-HC.jpg
From: Pictures\C\Chronicle\Star Wars Vader Family Sithmas, A
To: Pictures\C\Chronicle\Vader Family Sithmas, ARename TPB-A.jpg to HC-A.jpg and TPB-B.jpg to HC-B.jpg
From: Pictures\A\American Fantasy\Collector's Book of Virgil Finlay, TheRename TPB.jpg to Staple.jpg
From: Pictures\N\Necronomicon Press\Index to the Fiction & Poetry of H. P. Lovecraft, AnRename TPB.jpg to HC.jpg
From: Pictures\C\Cider Mill\Lois Lane's Dating HandbookRename Staple 1.jpg to Staple.jpg
From: Pictures\R\Russ Cochran\Magic of Frank Frazetta, TheDelete 1.jpg
From: Pictures\D\DC\B\Batman Begins
(duplicate of MC 1.jpg)Delete or Rename 1.jpg to 1-A.jpg and 2.jpg to 2-HC.jpg
From: Pictures\M\Marvel\F\Fantastic Four by John Byrne OmnibusDelete or Rename 1.jpg to 1-A.jpg
From: Pictures\B\Black Mask\Rogue StateDelete or Rename 1.jpg to 1-A.jpg
From: Pictures\A\AfterShock\Tales of Mother F. Goose -
Can you give exact steps and options used?
-
I will add a little more detail.
With Series I Own selected and ONLY Missing Items checked, when you click Preview, the window just closes and nothing happens.With Select Series selected, a few series manually selected (doesn't matter if you own any issues in them or not), and Items in My Collection and /or Missing Items checked, when you click Preview, it works and you get what you would expect.
Only when you select the radio button 'Series I Own' does the Missing Items NOT get displayed or process if that is the only box checked).
-
I agree. I have come across on several series.
Currently it would have to be in the one field. Not sure if that would make Finds harder or not.
-
It is best when doing Finds to leave off the insignificant articles. CB stores them at the end of the name.
Typing 'Call t' brings up the ones you want in the top 5 of the list.
-
I checked with a usually reliable source (Midtown Comics) and they also 'skipped ...21 and ...31 (at least they have none listed for those UPCs) so cancelling could make sense.
-
Or, for #1, you could just each of the 4 Updates selecting only 1 Type each time (with the optimize database) and not have to do math.
-
For #1, you can get the current size by running 4 Updates.
1) Create a New database.
2) Run Update (making sure to check ALL for types).
3) Run File Tools, Optimize Database (to endure the database is as small as it can get)
4) Use File Explorer to find the size of the Database with all 4 types and record it some where
Repeat Steps 2-4 but remove one type from the Update (i.e. Newspapers, then Books, then Magazines) each time you process an update.
After the fourth Update you should have a list of database size with
Just Comic Books
Comic Books and Books
Comic Books, Books and Magazines
All 4 Types.
A little subtraction will get you the size needed for each Type (for example All 4 Types Size minus 3 Types (Comic Books, Books, Magazines) = Newspaper size).
PS If not know, you can force an Update by holding down the SHIFT key while checking for Updates.
As for #2, I am not sure if A) they want to supply the information or B) they don't have time to try to figure all that out from all the various tables/indexes. What I can tell you is the actual data tables are relative small (1/10 the size of the database?). But there are a LOT of indexes to speed up process, accommodate Psychic Typing and drop-down boxes. There is also space needed to store all the queries needed for reports and regular finds but they should take up much space.
-
I am not an expert at this but looking at all the covers that MyComicShop has for Canadian Incredible Hulk, I did find a common theme.
All of the covers had a single Price (75¢).
The US series has multiple prices (75¢US, 95¢Can)
I did find a couple of exceptions but in those cases the Canadian prices were more (US Issue #295 60¢, Canadian issue #295 75¢)
If it is true (and I am just basing this on the cover), then yours would be US newsstand versions.
(possible the Canadian ones have a slightly different indicia but I don't have any to check.)
-
8 hours ago, Larry Robertson said:
it's defaulting to the lowest issue number
Just to clarify this statement a little bit, It defaults to the lowest number in a TEXT sort order.
If it was a NUMERIC sort order and you had covers for issues 2 - 20, the cover displayed would be 2.
But with the TEXT sort order in CB, if you had covers for Issues 2 - 20, the cover displayed would be 10 (i.e 10, 11, 12, 13, 14, 15, 16. 17. 18, 19, 2, 20 (note position of #2))
Even stranger, if you had a set of covers for 2-9, 20-100 (skipping all the other issues that have a 1 at the beginning), the displayed cover would be 100.
This also means, if you had -2 and 1 with covers, 1 would be the displayed cover and not -2.
This makes no difference to your Feature suggestion. Just explaining what CB is really doing.
-
To do that, just click in any cell in the grid. That will remove the focus and the Title info will be displayed.
-
I believe it only goes by Width and Height not size. I am not sure how much bigger it has to be to allow replacement. You will probably have to wait until Pete gets back from vacation to get specifics.
-
The grid does allow for a drop-down box and currently has them for Condition and Currency. They don't show up until you click in the cell.
-
I think you are fine. As I said, there was a problem with the automatic options replacing any cover (regardless of size) but I think it was fixed. Just haven't tested it out recently.
-
1 hour ago, Fred Slota said:
Yes, I know you can click "Find | Other... | Find" and rerun the search, but that's multiple mouse moves and clicked, which could be shortened with the dedicated button.
There, sort of, already is. Instead of clicking the Find down-down box to the left of the Find text box, click on the Magnifying glass icon to the right. This will bring you your last Find (whether Regular or Advanced).
-
Interesting option. Currently, there is nothing like this in CB so you are missing something.
-
34 minutes ago, Larry Robertson said:
I do size all of my scans to 2160 pixel height (4k) but it would still be possible for a downloaded scan to replace this based on file size -yes?
The Update Options (when you manually start an Update in CB or in Sidekick) there is a check box 'Replace smaller existing pictures'.
If you Uncheck this, it shouldn't replace any covers.
If you Check it, it should only replace covers that are smaller in your database than the one the Update has.
(Also, the Update only has covers for that particular Update and not the entire database.)However, if you manually select one or more issues, right-click and select Download covers, it will download and replace (regardless of size) the current one in the database.
NOTE: This may or may not still be the case. There was some discussion about it and I don't recall the specifics.Additionally, in ComicBase Preferences, there is a check box for 'Automatically download larger pictures when viewing them'.
This is mainly for those who chose the Quick Start Picture install (a process that only loads thumbnail size covers saving time and space. Then, when you view a cover it will automatically download and display the full size cover).
However, it, too, had some issues about downloading and replacing any cover (regardless of size). Again, this may have been fixed but I don't use this process to be sure.PS to ensure this process work for the best, you should run the Rebuild Lists for Picture files to ensure all the picture size information is populated.
-
If the same updates were applied to two different databases, they 'could' have the same Ids as they should be applied in the same order in both updates. But it is not guaranteed.
Barcode or QRCode in your database wouldn't make a difference. Both would uniquely identify an issue in a single database or could have problems over multiple databases.
The only way to get a 'common' unique code for an issue regardless of which database would be for HC to add a new column and store this unique identifier in the master database which would then Update everyone's databases with the same unique number. Even then, due to human error, there could be problems with that method.
The only real way to use barcodes with multiple databases is to print the barcode labels from both databases.
-
CB generates the UPC for each issue and doesn't use the UPC any issue may have.
Correct. IDs are only relevant to a single database. However, if you make a copy (or use a backup) of a database, then the Ids will be the same (at the time of the copy or backup).
The various Unique Ids in a database are generated by that database and are not populated through the update process.
It depends. If you add/delete issues to different databases, then you can't be sure the same Ids will be assigned to the same issues.
But if you only add/delete issues to a single database then make copy/backups, then the ids would be the same across all databases.
Theoretically, if you start with identical databases, and added Issues in the same order to them, then they should generate the same Id for the issues in each database.
I would need to know more about how you work with you databases to be more specific.
-
While waiting for this feature, a work-around is:
Use Add by Barcode
Change the Qty value to 0
With the 'Display items after saving' checked, you will get a list of the scanned in items that you can do Quick Change on and it won't change the Qty value already in the database.
-
Use Report->Price Labels
In the list of check-boxes, there is 'Include barcodes'This will include a CB generated barcode on the label.
Not sure of the exact composition. Here is what the scanner sees on the one I just generated:
B4600003D
The number is the unique issue id (even if you have mulitple issue for the same number, each will be unique).
I think the first letter can be 'A' for Books, 'B' for Comic Books, 'C' for Magazines and 'D' for Newspapers.
Not sure what the last letter represents.PS My barcode scanner read the generated barcode with no problem.
-
All of these have qualify for Comic Books after seeing inside them:
'Mad about Mad!'
'MAD as the Devil!'
'MAD’s Don Martin Cooks Up More Tales'
'MAD’s Don Martin Steps Further Out'
'MAD’s Maddest Artist Don Martin Drops 13 Stories''Kittycat’s Motor Is Running'
'Oops! We’re Out of Juice!'
'Pick Up What Things?'
'Pick Up What Things?'
'Wanna Be Smiled At?'
'Who Invented Rain?'And so does 'Large and Lovable Marmaduke'
I couldn't see inside this one but it is just like all the other MAD books and should also qualify for Comic Books:
'MAD Marginals'
Export Select Titles
in Tech Support
Posted
Ronald, this is good and should be useful.
But I think Fred is looking for both Missing and Owned issues in the Titles he owns.