Change Field Names
Hello!
I'm trying to port a lot of reports (around 200, but multiplied by 100 because many customer DBs that have a little customised reports) to a new DB. The new DB is very similar to the old DB, but it has different field names (type of data is still the same).
I came up with the idea of some type of converting tool that would change the DB names. I will prepare a list of source and target names.
Is technically possible to load a report, change the Fieldnames (also in script and calculated) in the report and save it back? I know there will be some fields that will not convert, but my hope is to ger 90% of the reports converted, the rest will be done by hand.
I'm trying to port a lot of reports (around 200, but multiplied by 100 because many customer DBs that have a little customised reports) to a new DB. The new DB is very similar to the old DB, but it has different field names (type of data is still the same).
I came up with the idea of some type of converting tool that would change the DB names. I will prepare a list of source and target names.
Is technically possible to load a report, change the Fieldnames (also in script and calculated) in the report and save it back? I know there will be some fields that will not convert, but my hope is to ger 90% of the reports converted, the rest will be done by hand.
Comments
Take a look at the following example. It shows how to load a report from DB as text (for editing) then reload it back to the DB. You should be able to use this technique to automatically load/alter/reload each report you need to port.
https://rbwiki.digital-metaphors.com/end-user/fundamentals-end-user/how-to-edit-templates-as-text/
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com