7 posts in this topic
I've got multiple Filemake databases with 4m+ records each. I've created a layout which calculates a summary using a sort, Groups and Counts. This takes 10-15 seconds, which is OK.
However, when I try to export this summary report to Excel it appears that Filemaker has to recalculate all the Groups & Counts, but for some reason this takes several hours. The last report took over 4 hours.
I can't figure out how I can simply export or copy the summary report that Filemaker creates for the Layout?
Please can someone provide assistance because I have another 20 similar reports to do and this will take me days instead of hours
I recently imported records from an excel sheet into my filemaker solution. I just noticed that the dates in the excel sheet were entered in this format 1996-04-19
and as a result, all my date calculations are not working. For example, the Age and other functions. Manually changing the date to 4-19-1996 resolves it.
Is there a way i can do this without manually going to each record? because there are a lot of records to deal with..
Thanks for your anticipated response
I have a small problem before importing an Excel file in Filemaker
As I run a macro on Windows all goes well the work is done corectement to use the file to import into Filemaker
But on Mac that does not work I tried with several Excel and of course Windows Excel for Mac
I think this is the path for the error message, this is the way:
sPath = "C: \ input \"
I am trying to chart data using the session model file from Tom Geist, the chart on the file is supposed to display Sales from the current month, with respect to the status of the sales. (Closed and Open). However, the chart is not actually displaying correctly. I am trying to implement the session model on my database, but this issue of the chart not displaying the accurate data is posing a problem. From the records in the file, the sales have more Open sales than Closed ones, also the current sales for the month of february has no closed sales. .
Please can someone assist me .. thanks
Sorry if the title is a bit confusing, I wasn't sure how to explain it.
Basically I've got a layout that contains a portal to another table. abc0198_cpa_v002 and xyz0570_cpa_v0008 are the link to the other table (linked to the table by the first 6 characters)
the problem I have is when I export this I get the following in Excel. I was hoping that the empty fields beneath abc0198_cpa_v002 would be filled with abc0198_cpa_v002.
I can get it to work by going to the related table, searching for those records (abc0198 & xyz0570), but I will fall into the same problem when I receive multiple records that relate to the same record in the other table. IE I might receive abc0198_cpa_v002 and abc0198_cpa_v005 etc.
I hope this makes sense and thanks in advance for any help.