(Unofficial) Planet FileMaker, Forums

... helping to feed the FileMakers ...

Random URL | Home

August 28, 2008

FileMaker Café

Exporting Problems

Forum: FileMaker Pro 9 Posted By: stock1lj@cmich.edu Post Time: 08-28-2008 at 09:06 AM

August 28, 2008 02:40 PM

how to delete html tags from a field

Forum: FileMaker Pro 9 Posted By: mingmen Post Time: 08-27-2008 at 10:56 PM

August 28, 2008 06:40 AM

Container Fields in IWP

Forum: FileMaker Pro 9 Posted By: Rogerdiddy Post Time: 08-27-2008 at 06:17 PM

August 28, 2008 02:40 AM

Google Groups: FileMaker

Re: Re: Two-way MySQL <--> FM9 connection Options, part II

[snippolade]
Diego,
In my description of how to do a scheduled import I forgot one very
important thing: In your call file (import.fp7) you need to configure
file preferences so it runs your call script when import.fp7 opens;
and configure your call script in import.fp7 to close the import.fp7
file after it has run.

by FastWolf (wolfsof...@nospamcomcast.net) at August 28, 2008 01:44 AM

Re: Re: Two-way MySQL <--> FM9 connection Options, part II

On Wed, 27 Aug 2008 14:01:02 -0700 (PDT), Diego B <messa...@yahoo.it>
wrote:
I do it by creating a separate "call" FMP file with no records in it.
It just holds a script, and that script "calls" the import/export
script in my main FMP solution. To call the "call" file I use a one
line batch file and Windows Scheduled Tasks. Let's say we have

by FastWolf (wolfsof...@nospamcomcast.net) at August 28, 2008 01:20 AM

Re: Two-way MySQL <--> FM9 connection Options, part II

All right then, I will setup a robot such as you described, although
I do not know what machine I will use for that purpose yet...
but at least it is a solution and let me centralize everything.
Thanks again
Diego

by Diego B (messa...@yahoo.it) at August 28, 2008 01:04 AM

Re: Problem w/ Dynamic Sorts using a summary field

In article
<4d4848f4-3657-4dfd-a4a9-a0a47 2c34...@l33g2000pri.googlegrou ps.com>,
Sorry, I incorrectly thought you were trying to obtain a viewable total
outside of the Portal (ie. TOTAL of remaining days and OVERALL
completion date).
You can not use Summary fields for what you are trying to do. Summary

by Helpful Harry (helpful_ha...@nom.de.plume.com) at August 28, 2008 12:37 AM

August 27, 2008

FileMaker Café

FM9 vs. FM6 related records and portals update??

Forum: FileMaker Pro 9 Posted By: Dr. Virus Post Time: 08-27-2008 at 03:52 PM

August 27, 2008 10:40 PM

Looking for help

Forum: ScriptMaker and Scripting Posted By: Sunitha Post Time: 08-27-2008 at 03:46 PM

August 27, 2008 10:40 PM

Google Groups: FileMaker

Re: Problem w/ Dynamic Sorts using a summary field

I guess I am simply looking for a way to get running totals when
dealing with a non-sorted portal. Anyone have any ideas?
Thank you.

by icedgar (iced...@gmail.com) at August 27, 2008 09:53 PM

Cleveland Consulting Support Forum

General Support :: The old CAPS LOCK problem. . .

Author: Ziggy
Subject: The old CAPS LOCK problem. . .
Posted: Tue Aug 26, 2008 5:45 pm (GMT -9)
Topic Replies: 0

Someone smarter than me must have thought this through already...
Is there a way FileMaker can convert text entered with the CAPS LOCK on (i.e. all in caps)?
Sure, you can make use of GetStatus to display a pop-up warning to FileMaker users - but once you already have data in caps, is there a way to convert it to normal upper and lower case?
I have experimented with the Lower and Proper functions, but of course all they do is convert all caps text into all lower text, for example. Could a more complex calc function be used to then apply a cap to every word appearing immediately after a full point?
A FileMaker solution which achieved this would be really useful, not just within FMP databases, but also to convert text obtained through other means such as web forms and email.

August 27, 2008 06:40 AM

August 26, 2008

SeedCode Support Forums

fmSpark :: mail.it plugin

Author: jrivera
Subject: mail.it plugin
Posted: Tue Aug 26, 2008 10:20 am (GMT -9)
Topic Replies: 1

Hi,
I was able to send email on the computer I started testing the product on. However, I get errors on everyone else's computer "The mail.it plug-in is not correctly installed. The plug-in must be installed before email messages can be sent."

I thought this should be handled automatically when opening the fmSpark file for the first time and restarting (as I didn't have to do anything else on my computer). After doing so I still get the same error.

It doesn't seem to be a user/group specific problem because I am unable to run it successfully logged in as me on the other computers.

Any ideas?

August 26, 2008 10:40 PM

fmSpark :: RE: mail.it plugin

Author: John Sindelar
Posted: Tue Aug 26, 2008 12:21 pm (GMT -9)
Topic Replies: 1

Hmmm. I can only suggest a couple of things to check as I haven't seen or heard of this before...

- if the files are being served, make sure that all fmSpark files (including fmSparkUtil.fp7) are open on the machine in question. You may need to revisit the sharing settings for some files to get them all served.

- if your on XP or Vista, make sure that you're working with the extracted files and not opening them from within the still-zipped archive. Try quitting FileMaker and then right-clicking on the .zip and selecting "Extract All". Then be sure you're working with the extracted files. (Don't really think that sounds like it, but you never know.)

If neither of those help, post some more details about your situation and we'll figure it out.

- John
_________________
John Sindelar
SeedCode LLC

August 26, 2008 10:40 PM

SeedCode Calendar :: RE: 24Hrs Horizontal Schedule View

Author: maidanss
Posted: Tue Aug 26, 2008 9:27 am (GMT -9)
Topic Replies: 5

John Sindelar wrote:
Ah. You're right. The number of extra columns needed depends on the scale you wish to use (you'd need 10 new columns at a 1 hour scale, 82 new columns at a 15 minute scale). In either case this is a major undertaking and would make the resulting screen quite wide. If your client's have large enough monitors for this I'd be happy to get you an estimate for making this change. Email me at john at seedcode.com if you'd like to pursue this.


Thanks for the tip John, I implemented your advice and it turned out beautifully on a 20 inch screen.

Thanks again, Much appreciated
_________________
Salman Maidan

August 26, 2008 06:40 PM

SeedCode Calendar :: RE: Appointments under one project in one day

Author: maidanss
Posted: Mon Aug 25, 2008 9:15 pm (GMT -9)
Topic Replies: 2

Thanks John
_________________
Salman Maidan

August 26, 2008 06:40 AM

SeedCode Calendar :: RE: Appointments under one project in one day

Author: John Sindelar
Posted: Mon Aug 25, 2008 2:42 pm (GMT -9)
Topic Replies: 2

Hi,

Doing this when printing the appointment list (from the list view or daily view) is pretty simple as it is just a sub-summary report.

However adding this to the week and month print outs (which print as a grid) is much more involved and isn't the kind of thing I could provide instructions for. Please feel free to email me directly ( john at seedcode.com) and I'd be glad to get you a price for making this change in your copy of the file.

Hope that helps,
_________________
John Sindelar
SeedCode LLC

August 26, 2008 02:40 AM

August 20, 2008

Cleveland Consulting Support Forum

Custom Functions :: RE: Function for parsing values in a text field

Author: CasusBelli
Posted: Tue Aug 19, 2008 5:49 pm (GMT -9)
Topic Replies: 4

Court Bowman wrote:
Aaah, i think I understand. If they are indeed return separated then they can be referred to as values, and there is a good discussion of a couple ways to do that in this thread:

http://www.clevelandconsulting.com/support/viewtopic.php?t=120


Thank you so much Court. This is precisely what I was looking for. I modified Shaun Flisakowski's excellent RemoveValues function so it would substitute a value for another instead of simply deleting it. Here it is:

Code:
SubstituteValues (valuesList; valueToChange; substitutedValue)


Code:
/* Function based on RemoveValues by Shaun Flisakowski, Software engineer, Apple Computer, Inc.
Published Apr 28, 2004 on http://www.clevelandconsulting.com/support/viewtopic.php?t=120 */

Case ( IsEmpty ( valuesList ); "";
           IsEmpty ( valueToChange ); valuesList;

           Let ( [ item = LeftValues ( valuesList ; 1 );
                   remain = SubstituteValues ( RightValues( valuesList; ValueCount ( valuesList ) -1 ); valueToChange; substitutedValue )
                   ];

             If ( IsEmpty ( FilterValues ( item; valueToChange ) );
                   item & remain;
                   substitutedValue & ¶ & remain
             )
          )
)


This function will find full occurrences of a value and substitute another value for it. It will not change partial matches (using it to change the value "1" in the list "1¶2¶3¶4¶5¶6¶7¶8¶9¶10" will change the first value, but will not affect the "1" in "10")

Thanks again,
Casus

August 20, 2008 06:21 AM

Custom Functions :: RE: Function for parsing values in a text field

Author: Court Bowman
Posted: Tue Aug 19, 2008 3:40 pm (GMT -9)
Topic Replies: 4

Aaah, i think I understand. If they are indeed return separated then they can be referred to as values, and there is a good discussion of a couple ways to do that in this thread:

http://www.clevelandconsulting.com/support/viewtopic.php?t=120

Let me know if that does it.

Court
_________________
Court Bowman, President
Cleveland Consulting, Inc.

http://www.clevelandconsulting.com/

August 20, 2008 02:20 AM

August 19, 2008

Cleveland Consulting Support Forum

Custom Functions :: RE: Function for parsing values in a text field

Author: CasusBelli
Posted: Tue Aug 19, 2008 6:45 am (GMT -9)
Topic Replies: 4

Court Bowman wrote:
Casus,

While you could write a custom function to do this, I think the standard substitute function would work just as well, if not better.


Hi Court,

Thank for the quick reply (and for the tip on how to log in Smile

I tried several variations of the substitute function, but none worked. Looking for "ABC " doesn't find occurrences where "ABC" is the complete value (ie, it is on a single line). My example was faulty as I should have written "ABC¶ABCD". My mistake!
What complicates matters (and I didn't show that in my example) is that my values are composed of several words.

Better example:
I need to be able to change "ABC D" but not "ABC DEF" in fields containing the following:
"ABC D¶ABC DEF" or "ABC DEF¶ABC D"

Any ideas? Thanks,

CB

August 19, 2008 06:20 PM

Custom Functions :: RE: Function for parsing values in a text field

Author: Court Bowman
Posted: Tue Aug 19, 2008 6:30 am (GMT -9)
Topic Replies: 4

Casus,

While you could write a custom function to do this, I think the standard substitute function would work just as well, if not better.

The issues is how do you determine what are unique values, I would suggest looking at including a space in your search string so that:

Code:
Substitute ( Text ; "ABC" ; ReplacementValue )


becomes:

Code:
Substitute ( Text ; " ABC " ; ReplacementValue )


Give that a shot and let us know if it helps.
_________________
Court Bowman, President
Cleveland Consulting, Inc.

http://www.clevelandconsulting.com/

August 19, 2008 06:20 PM

August 16, 2008

FileMaker Wikipedia Revision History

24.8.242.114: /* History */

History

← Previous revision Revision as of 14:54, 16 August 2008
Line 50: Line 50:
By 1995 FileMaker was the only strong-selling product in Claris’s lineup. In 1998, Apple moved development of some of the other Claris products in house, dropped most of the rest, and renamed Claris to “FileMaker, Inc.” to further develop and market FileMaker.
By 1995 FileMaker was the only strong-selling product in Claris’s lineup. In 1998, Apple moved development of some of the other Claris products in house, dropped most of the rest, and renamed Claris to “FileMaker, Inc.” to further develop and market FileMaker.
-
Version 4.0, introduced in 1997, added a plug-in architecture much like [[Adobe Photoshop|Photoshop]], which provided for third-party developers to add various non-native functionalities to FileMaker. A bundled plug-in was the Web Companion, which allowed the database to act as a web server; other “plugs” add new features to the interface or allow FileMaker to act as an FTP client, perform external file operations, and send messages to remote FileMaker files over inter- or intra-net.
+
Version 4.0, introduced in 1997, added a plug-in architecture much like [[Adobe Photoshop|Photoshop]], which provided for third-party developers to add various non-native functionalities to FileMaker. A bundled plug-in was the Web Companion, which allowed the database to act as a web server; other “plugs” add new features to the interface or allow FileMaker to act as an FTP client, perform external file operations, and send messages to remote FileMaker files over internet or intranet.
Since its emergence from the Apple fold, FileMaker Inc. has invested substantially in software development. Version 7 of FileMaker Pro, released in March 2004, supported file sizes of up to 8 terabytes (up from 2 gigabytes in previous versions). Individual fields could hold up to 2 gigabytes (up from 64 kilobytes in previous versions) and FileMaker’s relational model was enriched, offering multiple tables per file and a graphical relationship editor which displayed (and allowed manipulation of) related tables in a form which in some respects resembled the familiar “[[Entity-relationship model|entity-relationship diagram]]” format. With this change, FileMaker Inc. also introduced a worldwide developer certification program in recognition of the growing numbers of professional developers working with FileMaker.
Since its emergence from the Apple fold, FileMaker Inc. has invested substantially in software development. Version 7 of FileMaker Pro, released in March 2004, supported file sizes of up to 8 terabytes (up from 2 gigabytes in previous versions). Individual fields could hold up to 2 gigabytes (up from 64 kilobytes in previous versions) and FileMaker’s relational model was enriched, offering multiple tables per file and a graphical relationship editor which displayed (and allowed manipulation of) related tables in a form which in some respects resembled the familiar “[[Entity-relationship model|entity-relationship diagram]]” format. With this change, FileMaker Inc. also introduced a worldwide developer certification program in recognition of the growing numbers of professional developers working with FileMaker.

by 24.8.242.114 at August 16, 2008 02:54 PM

24.8.242.114: /* History */

History

← Previous revision Revision as of 14:52, 16 August 2008
Line 48: Line 48:
A significant milestone in FileMaker’s history came with the release in September 1992 of a multiplatform version. Except for few platform-specific functionalities, a “solution” (as FileMaker Pro databases are called) [[look and feel|looks and feels]] the same in Windows as on a Mac. This gave it a very strong position in the marketplace and continues to be one of its key advantages. The following version 3.0, released around 1995, was a significant upgrade with new relational and scripting features.
A significant milestone in FileMaker’s history came with the release in September 1992 of a multiplatform version. Except for few platform-specific functionalities, a “solution” (as FileMaker Pro databases are called) [[look and feel|looks and feels]] the same in Windows as on a Mac. This gave it a very strong position in the marketplace and continues to be one of its key advantages. The following version 3.0, released around 1995, was a significant upgrade with new relational and scripting features.
-
By 1995 FileMaker was the only strong-selling product in Claris’s line-up. In 1998, Apple moved development of some of the other Claris products in house, dropped most of the rest, and renamed Claris to “FileMaker, Inc.” to further develop and market FileMaker.
+
By 1995 FileMaker was the only strong-selling product in Claris’s lineup. In 1998, Apple moved development of some of the other Claris products in house, dropped most of the rest, and renamed Claris to “FileMaker, Inc.” to further develop and market FileMaker.
Version 4.0, introduced in 1997, added a plug-in architecture much like [[Adobe Photoshop|Photoshop]], which provided for third-party developers to add various non-native functionalities to FileMaker. A bundled plug-in was the Web Companion, which allowed the database to act as a web server; other “plugs” add new features to the interface or allow FileMaker to act as an FTP client, perform external file operations, and send messages to remote FileMaker files over inter- or intra-net.
Version 4.0, introduced in 1997, added a plug-in architecture much like [[Adobe Photoshop|Photoshop]], which provided for third-party developers to add various non-native functionalities to FileMaker. A bundled plug-in was the Web Companion, which allowed the database to act as a web server; other “plugs” add new features to the interface or allow FileMaker to act as an FTP client, perform external file operations, and send messages to remote FileMaker files over inter- or intra-net.

by 24.8.242.114 at August 16, 2008 02:52 PM

24.8.242.114: /* History */

History

← Previous revision Revision as of 14:50, 16 August 2008
Line 46: Line 46:
Claris changed the name to “FileMaker II” in order to be compatible with the naming of their other products, such as MacWrite II, but the product was changed little from the last Nashoba version. Several seemingly randomly numbered minor versions followed, and things finally settled down with the release of “FileMaker Pro” 1.0 in 1990. At this point, FileMaker was still a Mac OS–only application.
Claris changed the name to “FileMaker II” in order to be compatible with the naming of their other products, such as MacWrite II, but the product was changed little from the last Nashoba version. Several seemingly randomly numbered minor versions followed, and things finally settled down with the release of “FileMaker Pro” 1.0 in 1990. At this point, FileMaker was still a Mac OS–only application.
-
A significant milestone in FileMaker’s history came with the release in September 1992 of a multi-platform version. Except for few platform-specific functionalities, a “solution” (as FileMaker Pro databases are called) [[look and feel|looks and feels]] the same in Windows as on a Mac. This gave it a very strong position in the marketplace and continues to be one of its key advantages. The following version 3.0, released around 1995, was a significant upgrade with new relational and scripting features.
+
A significant milestone in FileMaker’s history came with the release in September 1992 of a multiplatform version. Except for few platform-specific functionalities, a “solution” (as FileMaker Pro databases are called) [[look and feel|looks and feels]] the same in Windows as on a Mac. This gave it a very strong position in the marketplace and continues to be one of its key advantages. The following version 3.0, released around 1995, was a significant upgrade with new relational and scripting features.
By 1995 FileMaker was the only strong-selling product in Claris’s line-up. In 1998, Apple moved development of some of the other Claris products in house, dropped most of the rest, and renamed Claris to “FileMaker, Inc.” to further develop and market FileMaker.
By 1995 FileMaker was the only strong-selling product in Claris’s line-up. In 1998, Apple moved development of some of the other Claris products in house, dropped most of the rest, and renamed Claris to “FileMaker, Inc.” to further develop and market FileMaker.

by 24.8.242.114 at August 16, 2008 02:50 PM

24.8.242.114: /* History */

History

← Previous revision Revision as of 14:49, 16 August 2008
Line 44: Line 44:
Shortly thereafter, Apple Computer formed [[Claris]], a wholly owned subsidiary, to market software. Within months they had purchased Nashoba to round out their software suite. By that time, Leading Edge and Nutshell had faded from the marketplace because of competition from other DOS and later Windows platform database products. FileMaker, however, continued to succeed on the Macintosh platform.
Shortly thereafter, Apple Computer formed [[Claris]], a wholly owned subsidiary, to market software. Within months they had purchased Nashoba to round out their software suite. By that time, Leading Edge and Nutshell had faded from the marketplace because of competition from other DOS and later Windows platform database products. FileMaker, however, continued to succeed on the Macintosh platform.
-
Claris changed the name to “FileMaker II” in order to be compatible with the naming of their other products, such as MacWrite II, but the product was changed little from the last Nashoba version. Several seemingly randomly numbered minor versions followed, when things finally settled down with the release of “FileMaker Pro” 1.0 in 1990. At this point, FileMaker was still a Mac OS–only application.
+
Claris changed the name to “FileMaker II” in order to be compatible with the naming of their other products, such as MacWrite II, but the product was changed little from the last Nashoba version. Several seemingly randomly numbered minor versions followed, and things finally settled down with the release of “FileMaker Pro” 1.0 in 1990. At this point, FileMaker was still a Mac OS–only application.
A significant milestone in FileMaker’s history came with the release in September 1992 of a multi-platform version. Except for few platform-specific functionalities, a “solution” (as FileMaker Pro databases are called) [[look and feel|looks and feels]] the same in Windows as on a Mac. This gave it a very strong position in the marketplace and continues to be one of its key advantages. The following version 3.0, released around 1995, was a significant upgrade with new relational and scripting features.
A significant milestone in FileMaker’s history came with the release in September 1992 of a multi-platform version. Except for few platform-specific functionalities, a “solution” (as FileMaker Pro databases are called) [[look and feel|looks and feels]] the same in Windows as on a Mac. This gave it a very strong position in the marketplace and continues to be one of its key advantages. The following version 3.0, released around 1995, was a significant upgrade with new relational and scripting features.

by 24.8.242.114 at August 16, 2008 02:49 PM

24.8.242.114: /* History */

History

← Previous revision Revision as of 14:48, 16 August 2008
Line 44: Line 44:
Shortly thereafter, Apple Computer formed [[Claris]], a wholly owned subsidiary, to market software. Within months they had purchased Nashoba to round out their software suite. By that time, Leading Edge and Nutshell had faded from the marketplace because of competition from other DOS and later Windows platform database products. FileMaker, however, continued to succeed on the Macintosh platform.
Shortly thereafter, Apple Computer formed [[Claris]], a wholly owned subsidiary, to market software. Within months they had purchased Nashoba to round out their software suite. By that time, Leading Edge and Nutshell had faded from the marketplace because of competition from other DOS and later Windows platform database products. FileMaker, however, continued to succeed on the Macintosh platform.
-
Claris changed the name to “FileMaker II” in order to be compatible with the naming of their other products, such as MacWrite II, but the product was changed little from the last Nashoba version. Several seemingly randomly-numbered minor versions followed, when things finally settled down with the release of “FileMaker Pro” 1.0 in 1990. At this point, FileMaker was still a Mac OS–only application.
+
Claris changed the name to “FileMaker II” in order to be compatible with the naming of their other products, such as MacWrite II, but the product was changed little from the last Nashoba version. Several seemingly randomly numbered minor versions followed, when things finally settled down with the release of “FileMaker Pro” 1.0 in 1990. At this point, FileMaker was still a Mac OS–only application.
A significant milestone in FileMaker’s history came with the release in September 1992 of a multi-platform version. Except for few platform-specific functionalities, a “solution” (as FileMaker Pro databases are called) [[look and feel|looks and feels]] the same in Windows as on a Mac. This gave it a very strong position in the marketplace and continues to be one of its key advantages. The following version 3.0, released around 1995, was a significant upgrade with new relational and scripting features.
A significant milestone in FileMaker’s history came with the release in September 1992 of a multi-platform version. Except for few platform-specific functionalities, a “solution” (as FileMaker Pro databases are called) [[look and feel|looks and feels]] the same in Windows as on a Mac. This gave it a very strong position in the marketplace and continues to be one of its key advantages. The following version 3.0, released around 1995, was a significant upgrade with new relational and scripting features.

by 24.8.242.114 at August 16, 2008 02:48 PM