Jump to content


Diecast Database Program


  • Please log in to reply
246 replies to this topic

#1 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 07 March 2010 - 08:09 AM

Here's something I've been working on in my spare time for the past year. It's a desktop application you can use to track & manage your diecast collection. I have just finished a new version it is available here if you're interested.

I will be starting on the next version soon (mainly performance improvements) but if you do decide to download & take a look please let me know what you think. My ultimate goal is to sell the software once I'm happy with the feature set and performance.
-- Douglas

Remove Advertisements User is offline Advertisement

  • DieCastXChange.com



#2 OFFLINE   Florin

Florin

    Member

  • DX Community
  • Pip
  • 2,626 posts
  • Gender:Male
  • Favorite Brands:Minichamps, Kyosho
  • Proud Citizen of: ca

Posted 07 March 2010 - 09:58 AM

I did download it and took a quick look at it. It looks pretty good, however don't have the time to create my DB right now. I will surely give you feedback.

One question:
My collection is split in 3 subcollections. How do you suggest that I handle that? Use different catalog #s (like C1/C2/C3 or 001/002/003) preceding the sequential catalog #?

Thanks   :clap:
But...but...but the Chinese labor rates!

#3 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 07 March 2010 - 10:40 AM

View PostFlorin, on 07 March 2010 - 09:58 AM, said:

I did download it and took a quick look at it. It looks pretty good, however don't have the time to create my DB right now. I will surely give you feedback.

One question:
My collection is split in 3 subcollections. How do you suggest that I handle that? Use different catalog #s (like C1/C2/C3 or 001/002/003) preceding the sequential catalog #?

Thanks   :clap:
Take a look at the groups. I'm thinking you could create 3 different smart groups based on a user tag. Using your example user tags could be C1, C2, & C3 or 001, 002, & 003.
-- Douglas

#4 OFFLINE   mairandeddy

mairandeddy

    Die-cast Happy Clappy!

  • DX Administrator
  • PipPipPipPipPip
  • 23,961 posts
  • Gender:Male
  • Location:Milford Haven
  • Favorite Brands:Kyosho,GMP
  • Proud Citizen of: gb

Posted 07 March 2010 - 11:17 AM

Thanks for sharing dbonser  :clap:

I've downloaded it and had a bit of a play.....it looks very good to me - i havent found anything that doesnt meet my needs  :tongue4:

MOTORHEAD - 21ST CENTURY - MOTORHEAD ALRIGHT!!!

Fast Eddy's

Weddings........................and .....................FUNERALS!

Posted Image


#5 OFFLINE   morpheus1979

morpheus1979

    Junior Member

  • DX Community
  • 1 posts
  • Favorite Brands:autoart
  • Proud Citizen of: es

Posted 07 March 2010 - 02:21 PM

A really, really good  aplication

Thanks so much from Spain

#6 OFFLINE   simondc07

simondc07

    Member

  • DX Hall of Fame
  • Pip
  • 3,554 posts
  • Gender:Male
  • Location:Melbourne
  • Interests:Cars, Sports, Finance, Poker, and the Wild
  • Favorite Brands:Exoto, CMC, GMP
  • Proud Citizen of: au

Posted 07 March 2010 - 05:41 PM

Very useful and easy to use database - love the features especially regarding the input of 1:1 specifications such as history. For insurance claim purposes this would be very handy to provide to underwriters.

Posted Image


#7 OFFLINE   klmneo

klmneo

    Junior Member

  • DX Community
  • 13 posts
  • Gender:Male
  • Location:Blacksburg, VA
  • Favorite Brands:Kyosho, PMA
  • Proud Citizen of: cn

Posted 07 March 2010 - 06:00 PM

Thank you dbonser,

this is a very useful database for all dxers!  :clap:

#8 OFFLINE   Diecast24/7

Diecast24/7

    Bronze Member

  • DX Hall of Fame
  • PipPipPip
  • 10,700 posts
  • Gender:Male
  • Location:Tropic of Cancer - Paradise!
  • Favorite Brands:Exact Detail
  • Proud Citizen of: us

Posted 07 March 2010 - 06:29 PM

Best wishes to your success, Douglas as I think you can fill a real void! I'm sure you'll get plenty of beta testers here at DX who can help you find-tune it! Posted Image
Justin

#9 OFFLINE   workhurts

workhurts

    Member

  • DX Community
  • Pip
  • 282 posts
  • Gender:Male
  • Interests:Cars, motorcycles and tennis
  • Favorite Brands:PMA, Kyosho, Exoto & CMC
  • Proud Citizen of: us

Posted 07 March 2010 - 07:18 PM

Looks good.  I'll try it out throughout the week and provide feedback.

#10 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 08 March 2010 - 07:47 AM

Thanks for checking it out guys!   :clap:

Please let me know what you think of it.
-- Douglas

#11 OFFLINE   JerryLH3

JerryLH3

    Member

  • DX Community
  • Pip
  • 454 posts
  • Gender:Male
  • Location:Tampa, FL
  • Interests:Cars, racing, racing cars, diecasts, travel, food
  • Favorite Brands:All of Them
  • Proud Citizen of: us

Posted 08 March 2010 - 02:39 PM

I only added one car so far, but I like it.  It's a simple interface with a nice looking display and summary.  Like others, I'll be adding things to it this week and will provide any more feedback I can.
Jerry

#12 OFFLINE   workhurts

workhurts

    Member

  • DX Community
  • Pip
  • 282 posts
  • Gender:Male
  • Interests:Cars, motorcycles and tennis
  • Favorite Brands:PMA, Kyosho, Exoto & CMC
  • Proud Citizen of: us

Posted 08 March 2010 - 08:01 PM

How do I go about exporting the database?  If I can import in .csv it might be nice to export in .csv.

Looking good so far.  One more thing.  It'd be nice to be able to launch a image viewer from the software or have the ability to make the image bigger.  I only have one fake car in there so far and will try the import utility next.  Maybe even provide a zoom utility within the image viewing window.

Edited by workhurts, 08 March 2010 - 08:23 PM.


#13 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 08 March 2010 - 10:09 PM

View Postworkhurts, on 08 March 2010 - 08:01 PM, said:

How do I go about exporting the database?  If I can import in .csv it might be nice to export in .csv.

Looking good so far.  One more thing.  It'd be nice to be able to launch a image viewer from the software or have the ability to make the image bigger.  I only have one fake car in there so far and will try the import utility next.  Maybe even provide a zoom utility within the image viewing window.
Export is on my to-do list for the next version.

Because of certain restrictions with the AIR runtime it's not so easy to launch external programs (if that's what you meant by an image viewer). Double clicking a thumbnail in the item details view will show a larger version of the image. However, that larger version is limited to the original image size or available screen real-estate (whichever is smaller). A zoom feature in there should be fairly easy to do though.
-- Douglas

#14 OFFLINE   mbc112

mbc112

    Member

  • DX Elite
  • Pip
  • 3,642 posts
  • Gender:Male
  • Location:Belgium
  • Favorite Brands:CMC,Norev
  • Proud Citizen of: be

Posted 09 March 2010 - 05:28 AM

an EDIT button ? if I want to change the info of a car, it does not want to save those changes....

Edited by mbc112, 09 March 2010 - 05:31 AM.

Gunther

Posted Image

#15 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 09 March 2010 - 09:29 AM

View Postmbc112, on 09 March 2010 - 05:28 AM, said:

an EDIT button ? if I want to change the info of a car, it does not want to save those changes....
Just view an existing item in the list (view button or double-click), make your changes & click Save.
-- Douglas

#16 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 09 March 2010 - 05:10 PM

I just uploaded a new version that incorporates a framework to handle application updates. Updates to this version will be much simpler and are as easy as clicking a button.

Now, the bad news (this is a work in progress, after all). For those who have already downloaded the application there is some work to get updated to this version (future updates will be painless). Please read these instructions if you have already downloaded the application prior to reading this message. Thanks!
-- Douglas

#17 OFFLINE   118

118

    Member

  • DX Community
  • Pip
  • 306 posts
  • Gender:Male
  • Location:NoVA
  • Interests:1/18 cars
    1/72 military jets
    1/400 airlines
  • Favorite Brands:GT Spirit
  • Proud Citizen of: us

Posted 10 March 2010 - 05:20 PM

How to import my speadsheet into this app?

#18 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 10 March 2010 - 06:20 PM

View Post118, on 10 March 2010 - 05:20 PM, said:

How to import my speadsheet into this app?
Check out Section 14 of the manual.
-- Douglas

#19 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 03 April 2010 - 08:45 AM

I just posted version 0.2.3 a few hours ago. If you already have v0.2.1 you can update to v0.2.3 through the About Box (Tools -> About menu item) in the program. Otherwise, v0.2.3 is available from the Diecast Database Program main page. Be sure to download the updated user manual for information on the new features.

Version 0.2.3 includes the following changes:

New/enhanced features
  • Better performance with large (1,000 items or more) groups
  • NEW: Wish List
  • NEW: Data export
  • Data import enhancements:
    • Support for more date formats:
      • MM/DD/YYYY
      • DD/MM/YYYY
      • DD.MM.YYYY
      • DD,MM,YYYY
      • YYYY-MM-DD
      • MM/YYYY (dates will default to the first of the month)
    • Support for more currency formats:
      • 1234.56
      • 1,234.56
      • 1.234,56
      • 1 234,56
    • Better handling of embedded double-quote (") and comma (,) characters in import files
    • Allow blank dates and years in import

Bug fixes
  • Fixed database migration issue when migrating from v0.2.1 to v0.2.2
  • Fixed crash when editing an item in a filtered list and saving changes that would remove it from the filtered list.
  • Fixed crash when performing expense analysis on regular groups.
  • Fixed bug where values greater than $999.99 would be changed to $1.00.
  • Fixed bug in date field breakdowns for regular and smart groups.
  • Fixed bugs when adding an item to an empty group (deleting, selecting, drag and drop, etc.).
  • Fixed bug where new item would not always scroll into view if the new item was the first item in the list.
  • Removed tool tip text from Import button when it is disabled because an import is in progress.
  • Average line always displays even when expense is $0 for the time period.

Edited by dbonser, 05 April 2010 - 11:09 AM.

-- Douglas

#20 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 05 April 2010 - 11:09 AM

bump
-- Douglas

#21 OFFLINE   mbc112

mbc112

    Member

  • DX Elite
  • Pip
  • 3,642 posts
  • Gender:Male
  • Location:Belgium
  • Favorite Brands:CMC,Norev
  • Proud Citizen of: be

Posted 06 April 2010 - 02:06 PM

OK, done that...thanks Douglas !!
Gunther

Posted Image

#22 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 15 May 2010 - 08:09 AM

Version 0.2.4 is now available and includes a lot of tweaks and bug fixes. You can download it from the main dcdb page or through the update mechanism within the program. The documentation has been updated as well.

The only 'new' feature is that Smart Groups can now search 'All Items' group, 'Wish List' group, or both. If nothing else, please read the following 4 points detailing changes to existing data:

IMPORTANT INFORMATION ABOUT CHANGES TO EXISTING DATA
- Any non-numeric characters will be removed from existing Competition Car No. values.
- Any non-numeric characters with the exception of ':' and '/' will be removed from existing Model Scale values.
- If you have created any Smart Groups that use the Competition Car Number field please edit them and choose the correct operator since the valid operators for this field have changed.
- Existing smart groups will default to search 'All Items' group

Enhancements/New Features
- Smart Groups can now search 'All Items' group, 'Wish List' group, or both groups
- The image browser will scroll to show the image after adding an image from a file or URL
- Line breaks in User Tags and User Notes values are now preserved during export and import
- Competition Results values in list view & list preferences now sort as follows: blanks, 1st, 2nd, 3rd, ..., 99th, ..., DNF, ...
- Model Scale values in list view & list preferences now sort as follows: blanks, 1:100, 1:72, 1:64, ..., 1:43, 1:24, 1:18, ...
- Competition Car No. values are now numeric only - non-numeric charcaters will be removed from database entries
- Model Scale values are now numeric and ':' or '/' only - other values will be removed from database and list preferences entries
- Export file name is checked to ensure that is has a .csv extension
- Better checking of Model Year, 1:1 Year, Competition Year values in import

Bug Fixes
- Competition Car No. values in list view now sort correctly
- Pre-Order Date, Purchase Date, Ship Date, Receive Date, Sale Date, and Loss Date values in list view now sort correctly
- Pre-Order Price, Purchase Price, and Sale price values in list view now sort correctly
- Fixed a problem where filtering lists would not always return the correct entries: "2010" would match " 10", '%' and '_' characters would not work
- Fixed a problem where filtering lists on date values would not always return the correct entries
- Fixed a problem where smart groups would not always find the correct entries: "2010" would match " 10", '%' and '_' characters would not work
- Fixed bug where the correct operator was not selected when editing an existing smart group
- New Item From Selection & New Wish List Item From Selection are enabled only when 1 item is selected
- Fix export bug where list view contents would change to show the contents of the group that was exported
-- Douglas

#23 OFFLINE   Diecast24/7

Diecast24/7

    Bronze Member

  • DX Hall of Fame
  • PipPipPip
  • 10,700 posts
  • Gender:Male
  • Location:Tropic of Cancer - Paradise!
  • Favorite Brands:Exact Detail
  • Proud Citizen of: us

Posted 15 May 2010 - 11:26 AM

Wow, Douglas! Posted Image  This is really turning into something!
Justin

#24 OFFLINE   mbc112

mbc112

    Member

  • DX Elite
  • Pip
  • 3,642 posts
  • Gender:Male
  • Location:Belgium
  • Favorite Brands:CMC,Norev
  • Proud Citizen of: be

Posted 15 May 2010 - 12:45 PM

Thanks Douglas !   :bawling:
Gunther

Posted Image

#25 OFFLINE   dbonser

dbonser

    Member

  • DX Sponsor
  • Pip
  • 1,422 posts
  • Gender:Male
  • Favorite Brands:Ebbro, HPI, Spark
  • Proud Citizen of: us

Posted 16 May 2010 - 09:49 AM

View PostDiecast24/7, on 15 May 2010 - 11:26 AM, said:

Wow, Douglas! Posted Image  This is really turning into something!
It's getting there Justin. I keep thinking of more features to add but I'm planning for one more release and then I'm considering it v1.0. At that point I'm not sure what I will do - do I offer it for sale, make it donation-ware, or just call it done and stop working on it? It does take a lot of my time and I'm not sure how feasible it is to try to sell something like this even though that's really what I would like to do.

View Postmbc112, on 15 May 2010 - 12:45 PM, said:

Thanks Douglas !   :bawling:
You're welcome!

Edited by dbonser, 16 May 2010 - 09:49 AM.

-- Douglas




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users





©2003-2014 DiecastXchange - The Complete Diecast Car Collectors Message Forum | Privacy Policy | Terms of Use