Jump to content


Photo

Fountain Pen Database Available for Download


  • Please log in to reply
455 replies to this topic

#361 pajaro

pajaro

    Amblin along like I had good sense.

  • Premium - Ruby

  • PipPipPipPipPipPipPipPipPipPipPip
  • 6,108 posts
  • Location:SE Michigan

Posted 12 May 2012 - 20:43

Great Inventory database. Thank you for developing it and making it available free. I am a little staggered to see how much I have spent on pens over the years.
"Don't hurry, don't worry. It's better to be late at the Golden Gate than to arrive in Hell on time."
--Sign in a bar and grill, Ormond Beach, Florida, 1960.

#362 Chi Town

Chi Town

    Antique

  • Premium - Ruby

  • PipPipPipPipPipPipPipPipPip
  • 1,591 posts
  • Location:Albuquerque, New Mexico
  • Flag:

Posted 12 May 2012 - 20:48

Great Inventory database. Thank you for developing it and making it available free. I am a little staggered to see how much I have spent on pens over the years.



Ha, Ha yes that's the down side of this program. Your able to see how much you have invested in your collection. But the upside is that it is a good program for your insurance co. To insure your pens with.

Mike

            Visconti Last Lira aka Luigi Einaudi #63 of 975, Stipula Yellow Da Vinci Carbon Fiber T, Stipula Model T, Vintage Fountain Pens, Delta Amerigo Vespucci LE, Pelikan Special Edition Sahara F/P, TWSBI Micarta, Danitrio Mikado, Genkai, Nakaya Decapod Cigar, Watley in Woodgrain, Marlen Yellow Liberty LE, Santa FE Style Custom "51" made by Ralph Prather, Danitrio Fellowship - president New Mexico Pen Collector's Club.


#363 pajaro

pajaro

    Amblin along like I had good sense.

  • Premium - Ruby

  • PipPipPipPipPipPipPipPipPipPipPip
  • 6,108 posts
  • Location:SE Michigan

Posted 13 May 2012 - 04:27

After adding quite a few pens, an error occured, something about date format. After this, all entered items were lost, except the one I was working on when the date formatting error occured.
"Don't hurry, don't worry. It's better to be late at the Golden Gate than to arrive in Hell on time."
--Sign in a bar and grill, Ormond Beach, Florida, 1960.

#364 pajaro

pajaro

    Amblin along like I had good sense.

  • Premium - Ruby

  • PipPipPipPipPipPipPipPipPipPipPip
  • 6,108 posts
  • Location:SE Michigan

Posted 13 May 2012 - 04:38


Great Inventory database. Thank you for developing it and making it available free. I am a little staggered to see how much I have spent on pens over the years.



Ha, Ha yes that's the down side of this program. Your able to see how much you have invested in your collection. But the upside is that it is a good program for your insurance co. To insure your pens with.


Invested? I don't think you can really count on that as an investment bearing a return. The P 51 set I bought for $25 in 1970 is unlikely to be worth enough to keep up with inflation. I would figure $250.00 adjusted for inflation plus or minus, and I think I would be fortunate to get $100 for them as a user-grade set. Just an example. It's a passtime, an obsession, a collection of stuff. The value erodes as you use the pen, as it acquires battle scars, etc. You can't take it seriously. It's a whole lot of mula down the drain. Like the ink I have purged from pens. It has been enjoyable, though, and you just have to keep smiling.
"Don't hurry, don't worry. It's better to be late at the Golden Gate than to arrive in Hell on time."
--Sign in a bar and grill, Ormond Beach, Florida, 1960.

#365 crofton99

crofton99

    Near Mint

  • Member - Gold

  • PipPipPip
  • 33 posts

Posted 01 July 2012 - 21:47

Just downloaded the program looks really useful. One question - I have an inventory number for my pens - is there a field for this?

Thanks,
Kevin

#366 ianmedium

ianmedium

    Vintage

  • Member - Gold

  • PipPipPipPipPipPipPip
  • 694 posts
  • Flag:

Posted 02 July 2012 - 21:41

Thanks so much for this. I am having problems though. i downloaded the Mac version, I am running Lion. I have the folder saying fountain pen inventory and then when I open it I see several things including fountain pen inventory and fountain pen inventory.fpn

When I double click on either it crashes and I get one of those report status things. What am I doing wrong?
Thanks in advance!
All the best.
Ian



Mont Blanc Alfred Hitchcock, Mont Blanc 149, Montegrappa Historia Limited editon 410/1000, Sheaffer imperial 777, Prker 51 special, Parker Duofold senior special, Stipula Tuscany dreams piston with 1.1 italic 036/351, incoming: Stipula Tuscany dreams T-flex. Incoming: Parker 51 Vac

#367 haldane3

haldane3

    Extremely Rare

  • Member - Gold

  • PipPipPipPipPipPip
  • 250 posts
  • Flag:

Posted 10 July 2012 - 00:28

Thanks!

Works great. Now it encourages me to get more pens to fill it up!
"Well, at least being into pens isn't a gross habit. Like smoking or whatever."

"Ahh, thanks?"

-My coworker Christine.

#368 ianmedium

ianmedium

    Vintage

  • Member - Gold

  • PipPipPipPipPipPipPip
  • 694 posts
  • Flag:

Posted 15 July 2012 - 04:23

I will try again! I have a Mac and am on lion. I have downloaded this programme several times now and each time it crashes. Could someone who uses a Mac and this programme please tell me what is going wrong and what I need to do to get it working! Thanks very much.
All the best.
Ian



Mont Blanc Alfred Hitchcock, Mont Blanc 149, Montegrappa Historia Limited editon 410/1000, Sheaffer imperial 777, Prker 51 special, Parker Duofold senior special, Stipula Tuscany dreams piston with 1.1 italic 036/351, incoming: Stipula Tuscany dreams T-flex. Incoming: Parker 51 Vac

#369 peterpen53

peterpen53

    Vintage

  • Member - Gold

  • PipPipPipPipPipPipPip
  • 551 posts
  • Location:Near the western shore
  • Flag:

Posted 23 July 2012 - 10:31

Thanks so much for this. I am having problems though. i downloaded the Mac version, I am running Lion. I have the folder saying fountain pen inventory and then when I open it I see several things including fountain pen inventory and fountain pen inventory.fpn

When I double click on either it crashes and I get one of those report status things. What am I doing wrong?
Thanks in advance!


Both items should work the same way, that makes no difference. Mine works on an almost 4-year old MBP running Lion. If it keeps on crashing, I would suggest you simply toss it and redownload the entire database. You might just have an incomplete or corrupt file, these things happen once in a while.

Good luck.

Cheers,
Peter

Edited by peterpen53, 23 July 2012 - 10:34.

May Your Force Be With You

If I mention a supplier, I am ONLY affiliated if I EXPLICITLY say so.

#370 mikalehtinen

mikalehtinen

    Rare

  • Member - Gold

  • PipPipPipPipPip
  • 133 posts
  • Location:Jakobstad, Finland
  • Flag:

Posted 31 July 2012 - 22:27

Thank you so much for this program Jon! Great that you share it for free to all of us who don't know how to create programs like this.
Great!
Cheers, Mika

#371 pen2paper

pen2paper

    arty o the irst art

  • Member - Gold

  • PipPipPipPipPipPipPipPipPipPip
  • 4,690 posts

Posted 31 July 2012 - 23:55

Question: Is there anyway to insert a recently acquired vintage pen into the list by its date, (oldest to newest), other than completely retyping the list?

Posted Image~Hi! fountain pen enthusiast here~

#372 pen2paper

pen2paper

    arty o the irst art

  • Member - Gold

  • PipPipPipPipPipPipPipPipPipPip
  • 4,690 posts

Posted 01 August 2012 - 00:05

Unfortunately there's no version for Linux. Perhaps an open standard application that can be used on various platforms would reach more users? Libre Office http://www.libreoffice.org/ is free, has a database program and can be used on Linux, Mac, and Windows.

Just saw this program used today.. Wondering how it compares to Open Office??? I did peek at the site and see it allows for collections database. Has anyone adapted libreoffice for their collections?




Posted Image~Hi! fountain pen enthusiast here~

#373 peterpen53

peterpen53

    Vintage

  • Member - Gold

  • PipPipPipPipPipPipPip
  • 551 posts
  • Location:Near the western shore
  • Flag:

Posted 01 August 2012 - 07:07

Question: Is there anyway to insert a recently acquired vintage pen into the list by its date, (oldest to newest), other than completely retyping the list?


If you go into the Records menu item and choose Sort records... you can choose any sort criteria you like. That's the nice thing about a database, you can make it do almost anything you want.

Edited by peterpen53, 01 August 2012 - 07:08.

May Your Force Be With You

If I mention a supplier, I am ONLY affiliated if I EXPLICITLY say so.

#374 Tdot

Tdot

    Get off my lawn

  • Member - Gold

  • PipPipPipPipPipPip
  • 278 posts
  • Location:Wasatch Back

Posted 08 August 2012 - 03:18

I will try again! I have a Mac and am on lion. I have downloaded this programme several times now and each time it crashes. Could someone who uses a Mac and this programme please tell me what is going wrong and what I need to do to get it working! Thanks very much.

No problems using it on my iMac-OSX 10.6 and my PowerBook-OSX 10.5.
Qui me amat, amat et canem meum

#375 Inginkpen

Inginkpen

    Mint

  • Member - Gold

  • PipPipPipPip
  • 66 posts
  • Flag:

Posted 04 September 2012 - 21:09

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



Thank you very much for this database. I'm not an expert database or computer user and was able to install it on my computer and start using it immediately!
All the best, Ingrid

#376 tenney

tenney

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 1,549 posts
  • Flag:

Posted 08 September 2012 - 07:21

Thanks for the database. Is there any chance of being able to export it (or something) to be able to import it into say Bento or to use it in your own Filemaker database?
--
Glenn (I have a "pen" circle on G+)

#377 iduncant

iduncant

    Rare

  • Member - Gold

  • PipPipPipPipPip
  • 148 posts
  • Location:Hamilton, Ontario
  • Flag:

Posted 14 September 2012 - 23:55

Thanks for the amazing resource!
Alexander Pen Co. - J.Herbin 1670 Bleu Ocean In Stock Now!
Visit our online store, based in Toronto, Ontario
www.alexanderpenco.com
$10 Flat Rate Shipping Now Available All Across Canada!

#378 C.W.

C.W.

    Dipped Only

  • Member - Silver

  • Pip
  • 7 posts
  • Flag:

Posted 26 September 2012 - 07:28

I am running Mac OSX 10.7.4 on a MacBook Pro, the software will not start up and continues to fail.

Have reinstalled, restarted and reinstalled, reinstalled then restarted, and a few other things, nothing seems to get it running.

Really wish I could get this running, seems like an amazing resource!

#379 outbackpengeek

outbackpengeek

    Mint

  • Member - Gold

  • PipPipPipPip
  • 96 posts
  • Flag:

Posted 26 September 2012 - 12:37

I will try again! I have a Mac and am on lion. I have downloaded this programme several times now and each time it crashes. Could someone who uses a Mac and this programme please tell me what is going wrong and what I need to do to get it working! Thanks very much.


You're not doing anything wrong...it crashes on startup every time on Mountain Lion (10.8) as well.

#380 eric47

eric47

    Tentative bohemian sniffing the celluloid

  • Member - Gold

  • PipPipPipPipPipPipPipPipPipPip
  • 4,269 posts

Posted 26 September 2012 - 13:14


I will try again! I have a Mac and am on lion. I have downloaded this programme several times now and each time it crashes. Could someone who uses a Mac and this programme please tell me what is going wrong and what I need to do to get it working! Thanks very much.


You're not doing anything wrong...it crashes on startup every time on Mountain Lion (10.8) as well.


I downloaded the DB again, and not much has changed since my last post. Again I suspect it's related to the included FM runtime engine; the files all date from 2007.

The included FM runtime engine is v8.5.1; the runtime engine a small program -- a stripped down bit of FM which lets those use a FM database without having the full FM program.

v8.5.1 is quite long in tooth these days and extends to the PPC era. There was an update to v8.5.2 -- I don't know if either version of the full FM application v8.5.x itself even runs under Mountain Lion. I don't know many 5 year old programs (from the 10.4 - 10.5 era) that still run unpatched or without any upgrade on Lion or Mountain Lion. Filemaker's table doesn't even go back to v8 for Lion Compatibility, see here. But v9 isn't compatible with Lion -- I can verify that, I tried to install it.

The current version of Filemaker is v12. It and v11 are both deemed Mountain Lion compatible by Filemaker. v11 was also Lion compatible on the release of Lion.

I have a copy of FM v11, so I don't need the runtime engine. I can open the DB file itself without issue, and can use the database.

If you want this to run, I see two basic options:
1. Contact the author of the DB (jonro), to see if he can repackage the db program with a Mountain Lion compatible runtime engine.
2. Use a Mountain Lion compatible version of Filemaker (the full program) to work on just the db file.

Edited by eric47, 26 September 2012 - 13:18.

Anyone becomes mannered if you think too much about what other people think. (Kim Gordon)

Avatar photography by Kate

#381 peterpen53

peterpen53

    Vintage

  • Member - Gold

  • PipPipPipPipPipPipPip
  • 551 posts
  • Location:Near the western shore
  • Flag:

Posted 26 September 2012 - 13:23

v8.5.1 is quite long in tooth these days and extends to the PPC era.


That probably explains it. PPC-program support was terminated in Lion already.

There was an update to v8.5.2 -- I don't know if either version of the full FM application v8.5.x itself even runs under Mountain Lion. I don't know many 5 year old programs (from the 10.4 - 10.5 era) that still run unpatched or without any upgrade on Lion or Mountain Lion.


Knowing Apple's stance on this kind of thing, the chance is virtually zero.
May Your Force Be With You

If I mention a supplier, I am ONLY affiliated if I EXPLICITLY say so.

#382 tenney

tenney

    Antique

  • Member - Gold

  • PipPipPipPipPipPipPipPipPip
  • 1,549 posts
  • Flag:

Posted 27 September 2012 - 06:55

I have FM 12 and it does open the DB file.
--
Glenn (I have a "pen" circle on G+)

#383 abend

abend

    Mint

  • Member - Gold

  • PipPipPipPip
  • 52 posts

Posted 28 September 2012 - 14:31

I finally got it running, on Mountain Lion no less, this morning - In System Preferences/Language & Text/Region, if Region: is set to 'United States' it works. If Region: is set to 'Canada' the database crashes on startup. From the crash dump it looks like com.filemaker.support.framework gets into trouble formatting the date. YMMV.

Bruce
BB is the new M

#384 eric47

eric47

    Tentative bohemian sniffing the celluloid

  • Member - Gold

  • PipPipPipPipPipPipPipPipPipPip
  • 4,269 posts

Posted 28 September 2012 - 18:22

I finally got it running, on Mountain Lion no less, this morning - In System Preferences/Language & Text/Region, if Region: is set to 'United States' it works. If Region: is set to 'Canada' the database crashes on startup. From the crash dump it looks like com.filemaker.support.framework gets into trouble formatting the date. YMMV.

Bruce

Interesting. I wonder which setting in Region is causing the problem.

the most obvious to me is probaly the date format which in the US is mm/dd/yyyy. The date format is written a FM database. If that's different from the OS, in FM (full app) that gets flagged and you get a dialog box asking whether you want to use the file/db formatting or the OS'. I suspect the old runtime are bombing when the date format difference is detected, and can't throw the dialog box.

Btw, you can do a custom date and time format where you change for instance only the date formatting, while leaving other formatting options untouched. But that assumes that the date formatting is causing it to crash.
Anyone becomes mannered if you think too much about what other people think. (Kim Gordon)

Avatar photography by Kate

#385 abend

abend

    Mint

  • Member - Gold

  • PipPipPipPip
  • 52 posts

Posted 28 September 2012 - 19:45


I finally got it running, on Mountain Lion no less, this morning - In System Preferences/Language & Text/Region, if Region: is set to 'United States' it works. If Region: is set to 'Canada' the database crashes on startup. From the crash dump it looks like com.filemaker.support.framework gets into trouble formatting the date. YMMV.

Bruce

Interesting. I wonder which setting in Region is causing the problem.

the most obvious to me is probaly the date format which in the US is mm/dd/yyyy. The date format is written a FM database. If that's different from the OS, in FM (full app) that gets flagged and you get a dialog box asking whether you want to use the file/db formatting or the OS'. I suspect the old runtime are bombing when the date format difference is detected, and can't throw the dialog box.

Btw, you can do a custom date and time format where you change for instance only the date formatting, while leaving other formatting options untouched. But that assumes that the date formatting is causing it to crash.




Thanks, Eric. I forgot to mention that I'd tried Custom date, time, and currency formats, but no joy.


Bruce
BB is the new M

#386 eric47

eric47

    Tentative bohemian sniffing the celluloid

  • Member - Gold

  • PipPipPipPipPipPipPipPipPipPip
  • 4,269 posts

Posted 28 September 2012 - 20:38

Thanks, Eric. I forgot to mention that I'd tried Custom date, time, and currency formats, but no joy.

Bruce


Based on your comments, I decided to try -- I forgot I could use "Open With" (or use the "Info" window) to force the DB to open in the included runtime rather than FM 11. While I wasn't able to test all possibilities, I managed to get it to launch with a custom region using:
- Short Date format: mm/dd/yyyy (US format) [I only changed the short "numeric" format, I left the other formats for the long ones]
- Currency: US
- Measurements Units: US

With those 3 set to US formats, I launched on more than one occasion. But it's not entirely stable; while testing I would change some values then changed them back to the US ones, and the db would crash. So I'm not entirely confident that those are magic 3. Maybe I needed more logouts and even a restart.

I suppose it's easier just to change the entire region using the "default" regions. I already have a custom profile that I use anyway; abd I hate having to set that up over again. If I use the default region where I actually reside, I get seriously confused with the decimal seperator. I'm used to a period, but the region where I reside uses a comma for the decimal (and the period as a thousands separator). While I've adapted to dd/mm/yyyy and the metric system, I still cannot get past the inverted decimal and thousand separators.
Anyone becomes mannered if you think too much about what other people think. (Kim Gordon)

Avatar photography by Kate

#387 C.W.

C.W.

    Dipped Only

  • Member - Silver

  • Pip
  • 7 posts
  • Flag:

Posted 01 October 2012 - 05:05

I finally got it running, on Mountain Lion no less, this morning - In System Preferences/Language & Text/Region, if Region: is set to 'United States' it works. If Region: is set to 'Canada' the database crashes on startup. From the crash dump it looks like com.filemaker.support.framework gets into trouble formatting the date. YMMV.

Bruce


Just wanted to add, that I tried this and it works perfectly now. Quite excited about this! Now, only to hope this inventory database doesn't start a pen acquisition disorder :embarrassed_smile:

#388 dasnet

dasnet

    Mint

  • Member - Gold

  • PipPipPipPip
  • 53 posts
  • Location:Argentina
  • Flag:

Posted 14 November 2012 - 03:09

In MacPro with Spanish Keyboard selected, in mountain lion, crash everytime. In a MacBook Pro with US english no problem at all.
Current office rotation: Nakaya Piccolo (Noodlers Turquoise Eel), Twsbi Mini (PR Plum), Onoto BCHR (Diamine Imperial Blue) http://plumasytintas.com
http://yuki-akari.blogspot.com

#389 woghd

woghd

    Dipped Only

  • Member - Silver

  • Pip
  • 5 posts

Posted 03 February 2013 - 06:08

WOW!
Thank you very much for sharing with us!

#390 Applebee

Applebee

    NOS (New Old Stock)

  • Member - Silver

  • PipPip
  • 20 posts
  • Location:200 north of San Francsico
  • Flag:

Posted 07 February 2013 - 04:36

Nice one, thanks so much, Jon!