Question -- has ANYBODY -- EVER -- used any date in BC?
And if so -- why? -John On Jul 29, 2011, at 11:50 AM, Kirill Eitvid wrote: ** John, as far I remember it's the number of days passed since 01.01.1970 for DATE and number of seconds since 01.01.1970 00:00:00 for DATETIME. Try it. On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg <john.sundb...@kineticdata.com> wrote: ** I am getting closer :) If the .arx value of a DATE field is 2455767 .... How does that get converted to human readable? Meaning -- does anybody know the conversion strategy? 1) Upload (which gets parsed for field names, types etc...) https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc 2) Select fields you want to see https://skitch.com/johnsundberg/fct9m/kinetic-data-inc 3) View https://skitch.com/johnsundberg/fct95/kinetic-data-inc 4) Party!!! -John On Jul 24, 2011, at 4:03 PM, Mike Buck wrote: ** Thank you I'll take a look. Kind regards On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky <m...@rrr.se> wrote: Hi, We have a tool that can do something like that, and more. It is called RRR|ArxToHTML, and can be downloaded from: https://www.rrr.se/cgi/tools/main#rrrArxToHTML You will get the best result if you have a def-file with the form-definition, as it will allow the tool to sort field by the form layout, use labels instead of database names, selection field values etc. You will get a result list with the normal entry-list-fields and links to individual records. The quick way to use it to convert an ARX-file to a table is to run it like this: rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html This will create a single HTML-file with a table including all fields of the ARX-file. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > It would be SO good to view ARX files, without having to import to the > target form, in order see all the data. > > Is anyone willing to share a utility, or build one to share, which will > parse an ARX file and present it in an easy to digest form? > > The data could be presented with column headers in notepad for example, or > even better in Excel (similar to how a CSV file is presented). > > This would be a really fantastic tool for code reviews and carry out > pre-deployment checks. > > I really do hope someone is able to help:) > > Thanks very much > Mike > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ -- John Sundberg Kinetic Data, Inc. "Building a Better Service Experience" Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Best regards, Kirill _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ -- John Sundberg Kinetic Data, Inc. "Building a Better Service Experience" Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"