Find Jobs
Hire Freelancers

Build program to query database file and display results continously

$30-250 USD

Closed
Posted over 8 years ago

$30-250 USD

Paid on delivery
I need a standalone database query application/program that will look up a DBF database file and display the results. The program will monitor a text file for key words, and will search the database for all records with matching fields, and then display a list of all the matching records in a specific order. Part 1. General Requirements: 1. The program needs to be able to run on all Windows versions (XP, Vista, and Windows 7 (32 or 64 bit), Windows 8, and Windows 10). 2. Needs to be a standalone program and to use very little CPU power. Especially when just monitoring the TEXT file for new input. 3. Option to start with windows and sit in the system tray for easy access to features, setting, options, etc. All configurations must be stored in an ini file for easy duplication of setting to another system. 4. The program should generate a log of the lookup data as it is processing including time and date, and if there is an error, so the user can see right away when the error occurred. The log file should be stored anywhere and name be set by the user. 5. All source code, and details or program used to create program, are to be provided at the end of the project. 6. There is no specific programming language requirement, but it need to be a standalone program, that should not need to have parent software installed. If you have an idea with Access, that could be an option. Part 2. Getting the information 1. The program will need to monitor a file on the computer. For example, C:\Temp\[login to view URL] and it will have one line in it such as DATA=WORD11, WORD2, WORD3, WORD4. Up to 4 different text WORDS may be provided. (A different and already existing program will create this file). As soon as the contents of the file change, the look up program need to go in to action. The program needs to have an INPUT dialog box to allow the user to manually enter lookup WORDS as necessary, and for testing, maybe visible on the top corner or something like that. 3. The lookup file name (example C:\temp\[login to view URL]) can be any file on the local system or network, specified by the user in settings. Part 3. Looking up the database 1. The program will copy a database file form the network to the local computer if the file is older than set by the user, for example if the local file is more than x days old, the program will attempt to copy a newer version from the network. The lookup function will be on a local file to speed up the lookup. (The lookup database does not change often.) Alternatively, if possible, it should be possible to set to lookup a file on the network, but the program should not lock the file. 2. The lookup file is a DBF (dBase) database file with the following fields: DATE, TIME, STATION, COMPANY, LINE, PN, ALT, CAGE, QTY, CN, DESC, PHONE, FAX, DISTANCE 3. The program will look up all records with matching any of the WORD11, WORD2, WORD3, or WORD4 in field PN. The program will omit spaces, dashes, and periods, only keep letters and numbers for the search. 4. The program will display in a list all the matching records sorted by COMPANY and Date (or possible other sorting options) . The display window will allow to select which columns display and which order, resize window, columns, text size, and placed anywhere on the desktop. 5. It should have some filtering option (if possible), for example QTY must be great that 1 or 0, and only newer than a certain date. 6. Need to be fast, the lookup DBF file may have several million records and can be 1GB or more in size. Part 4. Saving the results (Optional) 1. The program should have the option to print or save to file the results if needed (not that important) FILES Provided: Excel file has 4 worksheets showing what possible data looks like, and the lookup valued could be, and what the results should show. The DBF file is what the database file actually is.
Project ID: 8797479

About the project

25 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
25 freelancers are bidding on average $224 USD for this job
User Avatar
Hello sir/madam, However, I am new here in freelancer.com I have over 10 years of experience in .Net programming. I am going to write you a stand-alone application using C#. Please contact me to discuss the details. Waiting for your messages. Best regards, Tolib Rahimov
$250 USD in 7 days
5.0 (112 reviews)
7.2
7.2
User Avatar
Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$231 USD in 5 days
4.8 (85 reviews)
7.3
7.3
User Avatar
I am very proficient in c, c++. I have 15 years c++ developing experience now, and I have worked for 5 years. My work is online game developing, and mainly focus on server side, the language is c++ under linux. I used c++ to make many great projects, for example, I made the tools which can convert java files to c++ scripts which has the same effect, of course garbage collection included. I also made our own mobile game using c++, I even can show you the demo of client. Trust me, please let expert help you.
$200 USD in 3 days
4.9 (142 reviews)
7.0
7.0
User Avatar
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$244 USD in 3 days
4.8 (81 reviews)
6.5
6.5
User Avatar
Hello Sr., how are you ? Jorge is my name and I have wide experience doing all kind of apps to automate processes as you are requiring; using different tools. If you need to be compatible with all Windows versions, don't worry. You can visit my Portfolio to know my last jobs regarding these skills, the reviews received from clients and as you can see, a higher percentage of jobs completed. i'm interested to help you on this particular project. What I prefer is to discuss with you more in detail all your terms and I'll give you a better proposal. No more Sr.; contact me if you'd like it. Regards. Jorge. P.S.: I will not accept any award before to discuss with you all the details needed.
$250 USD in 7 days
4.9 (31 reviews)
5.6
5.6
User Avatar
Hello, I have good experience developing database desktop applications and I'm looking to do this project for you. I can send you a standalone exe and no need to install any required software. Regards.
$157 USD in 5 days
4.9 (39 reviews)
5.4
5.4
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$242 USD in 3 days
4.8 (31 reviews)
5.3
5.3
User Avatar
I have carefully read you task. I am an experienced .net developer and can do you task on C# and .NET. Always provide all source codes and support for project in future. For all my projects and employers small additions and bugfixes always for free.
$166 USD in 3 days
4.9 (26 reviews)
5.1
5.1
User Avatar
I can do this project within 3 days.
$306 USD in 3 days
5.0 (5 reviews)
4.7
4.7
User Avatar
A proposal has not yet been provided
$147 USD in 3 days
4.5 (22 reviews)
5.2
5.2
User Avatar
Hello, I'm a vb.net programmer with great experience in developing similar applications scenarios. Let me know if you are interested and I'm ready to start working on your project. Regards, Tony
$250 USD in 7 days
5.0 (24 reviews)
4.2
4.2
User Avatar
A proposal has not yet been provided
$300 USD in 5 days
5.0 (7 reviews)
4.2
4.2
User Avatar
Hello. More 20 years programming experience. Had already done similar. Regards. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
$155 USD in 3 days
4.9 (10 reviews)
3.8
3.8
User Avatar
Hi friend how are you doing? I'm Windows programmer with some years of experience in database programming. I can do this project for you as you mentioned with your specifications. if you like me to work on your project please let me know to start.
$150 USD in 3 days
4.6 (5 reviews)
3.3
3.3
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
5.0 (3 reviews)
2.6
2.6
User Avatar
A proposal has not yet been provided
$144 USD in 2 days
4.9 (6 reviews)
2.6
2.6
User Avatar
Sure to get done work with quality and delivered on time. Please give to change to do the same. Thanks VISHAL
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Aucune proposition n'a encore été fournie.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I read your requirements and would deliver a VB6 application (yeah I know VB6) because I can verify it runs on all the Windows versions you listed (including Windows 10). It has builtin acces to DBF format files.
$555 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am experienced working IT employee with hands on real time multiple Oracle DBA projects knowledge. Good in providing Online Oracle DBA classes, course includes oracle database, Oracle 10g database, Oracle 11g dba management, database creation, table space management, oracle performance tuning, oracle DBA real scenarios, Data Guard and RAC, ASM and OEM12C. Please reach me at 7729002111.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Oak Park, United States
5.0
3
Payment method verified
Member since Oct 15, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.