Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!

Problem import XML

Document created by jsf503 on Nov 28, 2016

Version 1Show Document

Like • Show 0 Likes0
Comment • 17
View in full screen mode

I try import XML to FM adv. v15

My xml is :

<ide>

<cUF>35</cUF> 
<cNF>03006952</cNF>
<natOp>Industrializacao</natOp>
<indPag>0</indPag>
<mod>55</mod>
<serie>1</serie>
<nNF>9756</nNF>
<dhEmi>2016-09-26T15:13:00-03:00</dhEmi>
<dhSaiEnt>2016-09-26T15:13:00-03:00</dhSaiEnt>
<tpNF>1</tpNF>
<idDest>1</idDest>
<cMunFG>3550308</cMunFG>
<tpImp>1</tpImp>
<tpEmis>1</tpEmis>
<cDV>9</cDV>
<tpAmb>1</tpAmb>
<finNFe>1</finNFe>
<indFinal>0</indFinal>
<indPres>9</indPres>
<procEmi>0</procEmi>
<verProc>PrjEstNFe 4.00.080</verProc>

</ide>

........

</infNFe>

</NFe>

</nfeProc>

My simple XSLT for Test is:

<?xml version='1.0' encoding='UTF-8'?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">

</METADATA>

<ROW>

<COL>

</ROW>

</RESULTSET>

</FMPXMLRESULT>

</xsl:template>

</xsl:stylesheet>

well .. i import and..

1 - import dont error

2 - FM indicate one record imported

3 - FM create a new record

4 - record is Empty... bffffffffff

where is the problem in my xslt ?

help me please ...

PD My English is very bad sorry

Joan

From Brazil

Attachments

Outcomes

17 Comments

fmpdude Nov 28, 2016 4:02 AM
I would try a dedicated XML tool to make sure your XML is OK first.

I like Oxygen XML, but there are cheaper tools available.

HOPE THIS HELPS.
Like • Show 0 Likes0
Actions
beverly Nov 28, 2016 5:05 AM
1. it may or may not be valid XML (you don't post the entire document)
2. there is a namespace in the source XML (http://www.portalfiscal.inf.br/nfe), which needs to be handled in the XSLT

beverly
Like • Show 0 Likes0
Actions
jsf503 @ beverly on Nov 28, 2016 5:40 AM
well.. i check xml and result ok
my xml
https://drive.google.com/open?id=0B_jELu2GsF-NWmVLaWNWRmxIZlU
Like • Show 0 Likes0
Actions
fmpdude @ jsf503 on Nov 28, 2016 6:40 AM
Isn't checking your XML what I already recommended?

XML Validator
Like • Show 0 Likes0
Actions
jsf503 @ fmpdude on Nov 28, 2016 7:43 AM
yes i check and result is ok
this xml is send by Brazilian Internal Revenue Services , and i check xml validator, XML Editor/Viewer Online - xmlGrid.net
This xml is import aviable in Acces,Delphi,Foxpro, etc....
Like • Show 0 Likes0
Actions
fmpdude @ jsf503 on Nov 29, 2016 3:22 AM
beverly is the resident expert here using XML in FileMaker. However, speaking for myself, it's difficult to reproduce an exact issue like this that you are having without being able to test the actual FileMaker solution.

A couple items:

I saw this posting about XML on the FM site:

FileMaker Software Deployment, Business Software Solution - FileMaker

----

Therefore if you're using XML to communicate data back and forth (and not just import), perhaps, as the link above suggests, JDBC might be a better solution?

If you can't import your XML, and you're sure it's correct, then perhaps FM support can help you.

HOPE THIS HELPS.
Like • Show 0 Likes0
Actions
beverly @ fmpdude on Nov 29, 2016 5:27 AM
thanks fmpdude
here is what I meant by using the NAMESPACE in the XSLT to make it works (unverified, as I cannot get to the raw source in the links above):

<?xml version='1.0' encoding='UTF-8' ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:nfe="http://www.portalfiscal.inf.br/nfe"
exclude-result-prefixes="nfe">
<xsl:template match="/">
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
       <METADATA>
            <FIELD NAME="cNF" TYPE="TEXT"/>
       </METADATA>
       <RESULTSET>
            <ROW>
                 <COL>
                      <DATA><xsl:value-of select="//nfe:cNF[1]"/></DATA>
                      
             </ROW>
</RESULTSET>
</FMPXMLRESULT>
</xsl:template>
</xsl:stylesheet>
the _stylesheet_ element defines the namespace and it is used anywhere the elements or attributes are called (such as the cNF, becomes nfe:cNF). because you don't need the namespace inside FM, it's also excluded from the final process. but it must be addressed if any namespaces occur in the source XML.
XML Namespaces

a good example for importing (to get you some or all of the way there) is this XSLT:
Universal XSLT für den Import beliebiger XML Daten | DJT Organisationsberatung

beverly
1 person found this helpful
Like • Show 0 Likes0
Actions
jsf503 @ beverly on Dec 3, 2016 5:05 AM
I got it, thank you very much and Sorry for responding so late.
Well... The problem is me... I need to study more XSLT

I am very grateful

Joan
Like • Show 0 Likes0
Actions
fmpdude @ jsf503 on Dec 3, 2016 6:36 AM
If you use a good XML Tool, the XSLT "tool tips" are sometimes available and, at the very least, checked by it. These tools make XML/XSLT a lot easier.

XML tools tend to be expensive, but I never balk at the price.
Like • Show 0 Likes0
Actions
dune54 @ beverly on May 12, 2017 10:47 AM
Hi,
I'm a newbie in xml.
I try to import an xml file to FileMaker.
I find this example :
Universal XSLT für den Import beliebiger XML Daten | DJT Organisationsberatung
But i don't understand how it works :
- i obtain something like Node1/Node2...in every records
- Every field is in a different record
---> 2 records in the xml file BUT 1512 Records in FM ! ! !
What i do modify in the xslt example ?
Thank you for your help.
Dominic
Like • Show 0 Likes0
Actions
beverly @ dune54 on May 12, 2017 11:05 AM
That is a very good example and does tell you the paths to the values your may need to extract from the XML.

From there, you must create your own XSLT to "map" the elements and/or attributes to the fields that would be in FileMaker. The Grammar required for import is
FMPXMLRESULT
- https://www.filemaker.com/help/14/fmp/en/html/import_export.18.29.html
this may also help:
- http://bluefeathergroup.com/blog/importing-xml-data-into-filemaker-using-xslt-xsl-style-sheets/
beverly
1 person found this helpful
Like • Show 0 Likes0
Actions
dune54 @ beverly on May 13, 2017 1:44 AM
Many thanks for the explanation and the links.
I'd already a xslt but the xml is very complex and try to learn more about xslt while understanding what a file (Universal.xslt) does.
But what the utility of all the paths and the value in FileMaker ?
How to map these directly to my own XLST ?
I don't understand the interest of such file : i've the xml file so i've the paths of the elements/attributes.
Dominic
Like • Show 0 Likes0
Actions
beverly @ dune54 on May 13, 2017 2:10 AM
knowing the paths is what helps "map" your fields in the XSLT you have created. It cannot be directly used with your XSLT, but many fail to understand the XPATH.
Did you understand the article from Blue Feather? There are other posts on this forum (and elsewhere that may also help).

some good tutorials:
- https://www.w3schools.com/xml/xpath_intro.asp
- https://www.w3schools.com/xml/xsl_intro.asp
beverly
Like • Show 0 Likes0
Actions
dune54 @ beverly on May 23, 2017 1:42 AM
Thanks for the tutorials.
i’ve now 2 problems :
1° How can i select one item : <artist main = 0><name>Beverly</name></artist><artist main = 1><name>Dominic</name></artist>
I want name for only main=1
2° For an album, i’ve N tracks with name, code, label…for each track.
how import the track one in fields track1, the track two in field track2…on FileMaker ?
Dominic
Like • Show 0 Likes0
Actions
nicolai @ dune54 on May 23, 2017 3:00 AM
to select an artist node with an attribute main=1 use xpath expression:

//artist[@main = '1']
Substitute "//" with your full path

To import XML use "Import Records" script step, in the "Specify data source" select XML and link to your xslt.
After this you should be able to map your incoming xml nodes to the filemaker fields in a standard import records dialogue bix.
1 person found this helpful
Like • Show 1 Like1
Actions
beverly @ dune54 on May 23, 2017 4:26 AM
This is XPath notation and nicolai is correct. The [...] allows you to be specific on any given element (or attribute). The "@" is shortcut for attribute. So basically, you are looking for the element 'artist' whose attribute 'main' has the value of '1'. There are other places to study XPath, in addition to the link I provided above.
Beverly
1 person found this helpful
Like • Show 0 Likes0
Actions
dune54 @ nicolai on May 23, 2017 10:25 AM
Fine Nicolai
nicolai a écrit:

to select an artist node with an attribute main=1 use xpath expression:

//artist[@main = '1']
Substitute "//" with your full path

To import XML use "Import Records" script step, in the "Specify data source" select XML and link to your xslt.
After this you should be able to map your incoming xml nodes to the filemaker fields in a standard import records dialogue bix.

Many thanks.
Dominic
Like • Show 0 Likes0
Actions

Incoming Links

Re: problem import xlm x xslt

Problem import XML

Attachments

Outcomes

Related Content

Recommended Content

Incoming Links