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] <mailto:[email protected]>> > To: [email protected] <mailto:[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] <mailto:[email protected]>> > To: "[email protected] <mailto:[email protected]>" > <[email protected] <mailto:[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] >> <mailto:[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] <mailto:[email protected]>> >> To: "[email protected] <mailto:[email protected]>" >> <[email protected] <mailto:[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] >>> <mailto:[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] >>> <mailto:[email protected]>> >>> To: "[email protected] <mailto:[email protected]>" >>> <[email protected] <mailto:[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] >>> <mailto:[email protected]>. >>> For more options, visit https://groups.google.com/d/optout >>> <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] >> <mailto:[email protected]>. >> For more options, visit https://groups.google.com/d/optout >> <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] >> <mailto:[email protected]>. >> For more options, visit https://groups.google.com/d/optout >> <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <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.
