Find Jobs
Hire Freelancers

Build program to query database file and display results continously

$30-250 USD

Cerrado
Publicado hace más de 8 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 8797479

Información sobre el proyecto

25 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
25 freelancers están ofertando un promedio de $224 USD por este trabajo
Avatar del usuario
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 en 7 días
5,0 (112 comentarios)
7,2
7,2
Avatar del usuario
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 en 5 días
4,8 (85 comentarios)
7,3
7,3
Avatar del usuario
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 en 3 días
4,9 (142 comentarios)
7,0
7,0
Avatar del usuario
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 en 3 días
4,8 (81 comentarios)
6,5
6,5
Avatar del usuario
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 en 7 días
4,9 (31 comentarios)
5,6
5,6
Avatar del usuario
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 en 5 días
4,9 (39 comentarios)
5,4
5,4
Avatar del usuario
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 en 3 días
4,8 (31 comentarios)
5,3
5,3
Avatar del usuario
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 en 3 días
4,9 (26 comentarios)
5,1
5,1
Avatar del usuario
I can do this project within 3 days.
$306 USD en 3 días
5,0 (5 comentarios)
4,7
4,7
Avatar del usuario
A proposal has not yet been provided
$147 USD en 3 días
4,5 (22 comentarios)
5,2
5,2
Avatar del usuario
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 en 7 días
5,0 (24 comentarios)
4,2
4,2
Avatar del usuario
A proposal has not yet been provided
$300 USD en 5 días
5,0 (7 comentarios)
4,2
4,2
Avatar del usuario
Hello. More 20 years programming experience. Had already done similar. Regards. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
$155 USD en 3 días
4,9 (10 comentarios)
3,8
3,8
Avatar del usuario
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 en 3 días
4,6 (5 comentarios)
3,3
3,3
Avatar del usuario
A proposal has not yet been provided
$155 USD en 3 días
5,0 (3 comentarios)
2,6
2,6
Avatar del usuario
A proposal has not yet been provided
$144 USD en 2 días
4,9 (6 comentarios)
2,6
2,6
Avatar del usuario
Sure to get done work with quality and delivered on time. Please give to change to do the same. Thanks VISHAL
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Aucune proposition n'a encore été fournie.
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Oak Park, United States
5,0
3
Forma de pago verificada
Miembro desde oct 15, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.