Home » Developer & Programmer » Forms » Load Data From External File (Forms 6i, Windows)
Load Data From External File [message #476869] Mon, 27 September 2010 01:21 Go to next message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
We are using hand scanning machine for attendance, machine saved data in a TEXT file now I want to load data into my oracle base payroll system.

data saved in this format.
31201009240928000100000002690001
31201009240933000100000000060001

as per my understanding
20100924 is date
0928 is time
269 is employee code

but I am unable to understand, is this IN or OUT time?

Please help me in this reagards

The reason for discussing about my requirement with all of you guys, if you know any other idea then please share with me.

I will be very gratefull to all of you.
Re: Load Data From External File [message #476871 is a reply to message #476869] Mon, 27 September 2010 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but I am unable to understand, is this IN or OUT time?

How could we know what YOUR data mean?

Regards
Michel

[Updated on: Mon, 27 September 2010 02:14]

Report message to a moderator

Re: Load Data From External File [message #476878 is a reply to message #476871] Mon, 27 September 2010 01:53 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, that's one of the best questions I've seen lately.
Re: Load Data From External File [message #478469 is a reply to message #476878] Sat, 09 October 2010 01:51 Go to previous message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member

you should decide it yourself whether it is IN or OUT.

if employee is already IN then it will be OUT otherwise IN.

Regards
Athar
Previous Topic: groups
Next Topic: New Bean Issue
Goto Forum:
  


Current Time: Thu Sep 19 17:17:20 CDT 2024