Bruce,If I recall correctly, the sequence determines how the data is
entered/impored and the format determines how it is displayed.Looks like you
might be importing without the decimals and this is why you are displaying it
as zeroes.Have you tried seting...SET TIME SEQUENCE HHMMSS.SSSSET TIME FORMAT
HH:MM:SS.SSSI am not near a computer or manual so just speculating.
Javier Valencia, PE
Sent from my T-Mobile 4G LTE Device
-------- Original message --------
From: Bruce Chitiea <[email protected]>
Date: 6/3/17 3:39 PM (GMT-06:00)
To: [email protected]
Subject: Re[2]: [RBASE-L] - Re: Importing Time Values: HH:MM:SS.SSS
<![CDATA[#xc7a1c65f3cfa4f2088c99098e8ee8213{
font-family:Tahoma;
font-size:12pt;
}#x2945fa7f85fb463099359fd6dd71a412{
font-family:Tahoma;
font-size:12pt;
}]]><!--body
{font-family: Tahoma; font-size: 12pt;}
-->Albert:
Both:
SET TIME SEQUENCE HHMMSSSSSSET 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 PMSubject: Re: [RBASE-L]
- Re: Importing Time Values: HH:MM:SS.SSSFrom: "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 importExample:
Excel: 16:30:45.321
Imports as: 16:30:45.000
Clues?
Bruce ChitieaSafeSectors, Inc.909.238.9012 Mobile
------ Original Message ------Sent: 6/2/2017 4:16:27 PMSubject: Importing Time
Values: HH:MM:SS.SSSFrom: "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 TimeImportTestSET 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.go
--
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.
