Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
transfer data from .DBF file to oracle database

Dear all,
I have fingerTec TCMS v2, it is a punish machine that save the coming time and leaving for employees in company which saves data in .dbf file. I need to transfer data such as ( employee number, date , in time and out time )from attend.dbf to same columns in my Oracle 9i data in table. I don't want to use extra system I need to do it manually.
please help.
Answers
-
3273235 wrote:Dear all,I have fingerTec TCMS v2, it is a punish machine that save the coming time and leaving for employees in company which saves data in .dbf file. I need to transfer data such as ( employee number, date , in time and out time )from attend.dbf to same columns in my Oracle 9i data in table. I don't want to use extra system I need to do it manually.please help.
What format does it store the data in this file with an extension of .dbf? Can you read it as a human if you opened it up in notepad, if so it should be easy enough to write a sqlldr control file to parse and load it.
If it is encoded in some way then you need to figure out how to decode it, that would be a question to ask the vendor.
-
no I can't read it in notepad but I installed the .dbf viewr tro view the tables
-
Hi,
check out the FingerTec User Manual (Time Attendance Software : FingerTec Worldwide ). It mentions a "FingerTec Data Processor" that lets you connect to other databases or export data into different file types.
Andris
-
They are providing tool called FTDP but I dnt want to use extra system I want for example to connect through odbc or something like this but am stuck
-
3273235 wrote:They are providing tool called FTDP but I dnt want to use extra system I want for example to connect through odbc or something like this but am stuck
How is odbc supposed to know how to interpret the file?
If they have provided a tool then why don't you want to use it?
-
The very first question to ask: "what these .dbf files are?". Chances are they are in some kind of dBASE compatible format, but this is not 100% sure.
If they are indeed dBASE, this means they can be read through ODBC using dBASE drivers that are available on pretty much every windows machine out there. They certainly are on my W7 I am writing this on. Don't know about W8 and W10 though, up to you to check this out. Things will be getting more complex if you're on Unix/Linux, but still are doable.
If this is NOT dBASE, good luck figuring out how to read those.
You will end up writing some king of code anyway, so this won't be too much different from using provided tool. Which your vendor officially supports too I imagine? If you have it - use it.
-
some people try to re-invent the wheel
everybody can have their moment for an "Eureka !" ... no ?
i'm guessing this is a man, trying to do something without first reading the manual
-
i'm guessing this is a man, trying to do something without first reading the manual
How do you know it's not a woman?
-
cos i just posted a link to 1 such manual
-
a woman usually has the link to the manual but doesn't understand it
have you never turned the map upside down for your spouce ?