Jump to content

Steven L. Dasinger

Moderators
  • Posts

    1,526
  • Joined

  • Last visited

  • Days Won

    72

Posts posted by Steven L. Dasinger

  1. It is by design. Certain abbreviations work without the period but others don't. Vs is one of these that requires the period.

    I asked Pete about this awhile back so I can't remember all the details.

  2. Delete or Move 1.jpg
    From: Pictures\D\Dark Horse\H\Hellboy and the B.P.R.D.- 1957-Fearful Symmetry
    To: Pictures\D\Dark Horse\H\Hellboy and the B.P.R.D.- Fearful Symmetry

    Delete or Move ALL (1-A.jpg - 1-H.jpg)
    From: Pictures\M\Marvel\S\Star Wars- The Mandalorian 2
    To: Pictures\M\Marvel\S\Star Wars- The Mandalorian Season 2

    Delete 8-D.jpg
    From: Pictures\B\Boom!\Firefly (Boom!)
    (duplicate of 8-B.jpg)

    Delete 800.jpg
    From: Pictures\D\DC\W\Wonder Woman (1st Series)
    (duplicate of 800-K.jpg)

  3. You will have a problem with accessing the directory structure based on CB title names.

    CB titles are Unicode.

    Windows file structure isn't so they won't compare/match up (then there are the forbidden window file characters that are used in CB titles (like, : / ?*)

  4. No. Alphabetized Title is a hidden column and is not displayed / accessible in the program (other than Advanced Find where it can be accessed with table name qualifier but still not displayed).

    The closest you can get is a list of Titles IN Alphabetized Title order.

    If you numbered them sequentially, you could use that number to get them in that order outside of CB.

  5. Delete or Rename MMPB 1.jpg to MMPB then Move
    From: Pictures\B\Berkley\Conan (Berkley)
    To: Pictures\B\Berkley\Hour of the Dragon, The (Berkley)

    Delete or Rename MMPB 2.jpg to MMPB then Move
    From: Pictures\B\Berkley\Conan (Berkley)
    To: Pictures\B\Berkley\People of the Black Circle, The (Berkley)

    Delete or Rename MMPB 3.jpg to MMPB then Move
    From: Pictures\B\Berkley\Conan (Berkley)
    To: Pictures\B\Berkley\Red Nails (Berkley)

    Delete or Move HC.jpg
    From: Pictures\H\Harper Voyager\Wrath of a Mad God
    To: Pictures\H\Harper Voyager UK\Wrath of a Mad God (Harper Voyager UK)

    Delete or Move 1.jpg
    From: Pictures\C\Conundrum\Grey Museum
    To: Pictures\C\Conundrum\Grey Museum, The

    Delete or Move Bk 1-HC.jpg
    From: Pictures\D\Dark Horse\B\Beasts of Burden- The Gathering Storm
    To: Pictures\D\Dark Horse\B\Beasts of Burden- Animal Rites

    Delete 2.jpg and 3.jpg
    From: Pictures\I\Image\G\Giant Kokju
    (Duplicates of 2-A.jpg and 3-A.jpg, respectively)

  6. Delete or Rename HC.jpg to HC 2.jpg then Move
    From: Pictures\T\TwoMorrows\American Comic Book Chronicles- The 1965-69
    To: Pictures\T\TwoMorrows\American Comic Book Chronicles- The 1960's

    Delete HC.jpg
    From: Pictures\D\Dark Horse\D\Drawing Lines- An Anthology of Women Cartoonists
    (duplicate of 1-HC.jpg)

    Delete TPB.jpg
    From: Pictures\D\Dark Horse\S\Sexy Chix
    (duplicate of 1.jpg)

    Delete 1.jpg
    From: Pictures\F\Fantagraphics\Book on the Edge of Forever, The
    (duplicate of TPB.jpg)

    Delete or Rename 1.jpg to 2020.jpg the Move
    From: Pictures\A\Archie\Archie's Halloween Spectacular
    To: Pictures\A\Archie\Archie Halloween Spectacular

  7. Delete or Rename
    FCBD 2023.jpg   to SE 2023.jpg
    FCBD 2023-A.jpg to SE 2023-A.jpg
    Then Move
    From: Pictures\D\DC\D\Dawn of DC Knight Terrors FCBD Special Edition
    To: Pictures\D\DC\D\Dawn of DC Knight Terrors

    Delete or Rename
    2003-A.jpg to SE 2023-A.jpg
    2003-B.jpg to SE 2023-B.jpg
    2003-C.jpg to SE 2023-C.jpg
    Then Move
    From: Pictures\D\DC\D\Dawn of DC Primer Special Edition
    To: Pictures\D\DC\D\Dawn of DC Primer

    Delete or Move 1.jpg and 4.jpg
    From: Pictures\T\Thorpe & Porter\Flash, The (Thorpe & Porter)
    To: Pictures\T\Thorpe & Porter\Flash, The (Thorpe & Porter, 1st Series)
    AND
    Delete or Move 2.jpg and 3.jpg
    From: Pictures\T\Thorpe & Porter\Flash, The (Thorpe & Porter)
    To: Pictures\T\Thorpe & Porter\Flash, The (Thorpe & Porter, 2nd Series)

    Delete or Move ALL (1.jpg - 1-C.jpg)
    From: Pictures\V\Vault\Money Shot- Comes Again
    To: Pictures\V\Vault\Money Shot- Comes Again!

    Delete MMPB 11.jpg
    From: Pictures\L\Lancer\Conan (Lancer)
    (This is not a Lancer published book. It is an Ace published cover).

  8. The Professional Edition comes with the initial number of covers (around 70,000). It does not include cover downloads,

    The Archive Edition comes with the initial number of covers (over 950,000) and includes cover downloads.,

  9. 10 minutes ago, Lance Fittro said:

    returns more than the max. 5000 results

    The maximum number of results returned depends on the amount of memory you have.

    The more memory, they more that can be returned. For example, I have 32GB of memory and the Max allowed in 2,000,000.

    PS there is also a Max Results box you can set the limit to which could be smaller that the Max allowed.

  10. I am not asking you to install them. Just whether you did or not.

    I don't know if the install of these populate the Picture fields correctly or not.  May affect the query I supplied.

    Hopefully the Rebuild will fix the problem.

  11. Go to the ComicBase website.

    Under My Accounts, select Registrations.

    Click the green arrow under download next to you active subscription.

    Here you can download the CB program, the Quick Start version of pictures and CB Media.

    If you click the Other radio button, you get to where you can download all the full size covers.

  12. What Edition of CB do you have? Pro or Archive?

    If it is Archive, you have an option to download / install the pictures with a Quick Start or downloading the entire full-size covers.

    The Quick Start installs smaller 'thumbnail' size covers. With Preferences setting 'Automatically download larger pictures...' checked, whenever you access a cover it will automatically download the full-size cover.

     

     

  13. This should work.

    ComicTitles.Publisher = 'Marvel' AND (I.PictureHeight IS NULL OR I.PictureHeight < 200)

    I used Picture Height (but you could use Picture Width) with an arbitrary value of 200 pixels.


    However, a few bits of information.
    Sometimes the Picture fields (Height, Width, File Size, Modified) information isn't correct or starnge. For example, they may have contain 0 instead of being NULL. Because of that, you might need to run File Tools->Rebuild Lists using the long running 'Picture files lists'.

    I have run this successfully on my database but I have all the full-sized covers.
    I am not sure if the 'quick-start' version populates the Picture fields the same way. I would hope it does but I haven't tested it.

    PS You need to check for both Less than a value and NULL since NULL is not a value.

  14. I am not trying to 'sell' an item but CB does sell an actual barcode scanner (you can buy other brands of scanners but they are not supported with help from CB). These allow you to use the desktop program with the Add By Barcode option to add comics by barcode very quickly (and much easier than the Mobil App).

    And the number of covers that come with CB depends on the Edition. Archive has all that are available (either submitted to or scanned by Human Computing). Professional only has enough covers for one issues per title (but even then, not all titles).

    As for whether or not you need the Collection (or other) Reports, that is what I was going to test (I don't really use the Mobile App so I am not as sure of it works as the desktop program). Now that the process is fixed and I have the reports displayed, it appears there is no correlation/interaction between them and the actual database.  They are just a method for you to review what you own without looking through all the other titles/issues you don't own.

    The Find Item only seems to look a Comic Book Types.

    However, when using Scan Item then Check For Sales and Purchases, it does correctly added the issues to the correct Types (I tested Comic Books and Books). In my case, increasing Qty to 2 since I already had them entered with Qty 1.

    I think the Mobile App barcode scan was envisioned for use when you are out of town and can't get to the Desktop program (i.e. convention). If you could get back to the Desktop App (and have a hand held scanner), it is MUCH faster to add you issues. In the time it takes the Mobile App to scan 1 issue, you can add a dozen (or more) issues with the Desktop program and a hand-held scanner.

    Pete has mentioned that he is working on an updated Mobile App. Hopefully, some of the features currently lacking will be addressed.

     

     

  15. Yeah, that is what I was going to do some testing on (Types other than Comics). Still having problems getting Reports to the web.

    I think you save a copy of your database to the Web (Sidekick can do this) and it uses that to get Qty.

    The last thing I will add is Peter knows the App has some 'issues' and is working on an upgrade.

    PS While you can scan bar codes to add items to the database, it wasn't really designed to be the main/only way to enter issues.

×
×
  • Create New...