PDA

View Full Version : Filemaker Pro logbook


Wizard of Draws
April 27th 05, 12:39 AM
Does anyone here use Filemaker Pro for keeping their logbook? I've just
finished creating one in version 6 because Excel seems to be getting
unwieldy as my time grows.

Since I'm a newbie at FMP, I wouldn't mind letting someone more experienced
with the program take a look and give me some feedback.
--
Jeff 'The Wizard of Draws' Bucchino

Cartoons with a Touch of Magic
http://www.wizardofdraws.com

More Cartoons with a Touch of Magic
http://www.cartoonclipart.com

Matt Barrow
April 27th 05, 03:00 AM
"Wizard of Draws" > wrote in
message news:BE944954.65763%jeffbTAKEOUTALLCAPS@TOEMAILwiz ardofdraws.com...
> Does anyone here use Filemaker Pro for keeping their logbook? I've just
> finished creating one in version 6 because Excel seems to be getting
> unwieldy as my time grows.
>
> Since I'm a newbie at FMP, I wouldn't mind letting someone more
experienced
> with the program take a look and give me some feedback.

My kid did one in MS-Access a few years ago and it works great. It keeps a
whole lot more than just the FAA required data (ie, hours under VFR flight
plans vs IFR plans, IMC, yada yada...).

I could maybe send you the structures and other components if you'd liketo
try it.

--
Matt
---------------------
Matthew W. Barrow
Site-Fill Homes, LLC.
Montrose, CO

Bob Chilcoat
April 27th 05, 03:13 AM
I'd certainly like to see it. I've been trying to move my Excel logbook
into Access, but I'm not apparently smart enough to make the Logbook "Pages"
look like my paper log. Demung my email address first. Thanks.

--
Bob (Chief Pilot, White Knuckle Airways)


"Matt Barrow" > wrote in message
...
>
> "Wizard of Draws" > wrote in
> message
news:BE944954.65763%jeffbTAKEOUTALLCAPS@TOEMAILwiz ardofdraws.com...
> > Does anyone here use Filemaker Pro for keeping their logbook? I've just
> > finished creating one in version 6 because Excel seems to be getting
> > unwieldy as my time grows.
> >
> > Since I'm a newbie at FMP, I wouldn't mind letting someone more
> experienced
> > with the program take a look and give me some feedback.
>
> My kid did one in MS-Access a few years ago and it works great. It keeps a
> whole lot more than just the FAA required data (ie, hours under VFR flight
> plans vs IFR plans, IMC, yada yada...).
>
> I could maybe send you the structures and other components if you'd liketo
> try it.
>
> --
> Matt
> ---------------------
> Matthew W. Barrow
> Site-Fill Homes, LLC.
> Montrose, CO
>
>
>
>

Matt Barrow
April 27th 05, 03:28 AM
"Bob Chilcoat" > wrote in message
...
> I'd certainly like to see it. I've been trying to move my Excel logbook
> into Access, but I'm not apparently smart enough to make the Logbook
"Pages"
> look like my paper log. Demung my email address first. Thanks.
>
> --
> Bob (Chief Pilot, White Knuckle Airways)


This is Chris, Matt's son "speaking".

You can do a direct importation from Excel into Access, but you'll want to
normalize the tables to create a true database. Depending on how your laid
out the Excel collumns/cells, this might be easy or hard.

First, do a report form and lay out your form fields to match the logbook
form. From there, link in a query to fill the pages. You can add total
fields at the bottom for the point in time (running totals) or grand totals.

See if that works. The database schema I laid out for the logbook program
has a lot more information than the typical spreadsheets. I did the program
originally in 1996 (It was a school project) or so when Dad had about 500
hours. I've added a lot of enhancements since then. He's been keeping it
religiously since then and the data since is much more complete and
accurate.

It might well be overkill for what your want.

Best,

Chris Barrow

>
> "Matt Barrow" > wrote in message
> ...
> >
> > "Wizard of Draws" > wrote
in
> > message
> news:BE944954.65763%jeffbTAKEOUTALLCAPS@TOEMAILwiz ardofdraws.com...
> > > Does anyone here use Filemaker Pro for keeping their logbook? I've
just
> > > finished creating one in version 6 because Excel seems to be getting
> > > unwieldy as my time grows.
> > >
> > > Since I'm a newbie at FMP, I wouldn't mind letting someone more
> > experienced
> > > with the program take a look and give me some feedback.
> >
> > My kid did one in MS-Access a few years ago and it works great. It keeps
a
> > whole lot more than just the FAA required data (ie, hours under VFR
flight
> > plans vs IFR plans, IMC, yada yada...).
> >
> > I could maybe send you the structures and other components if you'd
liketo
> > try it.
> >
> > --
> > Matt
> > ---------------------
> > Matthew W. Barrow
> > Site-Fill Homes, LLC.
> > Montrose, CO
> >
> >
> >
> >
>
>

aluckyguess
April 27th 05, 04:51 AM
This is pretty good and if you have a 296 you can download to it.
http://www.garmin.com/support/agree.jsp?id=35
"Matt Barrow" > wrote in message
...
>
> "Bob Chilcoat" > wrote in message
> ...
>> I'd certainly like to see it. I've been trying to move my Excel logbook
>> into Access, but I'm not apparently smart enough to make the Logbook
> "Pages"
>> look like my paper log. Demung my email address first. Thanks.
>>
>> --
>> Bob (Chief Pilot, White Knuckle Airways)
>
>
> This is Chris, Matt's son "speaking".
>
> You can do a direct importation from Excel into Access, but you'll want to
> normalize the tables to create a true database. Depending on how your laid
> out the Excel collumns/cells, this might be easy or hard.
>
> First, do a report form and lay out your form fields to match the logbook
> form. From there, link in a query to fill the pages. You can add total
> fields at the bottom for the point in time (running totals) or grand
> totals.
>
> See if that works. The database schema I laid out for the logbook program
> has a lot more information than the typical spreadsheets. I did the
> program
> originally in 1996 (It was a school project) or so when Dad had about 500
> hours. I've added a lot of enhancements since then. He's been keeping it
> religiously since then and the data since is much more complete and
> accurate.
>
> It might well be overkill for what your want.
>
> Best,
>
> Chris Barrow
>
>>
>> "Matt Barrow" > wrote in message
>> ...
>> >
>> > "Wizard of Draws" > wrote
> in
>> > message
>> news:BE944954.65763%jeffbTAKEOUTALLCAPS@TOEMAILwiz ardofdraws.com...
>> > > Does anyone here use Filemaker Pro for keeping their logbook? I've
> just
>> > > finished creating one in version 6 because Excel seems to be getting
>> > > unwieldy as my time grows.
>> > >
>> > > Since I'm a newbie at FMP, I wouldn't mind letting someone more
>> > experienced
>> > > with the program take a look and give me some feedback.
>> >
>> > My kid did one in MS-Access a few years ago and it works great. It
>> > keeps
> a
>> > whole lot more than just the FAA required data (ie, hours under VFR
> flight
>> > plans vs IFR plans, IMC, yada yada...).
>> >
>> > I could maybe send you the structures and other components if you'd
> liketo
>> > try it.
>> >
>> > --
>> > Matt
>> > ---------------------
>> > Matthew W. Barrow
>> > Site-Fill Homes, LLC.
>> > Montrose, CO
>> >
>> >
>> >
>> >
>>
>>
>
>

Wizard of Draws
April 27th 05, 02:33 PM
On 4/26/05 10:00 PM, in article , "Matt
Barrow" > spewed:

>
> "Wizard of Draws" > wrote in
> message news:BE944954.65763%jeffbTAKEOUTALLCAPS@TOEMAILwiz ardofdraws.com...
>> Does anyone here use Filemaker Pro for keeping their logbook? I've just
>> finished creating one in version 6 because Excel seems to be getting
>> unwieldy as my time grows.
>>
>> Since I'm a newbie at FMP, I wouldn't mind letting someone more
> experienced
>> with the program take a look and give me some feedback.
>
> My kid did one in MS-Access a few years ago and it works great. It keeps a
> whole lot more than just the FAA required data (ie, hours under VFR flight
> plans vs IFR plans, IMC, yada yada...).
>
> I could maybe send you the structures and other components if you'd liketo
> try it.

Matt,

I'm not sure if FMP will import MS-Access files, especially since I'm on a
Mac and I don't have MS-Access. If it will, I'd like to see it.
--
Jeff 'The Wizard of Draws' Bucchino

Cartoons with a Touch of Magic
http://www.wizardofdraws.com

More Cartoons with a Touch of Magic
http://www.cartoonclipart.com

Blueskies
April 28th 05, 02:39 AM
"Matt Barrow" > wrote in message ...
> This is Chris, Matt's son "speaking".
>
> You can do a direct importation from Excel into Access, but you'll want to
> normalize the tables to create a true database. Depending on how your laid
> out the Excel collumns/cells, this might be easy or hard.
>
> First, do a report form and lay out your form fields to match the logbook
> form. From there, link in a query to fill the pages. You can add total
> fields at the bottom for the point in time (running totals) or grand totals.
>
> See if that works. The database schema I laid out for the logbook program
> has a lot more information than the typical spreadsheets. I did the program
> originally in 1996 (It was a school project) or so when Dad had about 500
> hours. I've added a lot of enhancements since then. He's been keeping it
> religiously since then and the data since is much more complete and
> accurate.
>
> It might well be overkill for what your want.
>
> Best,
>
> Chris Barrow
>

Chris,

I like to see the database. Could you send to blueskies at ameritech dot net?

TIA!

Dan

john smith
April 28th 05, 03:12 AM
Wizard of Draws wrote:
> I'm not sure if FMP will import MS-Access files, especially since I'm on a
> Mac and I don't have MS-Access. If it will, I'd like to see it.

Do you use MacLinkPlus to convert files?

john smith
April 28th 05, 03:16 AM
Wizard of Draws wrote:
> I'm not sure if FMP will import MS-Access files, especially since I'm on a
> Mac and I don't have MS-Access. If it will, I'd like to see it.

I use an AppleWorks spreadsheet for my logbook.
I have added columns for HP (high-performance), CP (complex), TD
(taildragger), CV (conventional) landings to facilitate sorting of hours
by type.

Matt Barrow
April 28th 05, 04:08 AM
I'll have to get it off my dad's laptop. He's in Texas until Friday.

Best,

Chris

"Blueskies" > wrote in message
. ..
>
> >
> > It might well be overkill for what your want.
> >
> > Best,
> >
> > Chris Barrow
> >
>
> Chris,
>
> I like to see the database. Could you send to blueskies at ameritech dot
net?
>
> TIA!
>
> Dan
>
>

Matt Barrow
April 28th 05, 04:01 PM
"Wizard of Draws" > wrote in
message news:BE950CDF.657E4%jeffbTAKEOUTALLCAPS@TOEMAILwiz ardofdraws.com...
> On 4/26/05 10:00 PM, in article , "Matt
> Barrow" > spewed:
> >
> > I could maybe send you the structures and other components if you'd
liketo
> > try it.
>
> Matt,
>
> I'm not sure if FMP will import MS-Access files, especially since I'm on a
> Mac and I don't have MS-Access. If it will, I'd like to see it.
> --

When I get back I'll have Chris show me how to delete the records and
whatever else is needed.

Give me a few days.

Matt
---------------------
Matthew W. Barrow
Site-Fill Homes, LLC.
Montrose, CO

Blueskies
April 29th 05, 12:40 AM
"Matt Barrow" > wrote in message ...
> I'll have to get it off my dad's laptop. He's in Texas until Friday.
>
> Best,
>
> Chris
>

Excellent...Thanks!

Blueskies
April 29th 05, 12:41 AM
"Matt Barrow" > wrote in message ...
>
> When I get back I'll have Chris show me how to delete the records and
> whatever else is needed.
>
> Give me a few days.
>
> Matt
> ---------------------
> Matthew W. Barrow
> Site-Fill Homes, LLC.
> Montrose, CO
>
>

Thanks Matt...

Bob Chilcoat
April 29th 05, 03:13 AM
Don't forget that I wanted it, too. Thanks.

--
Bob (Chief Pilot, White Knuckle Airways)


"Blueskies" > wrote in message
...
>
> "Matt Barrow" > wrote in message
...
> > I'll have to get it off my dad's laptop. He's in Texas until Friday.
> >
> > Best,
> >
> > Chris
> >
>
> Excellent...Thanks!
>
>

Matt Barrow
April 29th 05, 04:21 PM
"Bob Chilcoat" > wrote in message
...
> Don't forget that I wanted it, too. Thanks.
>
> --
> Bob (Chief Pilot, White Knuckle Airways)
>
>
> "Blueskies" > wrote in message
> ...
> >


Okay...I've got Bob, Blueskies and Wizardof Draws.

Now there's a lineup :~)

Back tonight; work on it this weekend -- should have it shortly.


--
Matt
---------------------
Matthew W. Barrow
Site-Fill Homes, LLC.
Montrose, CO

ram
April 29th 05, 07:17 PM
Hi Chris.

I'd like a copy of the database, as well.

Thank,
Bob

"Blueskies" > wrote in message
. ..
>
> "Matt Barrow" > wrote in message
> ...
>> This is Chris, Matt's son "speaking".
>>
>> You can do a direct importation from Excel into Access, but you'll want
>> to
>> normalize the tables to create a true database. Depending on how your
>> laid
>> out the Excel collumns/cells, this might be easy or hard.
>>
>> First, do a report form and lay out your form fields to match the logbook
>> form. From there, link in a query to fill the pages. You can add total
>> fields at the bottom for the point in time (running totals) or grand
>> totals.
>>
>> See if that works. The database schema I laid out for the logbook program
>> has a lot more information than the typical spreadsheets. I did the
>> program
>> originally in 1996 (It was a school project) or so when Dad had about 500
>> hours. I've added a lot of enhancements since then. He's been keeping it
>> religiously since then and the data since is much more complete and
>> accurate.
>>
>> It might well be overkill for what your want.
>>
>> Best,
>>
>> Chris Barrow
>>
>
> Chris,
>
> I like to see the database. Could you send to blueskies at ameritech dot
> net?
>
> TIA!
>
> Dan
>
>

john smith
April 30th 05, 01:58 AM
Matt, please send me a copy at

Jens Krueger
April 30th 05, 04:14 PM
Wizard of Draws > wrote:

> Does anyone here use Filemaker Pro for keeping their logbook? I've just
> finished creating one in version 6 because Excel seems to be getting
> unwieldy as my time grows.
>
> Since I'm a newbie at FMP, I wouldn't mind letting someone more experienced
> with the program take a look and give me some feedback.

It's not FM, but have you had a look at LogTenPro/Express? It looks
pretty good and is native for OS X.

<http://www.coradine.com/software/logtenpro.html>

Cheers,
Jens

--
I don't accept any emails right now. Usenet replys only.

Wizard of Draws
April 30th 05, 08:42 PM
On 4/30/05 11:14 AM, in article ,
"Jens Krueger" > spewed:

> Wizard of Draws > wrote:
>
>> Does anyone here use Filemaker Pro for keeping their logbook? I've just
>> finished creating one in version 6 because Excel seems to be getting
>> unwieldy as my time grows.
>>
>> Since I'm a newbie at FMP, I wouldn't mind letting someone more experienced
>> with the program take a look and give me some feedback.
>
> It's not FM, but have you had a look at LogTenPro/Express? It looks
> pretty good and is native for OS X.
>
> <http://www.coradine.com/software/logtenpro.html>
>
> Cheers,
> Jens

Thanks but I've actually got my FM version pretty well in hand and I'm
trying to expand on it as much as I can. Creating the logbook has given me a
good excuse to learn a new program, and I've even found a few errors in my
paper logbook with it.
--
Jeff 'The Wizard of Draws' Bucchino

Cartoons with a Touch of Magic
http://www.wizardofdraws.com

More Cartoons with a Touch of Magic
http://www.cartoonclipart.com

Google