Jump to content

Marcwa19197

Members
  • Content Count

    16
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Marcwa19197

  • Rank
    member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi, we are using a little sync script via php, which allows us to store all data from a FileMaker DB into our internal MySQL-Database. The only problem iam unable to solve is how to download images from container fields and store them local on our web server. I tried something like: foreach($recordsPersons as $recordPersonsData) { //saving images to /srv/www/htdocs/ $url_orig = urlencode($recordPersonsData->getField('FotoDatei')); // Search for the extension of the file $url = substr($url_orig, 0, strpos($url_orig, "?"));
  2. yes I understand how to use ess and how to work with a table in fm. but image I have one column in both table (TableA-fm and TableA-mysql) called 'forename'. I place a Field object on a Layout, how can I say that the input of this forename-field should be written in both tables? if this is not possible I have to add two field objects.. one for every table. forename-mysql and forename-fm, so the data must be entered twice..
  3. i dont know if a field object can write into two different tables.. maybe i create an field for the mysql-table (TableA-mysql) and use a lookup-field in the Filemaker Table TableA-fm?
  4. Okay, i read about it. but is it possible to write in two tables with one field object? For example: Field "Name" writes Data in TableA-fm and TableA-mysql.
  5. Hi, i have a Filemaker Database with a TableA-fm. This Filemaker Database is hosted on an FMS14-Server, which is configured to use the MySQL-Odbc Driver to connect to an MySQL Server. The Mysql have the same Database and Table structure as the FM have. (TableA-mysql) now i want to do the following: Create a layout in FM on TableA-fm which let me enter Data (via Fields) to TableA-fm and simultaneously the same data to TableA-mysql on the MySQL Server. So i would like to have the same records of data in the FM-Table and the MySQL-Table. Any ideas how to do that automatically, or sync
  6. We want to use our own logging system. So is there any script snippet for doing the following: - Get current data of a field - Modify this data in the field - Save the old Data and the new (modified) data to a LogTable (Something Like: "PersonA's LastName was changed from "Marcwa19197" to "Marcwa" by "Username" on "Date") What i found is the GetField() function. So my idead would be: 1. Save the current data of a field with the GetField() function in a global variable (with the OnRecordLoad Trigger) 2. Modify the fielddata and save the changes 3. Check if there is a change betwe
  7. Now i understand, what you mean with the unique ID, because Persons to Employess is a one-to-one relation. Thank you for the hint with the fork, i didn't see that before. The best for our buisness would be to save all data historically. On the design side, there will be two "edit-modes", "Correction" and "Change". Correction: only for correcting mistakes, no audit logging needed here Change: for example the change of the LastName, every change in this "mode" should be logged. So are there any free "examples" for doing this? Or any "easy" way to do this in FM (maybe buildin functio
  8. Hi, thanks for the replies. here is my new database design. now i can track which Person has which childs, and if the child is of age i will set the "Aktiv" flag to 0. same for adress, if a Person have a new adress i will set the old one to "Aktiv" = 0 and enter the new adress with "Aktiv" = 1. for the jobs i have added an Start- and End Date. How can i track changes of Person names or changes in the Employees Table? For example: 1. Person gets married and change last name 2. Person is an employee and gets a new roomnumber How can i track the old name/roomnumb
  9. Yes, i know this fact. I was just a bit confused, of course i will have unique auto-increment IDs in every table. How do you think about the "history problem"?
  10. In my example, we need to track the childrens of persons until they get of age, so you are right anyway, i can simply add an Start- and EndDate to every table. My screenshot is a example with a few tables, the real database have much more we need to track history (Bankinfo, Address/Contactinfo, IT-Accounts, ...). Is this still the recommended/best way? yes, the relation between persons and employees is one-to-one. But there is a new "problem". If some person change his name, we need to track the old one. (so i think, i need an one-to-many relation here?) S
  11. Hi, im searching for a solution which will let me save the relationship history of records. I want to have something similar like a "snapshot" of every record if it gets modified. in my example i want so save which employee had which jobs and childs over time, so i can view the past history of a specific employee. What do you think will be the best solution for this problem? Thanks in advice.
  12. Okay, works perfect! Thanks for your help!
  13. yes, in case if both parents are employees and they have the same childs. so the childs must be associated to both employees.
  14. can you please share a screenshot of the relationships, just for understanding you correctly, thanks in advice!
  15. Hi, first of all, thanks for the fast reply. the problem we have is, that we would like to store all "basic data" (including Names, Birthdays, etc.) for every person in one table. So, of course your concept will work, but than we will have names stored in the Children table and in the Persons table (and later in many more tables, for example in the Sposes Table). a Person can be a Child, a Employee or a Spose. a employee can have many childs and one spose. we need to know which childs, or which spose is associated to which employee
×
×
  • Create New...

Important Information

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