2 posts in this topic
By Joost Miltenburg
We recently migrated from FM14 to FM15 and suddenly some invoices come out strange after the saveAsPdf script step . ( see pic ). When in preview mode everything seems to be ok and is printed to a printer ok.
Theme : Classic, Font used : Calibri size 11 and 12.
Problem occurs on Mac 10.11 and Win10 with FM15.
When I do a print ( to preview ( mac )) and then save as pdf everything is also ok, so it seems to be related to the FM pdf renderer.
However, not every invoice has this issue, but I wonder how data could cause this behaviour.
Best regards !
I have FileMaker 11 and I created a interface to pull data from my website's sql. I am able to change the name of a product, but I cannot change the price of the mysql table through the FM 11 interface. Is there something I miss doing? I am using odbc to connect. Thanks.
We've just installed Sage 200; from Sage 50.
So, now we have an SQL platform database to run our company on, moving up!
We use FM and FMS to add function and output. Sage 200 will take over some of this; but we have Shipping and Inspection systems we've built that need to read data from Sage.
The DSN has been setup and is working. The usr and pwd work. I can add a table to my FM database schema, go and select the data source and place/add a table. But there is no data inside any of the tables; and there should be.
Anybody got any tips for me?
By Roger Tuan
This is about a Filemaker Server <--> MySQL sync setup.
I have two fields, serialNumber and writeBackNumber, and an altogether separate primaryKey that isn't used for this part.
If I create a new record on Filemaker, everything is fine. the serialNumber is auto-incremented on record creation and synced successfully.
However, If I create a new record in MySQL, I can leave both serialNumber and writeBackNumber blank, but when the sync happens, Filemaker does not auto-increment the serial number and put it in the field. It looks like it's just skipping the auto-enter part altogether and leaving serialNumber blank. This seems like what's going on:
Create new record in MySQL. serialNumber and writeBackNumber are blank. Click sync, 1 record gets synced to Filemaker. Record appears in Filemaker with both fields blank. Click sync, that record gets erased from MySQL but is still in Filemaker. Is this a bug?
Do I need to edit the MirrorSync customization script to perform the auto-enter on hub (Filemaker) pre-sync and then copy that over to the spoke (MySQL) post-sync?