Jump to content

Steven L. Dasinger

Moderators
  • Posts

    1,853
  • Joined

  • Last visited

  • Days Won

    94

Posts posted by Steven L. Dasinger

  1. ComicTitles.[CustomCheck1] or ComicTitles.CustomCheck1 should have worked. I just did a quick test using both and the both returned what I expected.

    Normally the [] are needed when there is a space in the name of the field. if it had been Custom Check 1 then you would have to have it in []. (which is why smart database admins don't create fields with spaces...)

  2. 1) No, you are not missing anything. Currently, the only way to change the Title custom fields is per individual Title.

    2) Try ComicTitles.[CustomCheck1] (changing 1 to 2 or 3 if needed). This is assuming an Advanced Find.

    You could use the normal Find with the Title Fields and selecting the custom check boxes but that is all you would be searching for.

    3) No (see 1).

  3. I don't know of any Report or Search (Find) that works with Sets. I think they were created for selling on Atomic Avenue.
    Instead, if you opt for at least the Professional Edition, you will have some Custom fields that you can use (4 text, 2 date, and 3 check box).
    With a custom Text field, you can name one 'Bin #' and record the bin number there.
    You can run Reports and Finds on the Custom fields.

  4. Mark, Using CB 2021 4k Archive v21.0.0.1331, I get the same error without any special options.But they are:
    Titles to Pring: All items
    Cover size: None
    For the next check boxes, only Exclude Owned Items is checked.

    Then Click EXPORT...
    Brings up the Save as box and I leave the default name and click OK.

    Get Message box: Report is being prepared, then the error box is displayed.

    Export Wanted Error.JPG

    Export Wanted Options.JPG

  5. One more thing I meant to mention. The black underline I added is under a drop-down box that lest you switch between Views (Books, Comic Books, Magazines).

    The Find will only work on one View area at a time.

    So the Find will get you all your Comic Books but not anything in the Books or Magazine View.

    You can change your View and run the find in each to get a list for each View.

  6. Strange. Try it this way, bring up a Find window (CTRL+F or click the Magnifying glass icon).

    Select MyComics in the Find drop-down box.

    Optional (and should be redundant), click the List Only Items In Stock check box in the bottom left corner.

    When I run this I get a result of all my comics.

    Find MyComics.JPG

    • Like 1
  7. I guess I am still not sure what you are trying to display.

    The second suggestion (Find for Qty in Stock >= 0) will get a grid view of everything you own in one list that you can scroll through.

    This sounds like what you are asking for which is why I need a better idea what you want.

     

  8. After going back an re-reading your post, I will point out that you will still have to go Title to Title to see items in them.

    If you just one big list of all your owned Items, you can do a Find.

    One way is to use Item Field Qty in Stock and set Greater Than or Equal to 1.

     

     

  9. The total number of rows returned isn't usually displayed (even in CB 2021).

    There is a way, sort of to do this.

    In Setup->Preferences, there is an option for the Rows to Display in a Grid View. What it doesn't tell you is this is the max number to display at one time and you will get a next/previous arrow to advance to the next number rows.  It sounds more complicated to type than actually do.  For example:

    Set the rows to display in the Grid View to 500 (the smallest amount allowed)

    When you run an Advanced Find, there is also a box for limiting the Max Results. This will limit the find to ONLY that many rows. i.e. if you enter 100 and ran a Find that should return 1,000 rows, only the first 100 would be available.

    Now assuming you have the Advanced Find Max results set to 9999 (and the Preferences Grid View set to 500), when you run a Find that returns more than 500 rows, you will get the first 500 rows and at the bottom will be something like   <    1-500 of 1,272   >.

    This shows that a Total of 1,272 rows were returned (the number you asked about).

    Click the right > and the next 500 will be displayed, Click a second time and you will get the last 272 (of this example),

    It is a pain doing it this way as you can't select everything at one time if you want to do something (Quick Report, copy/paste) but you could run the Find twice. Once to find the Total rows and once with the Preference option Grid View rows set to a much higher number to get all at one time.

    Find Count.JPG

  10. Item # is made up of 4 parts. You need to sort by each one separately.  Try:

    I.[ItemType], I.[IssueNum], I.[Variation], I.[Printing]

    This is if you are doing one Title.  If you are doing multiple Titles, then add I.[Title] as the first thing.

     

  11. You should be able to load CB 2021 on top of CB 2020. But it won't hurt if you uninstall first.

    Also, there shouldn't be any more 'updaters' as there were in the past.  The install process has been streamlined so they are no longer needed.. You just install the most recent download.

  12. I don't believe that functionality made it into CB 2020/ 2021.

    The only way I know to simulate it is to View drop-down box  and select Items to Show->Owned Items.

    After that, the Nav arrows will only go to Titles contain an item you own.

  13. Short answer. No.  Longer answer. No way. Even longer answer.... Uh, I better not post it...

    (A, you don't have direct access to the database and B, you can't open 2 databases at the same time)

    =======

    After think about this I came up with a better answer. It is still NO but the reason is...

    There is no direct connection between the two databases. They can't see each other. The reason my solution above was possible is there IS a connection between the database and the HC Master Database via the Update process. Without that, the only option is to export the data to another process (spreadsheet or database) so that they can see and be compared to each other.

    • Like 1
  14. Until HC figures out an official way to way to check for any Titles that you have in your Database but are NOT in the Master Database HC maintains, here are steps to get the same (and better) information.  It is better because the old method only found Titles. This method will find Titles OR Issues.

    1) Make a copy of your database.
    Use Menu item File->Save a Copy and give it a new name.

    2) Switch to the new copy.
    Use Menu item File->Open...

    2.1) Optional. Change Theme.
    Use Menu item File-Theme...
    Using a color that is NOT your normal Theme will let you know this is NOT your real database.

    3) Run an Update.
    Use Menu item Internet->Check for Updates
    This is only needed if you have not run the most recent update. If you are not sure you can 'force' an Update by Pressing and Holding the SHIFT key when selecting Check for Updates.

    4) Set all comic Quantity in Stock to 0

    NOTE: Make sure you ARE in you database copy (the Theme Color would help). You can check by looking at the title bar (far top left corner) where you ComicBase Edition (database name) is displayed.

    Use Menu item Items->Mass Change.
    Set Change: to Qty in Stock
    Click To: Value and enter 0.
    Apply To: All Titles.
    Click Make Changes. (This can NOT be undone.  See Note about making sure what you are working with...)
    Do this for Comic Books, Books and Magazines.

    4) Force an Update.
    Press and Hold SHIFT key while selecting Menu item Internet->Check for Updates
    Using the SHIFT key 'forces' the system to re-run the last update.

    5) Display results.
    When the Update is completed, click the See What's New button.
    Anything Deleted (Titles or Issues, Comics Books, Books, or Magazines) is NOT in the Master database but WAS in your database.

    PS While these specific steps are for CB 2021 (and CB 2020), they should work for earlier versions.

    • Like 1
×
×
  • Create New...