Find Jobs
Hire Freelancers

Small Windows automation program

$100-500 USD

Cancelado
Publicado há quase 16 anos

$100-500 USD

Pago na entrega
Do you have strong WinAPI knowledge (C, C++, C#) and MS Office automation skills (to access and send data to MS Excel)? If you're interested in a fairly quick coding job, and you're familiar with these two tools for creating small PC/Windows desktop automation tasks, please tell me briefly what your experience is with them. A brief description of my programming needs -- This little automation program will need to interface with a proprietary database program that you probably don't have access to (Recruitment Plus by CollegeBoard). If that's the case, you'll have to be able to set this program up using some dummy database program like Access, where you set up the automation program to look for the tabs and fields in the database that I share with you that I need, copy all of the desired fields for the currently open database entry (in this case, a specific prospective student), and automatically paste that information into a specified spreadsheet that has a column heading for collecting each of the fields that was copied. For example: first name, last name, address, phone, etc. ...more in the detailed description... ## Deliverables Here's how a programmer friend said I should ask prospective coders to make this: 1) Install your RP system. Open the window/form from which to take details. Identify this window by means of some development tool (like MS Spy/Spy++ which is included in MS Visual Studio). Identify the windows-controls (textboxes etc) with the student-related info. 2) Create application "StudentDataTransfer" in Visual Studio. Implement grabbing captured values from the identified windows-controls: WinAPI code. 3) Extend the "StudentDataTransfer" application with the MS Excel automation functionality: inserting data into cells + other requested actions. 4) Implement the hot key functionality - here I see 2 options: if it is troublesome to implement a hot key function right in the "StudentDataTranfer" application, then to implement AHK script which would (upon firing the hot key) run the "StudentDataTransfer" application which immediately (invisibly without any user interface) grabs data from the RP's windows-controls and inserts it into MS Excel. 5) Test the whole thing. ...and here's how I originally described it: 1. I've got AutoHotKey running, Recruitment Plus (RP) running, and an Excel spreadsheet open. 2. I have a conversation with a student, or send her an email. I record it in Recruitment Plus, and then I hit my AutoHotKey keyboard short-cut to copy all the student's info. That's automation program step # 1 3. If it's possible for all steps to happen at once, just from one key sequence, that's great. But if not, I can use multiple keyboard shortcuts - each with its own key sequence (**important: you'll need to integrate this with AHK. I dont know how to.)** 4. Automation program step # 2 is when the student's copied ID info is pasted into the SS under appropriate columns, in its own row, by alphabetical order and date. And, pasted under an "Action" column in the same row, the date, time, and whether the contact was an email or phone call. 5. The automation process should end with the SS program on top of everything else, auto-saved, scrolled down to the row that was just entered, and with the curser in the final column of data for the student: "notes". 6. One last important point to clarify: when a student has multiple entries in the spreadsheet, there should be multiple rows for that student, all together, with the most recent entry on top, oldest entry on bottom. That's it. I really hope this is doable, and interesting to you. Thanks for your time, and I look forward to hearing back from you! Mac
ID do Projeto: 3007073

Sobre o projeto

2 propostas
Projeto remoto
Ativo há 16 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
2 freelancers estão ofertando em média $266 USD for esse trabalho
Avatar do Usuário
See private message.
$318,75 USD em 7 dias
3,7 (28 avaliações)
5,4
5,4
Avatar do Usuário
See private message.
$212,50 USD em 7 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Knoxville, United States
5,0
16
Membro desde ago. 23, 2006

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.