Jeff Lynch

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

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

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

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

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

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

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

Collections--> My Collection --> Right-Click on Country -->Database or Checklist Report Using--> Stamps I Don't Have

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

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"

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

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!

Is it possible to hide the field 'Avg. Cost Per Stamp' if the count for the stamp =1

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

@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