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: wriley
About
User Name: wriley
Forum Rank: Member
Real Name:
Location Plymouth, Michigan
Occupation: Data Integration Architecht
Interests:
Gender: None Specified
Statistics
Joined: Wednesday, February 3, 2016
Last Visit: Tuesday, June 8, 2021 3:12:09 PM
Number of Posts: 10
[0.06% of all post / 0.01 posts per day]
Avatar
Last 10 Posts
Topic: Result doesn't pass for error/success handling
Posted: Tuesday, May 18, 2021 1:22:17 PM
You should be able to get the output of the Error Handling step by declaring a variable (for lack of a better word), in the 'Assign this step's result to field.

This screenshot shows an example of it.

Hope this helps

Topic: FTP move
Posted: Wednesday, May 5, 2021 2:43:03 PM
If you are on FlowForce 2021 you can use the system/ftp/retrieve-wildcard feature for this.

Not sure if you can move directly inside the FTP though, you may need to move the file local and then upload to the desired directory on the FTP.

Topic: oAuth 2.0
Posted: Friday, February 26, 2021 8:40:49 PM
I am just curious if anyone has experience with the oAuth2 credential feature of FlowForce Server Advanced.

I am using it to access an Azure application and I can get the initial set of tokens at the credential level without any issues.

I can then run the flowforce job to retrieve the data desired from Azure.

But, once the authorization token expires, the flowforce job fails with a 401 not authorized error even though there is a refresh token in the credential that should allow the server to get a new token to run the job with.

So, if anyone has had the same issue and has been able to solve please share.

For the record, Altova Support has been fantastic at working with me to try and correct this but so far we have not sorted out the issue.

Thank you,
W.Riley
Topic: Dual input CSV (hdr / det) to flat structure
Posted: Thursday, February 25, 2021 7:23:30 PM
Julian,

You may want to try this with the Join Component, it may lend itself to this well.

It is covered pretty well in the help file, and for a quick review here is a link to a screen shot to part of the help section about it.

https://www.screencast.com/t/AnMQqK296WM0

No guarantee it is the path forward but worth a look I think.



Topic: Flowforce on AWS
Posted: Thursday, February 25, 2021 7:11:38 PM
This may not be directly applicable, but we have our server deployed in Azure on a VM with the appropriate cores to match our licensing and have had no issues.

Again AWS may be totally different.

For support I typically just go through the link form their website https://www.altova.com/support/supportform

Hope any of this was useful.
Topic: Left Join functionality for CSV files in Join Component
Posted: Tuesday, December 29, 2020 2:05:42 PM
You may have already seen this, but if you are running the latest version of MapForce Enterprise addition, that has been updated to support SQL left outer join. Not sure if that is exactly fits your ask as I am not much of an SQL expert.
Topic: realtime (webservices) project
Posted: Tuesday, November 10, 2020 7:52:23 PM
Can you share your schema and XML file used by the mapping?
Topic: Looking for date or datetime functions
Posted: Friday, February 7, 2020 7:18:02 PM
I had the same problem, in order to make re-usable one I simply created a date/time job in MapForce that formats the date from the NOW function how I want it to look. I deployed that to FlowForce and created a job that runs just after midnight to cache the datestamp. Then I just use that cached output wherever I need it. Hope this helps.
Topic: Base64 encode
Posted: Friday, August 18, 2017 5:44:41 PM
I am hoping I am just missing this somehow, but I do not see any method in MapForce to convert a string to a base64 UTF8. Can this be done in MapForce?

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