IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Profile: K101
About
User Name: K101
Forum Rank: Advanced Member
Real Name:
Location
Occupation:
Interests:
Gender: None Specified
Statistics
Joined: Friday, February 27, 2009
Last Visit: Thursday, January 23, 2020 2:09:48 PM
Number of Posts: 373
[2.14% of all post / 0.09 posts per day]
Avatar
Last 10 Posts
Topic: XML to MySQL conversion/mapping
Posted: Monday, January 20, 2020 10:43:30 AM
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
Topic: XML to MySQL conversion/mapping
Posted: Friday, January 17, 2020 7:38:05 AM
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
Topic: FlexiText Separator Pattern
Posted: Wednesday, January 15, 2020 3:02:34 PM
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
Topic: use query with parameter and java
Posted: Tuesday, January 14, 2020 8:47:46 AM
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
Topic: Error message window font
Posted: Monday, December 16, 2019 12:18:52 PM
It's not presently possible.

Technical Support
Altova GmbH
Topic: SQL Server generated inline xsd could not validate
Posted: Thursday, December 5, 2019 8:21:01 AM
XMLSpy doesn't presently support validating against inline schemas, but it'll be taken under consideration for the future.

Technical Support
Altova GmbH
Topic: mapping csv to nested XML
Posted: Monday, November 25, 2019 8:37:37 AM
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
Topic: Looking for date or datetime functions
Posted: Friday, November 22, 2019 9:32:40 AM
See this topic.

Technical Support
Altova GmbH
Topic: How often License server is connecting to Altova.com to verify licences
Posted: Tuesday, October 29, 2019 11:43:52 AM
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
Topic: Mapping FORTRAS BORD512 or similar flat file interfaces
Posted: Friday, October 18, 2019 8:26:54 AM
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

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.