Sunday, 30 January 2011

Organising Electronic Patterns

Currently I have 277MB of patterns stored on my PC and I’m sure this number will keep growing, I knew it was time I should start to think about how I would organise them.  I do use folders which separate my patterns e.g. Home Decor items and Dress Making, which segment further e.g. tops, dresses, accessories etc. This still wasn’t clear enough for me to see what I had.

The Solution

I have created a database to use to store patterns which is available  on open source for you to use for private use only. This software is released under the terms of the GNU General Public License.

Pattern Catalogue User Guide


This simple database will record  pattern information from those commercially brought patterns to PDF versions stored on a PC.

Data Input


It is a simple form which uses some drop down menus which allows you to choose from a selection of options. The drop down options are available for Pattern Company Name and Pattern Type.


The text boxes allow you to write your own data.

Adding Document Links


To add a location where the document is stored click on the Browse for File button.



A box will pop up and search for the file you want to link to at this location.



After clicking OK in the pop up box the file will be displayed on the record.

Opening the Link



Click on the link in the Location of PDF box the document will open in a separate window.

Adding Photos



To add a photo click the Browse for Photo button.


A box will pop up which will allow you to search your computer documents and select the photo to be placed. Click OK to accept.



After clicking OK the picture will now be visible on the record.

Finding Data


Click on the Find button at the top of the page and it will bring up a find search box to be able to search through the database.

Saving



Click on the Save button at the top of the database to save the record.

Closing Database



When your done adding in the information click the Close button at the top and this will also save the data entry and close the database.

Download the Software


Visit Pattern Catalogue  & User Guide  to download the software and the user guide which available in PDF format.

To make the software free to download I have used DropBox, which is a great free application for sharing or backing up your PC Files. (Please note: you do not need to sign up to download the software.)

Please comment below if you have downloaded this software and let me know what you think about it. It is also free for you to make changes to the categories as you wish.

3 comments:

Anonymous said...

Thank you so much for sharing this. I've been looking for a solution to inventory my packaged sewing patterns for a long time. What especially helped me was the field included for an URL. So far the data for patterns seems to be online, but it is too time consuming to copy all the info and the company websites vary...also, I can include electronic patterns, now, too! I'd be glad to show you a screen shot of my version, although I've just started working with it. khakidin at yahoo dot com. Thank you, again!

Anonymous said...

P.S. I've used the AutoNumber ID field as a storage location identifier - for the time being I'm just putting a numeric sticker on the pattern package and filing them in a tote. I guess I'll have to create an "electronic" identifier for those versions. I'm a novice sewer, but I'm going to learn! Thank you!!

Anonymous said...

I am so glad I found your blog and this software. I have been trying to figure out what to do for a long time and you have done such a beautiful job! Thanks so much! I just want to figure out how to add another pic or two to each pattern and I will be ecstatic. Truly! Thank you.