Shopping at LEGO or Amazon?
Please use our links: LEGO.com Amazon
As an Amazon Associate we earn from qualifying purchases.

ACM Export download file

TitanArchTitanArch US-Iowa-DavenportMember Posts: 27
I have noticed that the CSV export of the ACM data still includes sets that I have owned but do not own now. It's not that many extra rows at this point, but I'm wondering if there is a way to get those records to go away?

Comments

  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,522
    There should be a 'deleted' column, IIRC, that indicates these.
  • TitanArchTitanArch US-Iowa-DavenportMember Posts: 27
    Yes, there is a Deleted column; thanks for the tip!
  • quir0zquir0z Member Posts: 20
    However, changing the value on the Deleted column to "Yes" or "X" don't do anything upon reimporting. Thoughts?
  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,522
    I'll check the code. I think it's probably not implemented though.
  • quir0zquir0z Member Posts: 20
    Thanks Huw. Looking forward to your answer. It'll save me a lot of time as I edited already almost 500 rows.
  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,522
    I've just checked and it doesn't look at that column. I think it's because the ACM is kept in sync as you mark, and unmark, 'I Own' so acting on the deleted column would have implications on the main collection data.

    It's not impossible, but tricky...
  • quir0zquir0z Member Posts: 20
    Any other possible way to update inventory via spreadsheet?
  • LebosteinLebostein GermanyMember Posts: 12
    I have build my own tool (Lsetwatch) after I did not get along with the ACM editor at all. If you are interested, download and test it. You can import your Brickset-ACM-file and there is a possibility to download and show all Brickset-Set information automatically for offline use. The website is german only, but the tool is available in english too:

Sign In or Register to comment.

Shopping at LEGO.com or Amazon?

Please use our links: LEGO.com Amazon

Recent discussions Categories Privacy Policy

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Brickset.com is a participant in the Amazon Services LLC Associates Program, the Amazon.com.ca, Inc. Associates Program and the Amazon EU Associates Programme, which are affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.

As an Amazon Associate we earn from qualifying purchases.