Merge with Bricksync

I'm obviously not doing something right.

I've tried placing the file to be merged in every conceivable location within the data files.

"Failed to load" every time

Comments

  • 23 Comments sorted by Votes Date Added
  • @graham It goes into the same folder that the bricksync.exe file is in
  • I tried that again, but same result. I'm not that up on computers- windows especially- I'm probably doing something wrong!
  • Are you using BrickStock rather than BrickStore?
  • edited August 9 Vote Up0Vote Down
    OK thats weird I'm using Brickstore 13, on my mac the saved file shows as Brickstore .xml
    I sent the file via email to the Windows PC then drag and drop to the location
  • It could be a Mac thing? Can you try emailing the file to me - go to www.brickadoon.com, the email address is on there.
  • "the saved file shows as Brickstore .xml"
    BrickSync needs a BSX file, not an xml file.
    Not sure if that is the issue since your windows is not showing the full file name.

    From BrickStore did you just save the file or export it to Bricklink XML ?

    On the windows machine, right click the file and choose properties, full file name should now be shown
  • "the saved file shows as Brickstore .xml"

    That's your problem. Should be .bsx not .xml. Use "Save As" from within Brickstore rather than "Export".
  • I thought I should report success with help behind the scenes.

    I had an old version of BrickStock lurking somewhere hidden on the PC (I'm a Mac user, so not up on Wintel functionality). That was removed.

    I also had to update BrickSync. Now everything is go!

    Also shout out to the team that keep BrickSync available, I, and many of us, owe them much gratitude!

    Graham
  • Thank you @graham, we got there eventually!

    For info for everyone else who replied, the file format was fine (Graham sent it to over and it worked for me), as was the file name.

    The last resort was to update to the latest BrickSync version, and this fixed it.
  • @brickadoon not sure what caused this or more likely what I did / didn't do? Most lots would merge with preexisting lots, already assigned location (which is what I'm assuming would be remarks)

    In the past using the mass upload to BL I would enter location for new lots later.

    Does this mean I need to enter that data for all lots on BrickStore before using [merge] ?

    Thanks G
  • @graham Yes remarks have to be present in the BrickStore file before you use merge.
  • @brickadoon do remarks in the file to be merged overwrite the existing remarks of current inventory?

    And/or is this something that can be "switched off" so that remarks are not required?
  • @graham I can't remember if they get overwritten or appended to. As far as I know there's no way to switch off sending remarks in the merge command.

    This is what I do to prepare a merge file - it might help you when creating yours?

    1 - Prepare your BrickStore file with the parts you want to add. Leave the Remarks blank, but make sure you've set the prices. Save the file.

    2 - Import your current BL inventory into BrickStore. Select all and set the quantity field to 0.

    3 - Go back to your file with the parts you want to add. Select all and copy.

    4 - Go to your inventory file and paste. In the popup that appears, select the first option ("Use the same options to consolidate all lots"). In the next screen, set your options to those in the screenshot I've posted here. Click Finish.

    What this does is:
    Any parts that you are adding that currently exist in your store are added to the file, with the Remarks that are already in your store.

    Any parts that you are adding that don't currently exist in your store are added to the file, and the Remarks are left blank. I suppose what you could do at this point is to set all of those items to a 'dummy' remark (e.g. XXXX) so you'll know which ones they are.

    5 - Delete all of the parts in the inventory file with a 0 quantity. Save the file.

    This will leave you with a file of the parts you are adding. Some will have a Remark that already exists, some will have a dummy remark.

    Does that help at all?
  • @brickadoon Yes thanks much for that explanation, I'll give it a go !
  • @brickadoon finally took the plunge, with success. Thanks for all your help!

    At first I thought this process would be more cumbersome, however when executing I found it easier :)
  • @brickadoon Am I correct to assume that this way BrickSync "forces" the local inventory into both venues, that it will remove the strange quantity errors Ive been having over the years?
  • @graham Glad you got on OK with the process - it doesn't take long once you get the hang of it :)

    From BrickSync's point of view the inventory on BL is the master (this is the one that gets tracked in the BrickStore directory), so whatever changes on there should be committed to BO too. If you do it through BrickStore it will happen automatically, but if you make a change on the BL website directly (e.g. adding a remark or changing a quantity) you will need to do a 'blmaster on' followed a 'blmaster off' on BrickSync. Don't make any manual changes on the BO website directly, as BrickSync won't pick those up.

    Going back to the previous discussion, how are you going to update the Remarks for those items that didn't have them? Are you just updating them as you put the items away?
  • @brickadoon Updating remarks was much easier!

    Once I had the items missing remarks, where I had a location, i entered that in brickstore remark.

    Lots that had no location I simply added "1" to the remark.

    After the merge the lots (without a location) show up at the top of parts (sorted by remarks) on BL.

    In this case that was only 5 lots... find somewhere to put them enter location on BL (then master on/off) job done!!

    Making life easier too, far less time consuming!
  • @graham Great news! Glad it's working for you.

    If you need to do a bulk update of lots of remarks (or prices) let me know, you can do that in BrickSync too :)
  • @Graham there is an option on Brickstore called Edit-> Copy Values from document, so you just need your partout file, and your imported store, then on the partout file use the copy values option and just ignory qty and copy the rest.
  • In case anyone was still worried about bsx vs xml - .bsx files *are* xml. bsx stands for "brick store xml". It is a specification of xml tags.

    That is all
  • Good to know, a .BSX file opened Final Cut Pro on my mac that didnt have BrickStore on it - that explains it thanks!
Sign In or Register to comment.