Greg Picklesimer

The case statement (after I added a qty in stock > 0) did exactly what I expected it to do. However, it's not as useful as I expected since the display of the year4 value is still the NM value, which makes comparison tedious. Maybe what follows belongs in a different thread. My problem is coming from using the lock price in the price field to set my selling price. The documentation suggests there is a Selling Price field available but I can't seem to find that in the columns to display setup or the fields drop down in the advanced find in Professional. Does that field still exist? How does one allow the updates in the price field but keep set prices for the selling price?

Thanks, Steve. I'm just using the values to identify books that I may have underpriced and need to do some more investigation so this should be fine even if the year 4 value isn't exact. I was thinking there was maybe a table that I could use the condition as a key to find the multiplier value to make the calculation, like python has.

How would I access the values stored in the grading table to calculate the current price? I have set and locked my on prices and want to find issues that are less than a percentage of the current price. For example I.[Price] < I.[ValueYear4] * .5 will find if my prices are less than 50% of the year4 NM value. So I need to replace the ValueYear4 with the condition adjusted value using the grading table multipliers.

Thanks, guys. I can think of several ways to do this using a copy of the databases involved and standard/custom tags so I can get it done. Just seemed to me like import/export would have been cleaner.

I would like to export a subset of one database and import it to another database. I can used the advanced search to identify and select the entries I want to move but I don't see any way to use the export command to work on a group of items that is selected. Is this possible (with Pro)? Is there another way to accomplish this besides exporting the entire database and editing the text file? Greg

Thanks, Mark, That seems to have worked. Greg

Hi, I'm having trouble when Sidekick opens using ComicBase 2022. Details below. Any idea what I need to do to resolve this? Thanks, Greg ************** Exception Text ************** System.IO.FileLoadException: Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) File name: 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' at ComicBase_Sidekick.Badges.VB$StateMachine_12_SyncBadgesAsync.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at ComicBase_Sidekick.Badges.SyncBadgesAsync() at ComicBase_Sidekick.FrmMain.VB$StateMachine_12_FrmComicBaseSidekick_Load.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.<ThrowAsync>b__6_0(Object state) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. ************** Loaded Assemblies ************** mscorlib Assembly Version: 4.0.0.0 Win32 Version: 4.8.4470.0 built by: NET48REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll ---------------------------------------- ComicBase Sidekick Assembly Version: 22.0.1.1607 Win32 Version: 22.0.1.1607 CodeBase: file:///C:/Program%20Files%20(x86)/Human%20Computing/ComicBase%202022%20Professional%20Edition/ComicBase%20Sidekick.exe ---------------------------------------- Microsoft.VisualBasic Assembly Version: 10.0.0.0 Win32 Version: 14.8.4084.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll ---------------------------------------- System Assembly Version: 4.0.0.0 Win32 Version: 4.8.4360.0 built by: NET48REL1LAST_C CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Core Assembly Version: 4.0.0.0 Win32 Version: 4.8.4470.0 built by: NET48REL1LAST_C CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll ---------------------------------------- System.Windows.Forms Assembly Version: 4.0.0.0 Win32 Version: 4.8.4400.0 built by: NET48REL1LAST_C CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System.Drawing Assembly Version: 4.0.0.0 Win32 Version: 4.8.4390.0 built by: NET48REL1LAST_C CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Configuration Assembly Version: 4.0.0.0 Win32 Version: 4.8.4190.0 built by: NET48REL1LAST_B CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Assembly Version: 4.0.0.0 Win32 Version: 4.8.4084.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Runtime.Remoting Assembly Version: 4.0.0.0 Win32 Version: 4.8.4084.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll ---------------------------------------- System.Net.Http Assembly Version: 4.0.0.0 Win32 Version: 4.8.4084.0 built by: NET48REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Net.Http/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Net.Http.dll ----------------------------------------

I'm using ComicBase 2020 Professional v20.0.3.3804. I'd like to change the price of a subset of issues based on a percentage of their 2020 value. I can use the Find command to identify the issues in the range and using the CTLR-A, I can select them. The Quick Change recognizes the correct number of issues selected but seems to only allow a fixed value, not the percentage multiplier like Mass Change. When I try to use Mass Change on the selected items, it does not use the currently selected issues (shows none selected) but opens a new select GUI with Titles in the header. Why does it not recognize the preselected set from the Find command? Greg