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
User Name: K101
Forum Rank: Advanced Member
Real Name:
Gender: None Specified
Joined: Friday, February 27, 2009
Last Visit: Friday, July 16, 2021 9:56:31 AM
Number of Posts: 439
[2.47% of all post / 0.10 posts per day]
Last 10 Posts
Topic: XML to Excel- variable number of columns
Posted: Monday, June 28, 2021 12:13:32 PM
You have to switch the column mode. As that described, you can show columns in two ways: "Show a single Cells item for all columns," or "Show separate items for columns". The latter mode is what gives you letter-named columns A, B, C, etc., and the former gives you "Column Name" and "Column Number." This is described in the documentation topic, "Selecting Ranges of Cells".

Technical Support
Altova GmbH
Topic: MapForce-Require to generate one API entry per container using Web service post method
Posted: Friday, June 11, 2021 9:31:04 AM
Is the parameter set as repeating in the web service call settings? See "Defining Web Service Parameters" on this page.

Technical Support
Altova GmbH
Topic: SGML DTD to XSD
Posted: Wednesday, June 2, 2021 9:26:38 AM
XMLSpy supports DTDs which are XML compliant.

Technical Support
Altova GmbH
Topic: Result doesn't pass for error/success handling
Posted: Thursday, May 20, 2021 8:51:34 AM
It's by design. Per the documentation, "one cannot refer to the result of a step that's within a protected block, from the exception handler…It doesn't matter if the exception handler is On Success, On Error or Always."

Technical Support
Altova GmbH
Topic: Project code - Validate XML
Posted: Monday, May 10, 2021 3:34:05 PM
The generated code doesn't include any XML validation functionality. The intention is that you use the validation provided by the underlying platform such as MSXML (C++), System.XML (C#), or JAXP (Java).

Technical Support
Altova GmbH
Topic: Regex replace command syntax
Posted: Tuesday, April 6, 2021 9:49:35 AM
Any particular reason you want to do everything in regex? How about this example?

Technical Support
Altova GmbH
Topic: switch destination database
Posted: Wednesday, March 10, 2021 10:29:28 AM
All you have to do is drag the root connection from the old Access table to the SQL Server one (that is, from Access' schema-less "example" in the attached screenshot to SQL Server's "dbo.example"). MapForce will prompt you to decide if you want also to move descendant connections as shown in the screenshot. Click "Include Descendant Connections" and MapForce will move them all in one go. This is described in the documentation under, Moving Connections and Child Connections.

Technical Support
Altova GmbH
Topic: Grouping
Posted: Tuesday, March 2, 2021 7:52:35 AM
That's a tricky one. Rather than mapping directly from Excel to what you need as final output, I would suggest you first try mapping to some sort of record/lines structure, where each date constitutes a record, and then each row constitutes lines in those records. Maybe XML would be the best choice, or FlexText. In any event, the idea is first to get past the idea of working with groups of four columns.

Once you have that, then it should be much easier to group the lines by key as necessary.

If you get stuck, feel free to attach your files here.

Or, try Altova's Product Consulting service. I'm sure they can create the mapping for you.

Technical Support
Altova GmbH
Topic: Access data from IMAP Server
Posted: Thursday, February 18, 2021 12:06:55 PM
It doesn't. Some relevant questions come to mind.

Do you need actually to connect to the e-mail server to retrieve the message? If so, via what protocol? POP? IMAP? Exchange?

Is the message a standard RFC 822-style message with the Excel file as a MIME attachment?

Technical Support
Altova GmbH
Topic: Multiline CSV row
Posted: Tuesday, February 16, 2021 10:54:21 AM
Could you attach an example file?

Technical Support
Altova GmbH

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