rautr |
Member |
|
|
|
|
None Specified |
|
Tuesday, March 6, 2018 |
Thursday, October 14, 2021 6:13:12 AM |
28 [0.15% of all post / 0.01 posts per day] |
|
Hi ,
How often License server is connecting to Altova.com to verify licences of mapforce and flowforce server? Just want to check if we need internet all the time to connect to altova.com?
Thanks.
|
Thank you. I am using Exists fuction now. Its working fine.
|
Hi All,
How can I check If the cvs file is empty in mapforce. I tried to check rowcount equals 0. But it's not working.
Thanks.
|
Hi All,
Please find attached sample mapping. I want to create sample2 file from sample1 sorted by rowNumber. Please help.
Thanks.
|
Hi All,
I am trying to call stored procedure for each row in file based on some certain conditions. Its calling The stored procedure twice per row. How can we implement this to call stored procedure only once. store that value and reuse it when needed instead of calling it twice. Please help.
|
Hi all,
Its working fine after selecting checkbox for nullable field as per beow link.
https://manual.altova.com/Mapforce/mapforceenterprise/index.html?mff_db_update_if_insert_rest.htm
Thanks
|
Hi All,
I want to insert a address record in database as new address if any of the address field like unit/street type is changed. otherwise I want to ignore that record.
I used ingnore if and insert rest. Its not working.
Please help
|
Hi All,
I am trying to insert records in sql database from a csv file. How can we get count of records which are failed while inserting in database because of some sql errors like Referential integrity failed.
Or How to add records which are failed to insert in database in file.
Please help.
|
Hi All,
Can we pass connection string parameter to sql server database mapping in mapforce. Is there something like we can create connection string parameter in flowforce server job and pass it to mapforce database mapping.
Thanks
|
Thank you island.
Update table set x=10,y=10 where :myamountParam >100 and actType in ('a','b')
In this query myamountParam value is coming from the file. and actType is in database table.
for myaccountParam , I can use solution suggested by you. But I want to update only those rows in db table which has got actType 'a' or 'b' .
Using database Table Actions in Mapforce, I can use ignore if.. . But it has only equal and equal(ign case).
in,like or greater than conditions are not there.
I am using parameterised SELECT_statement on the table now.
Just want to confirm if it can be achived by database Table Actions by ignoring rows in table with actType other than 'a' and 'b'
|
|