| K101 |
| Advanced Member |
|
|
|
|
| None Specified |
|
| Friday, February 27, 2009 |
| Tuesday, June 24, 2025 11:02:03 AM |
588
[3.23% of all post / 0.10 posts per day] |
|
You're using regular XQuery 3.1 mode, not XQuery Update Facility. Click one of the XQU toolbar icons to switch modes.
Note that this is not really a support forum. You would be better off sending such questions directly to Altova Support.
Technical Support
Altova GmbH
|
Yes, simply bind a key to the command using the Customize dialog’s Keyboard tab.
Technical Support
Altova GmbH
|
Sounds like you need format-date.
Technical Support
Altova GmbH
|
Indeed, the replace function accepts only string arguments, not patterns. Try using tokenize-regexp in conjunction with string-join, and use a pattern of /\P{IsBasicLatin}+/ from the block escapes as demonstrated by the attached example.
Technical Support
Altova GmbH
|
When it comes to performance a database will probably perform best, even if it's just SQLite.
Have you tested your Excel-to-XML mapping using MapForce Server Advanced Edition? There are circumstances under which it executes mappings much more quickly than regular MapForce.
What's the data source for the Excel file data? Could it already be coming from a database? If so, why not map directly from that database to XML?
Even if you create the XML file another way, you can still create the Excel file purely for visualization. For that purpose, however, you could potentially use Authentic or even MobileTogether.
Technical Support
Altova GmbH
|
So you're generating the Excel file as well?
Is there a particular reason you chose Excel?
Frankly, that does not sound like the ideal choice to store the sort of data you describe.
Technical Support
Altova GmbH
|
"server123" and "server123.ourcompanyname.com" aren't two separate HTTP services in this case. The hostnames are resolving to the same IP address. The host name isn't considered until after the HTTP connection is established, and the TLS session is being negotiated. FlowForce Server can't reject the HTTP connection due to conditions which only the TLS session negotiation will reveal.
What behavior would you consider superior to the existing certificate error? Why would it be an improvement?
Can you simply configure your certificate to support both hostname variants?
Technical Support
Altova GmbH
|
My reply appears inadvertently to have edited your original post.
Quote:number(translate($XML/Decision/@Element,',','.'))
That looks fine, but where's the test for inequality with zero? Try:
Quote:number(translate(@Element, ',', '.')) != 0
See also the attached example.
Technical Support
Altova GmbH
|
RobPastoor wrote:Does this also mean that there is no option in MapForce to check a mapping for efficiency?
By this I mean an option to check whether a mapping can be improved, so that it can be executed faster.
There's no general check for "efficiency", no. The focus is on creating the output your mapping design specifies, in the most efficient way possible.
Technical Support
Altova GmbH
|
Quote:According to Microsoft Copilot, in Altova MapForce, there should be an option under the 'View' menu to turn on the 'Execution Log'.
Microsoft Copilot would appear to be mistaken. The actual available View menu items are described in the documentation.
Quote:Or is there another way to check my mapping for efficiency?
There's no general check for "efficiency", no. The focus is on creating the output your mapping design specifies, in the most efficient way possible.
Technical Support
Altova GmbH
|
|
