Jump to content

harryk

Members
  • Content Count

    191
  • Joined

  • Last visited

Community Reputation

0 Neutral

About harryk

  • Rank
    member
  • Birthday 04/02/1957
  1. You can use Export Field Contents, which is a fine and simple function to make includes on php webpages. As mentioned, the files that are made are in utf16 format, with a Byte Order Mark at the beginning. You must find your solution not within Filemaker but within your webpage to cope with the utf16 problem http://www.moddular.org/log/utf16-to-utf8 Here is a beautiful utf16 to utf8 translation function (php). Extend it a bit so that it gets the include file to translate, but also puts the file back as utf8. When it gets the file a second time, and finds no utf16 Byte Order Mark, it concludes it is utf8 and will pass it through without translation. But you have to adapt the php for that. Not too difficult. Happy including Harry
  2. I bought FM 8 Advanced, and I bought the English version, although I am Dutch, and have a Dutch OSX. I want FM to be in English as I am used to the English commands, script steps and all that and the 'world of information' on the web around FM is in English. (Also my manual on paper is english...) After installing, FM8 showed up in English, as I recall, but after running the updater to version 8.0.v2, FM8 showed up in Dutch. I talked to Filemaker and the 'solution' they offer, which works, is to change the system language, and log out and in again. This indeed gives me an english filemaker, but also an english system... So my wish is to be able to change FM language apart from the system language. And my question, as there are apparently the languages somewhere in the FM package available, is there a way to change in a plist for example, the language? Thanks EDIT at later time: It is possible to change language apart from the system language. Just select the application filemaker in the finder, and go to Get Info in the finder. In the info pane under Language uncheck all languages except the language you prefer... It is that simple, but not too well documented.
  3. I have a database longtime ago converted from FM5pro to FM7. I have global fields, set up as text, and with auto enter data text, allow override. I use these globals for print heads on certain lay-outs, when not filled out by the user the auto enter text is something like "Welcome to L.A.P." to avoid an empty line, to avoid the absence of a header. Always ok in FM5. In FM7.0v1 (I know, not the newest, that's v3) when I create a new record, the content of the global is overwritten by it's auto enter content! Anyone familiar with this?
  4. It seems to me that 'send event' isn't even necessary. When you define a container field, and insert the word doc as a file with only the reference (or if you wish the doc itself), then you can approach that field in a script with 'go to field'. Make sure the 'select/perform' option is checked. When you use the go to field script step, the document will open in Word... simple as that. Harryk
  5. Having thought of data separation, and noticing it is a hot topic now, just a thought for what it's worth. Data separation is a good thing, but it can be complex. It solves problems (data import after upgrading for example) but creates other problems to solve, too. My thought is, that if a database is relatively simple, and not too huge, you might think of a semi-solution. That is, that the main operations are executed on the main file (and perhaps some related files), just as you were used to without data separation. Extra though, is the built in option, to scripted export and import of data from the main file to a backup-data file (related of course), fully controlled through scripts. When update is needed of the main file, the data in it must be backed up to the data-file, before it is replaced. The new main interface file can be delivered/installed empty, scripts and control flags take care of the 'refill' of the main file with the contents of the related data file. The extra work of this scenario is scripting (field by field) the in- and export of the data. You could script it in a way that modifications are noticed and that on startup and/or closing the file the data-file is kept up to date. Extra benefit, some kind of backup. Just a thought. Harryk
  6. Yes, I noticed this too, but it is merely a kind of bug in the Apple Mail display. You can check out for yourself: send an email (with dialog, so Mail will 'hold' the message) to an address that is not in your address book. (If it is in your address book, the display error will not occur by the way). You will see the double <name@mail.com><name@mail.com> in the To: field (or cc: or bcc:). When you save the message as a concept, and review the source there, you will notice that in the source everything is correct. As far as my experience goes, there is only the display problem and not a real problem. Harryk
  7. Problem solved...there is a separate 5.5v2 updater for OSX which I overlooked... Harryk (but i DO miss the toolbars in OSX regarding version 5.5..) FileMaker Version: 5 Platform: Mac OS X Panther
  8. When trying to use the updater for upgrading developer 5.5v1 to 5.5v2, both in the classic environment as well as a native started OS 9, I get an error after the installation has just begun. Error message is 'Resource was modified'. Anybody a clue? My system is Panther, the current Filemaker (Developer) 5.5v1 is running smoothly there. The updater asks to go to classic. Thanks in advance. Harry FileMaker Version: 5 Platform: Mac OS X Panther
  9. The bottleneck of the carriage return replacement is not of course what you see in your own E-mail-client but what the clients see in their E-mail...When using Netscape 4.79 as my default E-mail client I used %0A as the replacement, which looked ok in Netscape. I got the %0A replacement tip somewhere from the internet, but it sucks..Outlook Express misunderstands the %0A. When using %0A%0D my Outlook Express (Mac) displays an extra square next to the carriage return, so that does not work well either. In my experience just replacing the
  10. Hello outthere, My question, is there an internal filemaker limitation on the numbers of nesting in a subsitute function? Example below. Is it wise to limit and to split up, or is there no known limit to the number of nestings? Thanks Harry (example below) -- Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( field to substitute,"?","&Auml;"), "?", "&Aring;"), "
  11. I think the answer (at least in my setup, other options in other directions as you mention are possible too) lies in a calculation with a nested substitute function that replaces all the special signs in the html-entities. I found something on the internet like below. Does anyone know whether there is a limit to the number of nestings you can use in a substitute function? Harry (see below) Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( field to substitute,"?","&Auml;"), "?", "&Aring;"), "
  12. Hello, long time no see. I used to post often, long time ago. I don't use Filemaker online, just as an interface to help me publish things online. It's something like this, I've got on a site a list of teachers. When people apply for the list, they use a form. This form generates with javascript the complete html code of all the infomation they fill in, I get the html-code via a field in the form. There's even a preview function so they can see how their application will look like on the web. Recently I use Filemaker to organize those chunks of html, to compose once a month the complete html-file. My problem is the representation of non-ascii html signs, normally represented by html-entities like &aacute; that sort of thing. Filemaker will be able to help me, by finding and replacing the signs that need html-entities. My question is, does anyone know whether FM calculations exist that do that job for me, so I do not have to invent the wheel again? Harry
  13. No, but you could add a verticall scroll bar to the field. Harryk
  14. I do not know the cause of that problem. It is a TRAILING summary? (summarys can be leading or trailing). Furthermore, do you for the first page use a title header which is larger then the normal header? This would explain why on the second page and further the things are allright. Or are the lines that the records occupy larger then normal on the first page? You use list view in this case, and I do not understand you saying that you adjusted the body size. You keep the body as tight as possible, the more records fit on a page. The subsummary is below the body part..not part of the body itself. Harryk
  15. >No sort on the global field Yep, but you should not sort on the global field but on an unstored calculation field that contains: Int((Status(CurrentRecordNumber) -1) /PTR_gLinesonpage) Name that field the way you like, and use that field to make appear the subsummary. This works, I use it myself. There is only one drawback. As the records are sorted by this field, another sort is impossible. But I know of no other way of getting a running total subsummary at the end of a page. Harryk
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.