[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Structure of data in Filemaker

Posted on 2004-04-23
5
Medium Priority
?
356 Views
Last Modified: 2010-04-27
Hi!

Since Im new to Filemaker I would like to have an explanation how its data is stored and suggestion how to export it most efficiently. I hope I can make myself understood even though I use "Access vocabulary" :-)

I connect to a FM DB with a lot of information placed in different tables, and some fields use lookup and calculation functions.

When I try to fetch data from Filemaker, it seems to hang some times and I guess its because of the lookup and calculation functions. I try again and again and after some tries it works.

I only need raw data from some of the tables, not those calculations. Can I make FM to skip calculations when I get the data? I have tried to select only my preferred fields, but it doesnt seem to work.

Thankful for any clues / suggestions!

Btw, the FM database is not developed by me as you probably understood already.

I have experimented with both ODBC (Asp) and Datavations FM Connect.
0
Comment
Question by:vb_jonas
  • 2
3 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 10909587
Fm as ODBC server is very slow.
non stored calculated fields are not calculated unless you display/print/request for them, so this is not the reason for the base to be slow normally. How big is the base(s)? over 100000 lines? If you have any doubt about this, duplicate the FM base to have a backup, and delete caculated fields to make a test.
In any case, it would be faster if you would use FM to write into the access base using ODBC.
0
 
LVL 12

Author Comment

by:vb_jonas
ID: 10916894
Ok, thanks!

Not 100 000 lines, no, but 10 000. But the datastructure seems to be pretty complex. Perhaps I force FM to give me the calculated fields.

Hmm... Slow ODBC, yes, but when I use Datavations FM Connect, it uses Web Share, not ODBC, but it seems to be as slow as ODBC. Why?

How about using FM to write into Access? What do I need to make that work (automatically every evening)? FM Developer? Do you have some good link with a sample?

Regards
Jonas
0
 
LVL 28

Accepted Solution

by:
lesouef earned 1400 total points
ID: 11008854
The web share if not really faster than Filemaker in ODBC server mode...
To write from FM to Access, you need to write a script in FM to do the proper SQL commands and close the app, set this script to be executed at FM startup in doc prefs, and then use the windows schedule service to start FM every evening.
I have no good link as an exmaple but I can post an almost similar solution I am currently using to read from mySQL at every startup; you could use a similar method to write to any ODBC server.
interested? let me know as I need a bit of work to send a dummy copy of it, it contains company info which I cannot release to you.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses
Course of the Month10 days, 22 hours left to enroll

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question