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

Thanks - but I already had understood that issue - all parts are 'U'. I have found that by ensuring that I completely exit and re-load BF and then slowly adding parts, say 5 or 10 at a time, all works well, if prices cannot be found the scan stops and I can see which part caused the problem. Remebering to exit BF, modify the partys list with BS and then restart BF and re-open the file. (If I tried just closing the file in BF. Modifying it with BL and then reopening it with BF without restarting BF there were issues.) I then take that part out and try again, When all the parts I added are 'priced' the process complets. I can then take out any parts that are 'scarce' (<10 shops) I then sat 'exclude' on all those parts and add another 10. Once the process was complete for all 100ish parts I was left with 2 lists, one that was able to find parts in more than 10 shops - 65 parts, 110 items, and one with scarceparts. Sadly no 4 shop solutions in the UK. The scarce list has 35 lots, 5 items, of those 12 lots have no 6 month average price from BL. I suspect it was the last 12 lots that were causing the problem. Now I understand whats happening and I can see a process to use. 1. Build the list in Brickstock - populate with prices and exclude those with no price available. 2. Upload the remainder to a BL Want file and look at availability within the required region, exclude scarce parts 3. Run BF on the remainder. Allan

Now i am getting an error If I log in to BL and check part no. 2351 Crane Arm Center in Black it is available in 44 stores and the price guide is properly populated. This is the first item in the file. If I turn off 'Log in to retrieve Price Guide Pages' there is no error Indeed there were several items in the list that has no sources. I changed status to 'x', saved the file. CLosed and re-opened BF and tried again with log in enabled and got the same error message. Tried calculate again and got a slightly different error According to BL all parts are available inthe UK, but some of them have limited sources. BrickStock is able to put a 6 month average price against all of the parts inthe list. tried saving the file. Re-opening with brickstock and changing all part status to 'x' and then resetting status and a small number of parts to 'tick' - same error on first part enabled in the list , in this case a yellow 1 *2 grill 2412b, empy price guide Allan Closed BrickFiciency and reopened and loaded the short file and it works. Seems closing and re-opening files doesn't work, but closing and re-loading app picks up ok. Now to try adding a few parts at a time. Allan

Its working this morning, just flashed through the databse load - must have been network issues or something

I just installed Brickificiency. I downloaded the program and the SQL free server , installed the server and ran the program. I am using 64bit Win8.1 so I downloaded the 64bit version of the SQLServer. When I run Brickificiency it starts 'Downloading BrickLink database', the green progress bar gets abt half way across the screen then stops. After a while I get 'Brickificiency has stopped working' error message from Windows. I tried several times, sometimes the 'stoppedworking doesn't appear, it just hangs and after a couple of hours I closed the program and tried again. Any suggestions what may be going wrong would be appreciated. Thanks

Just joined up - as an old fogie I have had Lego since around 1962. Admittedly its been in the loft for many of those years. It came out again when my son played with it in the 1980s, and then went back in the loft along with his 1980s era Lego. Sadly the grandchildren arent interested at all - so what do I do with all that vintage 'Pat Pend' era Lego. Polite suggestions welcome. I cant access MyProfile to edit my website link - so its my Lego web page.