Rob, I have now updated our rrrDefFieldList-tool to include field labels.
This tool runs on def-files and produce a list of all the fields in the file. It does not connect to the server or the network. The result is a semicolon separated text file that you can open in Excel. The listed information includes information about Form, Id, Name, Label, Type, Option, Length, Enum-values, Default, Pattern and Menu of each field. https://www.rrr.se/cgi/tools/main#rrrDefFieldList Best Regards - Misi, RRR AB, http://www.rrr.se > As we all know each field in a form has at least three names, one the user > sees (user-facing), the name we see in the admin tool and the name stored > in > the database. > > I have a manager who wants a csv file listing all the fields on a form > showing the user-facing name alongside the admin-tool name. The reason is > that users see the admin-tool name (or the database name) while putting > together reports. We have for instance, relabeled field 'Tag Number' so > that > users see 'PIMS Number', but it remains 'Tag Number' in the admin tool and > Tag_Number in the database. > > The admin-tool and database names are easy to come by, but how can I > extract > the user-facing names? Will arinside do it? I can't install anything > needing > admin rights without a song-and-dance routine with computer security--that > takes weeks. If arinside or some other tool will do the trick, I can > possibly speed up that process. > > I've been through the database this morning looking in a MS SQL > installation > on my laptop, and I do not see a table under ARSystem that holds the info > I > need. For instance, Field has the name and a lot of other info, but column > fieldName is the admin-tool name. > > Any help would be appreciated. Is the answer obvious? Am I missing > something, as usual? > > Thanks. > > -- > Bob Rowe, Remedy Action Request System Development and Administration > [EMAIL PROTECTED] > "The golden rule is to test everything in the light of reason and > experience, no matter from where it comes." > Mohandas K. Gandhi > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"