Jump to content

Steven L. Dasinger

Moderators
  • Posts

    1,556
  • Joined

  • Last visited

  • Days Won

    75

Steven L. Dasinger last won the day on July 3

Steven L. Dasinger had the most liked content!

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Steven L. Dasinger's Achievements

Experienced

Experienced (11/14)

  • Conversation Starter
  • First Post
  • Collaborator Rare
  • Posting Machine Rare

Recent Badges

93

Reputation

  1. Delete or Rename 1.jpg to 47.jpg 2.jpg to 48.jpg 3.jpg to 49.jpg Then Move From: Pictures\F\Fantagraphics\Birthright To: Pictures\F\Fantagraphics\Critters Delete or Move ALL (1.jpg - 1-C.jpg) From: Pictures\M\Marvel\L\Lords of Empyre- Emperor Hulking To: Pictures\M\Marvel\L\Lords of Empyre- Emperor Hulkling Delete or R 1-B.jpg to 1-D.jpg 1-C.jpg to 1-E.jpg Then Move ALL From: Pictures\A\AfterShock\Maniac of New York- Don't Call It a Comeback To: Pictures\A\AfterShock\Maniac of New York (Vol. 3) Delete or Move 1.jpg From: Pictures\C\Critical\Quarel, The To: Pictures\C\Critical\Quarrel, The Delete or Move 1/A.jpg From: Pictures\I\IDW\Teenage Mutant Ninja Turltes-Usagi Yojimbo- Saturday Morning Adventures To: Pictures\I\IDW\Teenage Mutant Ninja Turtles-Usagi Yojimbo- Saturday Morning Adventures Delete or Rename 19.jpg to 19-A.jpg then Move From: Pictures\T\Titan\Official Xena, The- Warrior Princess Magazine To: Pictures\T\Titan\Xena- The Official Magazine featuring Hercules Delete 4.jpg From: Pictures\I\Innovation\Group Larue, The (Mike Baron's-)
  2. I don't believe there is a way to easily get a list in the same order outside of CB. Or at least not directly. This may or may not help you depending on what you are doing or trying to accomplish (need CB Professional or higher). CB has a 'hidden' title column called AlphabetizedTitle. This is used by CB to get the Titles in the displayed order. Instead of using Export, you can run an Advanced Find, then Copy/Paste the result column into Excel (note you still can't use Excel to sort as it will change the order since it won't have AlphabetizedTitle available). To get a list of all the Comic Book Titles/Issues you own: Run an Advanced Find with: WHERE I.[QtyInStock] >= 1 ORDER BY ComicTitles.AlphabetizedTitle, I.[ItemType], I.[IssueNum], I.[Variation], I.[Printing] Select All with CTRL+A Copy with CTRL+C In Excel, Paste with CTRL+V NOTE: If you only want Title and Item #, you can just select those columns by Click in the first Title cell Scroll to the bottom and with the SHIFT key pressed and held, click the the last Item # Cell. Then Copy (from CB) and Paste (to Excel) If you want more columns, you can either copy all the columns then delete what you don't want from Excel or use menu item Setup->Columns to View to only display the columns you want before selecting all (either with CTRL+A or Selecting the first row/first cell and the last row/last cell with SHIFT pressed and held). Finally this is just for Comic Books. If you need Books and/or Magazines you would use: BookTitles.AlphabetizedTitle MagazineTitles.AlphabetizedTitle PS You will want to format the Title and Item # columns in Excel as 'TEXT' so they justify correctly.
  3. I am not sure I have a clear picture of what exactly you need. Did you bad hard drive contain the program, you database or both? Normally, the icon on your desktop is the Program and not the actual database. Having said all that... If not already done you (may) need to reinstall CB. Database are located by default at C : \Users\<logon-id>\Documents\Human Computing\ComicBase Databases. NOTE: You can locate the database any where you like (even on a different drive). Copy the database backup to the default location (or the location you may have been using) AND Rename it to the normal database name you were using. Do NOT open a database with (Backup <timestamp>) as part of the name (or you will get backup of backup in the name and it gets messy). Installing the Program should put the icon back on your desktop. To open up the database (where ever you put it), you can double-click on the actual database name. This will open it up in CB and remember where it is when you close and reopen CB. If this doesn't help, I will more specific information.
  4. Yes, titles designated as 'Light Novel's are either text only or text with illustrations and should be Type Books (at least in all cases I have come across).
  5. Delete or Move ALL (1-A.jpg - 2-A.jpg) From: Pictures\I\Image\F\Falling in Love on Path to Hell To: Pictures\I\Image\F\Falling in Love on the Path to Hell Delete or Rename TPB.jpg to TPB 1.jpg From: Pictures\S\Scholastic\Pokemon- World Championship Delete or Rename x.jpg to TPB x.jpg (where X is 1 through 17) From Pictures\Y\Yen\Irregular At Magic High School, The (Light Novel) Delete or Rename 1.jpg to 1-A.jpg and 2.jpg to 2-A.jpg From: Pictures\I\Image\R\Rat City
  6. Delete or Rename 4.jpg to 4-A.jpg From: Pictures\I\Image\S\Sam and Twitch Case Files Delete 1-F.jpg From: Pictures\M\Marvel\U\Ultimate X-Men (3rd Series) (Duplicate of 1-2.jpg)
  7. Delete 18.jpg From: Pictures\A\Andrews McMeel\Get Fuzzy (Duplicate of correct Bk 6.jpg)
  8. In the top left side of the window, click on the VIEW drop-down icon. Then select Grid Cover Icon Size and then The size desired. (see attached)
  9. Delete or Rename 1.jpg to 2005.jpg then Move Move From: Pictures\M\Marvel\F\Free Comic Book Day 4 To: Pictures\M\Marvel\F\Free Comic Book Day (Marvel) Delete or Move ALL (1-A.jpg - 1-C.jpg) From: Pictures\B\Brilliant\GunHAND, The To: Pictures\A\American Mythology\GunHAND, The Delete or Move 0.jpg - 124.jpg From: Pictures\E\Editorial Bruguera\Can Can (Editorial Bruguera) To: Pictures\E\Editorial Bruguera\Can Can (Editorial Bruguera, 1st Series) Delete or Move 201.jpg - 230.jpg From: Pictures\E\Editorial Bruguera\Can Can (Editorial Bruguera) To: Pictures\E\Editorial Bruguera\Can Can (Editorial Bruguera, 2nd Series) Delete or Move ALL (1.jpg - 199.jpg) From: Pictures\E\Editorial Bruguera\Can Can To: Pictures\E\Editorial Bruguera\Can Can (Editorial Bruguera, 2nd Series) Delete 1-E.jpg From: Pictures\M\Marvel\U\Ultimate Spider-Man Delete 10-A.jpg then Rename 10.jpg to 10-A.jpg From: Pictures\B\Boom!\Wynd (10-A.jpg is a duplicate of 10-B.jpg)
  10. Delete or Move ALL (1.jpg - 7.jpg) From: Pictures\I\I.W\Little Eva (I. W.) To: Pictures\I\I.W\Little Eva (I.W.) Delete or Rename Bk 1.jpg to 1.jpg Bk 2.jpg to 2.jpg Bk 3.jpg to 3.jpg Bk 4.jpg to 4.jpg then Move From: Pictures\G\Gold Key\Star Trek (1st Series) To: Pictures\G\Golden Press\Star Trek- The Enterprise Logs Delete or Rename Bk 5.jpg to 5.jpg then Move From: Pictures\G\Gold Key\Star Trek (1st Series) To: Pictures\C\Checker\Star Trek- The Key Collection
  11. Are the missing/non-importing issues in the file that was Exported? If the are, can you see anything strange about the data for those issues? If they are not in the file, then they didn't get Exported for some unknown reason. And if they are not in the file? can you try to Export one or more of those issues by themselves? You can do this by checking the 'Marked' box on the issue( s ). Then, when Exporting, select 'Export only marked items'. PS, If you seem to be missing entire titles, you might do a Find for Publisher name 'Unknown Publisher'. Any title CB can't match to an existing Title in CB will have the Publisher set to 'Unknown Publisher'.
  12. Delete or Move ALL (1.j.pg - 1-E.jpg) From: Pictures\M\Marvel\S\Star Wars- The Mandalorian 2 To: Pictures\M\Marvel\S\Star Wars- The Mandalorian Season 2 Delete or Move 4.jpg through 17.jpg From: Pictures\G\Go! Comi\07-Ghost To: Pictures\V\Viz\07-Ghost (Viz) Delete or Rename 1-GIVE.jpg to 1.jpg then Move From: Pictures\M\Marvel\C\Custom M&M 2021-22 Print Comic To: Pictures\M\Marvel\C\Custom M&M 2023 Custom Comic Delete or Move FCBD 2021.jpg From: Pictures\I\IDW\Star Wars- The High Republic Adventures To: Pictures\T\Tokyopop\Free Comic Book Day (Tokyopop) Delete 1-G.jpg From: Pictures\M\Marvel\U\Ultimate X-Men (duplicate of CS 2.jpg)
  13. If I am editing a long string, I tend to copy it out into Notepad (or text editor of your choice) and making the correction there just because of the scenario you described. However, if you want to edit in the cell, here are a couple of tricks. 1) select/high-light just the character (singular) you want to manipulate. Then either delete or type in the replacement character. 2) Copy a single or multiple characters from another source. Then either place the cursor where you want to insert it and Paste or high-light one or more consecutive chatterers and paste it in. You may have to experiment a little to get used to doing these in cell changes.
  14. One more thing you can try. Load the export file to a spreadsheet. Sort by Title and see what the first or last row looks like. The Problem row should (hopefully) be the first or last row.
×
×
  • Create New...