Posts Tagged stored

Transform SQL Query To An Updating Stored Procedure

I have a SQL query that returns 2 columns whice are IDs from 2 tables on a one to one relationship.
I need this to update two table in a MS SQL database using a stored procedure, looping through each row of the query. The query currently matches 1:1 even if there is a dupe and it is important that it only updates 1 matching entry in each table even if there are dupes.

Please see attached sample query and notes.

Tags: , , , , , , , , , , , , , , , ,

Password Storage Application

Build a secure application for an individual to store many id/password pairs. You may use any suitable programming language and cryptographic library. The task requires the ability to select appropriate cryptographic tools and proper use of a cryptographic API.

Password Storage Application

Tags: , , , , , ,

Private Job For Shmai2

custreg.asp?action=login

once logged in custreg.asp code points them to here if login is successful.

custreg.asp?action=goodpass

This page is stored in CustomerRegPages table. pageid is 23 – Good Login. this is the same place you added new cells for pro club form. So just do a quick hack as before. If the user logins and their ALTCUSTID (customers table) has something rather than null then display the new page which will be stored in new cell.

Tags: , , , , , ,

Webbased Timebooking

We need a page for timeslotsbooking.
Built in Asp.Net vb, Mysql-database.

UI:
We like to have a clean nice looking calendarview, that shows free and avaliable times.
All other booked times and unavaliable times should be readonly with no info about the booker. So the user can only see and manage their own booking on avaliable times.
It is supposed that the user clicks on the desired time and then confirm it with another click. And only then the reservation is stored in the database. So the user can click around without submitting, without any stored reservations.

ADMIN:
Admins can set the times to be booked from some simple adminpage. Like every weekday 07:00-16:00, in 30min´s interval, except between 12:00-12:30 and 15:00-15:30 just as an example. Of course you should be able to put these times how they want.
Also an option to close an whole day for bookings, like an holiday.
It has to be an option to set how many bookings allowed per slot. Default 1.

Admins can also see the whole calendar and granted full rights for any changes they want.

Tags: , , , , , ,

WordPress Plugin Expert

Hi, I am looking for WordPress, mysql and php expert to write a wordpress plugin. the plugin will mainly require to pick data using stored procedures and write the data on the custom page.

I will provide the stored procedures and html page design (CSS, images, etc).

Please bid only if you are wordpress and mysql expert, and know how to interact with database using WordPress apis.

thanks.

Tags: , , , , , ,

Data Query And Reporting Module For Existing Application

Module Development needed to work with existing Application which currently collects and stores data in Microsoft SQL Server.

Existing application is written in ASP.net, Cold Fusion and uses MSSQL Database back end

Modules Needed:
Data Query
A query module to allow compound searches of the stored data. Allowing searches and result sets to be stored, retrieved, saved, sorted, emailed and printed. Structures should include all modern page and form user corrections for proper data input.
Result set should also allow charting function so that they can be displayed in graphical layouts when possible.

User Administration Module
This module should allow the administration of users who has access to the application. and The creation of User credentials (user-name and password) and well as all related permissions. All such data is stored in one user table

Reporting Module:
This reporting module will allow users to generate predefined reports as well as custom reports and have them ready for printing and exporting in PDF and other portable document formats. Reports will be a a statistical or of a Detailed nature.

Further and more detailed information will be forthcoming after Developer have been selected.

Tags: , , , , , ,

Iphone Application Food Ordering

Need to develop an iphone application. The iphone application will be suited for online ordering for pizza shops.

It will be basic ordering system with shopping cart facility and checkout.
All menu items will be generated by xml and orders will be stored in a mysql database.
All data will be stored in an online database which i have created.
It will handle multiple shops, shops determined by current location or by postcode.
I can provide psd screen shots and application flow.
I have developed an online version of this but want to create an iphone application.

Tags: , , , , , ,

Senior Joomla Programmer Needed To Write Custom Component

We currently have a client wizard- they do 3 things: survey, upload photos, answer questions (jext survey, jfuploader, ckforms). The answers are stored in 3 separate files. We want them to be stored additionally in one file – that can then be displayed to our designers in a back-end area of the site rather than in admin panel. Needs to be in a readable format that they can simply see.

Urgent
Max Budget: $40

Tags: , , , , , ,

Need To Design A Website

Hi
We would like to build a website similar to the following:

http://www.goodwill.org/

(please navigate through different pages in this template to get clear impression of what we need).
Our preference is to use the existing template mentioned above for customization
Everythig has to be stored as a database to allow convenience of future changes.
The domain and database to be stored at godaddy.com
All images should be different from the current template and contain no people on them.
Main purpose of the site is to provide translation services.

Will discuss about more features with the winner of this project.

Thanks

Tags: , , , , ,

PDF Filling Application

I need an application/script that will fill a collection of different pdf-forms with data and embed a image with a signature in the right place on the form. The forms are stored in a database (MySQL) and information on the form fields and their content is stored in tables in the database.

The application needs to retrieve the correct form from the db, fill the form with the supplied data including the signature image and save the filled-in form in the db.

If a field is not filled by the application for some reason the form field needs to be manually enterable.

The db is running on a Mac OS X server and the application runs preferably on the same machine.

Tags: , , , , , , , , , , , , , , , ,

PDF Filling Application

I need an application/script that will fill a collection of different pdf-forms with data and embed a image with a signature in the right place on the form. The forms are stored in a database (MySQL) and information on the form fields and their content is stored in tables in the database.

The application needs to retrieve the correct form from the db, fill the form with the supplied data including the signature image and save the filled-in form in the db.

If a field is not filled by the application for some reason the form field needs to be manually enterable.

The db is running on a Mac OS X server and the application runs preferably on the same machine.

Tags: , , , , , , , , , , , , , , , ,

Web Cam Recorder Using Red5

Overview

Tags: , , , , , , , , , , , , , , , ,

Help Migrate Data Export Script

Hi,

I am migrating my .net nuke site from one host to another. The new host is in a plesk environment. Everything works except for one script that exports data to an ms access table using a stored procedure.

The access file downloads without any issues but is blank when opened. Obviously there is a problem with the stored procedure that actually does the data export. ( It worked on the old host)

I need someone that is experienced with .NET and a windows server environement to login and troubleshoot why it might not be working.

Tags: , , , , , , , , , , , , , , , ,

Hay Tracker Website Changes

Here are the additions.

Change Copyright 2011 on all pages.

I will create a graphic for "Search", "Join" and so forth and these would work as the buttons due now.

Add Hay Type dropdown labeled "Hay Types" for each of the following:
Alfalfa
Alfalfa/Orchard Grass
Bahia
Brome
Coastal Bermuda
Common Bermuda
Jiggs Bermuda
Kleingrass
Mixed Grass
Oat Hay
Other
Sudan Haygrazer
Tifton 44
Tifton 85
Timothy
Wheat Straw

Admin would be able to add/edit hay types.

There would be a dropdown with the question for the seller when entering inventory.
Was this hay irrigated? The default would be NO. The result would be stored in the database in the field "Irrigated" for this hay.

There would be a dropdown with the question for the seller when entering inventory.
What was the cost to irrigate this hay? The default would be 0. The result would be stored in the database in the field "Irrigated_cost".

There would be a dropdown with the question for the seller when entering inventory.
Was this hay fertilized? The default would be NO. The result would be stored in the database in the field "Fertilized" for this hay.

There would be a dropdown with the question for the seller when entering inventory.
What was the cost to fertilize this hay? The default would be 0. The result would be stored in the database in the field "fertilizer_cost".

There would be a dropdown with the question for the seller when entering inventory.
Was this hay tested for protein? The default would be NO. The result would be stored in the database in the field "Protein_tested" for this hay.
If answered yes the protein percent would be entered in and stored in the database as protein_percent for this hay.

There would be a dropdown with the question for the seller when entering inventory.
Was this hay fire ant quarantined? The default would be NO. The result would be stored in the database in the field "fire_ant_quarantine" for this hay.

There would be a dropdown with the question for the seller when entering inventory.
Can you load this hay? The default would be NO. The result would be stored in the database in the field "load_hay" for this hay.
There would be a dropdown with the question for the seller when entering inventory.
What is the approximate weight of this hay? The default would be 0. The result would be stored in the database in the field "bale_weight" for this hay.
There would be a dropdown with the question for the seller when entering inventory.
Is this organic? The default would be NO. The result would be stored in the database in the field "organic" for this hay.
There would be a dropdown with the question for the seller when entering inventory.
What Were the labor costs for this hay? The default would be 0. The result would be stored in the database in the field "labor_cost" for this hay.

There would be a dropdown with the question for the seller when entering inventory.
What was the cost of pestcides for this hay? The default would be 0. The result would be stored in the database in the field "pesticide_cost".

There would be a dropdown with the question for the seller when entering inventory.
What where the miscellaneous costs for this hay? The default would be 0. The result would be stored in the database in the field "misc_cost" for this hay.
There would be a dropdown with the question for the seller when entering inventory.
What were the fuel costs for this hay? The default would be 0. The result would be stored in the database in the field "fuel_cost" for this hay.

All of these answers and choices would be displayed to the seller in addition to what is currently displayed. The answers would be used for the Cost/Profit Calculator.

Buyers would see the following information for all hay available and would be printable in PDF. Printed text could be a 14 font.
Date added to inventory
Bale Type
Bale Style
Bale Weight
Bale Quality
Bale Quantiy

Tags: , , , , , , , , , , , , , , , ,

Add/Edit Images On My Website PHP/MySQL

I need an admin page or pages to Add and Edit images on specific pages of my site. I need the images to be stored in specific folders and the info for the image to be stored in MySQL DB Table. I also need the images to display in the same size box without being distorted, regardless of the dimensions of the image. (Im assuming geometry will have to be used but im not sure how to do that!)

Tags: , , , , , , , , , , , , , , , ,

ERLANG Large Scale Concurrent Real Time Website Scanning

Im looking for expert consulting on the feasibility (costs in terms of hardware/development) of scanning several million webpages in real-time or close to real time). Longer term employment may result if you can provide a solution that is feasible and within my budget. If youd like this, youd need to write a small mini-program to demonstrate the feasibilty and speed of your proposed solution. Knowledge of Python and mysql are a plus, but not required. This project may close as soon as I find someone suitable (it may not stay open the full 60 days).

Currently we have about several million html (no-rss feed) websites to scan stored in a database. Id like to have them scanned on a real-time basis or a nearly real-time basis because the market data needs to be updated as fast as possible. Im wondering if Erlang can do this.

Currently, these websites are stored in a database and scanned via brute force methods using approximately 1,000 IPs and three servers with xeon hex cores on each. These are all connected to a database server on the same network. With this, the scanning speed is approximatly 1-3 times every 1-2 hours depending on server load. This is too slow for our needs.

Tags: , , , , , , , , , , , , , , , ,

CRE Loaded, Cross Sell With Discounts On Combination Deals

Cross sell function needed with the ability to offer cross sell products at a discounted rate:

We sell bedframes and would like to cross sell mattresses with our bedframes. If a customer wants to add a mattress into there shopping basket then that item gets discounted down.

A perfect working exmaple of what we require can be found here:

http://www.leatherbedsworld.co.uk/p/Alyssa_High_Foot_End_Faux_Leather_Bed.htm?item_id=2631&category_id=244&category_name=All%20Leather%20Beds&group_name=

==========================================================================

We have a heavily customised site; any programming must fit in with this customisation.

Discount structures /rates must be user modifiable, i.e. stored in the database, NO hard Coding of variables.

Discounts granted should be stored in the appropriate field in the Orders total table.

Tags: , , , , , , , , , , , , , , , ,

Google Apps

I am looking for a simple programming to streamline my google doc file management.
If on sharepoint you can add meta data to each file you upload (then easier to search) then in google docs this feature does not exist.
I would like to receive a quote on simple document management feature that would collect meta data on each file, assign serial number to each file stored on google doc and allow me to search by all the data stored on meta file.

thank you in advance,

Tags: , , , , , ,

Web Crawler / Data Cleanser

Skills required:
mySQL stored programs, Hibernate, Spring, JDBC, threaded programming, SVN

Much of working code already exists – this is mostly a refactoring and documentation project. Will work with an experienced Java developer Project Lead / Architect. We are NOT using Lucene.

Web Crawler
Analyze existing functioning code base, refactor to improve maintainability
Implement new features to allow crawler to crawl more sites with minimum of configuration changes
Refactor crawl process to handle 1000s of crawling threads with good performance
Refactor crawl process to crawl targeted sites several times a day with good performance
Document refactored code implementation
Document configuration process and crawling process
Work with Project Lead to make crawler operational on production servers (hosted remotely)

Data Cleanser – Develop 100% new Java code, calling existing mySQL stored programs (SP), refactoring mySQL stored programs, writing new stored programs. Documentation of what code calls which SP, which SP does what etc is 40% of the work.
Analyze patterns of crawled data to identify errors and potential errors
Analyze existing data cleansing mySQL stored programs (70% existing)
Refactor existing stored programs, develop new ones and maintain data cleansing stored programs
Develop using Java, mySQL stored programs to create data cleansing process
Document developed systems
Work with Project Lead to make Data Cleanser operational on production servers (hosted remotely)

Tags: , , , , , , , , , , , , , , , ,

PHP Image Gallery

Need to add a php image gallery directly to a php profile page for a directory website. Gallery needs to be similar to SimpleViewer software. All images are stored on the server and image file locations stored in SQL tables. Profile page already built to pull in the correct row from database.

Tags: , , , , , , , , , , , , , , , ,

Database Expert To Answer 7 PL/SQL Questions ASAP!

You are required to look at a database and answer 6 questions.

3 questions are simple SQL queries
4 are PL/SQL cursors, PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers.

I will provide you with the database in text files.

This should not take an expert more than 4 hours to complete.
You have to explain to me how to excecute the SQL and PL/SQL.

The budget is $20 – $30.

I want this done quick so only fast workers please.

Tags: , , , , , , , , , , , , , , ,

An Application Transfer From IPhone To Android

We are looking for a programmer in order to transfer an existing iPhone application to the Android platform.

This application is a quiz. The questions are stored on a server. The customers answers should also be stored on the remote server.
The main requirement for the application is an attractive GUI and audio, graphic and sound files are provided.

The project is to be accomplished in 15 days.
In order to get details and specification you have to sign the NDA .

Budjet: $ 200-250 USD.

Tags: , , , , , , , , , , , , , , , ,

Microsoft SQL Stored Procedures

I am looking for someone to occasionally write stored procedures (sps) for my ongoing project. I have two full time programmers working on this currently. One is proficient with sps and the other is not. I just need someone to help when needed. Personally, I feel the sp level required is above average to complex. I will require to see some of your completed sps to review the skill set and professionalism

Tags: , , , , , , , , , , , , , , ,

Setup Dedicated Server To Backup To Amazon S3

Ive just purchased a dedicated server to host around 10 websites for a client.

I want all sites i add into the dedicated server along with sql, mailservers, etc to be backed up daily stored on the server and also stored on my amazon s3 storage space.

If possible I would like some sort of automation added so that old backups are deleted automatically & probably a bit of instruction on how to manage this my self.

As you may have guessed I dont know an awful lot about this, hence the job on here.

The dedicated server is a quad core server, with plenty of space, and has cPanel installed.

Tags: , , , , , , , , , , , , , , , ,

Setup Dedicated Server To Backup To Amazon S3

Ive just purchased a dedicated server to host around 10 websites for a client.

I want all sites i add into the dedicated server along with sql, mailservers, etc to be backed up daily stored on the server and also stored on my amazon s3 storage space.

If possible I would like some sort of automation added so that old backups are deleted automatically & probably a bit of instruction on how to manage this my self.

As you may have guessed I dont know an awful lot about this, hence the job on here.

The dedicated server is a quad core server, with plenty of space, and has cPanel installed.

Tags: , , , , , , , , , , , , , , , ,

Iphone Sound Pattern Detector

Detect particular sound pattern and make a phone call to a pre-defined phone number after it is detected.

The app will have some previously stored sound files (wav file, for instance). Each file will have a length of about a few seconds.

The app has to continuously listen what is received from the microphone and show in the screen a number indicating the "similarity" of what is hearing with the previously stored sound files, in a scale from 0% to 100%.
In case it is over the threshold (say 80%), it will make a phone call to a pre-defined phone number.

Tags: , , , , , , , , , , , , , , , ,

Caller Info

The application is to work on Android Mobile devices such as Nexus one, Sprint Hero and etc… . The application is very simple. A popup window appears upon a person call you or you dial a number to call a person. This popup window searches the contact database and if a persons number is stored there it will fetch it and show the name and number on screen. if the number is unknown or not stored in the contact database, the program should fetch those numbers from a local stored database (MS SQL Compact)(4 databases in total all in .sdf format) this shouldnt take a second to search the local database and should appear immediately . in the same popup window there should be a hide button and add to contact button. In addition to that a small program that will be used offline to search these databases in numbers or names. all names are stored in Arabic language so the program should be able to handle Unicode.

also the program should have some sort of security to prevent it from installing on other devices without a permission.. i.e. the ability to lock the program to a specific device via IMEI # or ESN # and this should be hard coded to the code.. and should support Unicode

in general the application should function like this one here

http://www.truecaller.com/?p=phone_android&os=Google%20Android

Tags: , , , , , , , , , , , , , , , , , , , ,

Photoboof Addon

I have a program that runs a photo booth, its name is Photoboof (demo copy available free. The program takes 4 pictures, makes a strip out of them and prints of the strip. The pictures are placed in one directory the strips in another. I need a program that integrates with this program through a command line code. The program needs to accept smtp info for my server. It needs to find the "Last" strip created in the directory, resize it, and send it to 1 or more imputed addresses. The emails need to be stored in a file. If no internet connection is available(or an option to turn on or off) the emails need to be stored for emailing at a later time. This process needs to be completed quickly with a minimum of resources being used. The program needs to be running in the background and not restarted each time. The imputed info will be done on an external ELO touchscreen monitor. I have an older program that did some of these things attached.

Tags: , , , , , , , , , , , , , , , ,

MSSQL Procedure

I have a very small project. I need a report modified in a sql stored procedure. Probably would take less than an hour for someone. We need to modify an aspx page and the stored procedure. Good with MSSQL.

Tags: , , , , , , , , , , , , ,

Number De-Dupe System

The Project is to develop a system that will de-dupe large quantities of numbers.
The numbers will be from 8 to 12 digits in length and contain upto 1 million records per batch, each project could end up with as many as 20million records. So the program would have to be efficient in order for the de-dupe process not to take too long.
1. Setup a specific project in which to upload numbers

Tags: , , , , , , , , , , , , , , , ,

A Software To Decrypt An Encoded String, Stored In Registry.

I have a code written in C. I need a programmer who can convert this C code to C#.NET or Visual Basic 6 (preferable), A GUI based software.

Tags: , , , , , , , , , , , , , , , ,