Creative ... Mr. Berry, you are a dangerous fellow. Would prefer not to
do that, and have a native TIME solution; but, as deadline looms, may
give it a shot.
I also thought about submitting an enhancement request for a special
thousandths mask character. Originally, I considered "K" for "kilo", but
decided the optics might be a bit dicey.
Thanks for hanging in on this.
Bruce
------ Original Message ------
Sent: 6/4/2017 12:17:48 PM
Subject: Re: [RBASE-L] - Re: Importing Time Values: HH:MM:SS.SSS
From: "Albert Berry" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
I wonder if you could import the time into a text field instead of time,
and then parse it (in a computed column?) to create a proper TIME format
entry.
Albert
On Jun 4, 2017, at 12:56 PM, Bruce Chitiea <[email protected]>
wrote:
All:
Excel 2016, RBGXE 10.0.2.20530
After numerous controlled tests, at best, TIME values are
Gateway-imported from Excel with zeroes in place of thousandths of a
second.
SET TIME SEQUENCE [ HHMMSS \ HHMMSSSSS \ (winging it now:) HHMMSS.SSS |
HHMMSS.000 | HHMMSS000 ]
SET TIME FORMAT HHMMSS.SSS
... imports: 12:45:30.123 as 12:45:30.000.
Settings > Configuration Settings > Format > Time > Sequence accepts
and appears to save [ HHMMSSSSS | HHMMSS.SSS ] to RBENGINEXE.CFG; but,
upon return to Settings, Sequence displays as 'HHMMSS', suggesting that
these "extended" formats are unsupported.
Our Excel source data is custom-formatted as: 'hh:mm:ss.000', as Excel
does not have a "native" TIME format incorporating thousandths.
Nevertheless, Excel can be switched between the custom and recognized
TIME formats without loss of the thousandths data.
Thoughts? Experience?
Bruce Chitiea
SafeSectors, Inc.
------ Original Message ------
Sent: 6/3/2017 1:39:28 PM
Subject: Re[2]: [RBASE-L] - Re: Importing Time Values: HH:MM:SS.SSS
From: "Bruce Chitiea" <[email protected]>
To: [email protected]
Cc:
Albert:
Both:
SET TIME SEQUENCE HHMMSSSSS
SET TIME SEQUENCE HHMMSS.SSS
No effect. It is to scratch head, no?
Bruce
My basic test code:
SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS.SSS
DELETE ROWS FROM TimeImportTest
GATEWAY IMPORT XLS TimeImportTest.xlsx +
APPEND TimeImportTest +
OPTION FIRST_ROW 2 +
|ADD_MAPPING TimeImportID = A +
|ADD_MAPPING TimeImportTestValue = B
BROWSE * FROM TimeImportTest
SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS
RETURN
------ Original Message ------
Sent: 6/3/2017 1:27:22 PM
Subject: Re: [RBASE-L] - Re: Importing Time Values: HH:MM:SS.SSS
From: "Albert Berry" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
I mis-typed! Sequence HHMMSS.SSS or HHMMSS.SSS ?
Albert
On Jun 3, 2017, at 2:10 PM, Bruce Chitiea <[email protected]>
wrote:
Albert:
Thanks, yes.
Tried several TIME FORMATS, producing for all records (examples):
1. HH:MM:SS.SSS > 16:30:45.000
2. HH:MM:SS.sss > 16:30:45.45
3. HH:MM:SS.000 > 16:30:45.000
4. HH:MM:SS.TTT > (No Import)
5. HH:MM:SS.123 > 16:30:45.123
6. HH:MM:SS. > 16:30:45.
Missing something, certainly.
Any thoughts appreciated.
Bruce
------ Original Message ------
Sent: 6/3/2017 12:59:47 PM
Subject: Re: [RBASE-L] - Re: Importing Time Values: HH:MM:SS.SSS
From: "Albert Berry" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
Definitely an off the wall idea, but have you tried setting the
sequence to HH:MM:SS.SSS or HH:MM:SSSSS ?
Albert
On Jun 3, 2017, at 12:01 PM, Bruce Chitiea <[email protected]>
wrote:
Progress:
Placing the "BROWSE * FROM TimeImportTest" line immediately after the
import code (before re-setting the Time Format *doh* ) produces the
desired time FORMAT but drops the thousandths values during the
import
Example:
Excel: 16:30:45.321
Imports as: 16:30:45.000
Clues?
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
------ Original Message ------
Sent: 6/2/2017 4:16:27 PM
Subject: Importing Time Values: HH:MM:SS.SSS
From: "Bruce Chitiea" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
All:
RBGXE Latest:
I need to import Time values
... from Excel format: hh:mm:ss.000
... to R:BASE format: HH:MM:SS.SSS
Best import result I get in R:BASE is: HH:MM:SS
So I'm missing a step. How do I import those thousandsss?
Thanks much,
Bruce
My test code:
SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS.SSS
DELETE ROWS FROM TimeImportTest
GATEWAY IMPORT XLS TimeImportTest.xlsx +
APPEND TimeImportTest +
OPTION FIRST_ROW 2 +
|ADD_MAPPING TimeImportID = A +
|ADD_MAPPING TimeImportTestValue = B
BROWSE * FROM TimeImportTest
SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS
RETURN
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
