Jump to content


Photo

Fountain Pen Database Available for Download


  • Please log in to reply
455 replies to this topic

#1 jonro

jonro

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 2,528 posts
  • Location:South Florida

Posted 08 April 2007 - 23:58

My fountain pen inventory database is ready to download. There is a version for both Mac and PC users. The database maintains a lot of useful information about your fountain pen collection, including basic descriptive info, prices paid, repairs made and unlimited photographs. It also makes it very easy to post reviews to FPN. This database isn't associated with FPN, but I did add a couple of features that plays nicely with FPN.

As I mentioned, there's a Mac and a PC version. I ran into some font issues on the PC and had to make a a couple of small changes to the PC version in order to get it posted without delay. There isn't a large difference, but the Mac version looks a little nicer.

When you download it and unzip it, you will see a file and a folder named Fountain Pen Inventory. The file is an alias to the main program file in the folder. I don't usually distribute my solutions as standalone runtime databases. I've tested it as carefully as I could, but let me know if you have any issues. Even better, let me know if you like it, too. There is no charge for Fountain Pen Inventory. It's my gift to the FPN fountain pen community. You can redistribute it to someone else, but are not allowed to charge for it, modify it or present it as your own work.

Enough of the intro, you can download it at: http://www.jonro.com/downloads/

Regards,

Jon

Edited by jonro, 09 April 2007 - 02:53.


#2 Bayes

Bayes

    Mint

  • Member - Gold

  • PipPipPipPip
  • 97 posts

Posted 09 April 2007 - 00:50

I downloaded it. Thanks!

I've always liked FileMakerPro. I keep meaning to get a copy and start using it. I just haven't had much need for a database.


#3 girlieg33k

girlieg33k

    ...

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 1,837 posts

Posted 09 April 2007 - 01:07

Wow! Thank you, thank you, thank you! I just imported my existing database from Excel, and this is a much more intuitive way of keeping the info up to date.
Talking about fountain pens is like dancing about architecture.

#4 sam

sam

    Extremely Rare

  • Member - Gold

  • PipPipPipPipPipPip
  • 240 posts

Posted 09 April 2007 - 01:43

very nice! smile.gif
thank you smile.gif

#5 badrsj

badrsj

    Collectors Item

  • Member - Gold

  • PipPipPipPipPipPipPipPip
  • 1,002 posts

Posted 09 April 2007 - 02:28

Do I need a copy of filemaker pro to use this database?
Thanks
Badrsj

#6 Bayes

Bayes

    Mint

  • Member - Gold

  • PipPipPipPip
  • 97 posts

Posted 09 April 2007 - 02:37

Nope. It's a standalone application created with the developer's version of FMP.

#7 badrsj

badrsj

    Collectors Item

  • Member - Gold

  • PipPipPipPipPipPipPipPip
  • 1,002 posts

Posted 09 April 2007 - 02:48

thanks
Badrsj

#8 rroossinck

rroossinck

    Donor Pen

  • Moderators

  • PipPipPipPipPipPipPipPipPipPip
  • 4,683 posts
  • Location:Corn Country USA (Iowa)

Posted 09 April 2007 - 03:06

Absolutely stellar, Jon! My compliments to the "chef"!
Posted Image
Brassing Adds Character: Available by clicking on my signature.

#9 laburlisque

laburlisque

    Mint

  • Member - Gold

  • PipPipPipPip
  • 62 posts

Posted 09 April 2007 - 04:39

Wow, very nice- thank you for sharing this! There will be a few pleasurable hours ahead, getting this filled in and set up - an excellent tool.

#10 glkpens

glkpens

    Near Mint

  • Member - Gold

  • PipPipPip
  • 37 posts

Posted 09 April 2007 - 04:41

Jon:

Thanks! What a wonderfully generous contribution to the pen collecting
community.

Best,

Gary K.

#11 Epictete92

Epictete92

    Vintage

  • Member - Gold

  • PipPipPipPipPipPipPip
  • 743 posts
  • Location:Paris, France

Posted 09 April 2007 - 06:48

Hello that is a veru clean,great and usefull tool.
Easy to use.
Thank you very much for sharing with us !

Just a question, is it possible to sort the results also by "sold/traded to" informations, it can be usefull to rank the best buyers :-)

Have a nice day
Best regards
Jean Elie


#12 jonro

jonro

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 2,528 posts
  • Location:South Florida

Posted 09 April 2007 - 12:17

QUOTE (Epictete92 @ Apr 9 2007, 06:48 AM)
Hello that is a veru clean,great and usefull tool.
Easy to use.
Thank you very much for sharing with us !

Just a question, is it possible to sort the results also by "sold/traded to" informations, it can be usefull to rank the best buyers :-)

Have a nice day
Best regards
Jean Elie

Thanks, Jean Elie! I'm glad that you and everyone else here are enjoying FPI. You can sort the database on any field or combination of fields. Select Sort from the Fountain Pen menu or type Cmd-S. You can select sort fields from that dialog. The field named "Sold_To" is the one you are looking for.

Regards,

Jon

#13 Video11

Video11

    Extremely Rare

  • Member - Gold

  • PipPipPipPipPipPip
  • 331 posts
  • Location:London, Canada
  • Flag:

Posted 09 April 2007 - 13:14

Thanks Jonro. Spent a couple of hours playing around and really like what you've done. My compliments to the programmer.

Rick.

edit for spelling.

Edited by Video11, 09 April 2007 - 13:15.

Life Is Not A Rehearsal.

My Pen Club: http://londonpenclub.com

#14 gwoman13

gwoman13

    Ms.

  • Member - Gold

  • PipPipPip
  • 37 posts

Posted 09 April 2007 - 18:05

Hey this was really a nice gesture, thank you. I did not realize I had so many pens.

Margie


Margie

#15 Margana

Margana

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 1,918 posts
  • Location:That Abyss Called California
  • Flag:

Posted 09 April 2007 - 18:07

Wow, do I need this for my ink inventory. I own lots more ink than pens. Well, maybe not lots... wink.gif
A certified Inkophile

#16 jonro

jonro

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 2,528 posts
  • Location:South Florida

Posted 09 April 2007 - 18:30

QUOTE (Margana @ Apr 9 2007, 06:07 PM)
Wow, do I need this for my ink inventory. I own lots more ink than pens. Well, maybe not lots... wink.gif

Ink support is already planned for the next release. I'd be interested to hear what information about your inks that you would like to track.

Jon

#17 Margana

Margana

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 1,918 posts
  • Location:That Abyss Called California
  • Flag:

Posted 09 April 2007 - 18:53

QUOTE (jonro @ Apr 9 2007, 10:30 AM)
QUOTE (Margana @ Apr 9 2007, 06:07 PM)
Wow, do I need this for my ink inventory. I own lots more ink than pens. Well, maybe not lots...  wink.gif

Ink support is already planned for the next release. I'd be interested to hear what information about your inks that you would like to track.

Jon

There are some serious inkophiles here so why don't you start a discussion in Inky Thoughts to get some of them involved. smile.gif
A certified Inkophile

#18 George

George

    Collectors Item

  • Member - Gold

  • PipPipPipPipPipPipPipPip
  • 1,470 posts

Posted 09 April 2007 - 18:55

Flawless program. Thank you once again. An ink one would be nice as well rolleyes.gif


PS. I love the FPN review function. Very handy.

Edited by George, 09 April 2007 - 18:55.


#19 coy55boy

coy55boy

    Rare

  • Member - Gold

  • PipPipPipPipPip
  • 172 posts

Posted 09 April 2007 - 19:22

Thanks, jonro!

This is better than the program I bought for this purpose. Great work! eureka.gif
The pen may be mightier than the sword...
but don't take your favorite fountain pen to a sword fight!

#20 Ernst Bitterman

Ernst Bitterman

    Nil Magnum Nisi Bonum

  • Member - Gold

  • PipPipPipPipPipPipPipPipPipPipPip
  • 7,049 posts
  • Location:The Flat Bit, Canada
  • Flag:

Posted 10 April 2007 - 11:31

Miserable wriggling newbie that I am, I find myself baffled by the "Nib_Stroke" field. Wussat?

Otherwise, supercool resource.
Ravensmarch Pens & Books
It's mainly pens, just now....

Oh, good heavens. He's got a blog now, too.

#21 jonro

jonro

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 2,528 posts
  • Location:South Florida

Posted 10 April 2007 - 12:50

QUOTE (Ernst Bitterman @ Apr 10 2007, 11:31 AM)
Miserable wriggling newbie that I am, I find myself baffled by the "Nib_Stroke" field. Wussat?

Otherwise, supercool resource.

Fine, medium, broad, etc. Thanks!

#22 Elaine

Elaine

    Mama Tiger

  • Admin Hon.

  • PipPipPipPipPipPipPipPipPipPipPip
  • 6,522 posts
  • Location:New Jersey, USA

Posted 10 April 2007 - 13:51

I'm having fun unsure.gif entering all the data from my Excel file. A few suggestions for the next version:

1. Have an entry for filling mechanism
2. Ability to sum up the prices.

Thanks again!

#23 Daniele

Daniele

    Extremely Rare

  • Member - Gold

  • PipPipPipPipPipPip
  • 388 posts
  • Location:Italy
  • Flag:

Posted 10 April 2007 - 13:55

Beautiful and very usefull!!!
Many thanks!!!!
Daniele


#24 dwmatteson

dwmatteson

    Vintage

  • Member - Gold

  • PipPipPipPipPipPipPip
  • 630 posts

Posted 10 April 2007 - 17:09

jonro - Thanks so much for taking the time to design this wonderful database. It's a fantastic tool!

QUOTE (Elaine @ Apr 10 2007, 08:51 AM)

...
A few suggestions for the next version:
...
2. Ability to sum up the prices.

Thanks again!



Are you mad, woman?! tongue.gif If you do implement this, jonro, please make sure that it's well safe-guarded with biometric IDs or something like that. If my wife knew that total I'd be dead for sure! ph34r.gif

Don

#25 jonro

jonro

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 2,528 posts
  • Location:South Florida

Posted 10 April 2007 - 17:47

QUOTE (Elaine @ Apr 10 2007, 01:51 PM)
I'm having fun unsure.gif entering all the data from my Excel file. A few suggestions for the next version:

1. Have an entry for filling mechanism
2. Ability to sum up the prices.

Thanks again!

There is an entry for filling mechanism on the Review page, but I will add a small entry field for filler on the main page. About summing up the prices, are you sure you want to know?

Regards,

Jon

#26 Shari

Shari

    Extremely Rare

  • Member - Gold

  • PipPipPipPipPipPip
  • 278 posts

Posted 10 April 2007 - 18:44

Thanks very much for sharing this!

A couple of things I have found. The program is not happy running with the full version of Filemaker running at the same time (I'm on a Mac). I have been trying to figure out how to get the pix from my current filemaker database into this one without exporting/importing each and every image, but I'm not having any luck so far. I'm a very basic user of Filemaker, and the scripts and tabs you have created make for a much nicer database than the one I made for myself, based off of a provided inventory template.

Very very nice of you to share this. I appreciate it!
Exuberance is beauty.
(Wm. Blake)

#27 Elaine

Elaine

    Mama Tiger

  • Admin Hon.

  • PipPipPipPipPipPipPipPipPipPipPip
  • 6,522 posts
  • Location:New Jersey, USA

Posted 10 April 2007 - 20:03

QUOTE (jonro @ Apr 10 2007, 12:47 PM)
About summing up the prices, are you sure you want to know?

Regards,

Jon

No.
unsure.gif But in my Excel file I could get a total if I want to. I think I did that once. When I came to I promptly forgot the figure. Just figured it could be useful if someone does want it.


#28 jonro

jonro

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 2,528 posts
  • Location:South Florida

Posted 10 April 2007 - 20:04

QUOTE (Elaine @ Apr 10 2007, 08:03 PM)
QUOTE (jonro @ Apr 10 2007, 12:47 PM)
About summing up the prices, are you sure you want to know?

Regards,

Jon

No.
unsure.gif But in my Excel file I could get a total if I want to. I think I did that once. When I came to I promptly forgot the figure. Just figured it could be useful if someone does want it.

It will be in the next version, at the bottom of the listview.

-Jon

#29 ViolinWriter

ViolinWriter

    Vintage

  • Member - Gold

  • PipPipPipPipPipPipPip
  • 446 posts

Posted 10 April 2007 - 22:13

Thank you so much for your efforts and your generosity. It is truly appreciated.

I've been on an organizing kick, which is amazing as I am congenitally impaired in the organizing department. This could be the start of something amazing.

Now, the next step is the sheet music. YIKES!!! That's TWENTY FIVE SHELF FEET OF SHEET MUSIC(!!!) in the standing up position, like books are shelved. And some, well most, of it is 10 pages or less, per piece.

OY! roflmho.gif
Elizabeth

Spring and love arrived on a bird's sweet song. "How does that little box sound like birds and laughter?" I asked the gypsy violinist. He leaned back, pointing to his violin. "Look inside, you'll see the birdies sing to me" soft laughter in his voice. "I hear them, I can almost see them!", I shouted as his bow danced on the strings. "Ah yes" he said, "your heart is a violin." Shony Alex Braun

As it began for Shony, it began for me. My heart -- My violin

#30 jonro

jonro

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 2,528 posts
  • Location:South Florida

Posted 10 April 2007 - 22:57

QUOTE (ViolinWriter @ Apr 10 2007, 10:13 PM)
Thank you so much for your efforts and your generosity. It is truly appreciated.

I've been on an organizing kick, which is amazing as I am congenitally impaired in the organizing department. This could be the start of something amazing.

Now, the next step is the sheet music. YIKES!!! That's TWENTY FIVE SHELF FEET OF SHEET MUSIC(!!!) in the standing up position, like books are shelved. And some, well most, of it is 10 pages or less, per piece.

OY! roflmho.gif

Elizabeth,

Have you ever looked at Levenger's Circa notebooks and organization tools? Like Tivo, they have changed my life (for the better). If you're not familiar with them, they are like a next generation spiral notebook or ring binder. The pages can slip in and out into different sections without opening a binder. The notebooks also lay flat like a spiral notebook. Very cool system.

Jon