I have a table with 3 columns and >100 rows, is there a faster way to add them to a Form in Extended ECM ?
If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.
What does this mean? What tools in extended ECM do you use or functionality. When you say Form is it backed by a table of some sort? and does it have a Form Template subtype?
just a form related to a form template used to capture data and store it in an SQL table
you can use a WebReport to populate the form from a source like a CSV etc.
Do you mean livereport? if so how can it be done?
you can use a WebReport to read the CSV / DB Table then use the SETFORM subtag in a loop to populate the form.
I created a webreport and set a csv file as data source and Form Report as a reportview file but the when I hit add then click on the webreport, I get 5 columns marked unknown column and with 100 rows with *invalid tag* , where can I use SETFORM and how to use it? (sorry for bothering with these questions)
This forum is not meant to be used to completely learn about the OT CS product and its varied uses. WR is a tool that is used to do many things Reports(based on data in tables or otherwise) as well as commonly done tasks (like entering form data as if a user pressed a button). It has very easy-to-follow examples using its tag guide and advanced help.
If You have a Form Template that has been created to store data in SQL(that itself has a myriad of possibilities) and you created a Form I would suggest you sit in the GUI and push the button and do ListData.You can also if it is sql write a LR that has select * from MyFormTable.The first 6 or eight rows are Livelinks specific and the dataid you see there should typically be the Form Dataid one sees.
OK now if you want to create a bulk utility that purportedly does this as @Greg Griffiths said one can do this in the ROW section of the WR
[LL_REPTAG_1 SETFORM:wonum /] [LL_REPTAG_2 SETFORM:description /] [LL_REPTAG_3 SETFORM:locdesc /] [LL_REPTAG_4 SETFORM:systemstatus /] [LL_REPTAG_5 SETFORM:userstatus /]
In the above snippet I would read that as when the WR executes take what came out of LL_REPTAG_1 perhaps the first column in your csv to a FORM Attribute called wonum and so on.
The destination of this example is set to the FORM so it simulates you clicking the button…
Once you have one row updated, you can put it into a loop to process a whole CSV file :
[LL_WEBREPORT_STARTROW /]
[LL_WEBREPORT_FOR DATA:[LL_REPTAG_ROWDATA FIELDS /] VAR:field /]
[LL_REPTAG_ROWDATA RECORD:[LL_REPTAG_!field /] SETFORM:[LL_REPTAG_!field /] /]
[LL_WEBREPORT_ENDFOR /]
[LL_WEBREPORT_ENDROW /]
thank you both for you detailed and helpful answer. I managed to get my webreport fill the form but I have to click submit for data to be registered in the form. Is this a normal behaviour? is there a way to have it write to the form without me clicking the submit button for each entry? Thank you
I think you are probably confused about the two products and interfaces. If we look at this without WR .
Form Template(think of it as the way Livelink will accept data). Usually, when I design forms I keep Revisions OFF and Submit with (SQL) as the main thing. When you create a Form with that mechanism if the Form Template has a name/value property like Name:[ ] then every time you submit a new entry will get added and the ListData RH will allow you to delete the row or update the data. Ok so now what happens if you need to add 100 entries like you want, either you sit in the GUI and submit 100 times or use a WR to simulate the 100 pushes…
Here where the WR comes in a WR has three entry points a Header a Footer and a Row section, the row section is akin to a programming loop so if you have a CSV file that has 100 entries if you say ll_repatga1 in the row section, and run it it will print 100 entries or whatever you have in the CSV. If you are a beginner in WR do yourself a favor and go and change the use of advanced Editor off
Now you will be able to understand the Header, Row, and footer aspects
so if you put a WR tag in the ROW that is where the loop effect starts(I will include a simple WR here) and if you have it done right then when the WR runs it will insert 100 rows as you want
I created a zipfile with a word document a WR you can use https://knowledge.opentext.com/knowledge/llisapi.dll/Properties/81842402
OT will kill the OTCS CS server in the future so if you need it download and keep it I may move it to my personal blog later
as @appuq mentioned, you should not need to press submit, you can just set up the WebReport and form as above and process it directly.
Thank you all, I managed to get it working
