Find Jobs
Hire Freelancers

Database Management Tool

$30-250 USD

Em Andamento
Publicado há quase 16 anos

$30-250 USD

Pago na entrega
Pleas see the attached files. The objective of Data Management System is: 1. Data input & storage in structured manner. Input can be done manually or by uploading data from .csv/.xls/.txt format 2. Query based data access using “Search” Function and downloading search result data in .csv format. 3. Identify duplicate value in a specified column of the database and remove/update other fields in the row of the duplicate value. Explaining Functionality 1. [login to view URL] Screen Shot – 1) This is used to give password protection to the DMS. There are two types of login authorities: a) Admin Login – Gives complete access to all the features & sections of DMS b) User Login – Gives complete access to all the features & sections of DMS except the “Control Panel” Section 2) Forgot Password – Click on this link sends automated Email to ID of Admin. This ID is input in the control section. Once logged in, this page takes to [login to view URL] 2. [login to view URL] Use of [login to view URL] – 1) Feed data in DMS – Data can be fed in 2 ways in DMS a) Upload data – Data contained in .csv / .txt or .xls format can be uploaded by selecting the data file from the computer and “submit”. Refer to sample data file for the format. It’s important to maintain the column headers name in data file so that the database of DMS can recognize and store data correctly. Once the data has been uploaded it shows [login to view URL] with “Action Done” b) Input Data Manually – Data can be typed in manually in point C and then “Submit”. Once the data has been uploaded it shows [login to view URL] with “Action Done” Please note that the column header names shown in the table of point C comes from the “Control Panel”. Also, the date of upload is automatically capture in DMS for each data row. 2) Remove Duplicate Entries from database of DMS. Duplicate entries can be removed from database of DMS using “ Duplicate Remover” (point A of Upload.htm.) Logic behind Duplicate Remover: Step 1 - Duplicate remover tool identifies 2 same values in a specified COLUMN of DMS database. (eg column 1) Step 2- By using the date of upload of these 2 same values, It identifies which one is older. Step 3 - It then does either of the following tasks: i) Updates other values in the ROW of the older duplicate value using the values of new duplicate row. OR ii) Deletes complete row of new value from DMS database. OR iii) Deletes complete row of old value from DMS database. Please note that the following details are provided to Duplicate Remover tool by the “Control Panel” section: a) The name of the column in the database where duplicate values have to be identified. (Step 1) b) Tasks to be done after identification has been done (Step 3) Once Duplicate Remover has removed the duplicate entries, it goes to [login to view URL] & shows the result as “xx Duplicates Removed out of xxxx Entries”. It also provides the download link of duplicate entries list for downloading in csv format. 3. [login to view URL] This page lets the user search the database after user gives search criteria. The name of column comes from the “Control Panel” . After the criteria is given and “search”, it goes to [login to view URL] Wild card will work if used in input (*). If any column is left blank, it means the result will use “All” criteria for that column 4. [login to view URL] 1) This shows the search result from database as specified. 2) It allows user to delete the selected profile. After the delete is pressed once, it asks for confirmation (javscript box). 3) It allows user to download the search result in .csv format (not only what’s showing this result page, but all the complete search result data) 4) It shows 100 results a page. Uses Next / Previuous links to brows through the search result data. 5) It maps the data in this tool with other databases (who’s login details will be provided in [login to view URL]). Refer to point 5.5 5. [login to view URL] It does 5 things – 1) Set Duplicate Remover Criteria – Refer to [login to view URL] – Duplicate Remover. 2) Assign Column Names for showing in search options, search results / Data Input table. (Please note that the column names of DMS database & data upload csv / xls / txt file remains 1,2 ,3 etc. These names are ONLY for showing in search options, search result & data input tables of [login to view URL] & [login to view URL] – point C.). Once set, the names will be shown in the text boxes. Important - Please note that if any of the columns haven’t been given any name in the control panel, the same will not be shown in search options,, search result table & data input tables. For eg if column 5-15 haven’t been given any names, the search options, data input & search result tables will only display tables column 1 to 4. 3) Login Details Settings for admin and user can be set from here. Please refer to index.htm. Text boxes will display current user name & password. 4) Assign admin ID- “Forgot Password / Login ID” mail will be received here. Please refer to [login to view URL] 5) Assign Database – It’s required for filling up “registered” column in search result page. This tool will look up into the specified column of database (using these database login details) and will match it with entries in 1st column of the tool. If any entries found same in both column, it will assign it as “Yes” else “No”. MISCELLANEOUS NOTES – [login to view URL] - Manual data Entry - Use Javascript for Auto complete suggestions. It should suggest (while entry happens) if data is already there in database.
ID do Projeto: 279427

Sobre o projeto

10 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
Concedido a:
Avatar do Usuário
Greetings, I am ready to do the two projects. Thanks
$50 USD em 10 dias
5,0 (3 avaliações)
1,9
1,9
10 freelancers estão ofertando em média $207 USD for esse trabalho
Avatar do Usuário
please check my PMB
$250 USD em 15 dias
4,8 (71 avaliações)
8,0
8,0
Avatar do Usuário
Will do it, check PM !
$250 USD em 5 dias
5,0 (140 avaliações)
7,1
7,1
Avatar do Usuário
have a glance at PM. Regards,
$249 USD em 5 dias
4,8 (207 avaliações)
7,1
7,1
Avatar do Usuário
Hi, Please see PMB for demo and more details. Best Regards ... ccpplinux
$250 USD em 15 dias
4,9 (117 avaliações)
6,9
6,9
Avatar do Usuário
Lets do it. USA based web development. Fast & quality. Escrow needed.
$175 USD em 5 dias
4,8 (25 avaliações)
6,8
6,8
Avatar do Usuário
Hi, Focal3, is a team of professionals in Data Management, DotNet, PHP and Testing. We are in the process of developing a team in Java. Please review PM. Thanks Sri
$250 USD em 30 dias
4,7 (11 avaliações)
6,0
6,0
Avatar do Usuário
Analysis - 1 days Design - 2 days Implementation - 5 days Testing - 1 day Deployment - 1 day
$225 USD em 10 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi this is kiran patel, i have 2.5 yrs exp in asp.net/vb.net 2.0 and sql... i can do this job well.. . please see pm for more details.
$220 USD em 6 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, I assure you of the desired results. Have a good experience in vb.net. Please check my PMB. Cheers
$170 USD em 12 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
The kind of Website You are offering to build ,We done a number of such kind of projects and quite expertise in database management tools and sql expertise well waiting for your positive response .what we said is that what we did .Building Your World According To you
$200 USD em 20 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) INDIA
Pune, India
0,0
0
Membro desde jan. 28, 2007

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.