ACM Export download file

TitanArch

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?

Huw

There should be a 'deleted' column, IIRC, that indicates these.

TitanArch

Yes, there is a Deleted column; thanks for the tip!

quir0z

However, changing the value on the Deleted column to "Yes" or "X" don't do anything upon reimporting. Thoughts?

Huw

I'll check the code. I think it's probably not implemented though.

quir0z

Thanks Huw. Looking forward to your answer. It'll save me a lot of time as I edited already almost 500 rows.

Huw

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...

quir0z

Any other possible way to update inventory via spreadsheet?

Lebostein

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:

http://lebostein.de/lsetwatch/