J..if I were building an application that tracked historical figures, and needed to track the birth date of those figures, I would need a date field that allowed for BC values..I believe the basis for this value was based on the Julias calendar..where 'day one' is over 6000 years ago..and since dealing with only the number of days.you can really go back as far as you want J
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Sundberg Sent: Friday, July 29, 2011 10: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 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 <[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 <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 <http://www.arslist.org/> > attend wwrug11 www.wwrug.com <http://www.wwrug.com/> ARSList: "Where the Answers Are" > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> attend wwrug11 www.wwrug.com <http://www.wwrug.com/> ARSList: "Where the Answers Are" _attend WWRUG11 www.wwrug.com <http://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 <http://www.kineticdata.com/> www.kineticdata.com _attend WWRUG11 www.wwrug.com <http://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 [email protected] 651.556.0930 I <http://www.kineticdata.com/> www.kineticdata.com _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"
