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: ejohann
About
User Name: ejohann
Forum Rank: Advanced Member
Real Name: Eric
Location cinti, Ohio
Occupation:
Interests:
Gender: None Specified
Statistics
Joined: Monday, November 2, 2009
Last Visit: Monday, July 20, 2015 7:02:05 PM
Number of Posts: 38
[0.21% of all post / 0.01 posts per day]
Avatar
Last 10 Posts
Topic: Are there any ACORD or DTCC Libraries?
Posted: Thursday, July 16, 2015 8:58:54 PM
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?
Topic: Adding Comments to MapForce
Posted: Tuesday, August 28, 2012 1:29:39 PM
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'.


Topic: null characters in text file
Posted: Tuesday, August 28, 2012 11:42:28 AM
"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:
Topic: Deploy visual studio
Posted: Monday, August 27, 2012 8:00:39 PM
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.


Topic: null characters in text file
Posted: Monday, August 27, 2012 7:41:53 PM
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)
Topic: SQL order by, rownum?
Posted: Monday, February 27, 2012 4:53:21 PM
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.
Topic: More about Nil vs missing
Posted: Tuesday, January 10, 2012 4:22:01 PM
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?

Topic: More about Nil vs missing
Posted: Friday, January 6, 2012 5:34:12 PM
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?
Topic: are support DLLs portable?
Posted: Thursday, November 3, 2011 7:26:47 PM
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
Topic: are support DLLs portable?
Posted: Thursday, November 3, 2011 12:20:35 PM
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?

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