[progress Communities] [progress Openedge Abl] Forum Post: Re: Use Generate Xml/create From...

[gwf]

Hello Mani, Thank you for your reply. First, to clarify, I am using XML to replicate an application within one zone/public account. The use case is that this is a project management application which I want to replicate for different projects that need to be segregated in their data, and also be able to account for some variations between them. I do not need to seed records, just set up new replicated applications which I can then add records to through importing from .xlsx files and/or manually. For the ID tags, my question is what the XML file should look like before importing to prepare for Rollbase to create the new application, object, field, etc. IDs. For example, in these lines from the XML file: When I export to XML the IDs are filled in for the original template application, so do I need to modify or delete the bolded ID tag before importing to create a new application? My question RE: modifying formulas is because I want expression fields generate values based on a single control record, not multiple related records. I thus need expression/formula fields and can’t use tokens (the way I understand it). Specifically, I have an object, objectA, with sets of fields following this convention: objAField1InUse [integer expression] objAField1Label [string expression] objAField1Value [picklist] objAField2InUse [integer expression] objAField2Label [string expression] objAField2Value [picklist] ... and so on Records in this objectA hold data for the application. Then I have an object, masterFieldSelector, which holds one record where I can modify the fields mfsField1InUse [checkbox] mfsField1Label [text] mfsField2InUse [checkbox] mfsField2Label [text] ... and so on So, for objectA objAField1InUse, the expression formula would be: function main() { var checkbox = rbv_api.selectValue("SELECT mfsField1InUse FROM masterFieldSelector WHERE id = 246824 "); return checkbox; } main(); And then I can modify the fields objAField1Value [picklist], objAField2Value [picklist], etc. to hold the data. Because the expression needs to include the id, my assumption is it needs to be hard-coded into the expression. So is there another way to do this with tokens or another approach that will allow for this flexibility and enable replicating with an XML file? Thank you very much, Greg

Continue reading...