#FileMaker Tricks
Explore tagged Tumblr posts
filemakerexperts · 3 hours ago
Text
Kalender mit FileMaker und PHP
Viele Jahre nutze ich nun in FileMaker das Kalendermodul von "Otmar Kramis". Ein wunderschönes aber extrem komplexes Modul um Kalenderdaten innerhalb von FileMaker in einem WebViewer darstellen zu können. Umfangreiche Berechnungen machen die Einbindung oftmals wenn auch nicht unmöglich, so doch recht schwierig und aufwendig. Deshalb habe ich mich entschlossen etwas schnelles und sehr agiles zu entwickeln. Heraus gekommen ist ein schöner Kalender, mit dynamisch geladenen Daten. Die Kartenansichten gibt es natürlich auch in iPad-Format Für die Nutzung am iPhone gibt es auch eine angepasste Version Die Umsetzung erfolgte mit FileMaker, PHP und JavaScript.
0 notes
huntercrew845 · 4 years ago
Text
Solid Work For Mac
Tumblr media
Mac set environment variable for java. Hi all – i tried the above sequence of steps – below output: Michaels-MacBook-Pro: mhasse$ $ vim.bashprofile-bash: $: command not found. Trying to run a Java application on your Mac and need to set your JAVAHOME? Follow the instructions below to quickly and easily do it: Open Terminal Confirm you have JDK by typing “which java”. It should show something like /usr/bin/java. Check you have the needed version of Java, by typing “java -version”. I want to add an environment variable ENVVAR=12345 to my Mac, so that I can import it into a Python module using os.environ'ENVVAR' The most relevant tutorial I have found is this, but it doesn't quite do the trick for me. A lot of others tell you how to temporarily add environment variables to bash, but I don't think this is good enough. Mkyong.com: How to set JAVAHOME variable in Mac OSX. YouTube: How to set environment variables on mac, linux, solaris, rhel. YouTube: How to Set Environment Variables in Mac. I was able to locate the terminal and I think I created some multiple files. I'm getting messages like this. Setting environment variables. For the tcsh shell, the format for setting an environment variable is setenv KEY value. The following is an example which will set the JAVAHOME variable to /Library/Java/Home.
As of 2007 there doesn't appear to be an official Microsoft Access version available for Mac. Parallels works great, but it's not a good solution for programmatic access (and you have to buy Access and Windows to install on your Mac). Alternatives to Microsoft Access on the Mac File Maker Pro. FileMaker is probably the best known database application for the Mac. It has a feature set comparable to Microsoft Access, but with a strong focus on forms (layouts) as the primary way of accessing databases. Knack is the best database software for Mac users by some distance. Knack is everything. Install microsoft access on mac. Microsoft 365 for Mac. Do your best work with Office apps in Microsoft 365—anywhere, anytime, with anyone. For home For business Get Office apps for Mac. Start quickly with the most recent versions of Word, Excel, PowerPoint, Outlook, OneNote and OneDrive —combining the familiarity of Office and the unique Mac features you love. Microsoft access mac free download - Microsoft Virtual PC for Mac 7.0.3 Update, Microsoft Virtual PC for Mac Update, Parallels Desktop for Mac, and many more programs.
Download new versions, service packs, and add-ins for SOLIDWORKS, Simulation, PDM, and Free CAD Tools (eDrawings, Composer Player, SOLIDWORKS Explorer). We are often asked if it is possible to run SOLIDWORKS on a Mac computer - find out in this video. Don't forget to check out our blog here for more informati. Running Parallels on a Mac is really convenient as you can seamlessly switch between Windows and Mac OS when needed. Unfortunately, it really stretches the capabilities of most machines to run both Mac OS and Windows as well as a heavy-duty program like SOLIDWORKS at the same time. โปรแกรม solidworks มีของ mac ไหมคะ. วิศวะ ปี2 ค่ะ กำลังเรียน Autocad เทอมหน้าเรียน solid work แล้วกำลังจะซื้อโน้ตบุ๊คค่ะ เลยอยากมาให้ช่วยแนะนำ.
Solidworks For Macbook
We are often asked if it is possible to run SOLIDWORKS on a Mac computer – the answer is YES you can! Watch our video summary to find out how.
We know quite a few users running SOLIDWORKS successfully on a Mac, and SOLIDWORKS recently updated their system requirements to include virtualisation such as parallels. However, the limit of this support is that although it will install, it may not run well as Macs rarely have supported graphics cards.
We therefore would NOT recommend this setup above a Windows based professional workstation.
Although SOLIDWORKS will run on OS X there are some major considerations to be aware of. SOLIDWORKS cannot run directly on macOS, so first you will need to install Windows on your Mac using an application such as Boot Camp or Parallels. There are other considerations such as graphics performance and the applications you are using SOLIDWORKS for. Watch the video above for a guide to this, alternatively, visit the original Solid Solutions article here.
Other SOLIDWORKS Applications for Mac
SOLIDWORKS do develop several other applications that are available for macOS and iOS. This includes eDrawings Viewer for macOS, as well as eDrawings and eDrawings Professional for iOS. DraftSight is also available for macOS as a beta version.
If you’re currently using SOLIDWORKS and considering a move to Apple hardware, or if you’re currently an Apple user and are considering SOLIDWORKS, we suggest contacting your local reseller (UK and Ireland) to discuss the pros and cons of using SOLIDWORKS on mac OS before making any final decisions.
Learn more about hardware and system requirements. Find your local educational reseller here.
Solid Solutions Management Ltd was founded in 1998, originally as a SOLIDWORKS training and support provider. Now a Group with over 20 offices across the UK and Ireland, Solid Solutions is not only the leading SOLIDWORKS 3D CAD reseller in both regions, it also offers expert professional design solutions and consultancy services to more than 15,000+ customers. With over 200 employees and the largest SOLIDWORKS technical team in the world, Solid Solutions is focused on growth and on its customers’ development and success.
Latest posts by Solid Solutions Technical Team (see all)
Run SOLIDWORKS on a Mac - April 16, 2019
This is a fairly long-standing issue we come up against on the Innova Systems technical support desk, and also while talking to prospective customers about SOLIDWORKS. The simple answer is that SOLIDWORKS do not develop an Apple Mac version of the software, so we can’t install SOLIDWORKS natively.
We used to recommend the Bootcamp route, which involves installation of Bootcamp and then Microsoft Windows on the partition Bootcamp creates. The issue here is that if you need to access the Apple Mac Operating System (OS), you would need to shut down windows and boot up the Apple Mac OS, because they cannot be running simultaneously. This allows the full use of the hardware (RAM and graphics card) you have in your Apple Mac for Windows.
The alternative solution that we used to steer people away from is Parallels, a virtual machine software that allows you to run another OS inside the Mac OS (inside a window). The reason for not recommending this is that you are sharing the resource of the machine with two operating systems, thus not necessarily having the required resource to run a demanding program like SOLIDWORKS.
There were also historic problems with not being able to use the graphics card properly which would result in exceptionally slow performance when selecting things. This is due to most Macs not having certified graphics cards for SOLIDWORKS and parallels using a virtual graphics card driver or the default Windows driver. The virtual or generic drivers don’t offer the level of performance needed to run SOLIDWORKS correctly.
Innova Systems Technical Director, Ed Hawkins, explains
We have now installed and configured this on over 20 users’ Apple Mac computers and I have to say the response from these people has been amazing.
I have a mid 2014 MacBook Pro, which I’ve been using as a test bed. The specs are listed below:
You will note that this machine has Intel Iris Graphics (specific to the Mac) and not a certified graphics card for SOLIDWORKS.
So, I installed the latest version of Parallels (version 10) and a fresh copy of Windows 10 into the virtual environment and then set about making SOLIDWORKS work!
It’s pretty easy to get Windows installed, as Parallels guides you through that process very nicely. You can specify how much of the machine’s resource to give to the Windows OS – which is where a high spec Mac will stand you in better stead. It is always a good rule of thumb to assign half the available RAM to the Windows OS, so in my set up, I assigned 4GB of RAM.
The difficult bit is making the “Use Software OpenGL” button inside SOLIDWORKS become accessible. When you first install SOLIDWORKS, this button is ticked and greyed out, so we can’t turn it off. In our opinion, SOLIDWORKS is unusable at this point, as selecting geometry and navigating the software is too slow to be productive.
With a bit of effort, and some registry modifications, I was able to untick the OpenGL box, allowing us to use the graphics card to a much higher potential. The difference in performance was huge, and it allowed me to select and navigate the software much, much faster. One limitation that frustrated me early on was the lack of RealView Graphics (Accurate reflections and appearances), so I set about solving this problem too. I’m happy to report that RealView works perfectly on a properly specced Mac Book Pro!
Of course, this isn’t necessarily a new solution – Parallels has been around for some time, and installing Windows on a Mac for as long. The difference with our solution is that we can make SOLIDWORKS behave as well as a normal windows PC. No more slow selecting or poor rotational speed.
Above is a screenshot of the working set up, albeit in Window mode, not full screen. I have this running at a resolution of 2560 x 1600 in full screen mode and it is functioning very well. Please note: the specification of my Mac, and the resource I can assign to Windows is far from ideal. It would be recommended for people who are creating fairly simple parts with up to 100 features, and assemblies containing up to 500 components. Any more than that, and I think it would struggle.
In summary, the Parallels solution is now recommended by Innova Systems. We are confident of this working well in a production environment, but the spec of the Mac is key to the success. Along with our modifications to the registry in Windows, of course.
Video: See SOLIDWORKS running on Apple Mac
Video: How to run SOLIDWORKS on Apple Mac Computers
Tumblr media
Get in touch with us to find out more
Are you based in the UK and interested in running SOLIDWORKS on your Apple Mac? We can demonstrate our configuration to you via a Team Viewer session, or if you prefer and are interested in purchasing SOLIDWORKS we can come out and show you live with some of your data.
Call us on (01223) 200690 or complete this form to organise a consultation
Solidworks For Macbook
Editor’s note: This post was originally published in August 2015 and has been updated to feature new information on our process.
Tumblr media
0 notes
filemakerexperts · 8 days ago
Text
Wenn der WebViewer plötzlich leer bleibt: Daten lieber per Session-ID statt über WebViewer.SetHTML
Nach etlichen Projekten mit WebViewer-Integration in FileMaker kennt man das: Eine aufwendig generierte HTML-Darstellung wird in eine Variable geschrieben und mit WebViewer.SetHTML in das Layout eingebunden. Doch irgendwann, meist nach einem Update, einer Layoutänderung oder schlicht durch zu große Datenmengen, bleibt der WebViewer plötzlich leer. Keine Fehlermeldung, kein Hinweis. Die Lösung, die sich in meinem Fall bewährt hat. Statt den HTML-Inhalt direkt aus FileMaker in eine Variable zu übergeben, wird dieser über ein PHP-Skript auf dem Server dynamisch aufgebaut. FileMaker überträgt die Inhalte per POST, der Server speichert sie mit einer eindeutigen Session-ID in einer temporären Datei. Anschließend ruft FileMaker einfach https://meinserver.de/tour.php?session=ava_65df75dca14f8 auf und der WebViewer lädt die fertige Darstellung wie jede andere Webseite auch. Vorteile dieser Methode: – Kein Zeichenlimit oder Kodierungsproblem in FileMaker-Variablen – HTML, CSS und JavaScript können deutlich umfangreicher sein – Die Darstellung ist im Browser direkt testbar (z. B. mit ?debug=1) – Die Daten sind temporär gespeichert und nach Ablauf automatisch gelöscht Vorgangsweise: Daten werden per POST an den Server gesendet, dort in einer temporären JSON-Datei abgelegt und über eine Session-ID abrufbar gemacht. Der WebViewer muss dann nur noch die Session-ID in der URL übergeben. Der Server liefert die fertige Darstellung. Also eigentlich wie mit dem Browser. Dieser Code-Bereich ist das Herzstück für den POST-Empfang. Er übernimmt Daten aus FileMaker, speichert sie temporär als JSON-Datei und gibt eine eindeutige Session-ID zurück. Wenn sonst nach dem FileMaker Befehl -Aus URL einfügen- eine ganze HTML-Strucktur zurückkommt, bekommen wir nur noch die Session-ID zurück. Diese wird dann nur noch an die eigentliche URL der PHP-Datei gehangen. Z.B. so: https://deinserver.de/tour_post_neu.php?session=id123456.7654321.
// POST: Daten speichern und Session-ID zurückgeben if ($_SERVER['REQUEST_METHOD'] === 'POST') { $postData = array_map('trim', $_POST); $sessionId = uniqid('ava_', true); $sessionDir = __DIR__ . '/sessions/'; if (!file_exists($sessionDir)) mkdir($sessionDir, 0755, true); file_put_contents($sessionDir . $sessionId . '.json', json_encode([ 'data' => $postData, 'created' => time() ])); echo $sessionId; exit; }
Nun wird diese URL (https://deinserver.de/tour_post_neu.php?session=id123456.7654321) im WebViewer aufgerufen. Für die Verarbeitung ist dieser Teil zuständig.
if (isset($_GET['session'])) { $sessionFile = __DIR__ . '/sessions/' . $_GET['session'] . '.json'; if (file_exists($sessionFile)) { $sessionData = json_decode(file_get_contents($sessionFile), true); if (time() - $sessionData['created'] > 3600) { unlink($sessionFile); echo "Session abgelaufen"; exit; } $postData = $sessionData['data']; // hier folgt die HTML-Ausgabe } }
0 notes
adaz3d · 5 years ago
Text
FileMaker: Tips, Tricks, and Techniques (2020)
Tumblr media
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Skill Level: Advanced | Genre: eLearning | Language: English + .srt | Duration: 64 Lectures (5h 19m) | Size: 649 MB
source https://www.adaz3d.com/tutorial/other/7994-filemaker-tips-tricks-and-techniques-2020.html
0 notes
directdownloadlinksnet · 5 years ago
Photo
Tumblr media
Download Lynda FileMaker: Tips, Tricks, and Techniques Description FileMaker: Tips, Tricks, and Techniques One of the company's training courses Lynda.com It teaches you important and professional techniques and tricks in using FileMaker 17.
0 notes
educationtech · 6 years ago
Text
Improve Your Computer Skills for your Career : Arya College
Tumblr media
How computer engineers can gain additional IT skills
Technology has taken over the business world. These days, people and businesses are progressively conditional in the technology world. As a result, computer engineers with impressive knowledge and experience with a computer are in demand.
Considering the growing market trend, individuals must wish to bag a profitable job. You must dig deeper into the business and technology world to look into the best computer skills to invest in and resources to get help from.
Most-in demand computer skills this year
When talking about computer skills, the following are some computer skills that can fill your mailbox with endless job opportunities.
Spreadsheets and databases
Considering the treasure trove of data companies, Spreadsheet and Database management skill tops the list. It is considered the most wanted job skill in the market, with a good salary for an entry-level position. However, the spreadsheet skill does not confine to auditing data from cells.
To get hired based on this computer skill; an individual needs to become a Spreadsheet expert. From storing data to organizing them, applying complex mathematics formulas, and creating complex macros, it needs to be an expert at all. However, an individual needs to have expertise in Microsoft Excel, Microsoft Access, Statistics, Data Analytics, Adobe Campaign, QuickBooks, XML Database management system, Filemaker Pro, MATLAB, etc.
Social media, email, and blogging
Though people are socially active, not everyone knows how to use social media tools on the professional front. In such a scenario, having expertise at writing engages professional emails, writing blogs, and managing social media activities. It is a ticket to entry in reputed organizations for the students of Computer Science Engineering at Engineering Colleges.
Some of the skills related to social media, email and blogging that will have a leg up in the hiring process are Content Management System (CMS), Google Analytics, Cascading Style Sheets (CSS), Email Marketing, Web Page Design, Word Press, etc.
Graphic Design and Word Processing
A solid grasp of skills presents the information in a much readable form. It is another market need. When considering this computer skill category, students of B Tech Colleges need to enhance their skills at Adobe Photoshop, Adobe InDesign, Adobe Illustrator, AutoCAD, CorelDRAW, Microsoft Visual Studio, Microsoft Word, etc.
Software and hardware design and development
Software and Hardware development means designing, implementing, and testing computer software/hardware applications. However, it is the most profitable computer skill, with a different job opening. It includes Software Architect, Software Analyst, Software programmer, Hardware configuration, etc.
To be capable of developing and testing the software and hardware, students of Computer Science need to peruse their users’ needs and build an application that hits their pain points. However, they need to work with different web and mobile app coding languages for gaining the attention of their audience. It includes HTML, C/C++, Java, Python, XML, UI/UX, LINUX, CISC and RISC architecture, Embedded Processor Hardware Design, Memory Management, etc.
IT troubleshooting
Working on computers is one thing and having a knack of looking into the associated issues and resolving them in real-time is another. There are various employees and graduates who work with computer systems in their daily lives.
Therefore, if computer professionals are familiar with the basic analysis of computers and machines and know the tricks to perform such tasks to streamline the working process, they must enter the IT support arena. There are some prime IT troubleshooting skills that one needs to work upon. In addition, it includes Backup management, Diagnostics, End User support, Client-Server management, Installation and configuration, Issue tracking system (ITS), System administration, etc.
Enterprise Systems
Many enterprises have their own solutions like People Soft for managing their data and operations. Becoming a master at using the enterprise solutions mentioned in their ‘Requirements’ area can also lessen the barrier to get a job.
Thanks for Read our blog, you can check out full blog on official Page Arya College, Arya College is one of the Best Engineering College In Jaipur Rajasthan. In This College Many Branches for Engineering you can make great future with us. Arya College Provides Computer Engineering, Electrical Engineering & Electronics Engineering’s Branch for our Engineering students with top companies placements in campus.
0 notes
notinthenews · 7 years ago
Text
Filemaker admits to making alien autopsy film.
Filemaker admits to making alien autopsy film.
Spyros was on TV tonight and he is a very poor liar – so he definitely didn’t make the film. To add to his lack of cred he tried doing a simple magic trick and it went completely wrong; so that clinched the fact he’s a conman.
Despite how the film looks to some people I know it has to be real due to the massive push to convince the public it’s fake; even going so far as to make a comedy about…
View On WordPress
0 notes
leahbroo-blog1 · 8 years ago
Text
FileMaker & Me - Michael Rocharde | Programming |532231582
FileMaker & Me Michael Rocharde Genre: Programming Price: $14.99 Publish Date: May 31, 2012 This new, interactive, multi-media text book takes a completely fresh, and thought provoking, approach to developing FileMaker solutions. Focussed on interface design, the author starts with the premise that function should follow form; which means you start with the interface and build from there. Critically acclaimed by some of the top FileMaker developers in the world, developers at all levels should find something in it for them. Geoff Ryle, co-founder of Excelisys had this to say: Among the plethora of FileMaker books that have been published, this book really stands out not specifically as a bible or tutorial (there are enough of those) but instead by offering insight only a seasoned developer can provide. Michael offers a unique perspective on building solutions based on his experiences — the good, the bad and the ugly — which combined gave way to his methods that promote a different approach to development, emphasizing form followed by function and always putting the user experience first. This book is an excellent addition to any developer’s library of resources. With chapters on: • Finding a Starting Point • Reworking Somebody Else’s Design • Reworking Your Own Design • WYS is not always WYG • Using Tab Panels • Using Conditional Formatting • Understanding and Using Variables • The Power of Virtual List • Scripting • Tips & Tricks and much, much more Includes dozens of interface examples from some of the best interface designers in the FileMaker® community, hundreds of screenshots and pages of useful resources to help you on your journey. Written by Michael Rocharde, a full time professional FileMaker® developer since 1987, FileMaker & Me is an ebook written to challenge and inspire FileMaker developers from the absolute beginner to the most expert in the community. It was created for the iPad®, using iBooks Author and is only available from the iTunes® Store.
0 notes
elizabethrus-blog · 8 years ago
Text
FileMaker & Me - Michael Rocharde | Programming |532231582
FileMaker & Me Michael Rocharde Genre: Programming Price: $14.99 Publish Date: May 31, 2012 This new, interactive, multi-media text book takes a completely fresh, and thought provoking, approach to developing FileMaker solutions. Focussed on interface design, the author starts with the premise that function should follow form; which means you start with the interface and build from there. Critically acclaimed by some of the top FileMaker developers in the world, developers at all levels should find something in it for them. Geoff Ryle, co-founder of Excelisys had this to say: Among the plethora of FileMaker books that have been published, this book really stands out not specifically as a bible or tutorial (there are enough of those) but instead by offering insight only a seasoned developer can provide. Michael offers a unique perspective on building solutions based on his experiences — the good, the bad and the ugly — which combined gave way to his methods that promote a different approach to development, emphasizing form followed by function and always putting the user experience first. This book is an excellent addition to any developer’s library of resources. With chapters on: • Finding a Starting Point • Reworking Somebody Else’s Design • Reworking Your Own Design • WYS is not always WYG • Using Tab Panels • Using Conditional Formatting • Understanding and Using Variables • The Power of Virtual List • Scripting • Tips & Tricks and much, much more Includes dozens of interface examples from some of the best interface designers in the FileMaker® community, hundreds of screenshots and pages of useful resources to help you on your journey. Written by Michael Rocharde, a full time professional FileMaker® developer since 1987, FileMaker & Me is an ebook written to challenge and inspire FileMaker developers from the absolute beginner to the most expert in the community. It was created for the iPad®, using iBooks Author and is only available from the iTunes® Store.
0 notes
filemakerinfo · 8 years ago
Text
FileMaker Devcon 2017 eBook | FileMaker, Inc., An Apple Subsidiary
See on Scoop.it - Filemaker Info
This ebook covers these topics:
Why does good UI matter?
Questions to ask
Soft skills for better UI
Hard skills for better UI
Tips and tricks
Click here to edit the content
0 notes
filemakerexperts · 22 days ago
Text
Listenansichten in FileMaker optimieren/ PHP und FileMaker
Listenansichten in FileMaker optimieren Nach einigen Jahren und vielen 1000 Datensätzen die neu ins FileMaker-System gekommen sind, war es soweit. Eine spürbare Verschlechterung der Performance beim Aufbau einer extrem komplexen Listenansicht. Diese Ansicht enthält sehr viele Sortierungen, diverse bedingte Formatierungen zum Ein und Ausblenden von Symbolen, Farbgebung etc. Wenn jetzt noch jemand per VPN auf die Datenbank zugreifen wollte, so konnte es einige Zeit dauern bis die Arbeitsfähigkeit hergestellt war. Dabei wurde die Struktur schon ohne Formeln entwickelt. Die schnellste und effektivste Lösung. Alles wird über ein WebViewer abgewickelt. Betritt der User das Listen-Layout wird ein Serverscript gestartet, sammelt alle FileMaker Daten und überträgt diese dann an ein PHP-Script. Bruchteile später, steht die Liste schon zum arbeiten bereit. Da die Liste nur mit Java-Script arbeitet, sind alle Aktionen sehr schnell. Die Daten werden mithilfe eines FileMaker-Skripts vorbereitet und mit Insert from URL an eine PHP-Datei auf dem Server geschickt. Der Request erfolgt als klassischer application/x-www-form-urlencoded-POST-Aufruf. Der Server nimmt die Daten entgegen, bereinigt sie, zerlegt ggf. Pipe-getrennte Listen, und speichert sie in einem assoziativen Array zur weiteren Verarbeitung.
<?php // Daten säubern function cleanData($value) { return trim($value); } // Pipe-Werte aufspalten (z. B. '4711|4712|4713') function processPipeSeparatedValues($value) { return array_map('trim', explode('|', $value)); } // POST-Verarbeitung starten if ($_SERVER['REQUEST_METHOD'] === 'POST') { $postData = array_map('cleanData', $_POST); // Weiterverarbeitung folgt... } ?>
Auf der FileMaker-Seite wird der Post so aufbereitet Das PHP-Skript erzeugt eine strukturierte HTML-Tabelle, die über CSS und JavaScript erweitert wird. Sticky-Header, Hover-Effekte, Icons, Kartenintegration, alles dabei. Dank JavaScript lassen sich die Einträge mit einem Klick sortieren. Nach PLZ, Straße oder Kategorie. Auch Gruppierungen sind möglich, z. B. nach Stadtvierteln oder Bezirken, die dynamisch über Google Maps Geocoding ermittelt werden.
function sortByPLZ() { const table = document.querySelector("table"); const tbody = table.querySelector("tbody"); const rows = Array.from(tbody.querySelectorAll("tr")); // Entferne alte Gruppenköpfe document.querySelectorAll(".plz-header").forEach(row => row.remove()); // Sortiere Zeilen nach PLZ (Spalte 12, also index 12) rows.sort((a, b) => { const plzA = a.cells[12].textContent.trim(); const plzB = b.cells[12].textContent.trim(); return plzA.localeCompare(plzB, "de", { numeric: true }); }); // Neue Gruppierung einfügen let currentPLZ = ""; rows.forEach(row => { const plz = row.cells[12].textContent.trim(); if (plz !== currentPLZ) { currentPLZ = plz; const headerRow = document.createElement("tr"); headerRow.className = "plz-header"; const headerCell = document.createElement("td"); headerCell.colSpan = row.cells.length; headerCell.textContent = "PLZ: " + plz; headerRow.appendChild(headerCell); tbody.appendChild(headerRow); } tbody.appendChild(row); }); }
In dieser Ansicht wird unter anderem die Entfernung zu den nächsten Standorten ermittelt. Nach erfolgter Sortierung ist es sehr schnell möglich Aufträge zu verketten bei minimierter Fahrzeit. In dieser Ansicht aber nur berechnet über die Haversinsche Formel. Aber es ist ein extrem schneller Anhaltspunkt um Aufträge in Gruppen zusammenzufassen. Besonders charmant: Das ganze geht auch über die Google Maps API. Die Ansicht dann über Google Maps. Über das InfoWindows-Fenster lassen sich unendlich viele Informationen einblenden. In meinem Fall kann aus dieser Perspektive schon die Tourenzusammenstellung erfolgen. Es wird die Arbeitszeit ermittelt und kenntlich gemacht. Eine implementierte Fahrzeiten-Anzeige hat sich für Berliner-Verhältnisse als Unsinnig herausgestellt. Zu viele Verkehrsänderungen, zu viel Stau, in diesem Fall bedarf es der Erfahrung von Mitarbeitern und Disponenten. Wichtig, ist natürlich auch die Sequentielle-Suche. Diese kann natürlich wie schon einmal berichtet, auch in normalen FileMaker-Listen, Anwendung finden. Eine klassische FileMaker angelehnte Suche fehlt natürlich auch nicht. Hier lassen sich verschieden Kriterien verbinden und ermöglichen eine flexible Suche, ähnlich der klassischen FileMaker-Suche. Das ich im Regelfall innerhalb von FileMaker immer Arbeitslayouts nutze, die im Hintergrund bei -30000 Pixel arbeiten, kann ich aus dem WebViewer heraus, alle FileMaker Script nutzen, die im Vorfeld genutzt wurden. Sie bekommen die Parameter in einer etwas anderen Form, meist als Liste. Somit ist der Aufwand auf der FileMaker-Seite überschaubar. Fehlerbehandlung und Fallbacks Natürlich kann nicht immer alles glattlaufen, etwa wenn der Server nicht erreichbar ist oder die Daten aus FileMaker unvollständig übertragen werden. Für diesen Fall habe ich einen einfachen Mechanismus eingebaut. Wenn keine oder fehlerhafte Daten ankommen, zeigt das Skript entweder eine Hinweisbox oder einen minimalen Fallback-Inhalt an. Dabei ist es wichtig, am Anfang der Datei gleich zu prüfen, ob zentrale POST-Werte gesetzt wurden. Gerade bei VPN-Nutzern oder instabilen Mobilverbindungen ist das hilfreich, der Nutzer bekommt sofort Rückmeldung, statt auf eine leere Seite zu starren.
if (!isset($_POST['touren']) || empty($_POST['touren'])) { die("<div class='error'>Keine Daten empfangen. Bitte erneut versuchen.</div>"); }
Unterschied zwischen FileMaker-Client und Server Eine kleine, aber entscheidende Stolperfalle hat mich bei diesem Projekt einige Nerven gekostet. Während der gesamte Aufbau der Liste über den FileMaker Pro Client reibungslos funktionierte, lief das gleiche Script nicht mehr, wenn es über ein Server-Script (FileMaker Server) angestoßen wurde. Die WebViewer-Seite blieb leer. Kein Fehler, kein Hinweis, einfach nichts. Nach längerer Analyse stellte sich heraus, die Anzahl und Verschachtelungen der DOM-Elemente war der Grund. Im Client lief das Rendering noch sauber durch, aber der FileMaker Server scheint bei der Generierung und Übergabe des WebViewers, speziell in Kombination mit „Insert from URL“ -> WebViewer -> HTML-Rendering, empfindlicher zu reagieren. Besonders bei vielen verschachtelten div-Containern, Tabellen-Inlays und Icon-Ebenen war Schluss. Die Lösung war eher pragmatisch als elegant, ich habe den DOM deutlich verschlankt, viele dekorative Elemente entfernt oder durch schlankere Varianten ersetzt. Statt
mit drei Ebenen für Rahmen, Schatten und Hover, verwende ich jetzt.
<tr class="hover"> <td>4711</td> <td>Berlin</td> <td>…</td> </tr>
Und auch bei Zusatzinfos im InfoWindow der Google Maps Ansicht wurde auf alles Überflüssige verzichtet. Das Resultat, die Darstellung läuft jetzt reibungslos auch bei serverseitiger Übergabe, ohne dass der WebViewer hängen bleibt oder gar leer bleibt. Was bleibt nach dieser Umstellung? Ganz klar, die WebViewer-Lösung ist ein echter Gamechanger für große, komplexe Listenansichten in FileMaker. Die Performance ist kaum vergleichbar mit der klassischen Layoutdarstellung, besonders dann, wenn Sortierungen, Gruppierungen und visuelle Hilfsmittel wie Karten gebraucht werden. Eine HTML-Tabelle mit JavaScript schlägt hier jedes FileMaker-Layout um Längen.
0 notes
fmprogurus · 8 years ago
Text
FileMaker to Amazon Database
FileMaker to Amazon Database
FileMaker to Amazon Database I’ve blogged for four and a half years now, and in the past two years I’ve seen an incredible increase in both the quantity and quality of blogging in the FileMaker world.  I’ve also noticed better posts, better writing, and posts on an incredible breadth of subjects – web connectivity, design, tips and tricks, exploiting new features in creative ways, and more (kudos…
View On WordPress
0 notes
joycelow-blog · 8 years ago
Text
FileMaker & Me - Michael Rocharde | Programming |532231582
FileMaker & Me Michael Rocharde Genre: Programming Price: $14.99 Publish Date: May 31, 2012 This new, interactive, multi-media text book takes a completely fresh, and thought provoking, approach to developing FileMaker solutions. Focussed on interface design, the author starts with the premise that function should follow form; which means you start with the interface and build from there. Critically acclaimed by some of the top FileMaker developers in the world, developers at all levels should find something in it for them. Geoff Ryle, co-founder of Excelisys had this to say: Among the plethora of FileMaker books that have been published, this book really stands out not specifically as a bible or tutorial (there are enough of those) but instead by offering insight only a seasoned developer can provide. Michael offers a unique perspective on building solutions based on his experiences — the good, the bad and the ugly — which combined gave way to his methods that promote a different approach to development, emphasizing form followed by function and always putting the user experience first. This book is an excellent addition to any developer’s library of resources. With chapters on: • Finding a Starting Point • Reworking Somebody Else’s Design • Reworking Your Own Design • WYS is not always WYG • Using Tab Panels • Using Conditional Formatting • Understanding and Using Variables • The Power of Virtual List • Scripting • Tips & Tricks and much, much more Includes dozens of interface examples from some of the best interface designers in the FileMaker® community, hundreds of screenshots and pages of useful resources to help you on your journey. Written by Michael Rocharde, a full time professional FileMaker® developer since 1987, FileMaker & Me is an ebook written to challenge and inspire FileMaker developers from the absolute beginner to the most expert in the community. It was created for the iPad®, using iBooks Author and is only available from the iTunes® Store.
0 notes
phylliscru-blog · 8 years ago
Text
FileMaker & Me - Michael Rocharde | Programming |532231582
FileMaker & Me Michael Rocharde Genre: Programming Price: $14.99 Publish Date: May 31, 2012 This new, interactive, multi-media text book takes a completely fresh, and thought provoking, approach to developing FileMaker solutions. Focussed on interface design, the author starts with the premise that function should follow form; which means you start with the interface and build from there. Critically acclaimed by some of the top FileMaker developers in the world, developers at all levels should find something in it for them. Geoff Ryle, co-founder of Excelisys had this to say: Among the plethora of FileMaker books that have been published, this book really stands out not specifically as a bible or tutorial (there are enough of those) but instead by offering insight only a seasoned developer can provide. Michael offers a unique perspective on building solutions based on his experiences — the good, the bad and the ugly — which combined gave way to his methods that promote a different approach to development, emphasizing form followed by function and always putting the user experience first. This book is an excellent addition to any developer’s library of resources. With chapters on: • Finding a Starting Point • Reworking Somebody Else’s Design • Reworking Your Own Design • WYS is not always WYG • Using Tab Panels • Using Conditional Formatting • Understanding and Using Variables • The Power of Virtual List • Scripting • Tips & Tricks and much, much more Includes dozens of interface examples from some of the best interface designers in the FileMaker® community, hundreds of screenshots and pages of useful resources to help you on your journey. Written by Michael Rocharde, a full time professional FileMaker® developer since 1987, FileMaker & Me is an ebook written to challenge and inspire FileMaker developers from the absolute beginner to the most expert in the community. It was created for the iPad®, using iBooks Author and is only available from the iTunes® Store.
0 notes
dawnlindse-blog · 8 years ago
Text
FileMaker & Me - Michael Rocharde | Programming |532231582
FileMaker & Me Michael Rocharde Genre: Programming Price: $14.99 Publish Date: May 31, 2012 This new, interactive, multi-media text book takes a completely fresh, and thought provoking, approach to developing FileMaker solutions. Focussed on interface design, the author starts with the premise that function should follow form; which means you start with the interface and build from there. Critically acclaimed by some of the top FileMaker developers in the world, developers at all levels should find something in it for them. Geoff Ryle, co-founder of Excelisys had this to say: Among the plethora of FileMaker books that have been published, this book really stands out not specifically as a bible or tutorial (there are enough of those) but instead by offering insight only a seasoned developer can provide. Michael offers a unique perspective on building solutions based on his experiences — the good, the bad and the ugly — which combined gave way to his methods that promote a different approach to development, emphasizing form followed by function and always putting the user experience first. This book is an excellent addition to any developer’s library of resources. With chapters on: • Finding a Starting Point • Reworking Somebody Else’s Design • Reworking Your Own Design • WYS is not always WYG • Using Tab Panels • Using Conditional Formatting • Understanding and Using Variables • The Power of Virtual List • Scripting • Tips & Tricks and much, much more Includes dozens of interface examples from some of the best interface designers in the FileMaker® community, hundreds of screenshots and pages of useful resources to help you on your journey. Written by Michael Rocharde, a full time professional FileMaker® developer since 1987, FileMaker & Me is an ebook written to challenge and inspire FileMaker developers from the absolute beginner to the most expert in the community. It was created for the iPad®, using iBooks Author and is only available from the iTunes® Store.
0 notes
filemakerexperts · 2 months ago
Text
Büro ist fertig...
Büro ist fertig... Nach drei Tagen Arbeit, das neue - alte Büro ist fertig
0 notes