Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


8 posts

Wannabe Geek


Topic # 31876 2-Apr-2009 16:22
Send private message

writing a script to export a filemaker record to an excel template so that at a click of a button in filemaker it will bring up an excel template with the selected data in the write places on the template then can be saved individually.

is this possible?

not sure how to go about it, cannot just go save as excel as this just saves the data. need each field to be exported to a certain place on a excel template.

Cheers,
Will

Create new topic
2 posts

Wannabe Geek


  Reply # 210438 29-Apr-2009 10:23
Send private message

Not too sure about filemaker as I have never used it before (I assume it is a database type product?) and have no idea of its scripting capabilities.

A couple of thoughts come to mind however.

1:  Save to CSV and then use a data source in the excel template for populating the data
2:  Create an Excel file on the fly using XML, you can have a look at the XML format for Excel XML spreadsheet documents by saving an excel document as an XML Spreadsheet (2003 format).  If you arent doing repeating rows it would just be a case of entering some identifiable text in each cell in the excel document before saving it and then doing a string replace.

Hmm, just noticed the date on the post (guess I havent had enough coffee this morning yet!), so I suppose you probably found a solution to this already.

Cheers,

Neil.

Create new topic

Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.