7 posts in this topic
Is there any reason that my chart will only display up to a certain number of records? I'm trying to plot GPS tracks and I have 21,000 records that represent 8 surveys. When plotting only found sets by survey, the chart still seems to only display up to a certain number of records. When I export the records into Excel and plot, all records get plotted without a problem. I'm using Filemaker Pro 13 Advanced on a Windows machine.
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