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, May 7, 2021 8:13:33 AM
Number of Posts: 434
[2.45% of all post / 0.10 posts per day]
Avatar
Last 10 Posts
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
Topic: DiffDogCmdClient timeout
Posted: Wednesday, February 3, 2021 3:05:11 PM
DiffDogCmdClient talks to a running instance of DiffDog Server. Do you have the service running? Is it running on the same machine as the client?

Perhaps it would be better to ask Altova Support for help here.

Technical Support
Altova GmbH
Topic: Excel to XML help
Posted: Monday, January 4, 2021 2:57:55 PM
That's possible to solve by applying several things in MapForce as demonstrated by the attached example and in the screenshot.

First, we need a variable to hold the rows grouped by ID. Since we can't use Excel structures for variables, we create an analogous FLF structure in MapForce's bundled FlexText utility.

Then, we need to use a source-driven connection to drive the creation of the groups of Item/Amount pairs in your output. The source-driven connection is the dotted line you can see in the screenshot. Without this, you'd get the two Items, then the two Amounts.

The item-at() function is used to limit the number of Name elements per group to only one (otherwise there would be two Name elements in the first VOUCHER).

Technical Support
Altova GmbH
Topic: Dynamic page headers
Posted: Friday, December 11, 2020 2:08:21 PM
It seems to work just fine for me using StyleVision Version 2021. In XSLT 1.0 mode, the attached PDF is produced from the also-attached design file. Which version of StyleVision are you using? Perhaps it's best to contact Altova Support directly for this one.

Technical Support
Altova GmbH
Topic: FlowServer parameter as a space
Posted: Friday, December 11, 2020 12:00:12 PM
That seems to be a bug to me.

A workaround is to declare a 'space' parameter for the job and reference that in the step parameter, since the job parameter's Default field accepts spaces.

Technical Support
Altova GmbH
Topic: Splitt Street
Posted: Wednesday, December 9, 2020 11:31:13 AM
Your example data doesn't really make sense at first glance. I suggest you attach actual example input and output files to your original post, perhaps along with whatever attempt you've made so far in MapForce.

Technical Support
Altova GmbH

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