I can see of a museum using Remedy to track their collections inventory and if an item is out on loan to another museum.
I think they picked January 1, 4713 B.C. as 0 for a DATE as it is also the 0 for an Oracle Julian date Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Sundberg Sent: Friday, July 29, 2011 11:12 AM To: [email protected] Subject: Re: ARX File Reader Utility Question -- has ANYBODY -- EVER -- used any date in BC? And if so -- why? -- 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 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kirill Eitvid Sent: Friday, July 29, 2011 10:51 AM To: [email protected] Subject: Re: ARX File Reader Utility ** 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. -----Original Message----- On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg 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 -- 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 -----Original Message----- On Jul 24, 2011, at 4:03 PM, Mike Buck wrote: ** Thank you I'll take a look. Kind regards -----Original Message----- On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky 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. -----Original Message----- > 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"
