Sign in to follow this  
Followers 0
Papabjoe

Chart using Filemaker Pro

7 posts in this topic

Hello all.

I have a problem that may be a step backwards for most of you. Starting in Version 7, I was an active user and developed some almost sophisticated solutions. Over time, my needs for FM dropped and as a result, so has my expertise.

My new role in my job requires some charting that would typically be done in Excel. However, I am doing most of the data entry and reporting in filemaker 9.

I need to create bar charts and I need a quick way to accomplish this.

My current idea, without upgrading to 11, is to create the summary date I need, export it as an excel file with the command to launch the application once the export is complete.

From there I would manually select the data and create a chart.

Question?

Is there a more efficient way to do this in filemaker 9 for mac? I'm not able to purchase any additional software or plugins. Ideally, I'd like to script it so that it not only exports the data but launches excel, and creates the chart. The reason being is that others in my office, may have to perform this task, and they are less than literate in FM, or excel for that matter.

Thank you for your assistance.

Share this post


Link to post
Share on other sites

Truthfully, the best way to go about it is to upgrade to FM11. Or use a chart plug-in, like fusion charts.

I did, however, created an AppleScript some time ago that sent the data to Excel to chart it then got the chart stored as a picture in FileMaker. Too bad these things break with every OS and software update.

So, back to my original suggestion: upgrade your FM version. That are quite a few new things in 10 and 11 over 9; you'll appreciate them.

Share this post


Link to post
Share on other sites

Thanks, but my issue is that I'm entrenched in an excel only office. My superiors are skeptical filemaker is as neato as I keep telling them it is. Needless to say, authorization to purchase upgrades or plugins is not going to happen. If I can make this work and satisfy the requirement for charts, I can then illustrate how I had to bubble-gum and chicken-wire the solution together. While that may or may be enough to motivate the purchase of an upgrade, I still need the solution. Believe me, if I could buy it, I would.

I will look into fusion charts though. Thanx for the tip.

Share this post


Link to post
Share on other sites

I'm not able to purchase any additional software or plugins.

There are many ways to produce a chart in a web viewer - Google Chart Tools and FusionCharts for FileMaker being just the first two that come to mind.

---

FusionCharts for FileMaker is not really a plugin, and IIRC, it's free.

Edited by comment

Share this post


Link to post
Share on other sites

I agree that using Google Chart may be the way to go. You get much better control over formatting using google than the native FileMaker chart tool.

You can learn how to build a chart using an http call here;

http://code.google.com/apis/chart/image/docs/making_charts.html

put the http code, into a web viewer and that is it.

This week (!) google updated the chart tool, I am not sure if the wizard will help you but check this out too;

http://code.google.com/apis/chart/image/docs/chart_wizard.html

this looks like a great tool!

Jerry

Share this post


Link to post
Share on other sites

There are many ways to produce a chart in a web viewer - Google Chart Tools and FusionCharts for FileMaker being just the first two that come to mind.

---

FusionCharts for FileMaker is not really a plugin, and IIRC, it's free.

Jan 11, 2014.  FusionCharts 'free' is no longer available.

Share this post


Link to post
Share on other sites

I agree that using Google Chart may be the way to go. You get much better control over formatting using google than the native FileMaker chart tool.

You can learn how to build a chart using an http call here;

http://code.google.com/apis/chart/image/docs/making_charts.html

put the http code, into a web viewer and that is it.

This week (!) google updated the chart tool, I am not sure if the wizard will help you but check this out too;

http://code.google.com/apis/chart/image/docs/chart_wizard.html

this looks like a great tool!

Jerry

Jan 11, 2014

Chart Wizzard is removed.  Code Playground is not useful in telling me how to get Google Charts to recognized FM tables.

post-72145-0-09068400-1389494370_thumb.p

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • By slbr549
      I am using Excel 365 on desktop and FileMaker Pro Advanced 15 with FileMaker Server. 
      I am able to connect to FileMaker from Excel using ODBC to read all records in a table or matching it to a hard coded name. Sample:
      Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar"
      What I'd like to do is add a where clause where it selects hours worked based on the date in the Excel spreadsheet. The cell's date is B12 and so on.  I know my syntax is wrong, but after several attempts, I haven't been able to solve it. Here is my syntax:
      Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar" and date = TimeSHeet(Select * FROM[SHRA Temp Timesheet.Range("B12).Value])
      Thanks.
       
    • By TaiChi56
      I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script:
      Perform Find [Restore] Save Records as Excel["TotalAttendance.xls";Automatically open;Records being browsed] Go to Layout[original layout] Show All Records In the Perform Find [Restore] I have the following coded:
      Find Records PersonnelRecords::PercentDaysAttended:[<_ .70] That is suppose to be less than and equal to. Did not know how to show it with the keyboard.
    • By fm8443
      I have 4 Tables of Sales Records (1 per Store) for the same 1000 products (each sold in the 4 Stores).   Table1 (T1) has 30,000 records T2 has 50,000 records T3 has 10,000 records T4 has 10,000 records   The fields in the 4 Tables have different names and contain similar “core” content.   Tables are added to each month with additional records (imported into FM 14 Pro Advanced from Excel).   Unfortunately the same Products are named slightly differently in each of the 4 tables.  Each store / table has a (text) Product-ID but (for the same product) it is different per store. I do want to rectify this “naming problem” (perhaps in a Table #5?)  so I can produce a report showing sales for each of the 1000 products across all 4 stores (grouped by date etc.) I’m not sure how to structure/carry-out this in Filemaker most effectively.  Any ideas?   Ultimately, when the data is clean, I want to upload ALL the records (e.g. 100,000 records) in one export into one Excel spreadsheet so I can run a Pivot Table (Cross-Tab) report.   Do I need to combine the 4 Tables into 1 Master Table before doing an Export on the Master Table? If so, how would I do this?   Thanks for any ideas about this?
    • By Ziphius
      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.
      Thanks.
    • By Neil_Million
      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