Jump to content

Switching from Excel to Google Sheets as source


sethgodin
 Share

This topic is 2385 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Thanks for taking a look at this.

I use an Excel spreadsheet as a safe data import device for the database I use to help my wife run her bakery.

Basically, non-tech folks can fill in the spreadsheet with costs and other data.

Then FM12 runs a script to delete its current data and pull in the accurate new data from Excel. A different script then turns that data into formatted reports that can be used to re-order items and calculate prices.

It works! Go figure.

Now, we want to switch to having the spreadsheet live in Google Docs. I see that OBDC can handle that. It seems like I might need to buy something like this:

http://www.rssbus.com/kb/articles/odbc-gsheets-filemaker-pro.rst

Here's the key question: can someone point me to instructions on how to change the script below so that it'll work? I'm guess there are three magic buttons I have to push, but I'm a better writer than programmer.

Appreciate the help. Here's the script:

https://www.dropbox.com/s/7t5ptbhnh2b0rye/Screenshot%202015-12-17%2012.17.10.jpg?dl=0

 

 

Edited by sethgodin
typo
Link to comment
Share on other sites

Hi Seth,

In your screenshot, you are still referencing the excel spreadsheet to import from. I think you want to import from the ODBC datasource instead. Where you "Specify data source" you can change it from "File" to "ODBC Data source" instead. That should allow you to follow along with the referenced article.

Thanks
Mike

 

Link to comment
Share on other sites

  • Newbies

Thanks Mike. You're correct, I haven't changed a thing, because I didn't want to just guess at formatting.

It seems, though, that there are SQL and DSN things, some of which aren't cross platform, that all have to be done properly.

Mostly fear on my part. I will hack my way through.

Thanks!

Link to comment
Share on other sites

This topic is 2385 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.