Jump to content
Sign in to follow this  
jknapp

Exporting XML using FMPDSORESULT- losing records in the export

Recommended Posts

I am using Filemaker Pro to export XML to produce listings in InDesign for information submitted by various organizations. My listings database is linked to another database in the following manner:

The listings for each month are in one database, and the usual suspects who submit the listings are in another Contacts type database. The listings DB pulls information from the related Contacts DB based on a key field to cut down on data entry, and puts it into portal fields. It pulls the id number from this related database, and stores that as well for each record. (I use this as a link to related record button --a quick way for our data entry folks to look up the related record.) The listings database also fills in a few lookup fields based on the key field as I've found that it is easier to use lookup fields when exporting the xml. (shorter name paths, less confusing structure when importing to other programs).

[color:green]The problem I am having: When I import the FMPDSORESULT xml into InDesign, only the first record for a listing at a specific place shows up. It seems that in the exported xml file, only the FIRST listing at this place is exported. Each additional record from that location is ignored. I have a hunch that this is because of the related records, I think I technically (yet inadvertently) created one to many relationships between the two databases based on the key field and the contact id number field. If that is the case, would the problem I am having be solved by simplifying the relationship to a one to one?

[color:green]My question: Does anyone have experience with this, and would I be able to solve the problem by creating a join table, and linking the two tables to the join table via a join id number instead? In this way, the id numbers for all records would be discreet, though the name field would obviously have the same data. So, will this work, and will my use of a join table really create a one to one relationship?

Thanks for any help you might be able to give.

Share this post


Link to post
Share on other sites

I'm fairly familiar with XML, but I think this is really not an XML problem.

Would you confirm the tables that you have and from which one you're exporting?

Listings

Contacts

Locations?

What are the relationships?

Share this post


Link to post
Share on other sites

Thanks for your response. another forum member, bruce wilson let me know that it was probably related to the sort. So, when exporting the xml, I had to unclick the group by options in the export fields dialog box.

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  

×

Important Information

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