Jump to content

Steven L. Dasinger

Moderators
  • Posts

    1,452
  • Joined

  • Last visited

  • Days Won

    69

Everything posted by Steven L. Dasinger

  1. What I am trying to say, is is I (or anyone else) submitted an addition/correct and did NOT put the info you want at the beginning, it won't be at the beginning. If you are the only one submitting the information, it (probably) won't be changed.
  2. Item Description is just a text field. If you have more than one item (separated by semi-colon), the only way to ensure a certain sequence is programmatically. Which means someone (Pete) would have to write a process to try to identify a particular string, they manipulate the data to get a certain order. Not saying it can't be done, but it may not be worth the time an effort.
  3. I don't believe you can guarantee, the order of different items in a field.
  4. Going by an on-line scan, on the back of #1, it has Cover A. The Credits however, don't mention multiple artists. The back of the others do not have Cover A (or anything else about other issues.
  5. Downloaded and followed steps. Encounter the following problems. When click on Refresh, Error Message: Initialization of the data source failed... A) Can you supply the steps/options to define a new Connection? OR B) It looks like Tab Item Checklist is a list of your data. Can I replace yours with copy/Paste?
  6. My guess is that in you Update options, you have 'Remove Obsolete Series' and/or 'Remove Obsolete Items' checked (in CB or in SideKick). See Attached. If you do, whenever you run an Update, CB will delete Issues or Titles if they are not in the Master Database. The exception is if you have QTY set to 1 or more. The is will NOT delete them.
  7. When it finishes syncing I will download and try it.
  8. PS This is ONLY for Comic Books. I was able to successfully duplicate issues in Books, Magazines and Newspapers.
  9. That helps. I am able to recreate your problem. (I didn't save before since I didn't really want a duplicate). Select a row. Select Duplicate. Make a change (to create a another issue (i.e. Condition or, Type or Variation)). Click Save. Nothing happens. No issues is created. I have left the title and returned (to refresh) and still no new issue. I have run Rebuild lists Issue Information and still no new issue.
  10. Unless you download the update to install it (as opposed to doing it through the program), I am not sure there is a way to roll back the change to the previous build. Do you use the Menu option (Edit->Duplicate), CTRL+D or Right-Click and select from the pop-up menu? Is the option 'grayed' out? Can you select it but nothing happens? (I will mention this, just to get it out of the way as it sounds like you have used Duplicate before, but you have to select/high-light the entire row to activate the Duplicate option.) And for comparison, I just updated to the same build and I can still use Duplicate.
  11. The following seems to respect the case of the search. It at least works to find ' series)'. Not sure how easy/difficult it is to alter it for general use in Case Sensitive finds. INSTR(I.Title, ' series)') > 0 Returns 1,572 rows INSTR(I.Title, ' Series)') > 0 Returns 122,658 rows INSTR searches the first parameter (I.Title in this example) for the second parameter (' series)' ) and returns either 0 if not found or the number of its position in the first parameter. Not sure why it works but it appears to.
  12. The indicia does NOT use the colon ( : ) in the title for this one. Also, the several I spot-checked all had lower-case 'p' for 'presents'.
  13. Not really. Instead of trying to create a 'classic' *ptych, the large image was just cut up. It just happened to be sort of close in one case and not really close in another (looking at just the 3 issues). Or maybe that's just me...
  14. I wouldn't consider this any type of *ptych cover due to the massive overlay. To me, to qualify for the *ptych' label, they should line up with no or very little overlap. It is one large image that has been cut up for the 5 covers.
  15. Don't be. I like the challenge and this is the 'fun' stuff...
  16. This one will return only 1 Title/Issue per distinct named *ptych' name set. I.CustomField3 LIKE '%ptych%' AND I.Title || I.ItemNumber in ( Select C.Title || C.ItemNumber From (Select B.Title , Min (B.ItemNumber) as ItemNumber From ComicIssues B WHERE B.CustomField3 LIKE '%ptych%' AND B.Title in ( SELECT Min(A.Title) as Title FROM ComicIssues A WHERE A.CustomField3 LIKE '%ptych%' Group by A.CustomField3 ) Group by B.Title ) as C )
  17. This works with some restrictions. If you have multiple 'ptych' set of the same name, you will only get 1 row for that set name. For example 9-ptych for Carnage titles. 9-ptych for Fantastic Four titles You will ONLY get one of them (either Carnage or Fantastic Four) and not both. If you have multiple 'ptych' sets of different names, you will get 1 row for each of the different set names. For example 9-ptych for Carnage titles 4-ptych for Fantastic Four titles You will get 1 title for each of the sets (both Carnage and Fantastic Four) for a total of 2 rows. I.CustomField3 LIKE '%ptych%' AND I.Title in ( SELECT Min(A.Title) as Title FROM ComicIssues A WHERE A.CustomField3 LIKE '%ptych%' Group by A.CustomField3 )
  18. Short answer is No. Every row in CB has a unique ID (which is why the Group By box was useless and removed). However, if you can be more specific with data, examples, and desired results, I may be able to find a way around this.
  19. Yes, you can Select All (click on the corner or use CTRL+A or you can us a Press and Hold the CTRL key to select non-consecutive issues. But those were outside your parameters. (and would have been a whole lot more testing...
  20. It is a little more complicated. Test data: Regular Find Cover Artist: Benes, Mariah 10 total rows. 9 rows with just Mariah Benes There are 4 possible ways to run Quick Change when Selecting all the rows that only have Mariah Benes for Cover Artist: Sort Ascending, click first row with only Mariah Benes, scroll down, press/hold Shift and click on last row with onl Mariah Benes' Sort Ascending, scroll, click last row with only Mariah Benes, scroll up, press/hold Shift and click on first row with onl Mariah Benes' Sort Descending, scroll down, click last row with only Mariah Benes, scroll up, press/hold Shift and click on first row with onl Mariah Benes' Sort Descending, click first row with only Mariah Benes, scroll down, press/hold Shift and click on last row with onl Mariah Benes' Here is a (shortened) list of the Cover Artist Values in Ascending and Descening order with Numbers to be specific on what rows are clicked on. Ascending order: 1 Ed Benés, Mariah Benes 2 Mariah Benes 3 Mariah Benes 4 Mariah Benes Shift Click on rows 2 then 4, fail, but 2 rows were changed. Shift Click on rows 4 then 2, success Descending order: 1 Mariah Benes 2 Mariah Benes 3 Mariah Benes 4 Ed Benés, Mariah Benes Shift Click on rows 1 then 3, success, but only 4 rows changed. Shift Click on rows 4 then 2, fail, but 1 row was changed. Results. Only one of the four methods worked successfully AND updated all the rows (Ascending order, click Last then First). One didn't cause any error messages but only changed 4 out of 9 rows (Descending order, click First then Last). Two caused error messages. Ascending, click First then Last (changed 2 out of 9 rows) Descending, click Last then First (changed 1 out of 9 rows) ERROR MESSAGES First: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index when attempting to update grid cells for row 1 - field CoverArtist - Value Mariah Benés Followed by: Index was out of range. Must be non-negative and less than the size of the collection. Parameter: index when getting item id for row 2 Repeated for each row as you clicked Ok.
  21. I am unable to re-create your situation. Find CoverArtist 'Benes, Ed' Click on Cover Artist header to sort. Select/Highlight all the single 'Ed Benes' rows. Quick change to 'Ed Benés' Change completed without any problems or errors. Am I missing a step? It may be possible if you have made a lot of changes, a Rebuild Lists could help.
  22. I am not disagreeing with you but I can save you a click or two. After click in the box to 'check' it., click on the same Field name (not a different one) to enable the Move Up/Down functionality. Basically, the Field column needs to be high-lighted to actually move up/down.
×
×
  • Create New...