tsrplatelayer

Thankyou. I downloaded this new version. 1. Import wanted list from BrickLink - fails with "Unhandled exception has occured - Table doesnt have a primary key." This doesnt happen with 95.4. 2. Open Wanted list (same one as previous) - Availstores is not populated, column is blank, despite progress window showing details are available. Attached are screen grab and my BF folder from the roaming profile - zipped together - https://www.dropbox....0rw/BF.zip?dl=0 This is probably due to 'United Kingdom' being set in the settings file. Also the settings in a users BL account may be significant - i.e. currency? 3. If I open the wanted file - available column is blank - click calculate and change 'Countried to Query' settings to 'All Countries'. Close BF and reopen BF, then reopen file availstores gets data - but active - highlighted row - shows 'unknown' in availstores until I move the focus to a new row when the 'unknown' gets replaced. This changes the <country' value in the settings file. It might be useful to have a 'button' on the bar or drop down in a menu to clear the cache and repopulate the available column. Thanks again Allan

OK - while it seems to be working - tried downloading a wanted list from Brickstok - got an error message "Unhandles exception has occured - Table doesnt have a primary key. - details as follws See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Data.MissingPrimaryKeyException: Table doesn't have a primary key. at System.Data.DataTable.FindByPrimaryKey(Object value) at Brickficiency.Mainwindow.itemTimerNew_Tick(Object sender, EventArgs e) at System.Windows.Forms.Timer.OnTick(EventArgs e) at System.Windows.Forms.Timer.TimerNativewindow.WndProc(Message& m) at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 4.0.0.0 Win32 Version: 4.6.1063.1 built by: NETFXREL3STAGE CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll ---------------------------------------- Brickficiency - AvailstoresAlpha Assembly Version: 0.95.4.0 Win32 Version: 0.95.4.0 CodeBase: file:///C:/Users/allans/Desktop/Brickficiency%20-%20AvailstoresAlpha.exe ---------------------------------------- System.Windows.Forms Assembly Version: 4.0.0.0 Win32 Version: 4.6.1038.0 built by: NETFXREL2 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 4.0.0.0 Win32 Version: 4.6.1038.0 built by: NETFXREL2 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Assembly Version: 4.0.0.0 Win32 Version: 4.6.1068.2 built by: NETFXREL3STAGE CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Data Assembly Version: 4.0.0.0 Win32 Version: 4.6.1038.0 built by: NETFXREL2 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- System.Core Assembly Version: 4.0.0.0 Win32 Version: 4.6.1038.0 built by: NETFXREL2 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll ---------------------------------------- System.Xml Assembly Version: 4.0.0.0 Win32 Version: 4.6.1064.2 built by: NETFXREL3STAGE CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Configuration Assembly Version: 4.0.0.0 Win32 Version: 4.6.1038.0 built by: NETFXREL2 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- Microsoft.GeneratedCode Assembly Version: 1.0.0.0 Win32 Version: 4.6.1064.2 built by: NETFXREL3STAGE CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Data.SqlServerCe Assembly Version: 4.0.0.0 Win32 Version: 4.0.8482.1 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Data.SqlServerCe/4.0.0.0__89845dcd8080cc91/System.Data.SqlServerCe.dll ---------------------------------------- System.Transactions Assembly Version: 4.0.0.0 Win32 Version: 4.6.1038.0 built by: NETFXREL2 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.EnterpriseServices Assembly Version: 4.0.0.0 Win32 Version: 4.6.1038.0 built by: NETFXREL2 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- System.Numerics Assembly Version: 4.0.0.0 Win32 Version: 4.6.1038.0 built by: NETFXREL2 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll ---------------------------------------- System.Data.DataSetExtensions Assembly Version: 4.0.0.0 Win32 Version: 4.6.1038.0 built by: NETFXREL2 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.DataSetExtensions/v4.0_4.0.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. Testing Alpha Availstores feature https://www.dropbox....issing.bsx?dl=0 The above file used for testing. Opened with Alpha -no problem. Availstores populated - no problem. These seem to be worldwide counts. Checked 'settings' file in the profile it has <countries> <string>All</string> </countries> There doesnt seem to be any way to configure this other than by clicking 'Calculate' and setting country filters here. Changed filter to 'United Kingdom' and performed calculation, which failed - but thats OKit would as some parts were not available. Closed Alpha. Checked settings file again - it now has <countries> <string>United Kingdom</string> </countries> Re-opened Alpha and re-opened wanted file as before Availstores column remains blank, even though the progress box shows all the parts data being downloaded Allan

Well -- I installed Alpha and 0.95.4 on laptop - forgot the SQL CE, wondered what was wrong for a while - remembered and installedf SQLCE - interestingly both 2008 SQL server - full edition and SQLCE3.5 were already installed. Anyway - added 4.0 version. Ran Apha - failed to download database - crash as on desktop. Ran 0.95.4 and downloaded database - no problem Exit and re-run Alpha - added technic connetors as before and it worked. Tried again on my desktop and it worked Explain that!! Lets see what tomorrow brings - ... A thought occurs but may be irrelevant - during the daytime my downloadspeed is 107Mbps, but in the evening it throttles back to 50Mbps do to local area loading. Could the response be ...too quick .... naa thats silly. I will try again tomorrow. Allan

I meant to add that the issue of downloading the database does not happen with 0.95.4, only with Alpha.

As requested - right click opens the appropriate page with the string "Currently Available", it opens quickly without error. Is it possible to add a debug string to save the page received. As I said tomorrow I will try on another computer. My file "Brickficiency - AvailstoresAlpha.exe"is located in "C:\Users\allans\Desktop" I tried "Run as Administrator" - no difference. ALso see https://www.dropbox.com/s/k5kn1cb8itl7dk1/bf2.jpg?dl=0

OK - so we need to work out where the differnces lie. Could it be related to server response times? Could it be related to the access rights on the folder where the file is stored, are any temporary files used that may have rights issues? I it possible to add to the report/ the status area or store sperately additional information to help work out what is going wong? I have tried completely removing both the released and alpha versions, then deleting the user folder - is there any other area that needs cleaning - registry, hidden folders or whatever? I had a look in the roaming/brickficiency/debug/debug-priceguide.txt file - it is empty. I will try - probably on Friday - on my other WIn 10 machine and also my old WIn 7 machine neither of which have had the program installed before. I will check both this part isue and the issue relating to downloading the database - where is the database stored? I hope the image link works - I havn't used this method before. - but just in case https://www.dropbox....tl/bf1.jpg?dl=0 Thanks

No parts list required - as I said I manually added the 32013 and 32014 parts and they generated the error.

I have downloaded and tried again - no change. Original has same problem - see post 8 Feb 10:52 above also see Posted 06 July 2015 - 10:38 AM Allan

I downloaded the alpha, put it in the same folder as my released version, and tried it with the following results. I am using Win 10. Opened program and updated the database, progress bas got about 90% across and then I got the '....has stopped working' crash message. I retried with the same result. I then used my released version to download the database without problem. I manually added 1 part 32013 in Black and got the following error Getting Price Guide information for Black Technic, Axle and Pin Connector Angled #1 Retrying... Retrying... Retrying... Retrying... Error downloading price guide Error downloading price guide (got page, but there was nothing on it) I deleted this part and tried 32014 with the same result. Allan

Please advise what the latest release number is and where I can download it. I have 0.95.4 and it returns " Getting Price Guide information for Black Technic, Axle and Pin Connector Angled #1 Retrying... Retrying... Retrying... Retrying... Error downloading price guide (got page, but there was nothing on it) Some items were unavailable. Calculation cancelled. " Even if this is the only part in the list it fails - yet BrickLink reports it is available in several hundred stores. If I down load a wanted list - which it does successfully. It returns this for the first part in the list. Changing the status to 'X' skips the first part and then returns this error for the second item on the list. Repeat this procedure and every item returns the same error

Just ran a test on a list of 14 freely available parts - worked for me. Also on a list of scarcer parts and it correctly identified which parts were not available. I didn't get the 'retrying' an 'empty page error' but that may be because the parts in BL for sale database havechanged. I had not expected that a user would edit the 'config' file. I had thought it was easier to release an update 'patch' containing a new config text file rather then re-compile a new distro. Also when (not If) BL makes change having all the URLs, file paths and regex expressions in one place means that they are easy to find and you (or anyone else doing the maintenance programming) can easily find them and none get overlooked. But as a user, not the programmer I will just be happy if it keeps on working. Good luck

This isnt my type of programming (I program control systems in assembler), but as a would be user I do hope you find a way forward. Good Luck. One suggestion - perhaps the parts of the code that are related to BL website design/layout could be built into a sperate data file and loaded at run-time. This way any changes to BL will be easily incorparated, needing only a mod and re-release of the data file.

I take your point abt the problems with 'leftovers' For me the 'extra' blue cross only has meaning when downloading a set inventory into BS then it indicates the 'etxra' parts that are in the set box that are not required for the build when built in accordance with the BI. From a buyers perspective I only ever use the 'tick' or if I need to temporarily omit something from a search the 'cross'.

Yes it does handle scarce parts - in so far as the log lists the number of stores with stock. This log can be used to 'exclue' scarce' parts to have a better chance of a solution. This process could be avoided with a user selectable minimum no. of stores. I would offer to have a go myself but my programming skills are very much at the beginner level. Another 'nice to have' would be a 'best incomplete solution' i.e a solution for 2 (3,4 etc) stores with the lowest number of 'leftovers'. As willl be seen from my earlier posts where I listed the extracts from the log it does not deal well with parts that have an empty price page. In fact it wasn't the crane arm that cused the problem, it was a completely different part. This and coupled with re-running giving different errors was frustrating but now I have a way of using iy that works for me I am happy. Despite these issues it is a great piece of much needed software, the author is to be congratulated If anyone wants the BSX file I was using I would be happy to send it.

Yes - double clicking the tick makes it 'exclude' but I found it unreliable without saving, closing BF and restarting. I think the following would be useful to have. 1. A user option to select "Ignore if fewer than 'x' stores have stock" and allow drop down selection of 'x' with a default of, say 25. 2. A list if ignored parts added to he report with the reason it was ignored, i.e. too few stores. 3. Ignore parts that have no price info available, rather than aborting. Ignoring parts could be achived by changing status from include to exclude during the price scanand then then running through the ignored list and setting the status back to include at the end of the processing. Allan