John,
I don't know if this will help you much, but this is a function I pulled off
the list a few years ago to help with that conversion
ALTER FUNCTION [dbo].[RemedyDateToHuman] (@dateint int)
RETURNS datetime AS
BEGIN
DECLARE @sql_date datetime;
-- SQL Server datetime values begin at 01/01/1753
-- Remedy Date-only values begin at 01/01/4713 B.C.
-- Remedy Date-only integer value for 01/01/1753 is 2361331
IF @dateint < 2361331
SET @sql_date = '17530101'
ELSE
SET @sql_date = DATEADD(dd,@dateint - 2361331,'17530101');
RETURN @sql_date;
END
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of John Sundberg
Sent: Friday, July 29, 2011 9:43 AM
To: [email protected]
Subject: Re: ARX File Reader Utility
**
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 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"
