Jump to content

Filemaker Export


 Share

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

Recommended Posts

  • Newbies

Hi there, 

 

We have been working on Filemaker for many years now and will be transferring all the information to a new platform. We have information that is very important that appear in more than one tab but we are seeking to export the information from these tabs onto one excel document. This would be instead of exporting from one tab and then exporting the next tab and trying to take the information from one excel to the other, we would like to be able to export the information all into one document. This would save us a lot of trouble as we do have 2700 lines of data. There are two tabs, one that contains contact details etc for donors and the second tab contains all the information for each donation provided by the donors from the first tab. The information is indeed all linked in a certain way. 

 

Do you think there is a way to do this or do we evidently have to combine all the information from each tab ourselves? 

 

Thank you in advance for any helpful answer to this query!

 

Link to comment
Share on other sites

It largely depends on the structure of your database, FileMaker is a relational database and depending on how it was architected yo may have to "flatten" out the data set in order to make it moderately useful via excel exports. 

your database may contain a 'join' table that links donors and contacts or other data, it may only contain parent & foreign keys that make the business logic work.

you need to look at the base schema how many tables you solution contains and export each table in to an excel file then you can bring all tables in to excel as separate tabs.

 

Link to comment
Share on other sites

This topic is 525 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.