| K101 |
| Advanced Member |
|
|
|
|
| None Specified |
|
| Friday, February 27, 2009 |
| Friday, July 16, 2021 9:56:31 AM |
439
[2.47% of all post / 0.10 posts per day] |
|
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
|
Is the parameter set as repeating in the web service call settings? See "Defining Web Service Parameters" on this page.
Technical Support
Altova GmbH
|
XMLSpy supports DTDs which are XML compliant.
Technical Support
Altova GmbH
|
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
|
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
|
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
|
|
