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: pavants
About
User Name: pavants
Forum Rank: Member
Real Name:
Location Trieste
Occupation:
Interests:
Gender: None Specified
Statistics
Joined: Tuesday, June 4, 2019
Last Visit: Thursday, January 9, 2020 3:58:24 PM
Number of Posts: 13
[0.07% of all post / 0.01 posts per day]
Avatar
Last 10 Posts
Topic: use query with parameter and java
Posted: Thursday, January 9, 2020 3:39:32 PM
Hi all,
how can I filter the rows obtained from a query based on some parameters and produce java code ?
actually is not supported, is there a workaround ?

Thanks
Topic: Connectio string name
Posted: Friday, September 13, 2019 9:17:27 AM
Is there a way to change the connection string name ?

I see that when the code is generated some objects take the name of the connection string of the database so name could be very long for example when database host is on cloud



Topic: Date Formate
Posted: Thursday, September 12, 2019 1:25:13 PM
Hi, I Have the same problem, did you figure out how to resolve the problem ?
Topic: Date Conversion
Posted: Thursday, September 12, 2019 1:18:45 PM
Ok,
Sorted out the problem on transforming from string to date but now when I try to insert the data in MSSQL database the code generated is:

INSERT INTO [Mytable] ([Rcvd_DateTime]) VALUES (2019-09-12T15:44:47.007+02:00)

Testing it in _Sql management studio I have an error on T15:, which is the best way to write this type of data in the db ?
Topic: Date Conversion
Posted: Thursday, September 12, 2019 11:25:43 AM
found the problem, the column was declared as Date. Changed to String and parsed it as date.
Topic: Date Conversion
Posted: Thursday, September 12, 2019 9:25:18 AM
Hello All,
I have a csv file where a date is in this format: MM/DD/YYYY and I'm trying to insert it in a SQL Database to a column of datetime2 format.
to do that I use parseDate passing as format [M,2]/[D,2]/[Y,4] but I get Type Mismatch The value '06/01/2019' is not of type 'date'

I tryed also with formatDate (which receive a string) but the problem is the same.

Any idea?
Topic: Enable/Disable Job in list
Posted: Friday, August 9, 2019 12:01:36 PM
In FlowForce I think should be very useful to have in the configuration Job list a checkbox function to enable/disable the job without to enter in it and modify

Thanks.
Topic: FlowForce get system date
Posted: Friday, August 9, 2019 11:59:31 AM
my vote to have it.
Topic: Failed moving the file: Access is denied.
Posted: Wednesday, July 31, 2019 5:42:06 AM
I have a function that every 5 minutes polls a directory and if a file is present send files via as2.
After the process I want to move the file in another directory but when I call the move function the result is everytime "Failed moving the file: Access is denied."

I guess is the loop that keep the file locked so how can I move the file ?

thanks forum
Topic: as2 send, as2-success function
Posted: Friday, July 26, 2019 8:34:45 AM
Hello Forum,
I'm trying top manage the result of a AS2 send process, to acheive this I read the MDN returned by the partner and if successfull I want to move the file sent.

I created these steps:
system/as2/send > store mdn in result

system/compute, exp: as2-success(mdn) -> result to as2success variable

system/compute exp: as2-mdn-serialize-> -> result in string

system/flesystem/copy -> save the stram to file

Expression Choose When: as2success
true ->move file
otherwise -> send mail

All the process run smooth, I receive and save the MDN, if I open it say message successfully sent to partner and partner received the message.
But, the result of as2-success(mdn) is everytime false.
In the first step send I used also Abort on error and it not fails so transmission is correct.

What I'm doing wrong ?
Thanks

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