Jump to content

Jeff Lynch

Members
  • Posts

    57
  • Joined

  • Last visited

  • Days Won

    14

Everything posted by Jeff Lynch

  1. Any News? last update did have some improvements but no fix to this bug. I really would like to update key information for my collection with the latest catalog information. Thanks, Jeff
  2. Any update regarding this issue? the issue persists and I would really like to update the information for my collection with the latest catalog information. Thanks, Jeff
  3. I see that 'OneDrive' is mentioned in the path, its a longshot but i have seen issues with syncing with onedrive cause issue with installation/updates of apps at work. Might be worth a try to pause its syncing (i believe 2hrs is the minimum, can always resume or restart to get one drive to resume synching) Best of Luck Jeff
  4. Did some poking around in the db (after taking a backup) to see if i could figure out something that might be causing it, but no luck... However of note, I did find a few entries with a Suffix of '_' and therefore a ScottsNum of <Num>_ (example: 232_) 1164 = thinking should be an 'a' instead of an '_' 2823 = i changed this to an 'a' i remember adding this in July and it does have my username in the 'CreatedBy' field. EXTREME CAUTION WAS TAKEN WITH THIS, didn't want to lose any of the 8,000+ entries in my StampManage collection. Correcting this and performing a 'Compact and Repair Database' allowed me to add 2823a to my collection and update it to add an image. Still unable to head into Stamp Data Manager --> Stamps - Text to update any entries where i want to add the 2024 values from newly purchased price guide. Thanks, Jeff
  5. Unsure why but since upgrading to StampManage Deluxe 2024 I am no longer able to update values/text within Stamp Data Manager-->Stamps - Text. I can still update fields within Stamp Data Manager-->Stamps - Image. Each time I attempt to go to Stamps - Text (for any country/stamp category) i get 3-6 warning dialog boxes that state 'Attempted an unsupported operation.' and only option for this dialog box is 'OK' I have already downloaded the latest file and reinstalled using the latest download mentioned in another post. Any advice? Thanks, Jeff
  6. Excellent news, thank you very much, in the meantime i am going to use PowerShell to query the DB and produce an Excel report Thanks, Jeff
  7. Ok did some more digging after returning from a stamp show this weekend and discovered that I ended up buying some dupes, even though I used the workaround that I thought would work 'Database-QuantitiesOwned' report 😔. I believe I found what is causing the reporting issue. I do prefer (where possible) to collect stamps with selvage and the way its entered or perhaps the way i entered the stamp format into the UI. Field: Format Working - Single Stamp Not Working - Single Stamp w/selvage, Singe Stamp with Selvage, SWS-Single Stamp w/Salvage I have to remove this since selvage is misspelled) ------------------------------------------------- Although, hmm after looking at my reports directory practically every report (LST,LSV) file has a last modified of December 2022 or older. I had thought the report was updated in the last released patch/update. Does the StampManage update laydown updated version of those reports? Or if worried about preserving user edited filter overwrite where last modified user contains LIBERTYSTREET-1 ? when i look inside the LST file with Notepad++ 'Database-StampsIDontHave.lst' LastModifiedByApp=StampMng.exe [2005, 7, 0, 4] LastModifiedByDLL=CMLL11.DLL [11,4,0,0 (05-08-09 08:46)] LastModifiedByUser=Paul Dembowski on LIBERTYSTREET-1 Database-StampsIDontHave.lst Thanks, Jeff
  8. Collections--> My Collection --> Right-Click on Country -->Database or Checklist Report Using--> Stamps I Don't Have
  9. While exporting content in Tab Delimited format I found a couple of stamps that had tabs at the end of the description field, which of course threw off the columns for the Quantities Owned report when exporting. I was able to quickly identify 2. but alas i only wrote down the second one. Romanian Scott# 5463 Was wondering if any Stamp Variety or Stamp Text updates could be trimmed of leading or trailing white space (spaces and/or tabs) Separate question: Are Tabs supported in any/all fields? Thanks, Jeff
  10. Seems as though an update came out already. I applied the update and still the same problem persisted 🙃. As a work around I am leveraging the Quantities Owned report. I am exporting to Text CSV with the following saved settings: Character Set: UTF-8 Create endless pages CHECKED Separator: Tab Framing: None Header and footer lines: Ignore Ignore group lines: CHECKED Side Note: I gotta add that I love the massive list of supported export formats And then for the last step I run a simple PowerShell script to convert the Tab Delimited file to Excel format $rawReport="Romania_Aug_2023.txt" $DateInfo=Get-Date -Format "dd-MMM-yyy" $myExcelFile=$rawReport.Split("_")[0] + "_" + $DateInfo +".xlsx" $filePath="C:\Users\jeffl\OneDrive\Stamps\Country Reports\" $unformattedreport=Import-Csv -Path $($filePath + $rawReport) -Delimiter "`t" -Header "ScottsNum","Description","Denom","Variety", "Color","DateIssued","ST","PB","FDC" # Requires the opensource ImportExcel PowerShell Module (install-module ImportExcel) # Only because i want to do some formatting to the spreadsheet columns Import-Module ImportExcel $x1=$unformattedreport|Export-Excel $($filePath + $myExcelFile) ` -WorksheetName "StampExport" ` -ClearSheet -BoldTopRow -FreezeTopRow -AutoFilter -TableStyle Medium16 ` -PassThru $ws=$x1.Workbook.Worksheets["StampExport"] Set-Format -Worksheet $ws -Range "A:A" -HorizontalAlignment Right Set-Format -Worksheet $ws -Range "B:B" -WrapText -Width 32 Set-Format -Worksheet $ws -Range "C:C" -HorizontalAlignment Right Set-Format -Worksheet $ws -Range "D:D" -HorizontalAlignment Right Add-ConditionalFormatting -Worksheet $ws -Range "g2:g40000" ` -RuleType GreaterThan -ConditionValue '0' -ForegroundColor "Green" -Bold Export-Excel -ExcelPackage $x1 -WorksheetName "StampExport"
  11. I was attempting to use the 'Stamps I Don't Own' report but i am seeing stamps i own show up in the report, any guidance for troubleshooting this? https://photos.app.goo.gl/3ymKmNYdpkgT9Pq77 https://drive.google.com/file/d/1YL7bxkNHDVrzplcrpoqKyIOwW14XAXvq/view?usp=drive_link tried multiple ways to embed the photo from my google photos or even my google drive but no luck. Examples of the issue are accessible from either link. Thanks, Jeff
  12. Hmm if I am following you. You are saying the Location would be tied to the Album not the Stamp It is my impression that the Location field is relevant to Grading, perhaps? I like the idea and it would be pretty awesome to add a field for AlbumLocation, especially if your collection is distributed across multiple sites/rooms/bookshelves Yah got my vote!
  13. Is it possible to hide the field 'Avg. Cost Per Stamp' if the count for the stamp =1
  14. I recently purchased a Scotts 2023 Standard Stamp Catalog and compared some of the prices in Stamp Manage. I am going through and updating values for stamps I have to correctly reflect what i am seeing in this catalog. My question is this. Is there anything that is added or removed from the price listed in the catalog when just adding the Mint-VF and the Used-VF Prices? I can proceed with just the values listed in the catalog? Asking since I see some discrepancies and wasn't sure if there was a special formula or percentage added/removed from the Catalog prices In the example below for the 1975 Romanian Stamp (2553) with a catalog value of .4 and .25, I believe they are just added directly yes? Pretty sure that is all that's to it, and can't hurt to confirm. Thanks, Jeff
  15. @admin - Thanks for ensuring this was fixed in the update. Just went through adding the Scotts Values for several Romanian stamps, and added the Scott's Variety # without issue. I just have to remember to switch between stamps before saving out of the Data Manager. If i update a single stamp value without switching to another stamp the update to the single stamp is not saved. Thanks, Jeff
  16. Hi-level answer: If you are scanning your stamps outside of StampManage, save them to your image folder. You will be importing them within the app, this will ensure they get placed in the appropriate StampManage folder. Multiple approaches: Initiate the scan directly from within StampManage Open the stamp properties of the desired stamp from your collection Click on Picture tab from the upper right corner where 'Scanner/Digital Camera' is located click on select source and ensure your scanner is selected Click on 'Acquire Image' Note: I had to close and reopen the stamp properties after completing the 'Selecting Source' step After Image appears within the Stamp Properties Pictures tab, continue to add photos (up to 4 based on the UI) Click on OK to save your changes Your photo(s) that were scanned will be stored in your 'Collection Stamp Images Directory' Scan externally using your favorite app and store where you wish. From within StampManage open the stamp properties of the desired stamp Click on Picture tab Click on Import, locate the image you scanned/saved of the stamp and click on Open to import the image (this will copy the photo to your 'Collection Stamp Images Directory' Click on OK to save your changes You can also just copy a photo of the stamp from a web page and then leverage the 'Clipboard'-->'Paste' feature found on the Pictures tab. This will also store the photo in the 'Collection Stamp Images Directory'
  17. Any luck reproducing the issue. Additionally since i clicked on the 'upload changes' button within the data manager it seems to be recalculating all stamps like it used to a few versions back Other functionality is still working without issue, at least of the features I have used.
  18. Thanks for adding this to the picklist!
  19. Running Stamp Manage Deluxe 2023, after the latest update I can still get into the Stamp Data Manager, Can select and update from the 'Stamp - Image' tab Cannot select entries or edit within 'Stamps - Text' when i head into that area I get the following dialog box popping up ~4x and each time I attempt to click on an entry it pops up another 2x Please advise. I was working on expanding some details and adding/updating records in Romania Thanks, Jeff
  20. When using the add a stamp, the dialog box allows you to select the category (to help with filtering if you are browsing through the stamps to locate your stamp) from the lower right part of the window as depicted below. If you didn't previously have any stamps in that category, it will automatically create that category in your collection.
  21. How can I add a cancellation type? Currently I see: Fancy Cancel Light Cancel Average Cancel Heavy Cancel Pre-Cancel I would like to add CTO or Cancel to Order. Is this possible? Thanks, Jeff
  22. Really enjoying StampManage 2022 deluxe, especially the Resizable Stamp Entry Window, to allow me to use more of my larger monitor real estate. I had a few, super minor asks, unsure if it's just my display but figured can't hurt to ask. 1. the price box, can this be moved over a bit since you can see that it's positioned either on the UI framed box or hanging just below it 2. the UI framed box can this be moved down to beneath the lower part of the price box? 3. the page detail, can the framed box for the album area be inclusive of the page fields since this is currently seated beneath the lower part of the framed box? Thanks, Jeff
  23. A super low level ask, but must ask. How can I specify the flag a country uses if one is not currently used?
  24. just removed my photos since there is a limit to what we can store in this forum
  25. Never noticed that one before. I can see that on the SM2020 version I am running as well. I normally only enter a quantity of 1 for most entries so never noticed that one. Curious find indeed
×
×
  • Create New...