| K101 |
| Advanced Member |
|
|
|
|
| None Specified |
|
| Friday, February 27, 2009 |
| Thursday, January 23, 2020 2:09:48 PM |
373
[2.14% of all post / 0.09 posts per day] |
|
I rather suspect it's the ITEM element which occurs 91 times within your SERIE. So, you most likely need to connect ITEM to your database "pol" (or "pel"? It's a little hard to read) root element. You can still filter that based on SERIE_NO=2.
If you still need more help beyond that, you should probably either attach your files here, or send them to Altova Support in case they're not appropriate for public disclosure.
Technical Support
Altova GmbH
|
Based on those screenshots MapForce is doing exactly what you've asked it to do which is insert one row based on the SERIE element with SERIE_NO=2.
You write that you want 91 inserts. Which XML element in your input file occurs 91 times?
Technical Support
Altova GmbH
|
It looks to me as though your separator pattern is " [0-9]{2}", that is with two leading spaces, which doesn't occur once you reach 100. Perhaps your pattern should instead be " {1,2}[0-9]{2,3}".
Technical Support
Altova GmbH
|
You can try using a regular filter with input parameters. If you must use MapForce's parameterized SELECT statement functionality, then you can also consider using MapForce Server, which you can call via Java API.
Technical Support
Altova GmbH
|
It's not presently possible.
Technical Support
Altova GmbH
|
XMLSpy doesn't presently support validating against inline schemas, but it'll be taken under consideration for the future.
Technical Support
Altova GmbH
|
It appears you me your output sample doesn't contain the same data as your input sample, but perhaps the attached example.mfd will help you understand how to use group-by.
Technical Support
Altova GmbH
|
See this topic.
Technical Support
Altova GmbH
|
Generally speaking, LicenseServer needs to be able to contact altova.com at any time. You shouldn't try to schedule any sort of intermittent network connectivity.
Technical Support
Altova GmbH
|
Hard to know exactly what you all need as output, but have a look at this demonstration, which tries to parse the file into consignments, then records grouped into type, subtype, and sub-subtype. The primary purposes is to parse structure into hierarchies.
At each level, we also write all the rows which are in that group, so you might see a row on both the type and subtype level (and the sub-subtype level as well, for that matter). You might be able to work further with this demonstration to get the exact results you want.
Technical Support
Altova GmbH
|
|
