11 posts in this topic
Import XLSX to Child Table
By John Kostenbader
It has been covered here but I really can't find a sufficient answer. When I do an automated import of an xlsx file that has no blank lines at the top into a portal that is part of a child relationship I keep getting blank lines. I've confirmed that there are no blank rows in the excel spreadsheet. For the particular import I'm talking about i get one blank line at the top (portal is not sorted in any way). I also get two blank lines at the bottom. I can almost understand the blank lines at the bottom (how does FM know when to stop?) but I cannot wrap my head around why I have one at the beginning
I'm using a web viewer to display a html webpage that allows the user to interact with it via java scripts. The web page works on a Mac running FM13 and FM14 with Mac OS X 10.10 and 10.11. When I try to view the web page in a web viewer on Windows 7 running with IE11 installed, the webpage doesn't allow any interaction with the java scripts, and the web page renders incorrectly. I'm running FM13 and FM14 in Windows 7, and they both render the webpage incorrectly.
When I copy the HTML out of FileMaker and paste it into a file and open it directly in IE11, I get a security warning on the bottom of the window that says "Internet Explorer restricted this webpage from running scripts or ActiveX controls", when I click Allow, the page renders correctly. If the Allow button is not clicked, the page would render exactly like it does FileMaker's web viewer. So it looks like FileMaker is suppressing this popup and just showing the web page with the scripts disabled.
I checked Internet Options in IE and all relevant scripting options are enabled, but every time I try to display the page in IE directly, I get the security warning. So I'm assuming if I can get the page to display in IE without the prompt I can get the page to display in FIleMaker. What options need to get set to allow the scripts to run? Why does it work on Mac OS X and not Windows 7?
Container Fields and Printing
In our database solution we have a table that holds other documents relating to the data. The enduser might insert a PDF or a JPG. So the table is made up of a container field, a job number (unique identifier). To view the file the user clicks in the container (script exports field contents and automatically opens).
The thing we would like to do is when printing a job report if there are any "external documents", would like them to print as well. We want it be be part of the complete report. The container is setup for interactive content and start playback automatically. The script exports the container and imports it back in... on the Mac it produces the correct results, on the PC it prints as a pdf icon for example. Maybe what I want is not possible. Any suggestions.
FileMaker 14 as data source to MS Access
I have a client that would like to use MS Access to connect to a table in a solution hosted on FMS 14.0.3. What I'm reading suggests that was possible with .fmp5 and .fmp7 but is no longer available in .fm12. I've tried to use Access and both (mac) Excel and (windows) Excel to connect via ODBC to the FMS hosted table and I can construct the query and see the fields, but when I submit the request I get an error. Is it still possible to connect Excel or Access to FileMaker 14.0.3 (hosted)? The error I get appears on the attached screenshot.
Is anyone currently doing this?
Thank you in advance.