Author Topic: KitBase 2 - New 'Paint Stock' Table - Feedback and Comments Appreciated  (Read 971 times)

Admin Gary

  • Developer and Owner of Suisoft
  • Administrator
  • Full Member
  • *****
  • Posts: 141
    • View Profile
    • Suisoft Website
A new table has been added to KitBase 2, allowing paint stock (and similar items such as thinners) to be recorded.

The table will be added in to your database when you upgrade to KitBase 2. As you can see from the screenshot below, KitBase 2 now has a tabbed setup showing the different main tables automatically when you open the database.

The approach I have taken for stock quantity is 'Containers in Stock (Full)', indicating how many bottles/tins you have unopened. This is backed up by a 'Containers Half Used' number, indicating the number of tins/bottles with half or less paint left.

A 'Containers Wanted' field is also provided, so that you can flag the paint you need for upcoming builds.




Stock List

The screenshot below shows the form and the stock list.






Equivalent Colours

Fields are also provided to specify 'Equivalent' colours from different manufacturers and standards, e.g. Equivalent Mr Color.

This screenshot shows paints by 'GSI Creos' number, the common paint numbering system used on many Japanese kits.






As with other tables in KitBase, you can customise the table, form design and views. You can easily add more 'Equivalent' columns to satisfy your requirements.



I have considered more complex solutions, allowing paint requirements to be recorded against kits, so that stock can be looked up automatically.

I'm not sure how many folks would want to fill in that level of detail, therefore I have kept it simple for this release.

Feedback and Comments Appreciated.
« Last Edit: February 09, 2017, 08:24:59 AM by Admin Gary »

kurtd123

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: KitBase 2 - New 'Paint Stock' Table - Feedback and Comments Appreciated
« Reply #1 on: February 10, 2017, 09:36:30 AM »
A standard report for a shopping list would be great.  I frequently go to the hobby shop looking for paints and find the brand I want out of stock, so including equivalents from other suppliers would be a huge help.  Great additions!

kurtd123

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: KitBase 2 - New 'Paint Stock' Table - Feedback and Comments Appreciated
« Reply #2 on: February 10, 2017, 09:53:39 AM »
Something else...  A utility that allows me to plug in a list of colors from a kit's instructions and return a list of equivalents in my stocks - then automatically adds them to the shopping list if I don't have one.  I build many aircraft and the kit instructions provide colors only from one company.  I have to then spend quite a bit of time looking over my collection for the equivalent colors or finding out what that equivalent color is...  The ability to edit the database, I assume, will be included.  A central file in the cloud for the paint xref we can all share would be the ideal thing...

Kurt

Admin Gary

  • Developer and Owner of Suisoft
  • Administrator
  • Full Member
  • *****
  • Posts: 141
    • View Profile
    • Suisoft Website
Re: KitBase 2 - New 'Paint Stock' Table - Feedback and Comments Appreciated
« Reply #3 on: February 10, 2017, 10:18:07 AM »
A standard report for a shopping list would be great.  I frequently go to the hobby shop looking for paints and find the brand I want out of stock, so including equivalents from other suppliers would be a huge help.  Great additions!

You will be able to generate a report from the Paint Stock to take along with you. A filter can be applied to just include 'Wanted' paints.

Also, when the mobile version is available, you would be able to sync then use the KitBase views from the mobile app.

Admin Gary

  • Developer and Owner of Suisoft
  • Administrator
  • Full Member
  • *****
  • Posts: 141
    • View Profile
    • Suisoft Website
Re: KitBase 2 - New 'Paint Stock' Table - Feedback and Comments Appreciated
« Reply #4 on: February 10, 2017, 10:23:44 AM »
...  A utility that allows me to plug in a list of colors from a kit's instructions and return a list of equivalents in my stocks - then automatically adds them to the shopping list if I don't have one.  I build many aircraft and the kit instructions provide colors only from one company.  I have to then spend quite a bit of time looking over my collection for the equivalent colors or finding out what that equivalent color is...  The ability to edit the database, I assume, will be included.  A central file in the cloud for the paint xref we can all share would be the ideal thing...

Thanks for the feedback.

I would like to do something that links together 'Kit Paints' to 'Paint Stock'. As you say, a centralised database would really be needed to prevent it from being too laborious.

For this release, I'm just including a basic stock function, with a view to making improvements down the line. The matching functionality will need some extra KitBase functionality to be built. My focus at the moment is to get a new PC version out there then mobile apps, so that you can take KitBase with you.

The 'Equivalent' columns are a basis for the matching up to kit colours, as you can filter on an 'Equivalent' column to see if you have a compatible paint.

As with all tables in KitBase, you can customise the fields, form and views for Paint Stock.

John Laidlaw

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: KitBase 2 - New 'Paint Stock' Table - Feedback and Comments Appreciated
« Reply #5 on: February 10, 2017, 11:04:42 AM »
Very happy to see this coming up. I currently use a spreadsheet to keep track of my paint stock - I also use it to record paint mixes that I've developed myself, or have collected from various people. Is there a chance of a paint mixes feature in KitBase in the future?

Many thanks.

Admin Gary

  • Developer and Owner of Suisoft
  • Administrator
  • Full Member
  • *****
  • Posts: 141
    • View Profile
    • Suisoft Website
Re: KitBase 2 - New 'Paint Stock' Table - Feedback and Comments Appreciated
« Reply #6 on: February 10, 2017, 11:37:31 AM »
Very happy to see this coming up. I currently use a spreadsheet to keep track of my paint stock - I also use it to record paint mixes that I've developed myself, or have collected from various people. Is there a chance of a paint mixes feature in KitBase in the future?

Many thanks.

Would you be able to email me a copy of your spreadsheet, so that I can see how you have recorded the mixes?

That way, I can see how it would fit into the database model.

You can reply to the news email I sent through.

Thanks,
Gary

John Laidlaw

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: KitBase 2 - New 'Paint Stock' Table - Feedback and Comments Appreciated
« Reply #7 on: February 10, 2017, 12:36:31 PM »
Certainly - it should be with you shortly.

Many thanks.

Admin Gary

  • Developer and Owner of Suisoft
  • Administrator
  • Full Member
  • *****
  • Posts: 141
    • View Profile
    • Suisoft Website
Re: KitBase 2 - New 'Paint Stock' Table - Feedback and Comments Appreciated
« Reply #8 on: February 10, 2017, 01:05:36 PM »
Certainly - it should be with you shortly.

Many thanks.

Thanks.

wrinkledm

  • Newbie
  • *
  • Posts: 1
    • View Profile
Let me start off with my sincere thanks for all the hard work you have accomplished on the Kitbase software.

I have more of a question vs a feature request referencing the paint database. 

Now, In theory, if someone took the time to say enter all the Tamiya 10ml bottle paints for that paint line they could then export that list for others to use. Correct?  (Provided they wouldn't mind sharing their hard work with others of course.) Other users could then in theory import that list into their own copy of KB2.  It would then, in theory, be a simple matter to alter the stock amounts for each color to suit someone's own paint supply.  Am I correct with this statement? 

My thinking is simply to save each and every user from "recreating the wheel" so to speak when it comes to paint data. 

Dave

Admin Gary

  • Developer and Owner of Suisoft
  • Administrator
  • Full Member
  • *****
  • Posts: 141
    • View Profile
    • Suisoft Website
Hi Dave,

Thanks for the encouragement.

Yes, that will be possible when the Excel (CSV) import functionality becomes available.

Gary.

John Laidlaw

  • Newbie
  • *
  • Posts: 5
    • View Profile
I've been playing around with the paint stock table (I have all of the Tamiya colours entered, and will happily export a CSV file when that function is available), and have a couple of thoughts which may or may not be of interest/use:

1. Would it be possible to have a "custom sort order" for paints? Tamiya, et al, don't have leading zeroes in their paint numbering system, so sorting by 'Paint Number', the listing goes XF-1, XF-10, XF-11, etc., etc. Those of us who suffer with OCD would thank you.

2. Would it be possible to have a 'transfer stock' button to move units from the "Containers in stock (full)" field to the "Containers half used" field (and vice versa in case of an accidental click)? Probably gilding the lily and more trouble than it's worth, but I thought I'd ask :).

Many thanks!

John


Admin Gary

  • Developer and Owner of Suisoft
  • Administrator
  • Full Member
  • *****
  • Posts: 141
    • View Profile
    • Suisoft Website
Hi John,

Thanks for the suggestions.

The Scale field has a similar sorting issue. It should be possible to create a couple of special fields that have the required sorting behaviour.

I'll have a think about the transfer stock feature. Because KitBase forms are customisable it will need some careful design. I wonder if I could create a calculated field that can alter data in other fields.

I have logged both of these. They probably won't end up in the first full release, as I'm focused on major features such as reports at the moment.

Kind Regards,
Gary

John Laidlaw

  • Newbie
  • *
  • Posts: 5
    • View Profile
Hi Gary,

Many thanks!

John

John Laidlaw

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: KitBase 2 - New 'Paint Stock' Table - Feedback and Comments Appreciated
« Reply #14 on: August 13, 2017, 10:37:19 AM »
Hi Gary,

I have exported my Tamiya paint stock table to CSV, and have removed location and stock data. I'm happy to share it, but should I wait and do it again in case there are changes to the table as you mentioned above?

Cheers!

John