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 < [email protected]> 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 <[email protected]> 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 > > [email protected] > 651.556.0930 I www.kineticdata.com > > > > > > > > > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Best regards, Kirill _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
