| ejohann |
| Advanced Member |
| Eric |
| cinti, Ohio |
|
|
| None Specified |
|
| Monday, November 2, 2009 |
| Monday, July 20, 2015 7:02:05 PM |
38
[0.21% of all post / 0.01 posts per day] |
|
|
I'm looking at doing some transformations from ACORD or DTCC standard transaction documents. ACORD has schemas available, has anyone seen any for DTCC messages?
|
These are all good suggestions and ideas. I'd like to suggest some sort of foreground/background feature on the mapping canvas display .
There can get to be just too many lines and function objects visible at once in the canvas, even with UDFs as suggested.
One thing that might help is to make lines and functions that are not 'active' (like parts of input or output trees that are not expanded) minimize or go into the background to make the active elements easier to see and work with.
Functions in the background might shrink into small icons on the line, then render fully when any the connected lines become 'active'.
|
"Treat empty fields as absent" is already unchecked. In the context of a CSV file, what would be considered "empty" ?
here is a fragment of the file:
|
You can generate code (in C#) and the result will be a ready to compile VS project. Just compile and deploy.
However, you might want to wait, and use the output tab in Mapforce to validate your output a few times before committing it to code. The testing cycle gets really long if you have to adjust the mapping, generate code, compile code, then deploy code too many times.
|
I have text CSV files which contain NULL (\0) characters.
The records break into fields as expected, but I'm unable to remove the NULLs from the fields.
right-trim considere them non-whitespace.
Attempts to use replace or translate fail because I can't seem to create a constant with a NULL string. char-from-code reports:
core.char-from-code with '0' and '0' produced a result that has no valid string representation.
Estimated type(s):positiveInteger.
Is there a function I'm missing, or an alternate way to create the needed string with a NULL in it? (backslash or hex data notations are not described in the docs)
|
|
Good News! The new release, v2012r2 release notes indicate you can now ORDER BY within the SQL-WHERE. Appears to be part of a Sorting feature blitz, with lots of additions.
|
Funny how one can get confused when being dismissive. There are many provided functions, and only 7 (3 new Nil-specific, and 4 database) document how they handle Nils and NULLs. The first sentence of the question indicates awareness of them. As you said, a simple search found them.
The question was how OTHER system core mapping functions do or don't process the new Nil. Do they ignore it, do they pass it somehow, or do they properly interpret a Nil in context when called?
|
I've been reading new information about the xsi:nil and substitute-missing features in the latest versions of Mapforce. The info I've seen covers what happens moving data among XML documents pretty well.
I'm reading XML, but but then doing some mapping, and updating a SQL database with the results. I'm looking for information of how (or if) system (or user) functions handle Nil or missing elements, and how the database support handles these conditions.
Is there any information about these cases yet?
|
Thanks. This is timely since I'm updating to the new 2012 version right now.
Are the DLLs backward-compatible (can I run code made with 2011 versions, using 2012 DLLs?)
Are there any 'best practices' about deploying multiple compiled Mapforce programs?
Eric
|
It seems like a simple question, but I've not seen it documented.
Are the support files (altova.dll, altovaDB.dll, AltovaFunctions.dll etc) generic and portable, or are they customized for each project?
|
|
