Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Need help In using Xslt in Eliminating Duplicates in Xml import

tapfumat
in XML/XSL

Featured Replies

  • Newbies

I am exporting child  records together with their parents to an Xml file from filemaker whilst i am sitting on the child records.MY problem now is when i want to import them into another database i want to import the parents separately and the children separately the parents are now coming in duplicates.So i need help in elimanating the duplicate parent records when importing into the secondary database.

 

Any help would be appreciated please

Need two imports, with a XSLT for each of them. One would loop the parent nodes, and the second would then loop the child nodes beneath them.

 

Also make sure the XML includes an ID that links them together.

  • Author
  • Newbies

Thanks hey...i m a beginner though.Dont you have sample code for looping the parent nodes

Got some sample data?

 

Been a while since I did a two level import, but the principles aren't too difficult...

  • Author
  • Newbies

The xml file is too long so i had to cut it...The fields i want to re import into filemaker are the first two .I am looking for stylesheets to now delete the duplicates.

 

 

<?xml version="1.0" encoding="UTF-8" ?>
- <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
  <ERRORCODE>0</ERRORCODE>
  <PRODUCT BUILD="06-11-2010" NAME="FileMaker" VERSION="ProAdvanced 11.0v2" />
  <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="SYSTEM Transaction Items" NAME="Tribac v1_0.fp7" RECORDS="471" TIMEFORMAT="k:mm:ss" />
- <METADATA>
  <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Account Master::Account ID" TYPE="TEXT" />
  <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Account Master::Account Name" TYPE="TEXT" />
  <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Transaction Master::Date" TYPE="DATE" />
  <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Transaction Master::Human Reference Number" TYPE="TEXT" />
  <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Transaction Master::Description" TYPE="TEXT" />
  <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Transaction Master::System Transaction Type" TYPE="TEXT" />
  <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Season Schemes for TI::Season Scheme Name" TYPE="TEXT" />
  <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Quantity Reference" TYPE="NUMBER" />
  <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Units Calc" TYPE="TEXT" />
  </METADATA>
- <RESULTSET FOUND="471">
- <ROW MODID="180" RECORDID="1233">
- <COL>
  <DATA>MUS001</DATA>
  </COL>
- <COL>
  <DATA>Musunje, Albert</DATA>
  </COL>
- <COL>
  <DATA>25/1/2011</DATA>
  </COL>
- <COL>
  <DATA>CD000001</DATA>
  </COL>
- <COL>
  <DATA>Test Drawdown 1</DATA>
  </COL>
- <COL>
  <DATA>CASH DRAWDOWN</DATA>
  </COL>
- <COL>
  <DATA>TOBACCO INPUTS, 2011-12</DATA>
  </COL>
- <COL>
  <DATA>41600</DATA>
  </COL>
- <COL>
  <DATA>USD</DATA>
  </COL>
  </ROW>
- <ROW MODID="174" RECORDID="1234">
- <COL>
  <DATA>MUS001</DATA>
  </COL>
- <COL>
  <DATA>Musunje, Albert</DATA>
  </COL>
- <COL>
  <DATA>25/2/2011</DATA>
  </COL>
- <COL>
  <DATA>CD000002</DATA>
  </COL>
- <COL>
  <DATA>Test Drawdown 2</DATA>
  </COL>
- <COL>
  <DATA>CASH DRAWDOWN</DATA>
  </COL>
- <COL>
  <DATA>TOBACCO INPUTS, 2011-12</DATA>
  </COL>
- <COL>
  <DATA>40000</DATA>
  </COL>
- <COL>
  <DATA>USD</DATA>
  </COL>
  </ROW>
- <ROW MODID="174" RECORDID="1235">
- <COL>
  <DATA>MUS001</DATA>
  </COL>
- <COL>
  <DATA>Musunje, Albert</DATA>
  </COL>
- <COL>
  <DATA>25/03/2011</DATA>
  </COL>
- <COL>
  <DATA>CD000003</DATA>
  </COL>
- <COL>
  <DATA>Test Drawdown 3</DATA>
  </COL>
- <COL>
  <DATA>CASH DRAWDOWN</DATA>
  </COL>
- <COL>
  <DATA>TOBACCO INPUTS, 2011-12</DATA>
  </COL>
- <COL>
  <DATA>40000</DATA>
  </COL>
- <COL>
  <DATA>USD</DATA>
  </COL>
  </ROW>
- <ROW MODID="174" RECORDID="1236">
- <COL>
  <DATA>MUS001</DATA>
  </COL>
- <COL>
  <DATA>Musunje, Albert</DATA>
  </COL>
- <COL>
  <DATA>25/4/2011</DATA>
  </COL>
- <COL>
  <DATA>CD000004</DATA>
  </COL>
- <COL>
  <DATA>Test Drawdown 4</DATA>
  </COL>
- <COL>
  <DATA>CASH DRAWDOWN</DATA>
  </COL>
- <COL>
  <DATA>TOBACCO INPUTS, 2011-12</DATA>
  </COL>
- <COL>
  <DATA>40000</DATA>
  </COL>
- <COL>
  <DATA>USD</DATA>
  </COL>
  </ROW>
- <ROW MODID="174" RECORDID="1237">
- <COL>
  <DATA>MUS001</DATA>
  </COL>
- <COL>
  <DATA>Musunje, Albert</DATA>
  </COL>
- <COL>
  <DATA>25/5/2011</DATA>
  </COL>
- <COL>
  <DATA>CD000005</DATA>
  </COL>
- <COL>
  <DATA>Test Drawdown 5</DATA>
  </COL>
- <COL>
  <DATA>CASH DRAWDOWN</DATA>
  </COL>
- <COL>
  <DATA>TOBACCO INPUTS, 2011-12</DATA>
  </COL>
- <COL>
  <DATA>40000</DATA>
  </COL>
- <COL>
  <DATA>USD</DATA>
  </COL>
  </ROW>
- <ROW MODID="175" RECORDID="1238">
- <COL>
  <DATA>MUS001</DATA>
  </COL>
- <COL>
  <DATA>Musunje, Albert</DATA>
  </COL>
- <COL>
  <DATA>25/6/2011</DATA>
  </COL>
- <COL>
  <DATA>RP00000002</DATA>
  </COL>
- <COL>
  <DATA>Test Repayment 1</DATA>
  </COL>
- <COL>
  <DATA>STOP ORDER</DATA>
  </COL>
- <COL>
  <DATA>TOBACCO INPUTS, 2011-12</DATA>
  </COL>
- <COL>
  <DATA>30000</DATA>
  </COL>
- <COL>
  <DATA>USD</DATA>
  </COL>
  </ROW>

That *is* a FileMaker XML file - it should just be able to import it, and match field names appropriately.

 

You can then deal with duplicates in FileMaker

Create an account or sign in to comment

https://fmforums.com/topic/88380-need-help-in-using-xslt-in-eliminating-duplicates-in-xml-import/
Go to topic listing

Similar Content

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.