Updates

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Updates

Danny Krumnow
By Updates I mean a change in the Database. For instance I use Filemaker in my Police Vehicles to Document Tickets, Stops, Arrests, and Calls for Service. These Files are exported Daily to the Police Station and stored there. I recently changed from a Magstripe Reader off the Driver's License to a Bar Code Reader. The Officers use this to Auto enter Personal Data. This made adding multiple Fields as well as Scripts very necessary. As I use the Program I am constantly having to Tweak the Program to make unforeseen things work. Such as Florida and one other State I have found enter their Dates in Backwards. Year, Month, Day, instead of Month, Day, Year, which is normal. Two days ago I found that Montana does not store what State the DL is from in the Bar Code Data in addition to storing their Dates backwards. Until I hit all 50 states I will constantly be tweaking and I hate swapping out the whole file because it is not as easy as just swapping the file. Each Officer has unique
  IDs, serial numbers on equipment and so forth. I also calculate fines which change, so finding a way to auto update is high on my list right now and in the cars I am using FMP 6.



From: john renfrew <[hidden email]>
To: "[hidden email]"
        <[hidden email]>
Subject: Re: Update for Filemaker Databases
Message-ID:
        <[hidden email]>

Content-Type: text/plain; charset="iso-8859-1"

Define easy.

Define updates.


________________________________
From: FMPexperts <[hidden email]> on behalf of Danny Krumnow <[hidden email]>
Sent: 22 April 2017 2:23 PM
To: Filemaker Experts Post
Subject: Update for Filemaker Databases

I have done Filemaker Databases for a long time but I am not an Advanced Developer. My question is this. Is there an easy way to have Filemaker Databases install updates without replacing the complete file?


D. Krumnow
254-717-8207



D. Krumnow
254-717-8207

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|

Re: Updates

Michael Kupietz
Short answer: no. In FileMaker 6, everything is contained in a single
file per table, and there's no way to swap out part of it. Your best bet
is one of the following (none of which may be a very good answer for
you):

1.) Do your work on the live system. (Not always a good answer,
especially in old versions, due to the inability to make certain kinds
of changes while users are in the file editing records.)
2.) Upgrade to FileMaker version 7 or later, which allow you to break
individual solutions across multiple files. (Note: upgrading from
pre-FM7 files can be complicated, depending on the structure of your
database and what kinds of scripts you have.)
3.) If you were using FileMaker 6 advanced, which I gather you aren't,
you could store some calculations that are likely to change in Custom
Functions instead of in field definitions, as they can easily be edited
in a live file.
4.) Keep on doing it how you've been doing it. (Obviously not a great
answer or you wouldn't be writing.)

If it were me, and cost weren't an issue, I'd say that generally,
investing in the upgrade to a newer version would be my preferred
answer. Just be prepared to understand the things that can complicate an
FM7 upgrade or hire someone who does. Without having seen the file
myself, though, that's only a guess.

Mike

--
Michael E. Kupietz
IT consulting solutions for FileMaker Pro • Web • OS X
https://www.kupietz.com
415.545.8743


On 23 Apr 2017, at 19:02, Danny Krumnow wrote:

> By Updates I mean a change in the Database. For instance I use
> Filemaker in my Police Vehicles to Document Tickets, Stops, Arrests,
> and Calls for Service. These Files are exported Daily to the Police
> Station and stored there. I recently changed from a Magstripe Reader
> off the Driver's License to a Bar Code Reader. The Officers use this
> to Auto enter Personal Data. This made adding multiple Fields as well
> as Scripts very necessary. As I use the Program I am constantly having
> to Tweak the Program to make unforeseen things work. Such as Florida
> and one other State I have found enter their Dates in Backwards. Year,
> Month, Day, instead of Month, Day, Year, which is normal. Two days ago
> I found that Montana does not store what State the DL is from in the
> Bar Code Data in addition to storing their Dates backwards. Until I
> hit all 50 states I will constantly be tweaking and I hate swapping
> out the whole file because it is not as easy as just swapping the
> file. Each Officer has unique
>   IDs, serial numbers on equipment and so forth. I also calculate
> fines which change, so finding a way to auto update is high on my list
> right now and in the cars I am using FMP 6.
>
>
>
> From: john renfrew <[hidden email]>
> To: "[hidden email]"
>         <[hidden email]>
> Subject: Re: Update for Filemaker Databases
> Message-ID:
>         <[hidden email]>
>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Define easy.
>
> Define updates.
>
>
> ________________________________
> From: FMPexperts <[hidden email]> on behalf
> of Danny Krumnow <[hidden email]>
> Sent: 22 April 2017 2:23 PM
> To: Filemaker Experts Post
> Subject: Update for Filemaker Databases
>
> I have done Filemaker Databases for a long time but I am not an
> Advanced Developer. My question is this. Is there an easy way to have
> Filemaker Databases install updates without replacing the complete
> file?
>
>
> D. Krumnow
> 254-717-8207
>
>
>
> D. Krumnow
> 254-717-8207
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|

Re: Updates

Mark Rubenstein
You might want to check out RefreshFM:

http://www.refreshfm.com/about-refreshfm/ <http://www.refreshfm.com/about-refreshfm/>

What is RefreshFM?
RefreshFM is an importing automation tool for FileMaker developers. It automates the creation of data migration scripts in any solution to allow quick imports of a live data solution into an empty “Development” version of the same solution. Because the build process is automated and comprehensively error checked you know in advance that you won’t miss any steps and that you can guarantee the import performs as expected.
RefreshFM can be used on any FileMaker solution, and it doesn’t require that you make any changes at all to your solution.

Mark
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|

Re: Updates

Stefan Schütt

> Mark Rubenstein <[hidden email]> kirjoitti 24.4.2017 kello 6.45:
>
> RefreshFM can be used on any FileMaker solution, and it doesn’t require that you make any changes at all to your solution.

Except that Danny’s solution is still in FMP 6. RefreshFM needs a minimum of fp7, more specifically FMP 11.

Otherwise a very good idea.

__
Stefan Schutt, Mouse Up, Finland



_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Reply | Threaded
Open this post in threaded view
|

Updates

Danny Krumnow
In reply to this post by Danny Krumnow
I guess this is the beauty of filemaker. Since Filemaker really has no easy way to upgrade, I scripted all my special fields which is only about 6, and had them copy to the Clipboard. I then pasted this into word. I then just replace the whole file or Database with the upgraded one. Then I scripted the Database to delete all records and then create one record. The Script then parses the info pasted into Word pasting in the special information needed. Not a great solution but it works and is much faster than writing this down and manually entering it. Thanks for your help


D. Krumnow
254-717-8207

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au