K101 |
Advanced Member |
|
|
|
|
None Specified |
|
Friday, February 27, 2009 |
Wednesday, April 24, 2024 9:45:34 AM |
565 [3.12% of all post / 0.10 posts per day] |
|
Yes, that's certainly possible. While the typical use case for Excel is to write to a defined range of columns (e.g., something like "Product ID" in column A, then "Description" in column B, etc.), one can also write them dynamically so that each occurrence of an element writes to the next column. The two column modes are described in the documentation as "Show separate items for columns" and "Show a single Cells item for all columns"
The attached example demonstrates this and also demonstrates even writing to worksheets dynamically. Each foo element denotes a new worksheet, and each bar element a new column.
Technical Support Altova GmbH
|
They're described in the MapForce documentation:
Quote:When you work with multiple mapping files simultaneously, you might want to display information, warning, or error messages in individual tabs for each mapping. In this case, click the numbered tabs available on the left side of the Messages window before validating the mapping.
Technical Support Altova GmbH
|
Set the type of that column to 'date' or 'dateTime' as appropriate. MapForce will automatically interpret the date as demonstrated by the attached example.
Technical Support Altova GmbH
|
Almost certainly. In general, the concept of processing multiple input or output files is described in the documentation.
You should probably just contact Altova Support directly and provide them with actual examples.
Technical Support Altova GmbH
|
The PDF Extractor's a very new part of MapForce. You're really better off contacting Altova Support directly for help with that.
Regarding a library, Altova's doesn't offer MapForce as a library, but you can generate program code based on some mappings (not those which use the PDF Extractor, I'm afraid) or use MapForce Server for automation since it offers API access via .NET, COM, and Java (and does support the PDF Extractor).
Technical Support Altova GmbH
|
nixfont wrote:Thanks for the explanation, your examples made it clearer to me what to do. I made it work, the only difference with your version is that mine only worked after putting the input of the tokenize through a .txt file as passthrough. No idea why, otherwise it would not work and be NULL
Sounds good. I'm pretty sure Altova Support could help you figure out how to do it without the pass-through, though.
Technical Support Altova GmbH
|
The tokenize function will definitely work in that scenario, as will the use of substring-before and substring-after as demonstrated by the attached example. The output is the same in both cases:
Obviously, in your case the input isn't exactly what you think it is. You should probably contact Altova Support directly with your actual input file for help.
Technical Support Altova GmbH
|
You should contact Altova Support directly for this sort of help.
Technical Support Altova GmbH
|
The simplest way is simply to use read-binary-file to get a URL from a constant (or wherever else), then send that straight to write-binary-file to save it to some location on your local filesystem. This example saves the logo from Altova's own web site in this way.
If your call's any more complicated you'll need to use the proper REST request functionality.
Technical Support Altova GmbH
|
Please contact Altova Support directly in this case as I previously advised.
Technical Support Altova GmbH
|
|