Jump to content
Salesforce and other SMB Solutions are coming soon. ×

auto export


Dorato
 Share

Recommended Posts

Hi all, i was thinking of making a database.

 

The problem i have is this database needs to be accessed by an application which can read excel.

 

I can export the filemaker database to excel which is fine but the database gets updated regularly, is there a way of runing the script automaticly?

 

Also the people updating filemaker are using instant web publishing so they do not have the full version of FM.

 

We are runing Filemker pro 7, server and advanced server if that helps.

 

Thank you...

Link to comment
Share on other sites

A quick easy solution that I made was to create a script that overwrites the source file that excel is reading from.

 

In my case I have UPS reading addresses, as new orders come in, UPS need to have access to those new addresses, so I just exported a csv file everytime a user adds new orders.

 

You could find a point in your process when you might wish to update your source file.

 

also,

 

If your source fiel contains data is is being used at the moment, then you might want to update it using a SQL statement, instead of overwritting the whole file (which is easier)... But that just depends on what you are doing and what you consider is easier and more efficient.

 

also,

 

You could setup Filemaker as a datasource, there is a driver called Sequlink, but I don't recomend it, I've had problems with it before.

 

I have FM Server also but I haven't messed with it to tell you the thruth, I don't know if there is a way to autoschedule scripts. I don't think so.

 

If you would like to autoschedule a script you would have to dedicate a machine to do it and build a script that exports data, pauses then loops. But I don't like that, that sound kind of stupid.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use