| K101 |
| Advanced Member |
|
|
|
|
| None Specified |
|
| Friday, February 27, 2009 |
| Friday, May 7, 2021 8:13:33 AM |
434
[2.45% of all post / 0.10 posts per day] |
|
Any particular reason you want to do everything in regex? How about this example?
Technical Support
Altova GmbH
|
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
|
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
|
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
|
Could you attach an example file?
Technical Support
Altova GmbH
|
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
|
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
|
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
|
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
|
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
|
|
