Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


pixi last won the day on April 26

pixi had the most liked content!

Community Reputation

17 Good

About pixi

  • Rank
    Digital Factotum @ herrfriedrich.com

Profile Information

  • Title
    Founder of dotfmp.berlin
  • Gender
    Not Telling
  • Location
  • Interests
    Learning, Learning, Learning

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
    Authorized Trainer
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Too many

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet
    FileMaker Business Alliance
    FIleMaker Platinum Member

Recent Profile Visitors

5,894 profile views
  1. You most likely have a layout element from a not connected/related Table(Occurence). Either ckeck the Objects panel in Layout mode for unrelated fields or remove one single element at a time.
  2. Run a scheduled system level/command line script! https://support.claris.com/s/article/FileMaker-Server-Command-Line-Reference-1503693065918?language=en_US
  3. Well, after experiencing a strong "Corona muscle" myself I wouldn't be responsible for the same with all the attendees. And doing one thing twice is lame, isn't it?
  4. Has anyone played with latest FMS Linux and LetsEncrypt-Certificates? (How) does it work?
  5. Berlin, 19. April 2021 - herrfriedrich.com, a long-time FileMaker Certified Developer and Claris Platinum Partner is pleased to announce that registration for dotfmp.berlin 2021 is open and can be accessed here: https://dotfmp.berlin dotfmp.berlin is an effort of various European FileMaker Developers and takes place in Berlin, Germany each year starting at the first Thursday in June. dotfmp.berlin is a 3 Day-Unconference and as such by definition an informal and self-organized effort to meet on a personal base. It is meant to bring all kinds of higher level developers together to share
  6. Digging deeper into JS I'm also musing about what JS-Framework may make the most sense!? ”Most sense" means: • What is easy to learn? • What does not have dependencies? • What is currently the most popular one? So may I ask around: 1) What is the JS-Framework you're using? 2) Why? 3) What are the Pros and Cons (if that's different from 2)
  7. Since I got some useful answers over at FB I want to make sure it stays here too, just in case someone is wondering as well, so:
  8. A table with 100ks of records should be checked for exactly identical records and those should get removed. So I concatenated all fields which have to be included into a single string. But when searching for duplicate records it failed to find the exact duplicates using "!". Some were the same up until the e.g. 176 chars, but then different. I assumed that even the word index is not working as expected. @Kevin Frank found out that it can find duplicates until the first 109 chars when 108 are identical but the 109 is different. But asa 109 are identical and the 110th is different it doesn
  9. Yes, meanwhile I understood why I couldn't get it. I thought the FROM and TO describe a DURATION while they just describe a switch in time. Well, I have https://en.wikipedia.org/wiki/List_of_tz_database_time_zones which gives me the "TZ database name" (which I guess is the official one, understandable by all system reading an .ics) and the related offset. Those value I need. Or am I missing something?
  10. While this may seem slightly of topic from pure FileMaker it may come in handy for creating and exporting .ics-files. To build an .ics-file which works across timezones they have to contains timezone components. Two of them are TZOFFSETFROM and TZOFFSETTO. While there is an official description here: https://tools.ietf.org/html/rfc5545#section-3.6.5 [Page 65] I can't wrap my head around the meaning and how to calculate it. I'm looking for a profound explanation what exactly the difference between both of them is and how to calculate/use it. I have a list of all timezones and th
  11. Checking a file with BE it throws me the error "Style has no name! This style has no name, and so won't appear in the style list, even though it exists in the file. This is a bug in FileMaker Pro, and there is no simple way to clear out the style as it can't be located. They don't cause problems, but do take up a small amount of space. You can try saving the style changes or the theme to clear these out." But neither saving all Styles on all Layouts nor saving or renaming the Theme works. Does anyone have any idea how to fix that? TIA pixi This is the xml co
  12. herrfriedrich.com, a FileMaker Platinum member (and now Claris Platinum member) is pleased to announce the dotfmp.berlin 2020 - The next Un-Conference for all types of Developers on higher levels. The 8th edition will feature again some of the most brilliant minds in FileMaker development, not only from all over Europe but also from the rest of the world. Since dotfmp is the only fully English-speaking FileMaker event in Europe, this is the chance to meet and share on a unique and personal level. It will be held from 4 - 6 June 2020 at the Schankhalle Pfefferberg in one of the
  13. Currently I only have problems with the null character. That is solved, thanks to your help! To avoid further hassle in the future/in other files I build a list using the control characters mentioned above. I'm aware that this won't solve the whole thing, but at least the most common ones. Thank you!
  14. Could it be possible that stripping out all C0-Control codes from Dec 01 to Dec 31 and HexDecode ( "00" ) solves the problem? https://en.wikipedia.org/wiki/C0_and_C1_control_codes
  15. So, if I get you right I just have to Substitute ( txt; HexDecode ( "00" ); "" ) ? That seems to be quite easy…a bit too easy maybe? The global fields retains the char, no matter if it is opened locally or from a server. Is there a way to discover/a list of all "invisible" chars? A CF to strip them would be very handy… An other "weird" thing I discovered is that if you have a calc in the Data viewer with the reversed question mark, close FMPA and re-open it, the calc is stripped after the first reversed question mark. So, if FM discovers these signs in the calc engine why the h
  • Create New...

Important Information

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