Stack Overflow
Stack Overflow

Questions tagged [filemaker]

FileMaker is a cross-platform (OS X and Windows) database development environment.

FileMaker is a cross-platform (OS X and Windows) database development environment targeted at both novices and professional developers, with deployment for desktop, mobile and web applications.

1303 questions
4
votes
2 answers

Force Hikari/Hibernate to close stale (leaked?) connections

I'm working with a FileMaker 16 datasource through the official JDBC driver in Spring Boot 2 with Hibernate 5.3 and Hikari 2.7. The FileMaker server performance is poor, a SQL query execution time can reach a minute for big tables. Sometimes it…
super.t
  • 2,526
  • 7
  • 32
  • 51
4
votes
4 answers

How to speed up MySQL INSERTs/UPDATEs?

I have three large MySQL tables. They are approaching 2 million records. Two of the tables are InnoDB and are currently around 500 MB in size. The other table is MyISAM and is about 2.5 GB. We run an import script from FileMaker to insert and…
Matt McCormick
  • 13,041
  • 22
  • 75
  • 83
4
votes
2 answers

Connect R to Filemaker Pro 15 on Mac

I'm trying to create a connection between R (3.3.3) Using RStudio (1.0.143) and Filemaker Pro Advanced 15 (15.0.3.305). I'm trying to create the connection using RODBC (1.3-15). So far I: Created a toy FM Pro database for testing User id:…
Brad Cannell
  • 3,020
  • 2
  • 23
  • 39
4
votes
1 answer

connect to FileMaker Server with pyodbc

I have a FileMaker db running on FileMaker Server 14 on a Mac Mini and I'm trying to get at it with pyodbc. It's not going well. First, what works: telnet 192.169.19.3 2399 ssh Name@192.169.19.3 tsql -H FM-Server -p 2399 -U Name -P pwd One weird…
brnco
  • 83
  • 6
4
votes
2 answers

How does Alpha Five Version 10 Rate for Web App Development

I came across this RDMS via the advert on stackoverflow. Seems to be in the vein of MS Access / Filemaker / Apex database development tools but focused on web based applications. It quotes rave reviews from EWeek and a favourable mention from Dr…
user183402
4
votes
1 answer

Filemaker script - XML Import

I have XML files to import into Filemaker and I managed to create the XSLT file that works with Filemaker. I also have written a script that imports these XML files into my database. However, I can only get it to import with a "matching names"…
Donald Rossi
  • 43
  • 3
4
votes
1 answer

filemaker xml export via xslt

I'm trying to export some data from our Filemaker Database and transform it via XSLT I have got most of the way but am getting stuck at some nested data: Current structure of the XML output is:
Alex Hellier
  • 435
  • 1
  • 7
  • 15
4
votes
1 answer

How to retrieve content from a website inside a FileMaker Web Viewer

I need to build a website which will be viewed inside a FileMaker Pro 11 Web Viewer. The URL will be initially set by FileMaker. After which the user may change the content of the page, generating new data. The idea is to retrieve the new data back…
CrazyTim
  • 6,695
  • 6
  • 34
  • 55
3
votes
2 answers

Boolean for whether a string contains a substring

Suppose I have a text variable $$string. How can I write a boolean to check whether $$string contains the text $$substring? e.g. if $$string is "foobar" and $$substring is "oo", then the result should be True, and if the $$string is "foo" and…
Andy Hayden
  • 359,921
  • 101
  • 625
  • 535
3
votes
4 answers

Filemaker: Script which calls PHP code

How can I write a script which calls my PHP code? This script should contain records which are in Filemaker Database.
Prasad007
  • 103
  • 3
  • 7
3
votes
1 answer

Splitting text in FileMaker

This may be a pretty easy question but I'm having some trouble with it. I have some information in a text field that logs a UserID in the form of firstname.lastname . What I need for reporting purposes is to split that data into 2 new fields…
wchsTech4
  • 33
  • 4
3
votes
2 answers

FileMaker - ODBC/JBDC Connection - What Dialect of SQL

I set up DB Visualizer as a JDBC client for FileMaker Pro 10 Server and it's working but I'm not sure what SQL syntax to use. For example select * from Holidays limit 10 yielded a parse error. Does anyone know the specific syntax? Or at least a…
Greg
  • 45,306
  • 89
  • 231
  • 297
3
votes
1 answer

Work with FileMaker Pro FP7 Files

Is it possible to work with FP7 file using the FileMaker ODBC driver without actually needing to have FileMaker installed? I can't seem to get it to work unless I have FileMaker open, with the database file opened. I periodically need to export an…
Devin Goble
  • 2,639
  • 4
  • 30
  • 44
3
votes
1 answer

FileMaker Pro - Sum of the specific record in the portal

I have a Portal that shows related records from GJ (General Journal). It has two fields inside the portal. First field is DebitTitle, the records that are being save in this field are "Cash in Bank" and "Inventory". Second field is Debit, the…
N.Omugs
  • 321
  • 4
  • 17
3
votes
1 answer

How to filter in dropdown lists in filemaker pro 15

I've been searching a lot for this. I do not want a drill down filter where I start with 1 dropdownand narrow down in the other based on one choice. No, I want to filter on 1 specific database field. An example: I have 1 table Companies. In that…
Zadder
  • 75
  • 1
  • 6
1
2
3
…
86 87