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: Friday, August 7, 2020 12:10:25 PM
Number of Posts: 395
[2.25% of all post / 0.09 posts per day]
Avatar
Last 10 Posts
Topic: setting soap content-type
Posted: Friday, August 7, 2020 9:37:03 AM
What content-type is MapForce sending now? Which WSDL version (1.1 or 2.0) are you using? Which SOAP version is the request (1.1 or 1.2)? Can you attach the WSDL?

Technical Support
Altova GmbH
Topic: CSV to XML
Posted: Friday, August 7, 2020 9:30:04 AM
You need to use grouping, an intermediate variable, and duplicate the E1EDL24 item in the variable.

Technical Support
Altova GmbH
Topic: XSD export to Postgresql
Posted: Thursday, August 6, 2020 7:26:04 AM
Regarding the conversion of xsd:string to bit, that appears to be a genuine problem. I recommend you report this directly to Altova Support.

Regarding the relationship, note that XMLSpy will create relationships between the tables when the schema has relationships defined in the form of identity constraints (see “Creating DB tables with relationships”). So, first add these to your schema, then try converting again.

Technical Support
Altova GmbH
Topic: Splitting Excel files containing random number of rows into groups of 30 rows each.
Posted: Tuesday, July 21, 2020 11:18:33 AM
Because your input component is processing multiple files (*.csv), but you have nothing coming out of that input component's File item, you're grouping all the rows from all the input files.

If you want, per input file to create one or more output files, you have to connect the File item from the input component to the output component's File item one way or another.

Technical Support
Altova GmbH
Topic: XML Importing Xportin to SQL
Posted: Tuesday, July 21, 2020 8:20:07 AM
Well, that's a lot of ground to cover.

2800 "fields": if your XML structure is simply a repeating element with 2800 fields (attribute or element), then it's fairly straightforward to convert it to a database table. You will likely run into limitations of the number of columns a table can have. Normally, SQL Server has a hard limit of 1,024 columns, but there are apparently ways to work around that.

You can use XMLSpy to convert your XML schema to a database structure, but you will likely need to edit it further using DatabaseSpy to actually work with SQL Server for at least this reason.

If your schema is more complex than can be simply represented in a single table's row/column structure, XMLSpy may need to generate multiple, related tables to represent the structure.

XMLSpy can export your XML data files directly to a database, but this is intended more as a one-time operation, rather than something you can automate. For that, you're better off using MapForce to create a mapping between your XML schema (representing your XML data files) and the database structure you converted your schema to using XMLSpy.

The mapping will be set up to process all *.xml files (for example) in your input folder.

For more complete automation, you'll need to use MapForce Server to run your mapping from the command line or via API.

More complex workflow automation requirements (scheduling, triggering, etc.) may necessitate the use of FlowForce Server.

Technical Support
Altova GmbH
Topic: Export to Web API
Posted: Thursday, July 2, 2020 9:49:58 AM
You can certainly create a mapping from CSV to a web service call, if that's what you mean.

Technical Support
Altova GmbH
Topic: Dark Theme
Posted: Wednesday, June 10, 2020 2:10:09 PM
This is something for future consideration.

Technical Support
Altova GmbH
Topic: https-Connection between Spy and Raptor
Posted: Wednesday, June 10, 2020 2:09:24 PM
It appears that XMLSpy presently supports only regular WebSocket ws connections to RaptorXML Server, rather than WebSocket Secure wss connections, so this will have to be taken under future consideration.

Technical Support
Altova GmbH
Topic: AS2 Listener - PKCS7 signature verification failed.
Posted: Friday, June 5, 2020 7:32:06 AM
There are some known issues involving incoming messages from Unix-based systems with LF line endings. Some fixes were included in v2020r2, and more are coming in Service Pack 1 for that version.

I recommend you contact Altova Support directly with more details about your particular case for more definitive information.

Technical Support
Altova GmbH
Topic: last page of a chapter in the table of contents
Posted: Tuesday, May 26, 2020 12:16:55 PM
What's your target output format? PDF? In that case it seems to me it might be possible using the page-number-citation-last element, but I can't get that to work with Apache FOP even by crafting raw FO.

Technical Support
Altova GmbH

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