Generate custom LDCad set part bin

[Trevor Sandy]

Is there a way to delete the faulty entry?

Philo, Yes there is. Roll up your DB admin sleeves...

BrickUtils uses H2 - the java SQL database (http://www.h2database.com/html/main.html). You'll need to start with obtaining their jdbc driver to connect - use the URL above.

Next you'll need a nice DB utility to query the BrickUtils dataset. I use Execute Query (http://www.executequery.org/index.php). It's java based and completely portable.

With Eq, you can directly manipulate the table or export to Excel (or whatever you want), manipulate the dataset and import. H2 is light-weight so you easily copy/paste to make a working copy of your BrickUtils DB.

Although it is quite obvious once you've connected the the schema, the data table you'll be interested in is PARTMAPPING. Here's an image of the schema.

   

Let me know if you need any specifics on setting up your DB connection ?

Cheers,