Archive

Posts Tagged ‘stored’

Stored Procedure Project

December 18th, 2011 Comments off

This project needs to be using stored procedures, and currently isn’t.

Ms Sql Stored Procedures

November 28th, 2011 Comments off

Read, Update, Insert, and Delete stored procedure writing for approximately 250 tables. So about 1000 stored procedures to write. We will provide table layouts and sp templates.

Job 10 Hours Of Work Aspx Vb Sql Stored Procedures ( 3

September 23rd, 2011 Comments off

I need a programmer to work on my website.

Programmer must have experience in:

– aspx
– sql server
– stored procedures

I estimate 10 hours of work that needs to be done… A variety of task needs to be done.

Fix stored procedures
Add some more functionality to our site

If you do a good job and fast, may turn into permanent job or ongoing jobs

Job 10 Hours Of Work Aspx Vb Sql Stored Procedures ( 3

September 8th, 2011 Comments off

I need a programmer to work on my website.

Programmer must have experience in:

– aspx
– sql server
– stored procedures

I estimate 10 hours of work that needs to be done… A variety of task needs to be done.

Fix stored procedures
Add some more functionality to our site

If you do a good job and fast, may turn into permanent job or ongoing jobs

Modify Stored Procedures Incorrect Changes To Aspx Site

September 2nd, 2011 Comments off

I have a
–few stored procedures need simple changes
–few pages need changing adding more functionality
–query string manipulation with a new form created to send values
–small changes to forms

10 hours of work may turn into long job or more projects… this would take an experienced programmer 5-6 hours but I will pay for 10

Im a programmer myself for 15 years.

Job 10 Hours Of Work Aspx Vb Sql Stored Procedures

August 31st, 2011 Comments off

I need a programmer to work on my website.

Programmer must have experience in:

– aspx
– sql server
– stored procedures

I estimate 10 hours of work that needs to be done… A variety of task needs to be done.

Fix stored procedures
Add some more functionality to our site

If you do a good job and fast, may turn into permanent job or ongoing jobs

Make A Php Script Zip Files In A Folder

June 21st, 2011 Comments off

I have a php scipt called rename.php than runs as a cron job evey night. “rename.php” renames current folders to include today’s date (“Front” becomes “Front_2011_06_19″; “Games” becomes “Games_2011_06_19″ etc) and then creates a new folder “Front” and “Games” for tomorrow’s files to be stored in.

The files stored in the folders are photo snapshots from IP cameras that are stored on server but the number of files is getting too much and ziping each day’s photos when I rename will significantly lessen how many files are stored on the server while still allowing me a chance to view them later on.

I need someone to modify this php scripts so that before it renames the folder each night, it will zip all the files (photos) in each folder into 1 zip file, delete all the individual files, then rename the folder and create a new one to get ready for tomorrow.

rename.php attached

T-sql Scripts

February 4th, 2010 Comments off

OBEJCTIVE:

WRITE tsql STORED PROCEDURES for 1 database to be run as jobs.

The database contains 2 Schemas and 96 tables but no stored produres yet. The stored procedures will only use 20% of all the tables.

TASKS TO PERFORM:
—————–

1. Requirement (1 hour).

Read through the requirement doc as a baseline to create the stored procedures

2.Create the ETL scripts as Stored procedures to transfer data from between the two schemas.(1 day)

3. Stored procedure 1 represents a hierarchic structure in the destination table, I have already scripted this script and you can just plug it into the stored procedure. (1 hour)

4. Create Error handling for all the stored procedure based of the requirement doc ( 4 hours)

5. Write a documentation about all stored procedures

DELIVERABLES:
————–

1. Stored procedures to transfer the data
2. Word documentation about all the stored procedures

PROCESS:
——–
1. I deliver the DDL to create the existing tables and schema
I include only some sample data since it’s too huge

2. You start the work and ask any required information about the role
of each stored procedure if not clear.

3. You deliver the work, I test it on an existing database that I have set up and check everything is working, and pay you immediately.

Mysql Stored Procedure

February 3rd, 2010 Comments off

Hi,

I need to have a stored procedure created where I take, on 15 minute intervals, data from a couple of tables and run them through a small formula, and update a series of records with the result.

Specifics are that two pricing tables (silver and gold) get a price update on 15 minute intervals, and those prices are “cleansed” and then applied to the relevant product records (those that are marked as either au or ag).

Thanks.

Php Paypal Subscription Integr

January 27th, 2010 Comments off

I have site which requires paypal subscription integration also with unsubscribe button.
Now how it should work is … i have my team working on site … but this part needs to be developed by someone who has expreience with paypal integration using IPN.
The case is:
When the customer clicks the subscribe button .. he will asked to login and he validates his paypal a/c or he enters the credit card info as paypal allows it. Once the payment it success the data required for storing in database should be stored along with subscription id and an email should be sent to customer about his subscription along with its details…and show a thank you page. immediately even before the customer clicks “goto merchant” etc..
Now if the payment is not successful, it should just come to the cancel page or try again page etc…

The important actor is the data should be stored only when the payment is susccess, not to be stored temporarily also..

Thanks

Photography Web Site

December 21st, 2009 Comments off

Hello,

I am looking for an experienced Flash/Flex Designer to design and build a very simple website. The website has the following requirements:

- Display a slideshow that will loop through 5 pictures
- Display 2 galleries of pictures similar to the one found in the “gallery” tab of this website: http://www.bfkphotography.com/index2.php
- Contains 6 pages. 1 Page will contain the slide show and static text, 3 Pages will include static text and 1 image, and the other 2 pages will contain 1 of the same gallery, one on each page.
- Content for the pages will be read from metadata stored in external data source (xml, txt, etc)
- A logo has been made and must be incorporated into website
- ALL IMAGES PATHS MUST BE STORED AND READ FROM AN EXTERNAL DATA SOURE (xml, txt, etc)
- ALL STATIC TEXT MUST BE STORED AND READ FROM AN EXTERNAL DATA SOURCE (xml, txt, etc)

Please only EXPERIENCED designers/developers. MUST PRESENT PORTFOLIO!

Categories: Flash, XML Tags: , , , , , ,

Gather Images And Info – Csv

October 29th, 2009 Comments off

The project is a bit simple, but it needs wits.

I need to fetch data from TemplateMonster (images, name, item number, and prices). My website has the intention of reselling templates from them + the service of template customization: all in one bundle.

How the system should work:

1. I need a simple script where I could specify an URL
Example: http://www.templatemonster.com/category/fashion/?from=10&order=date&cat=49

2. The system should download the small thumbnail for each template shown + the medium sized thumbnail that appears when rolling over.
The images should be stored in a folder.

3. I need data stored for each template: name, template number, prices, and the 2 thumbnail filenames. The information should be stored in a CSV formatted file.

I don’t need anything else. Just download images and data from specified URLS from that site. Should be a quick, easy project for a smart programmer. :)

Harvest/parse/stored Website

October 25th, 2009 Comments off

Need expert in xpath/xslt to parse a webpage and store the results into a mysql table.

Take a html page, run through one of the open source tools to convert to well formed xml (xhtml). Then using a stylesheet, parse the page and store into a mysql table. There are probably 15-20 things that need parsing and most of the pages. This needs to be very fast and this will run in realtime to extract data from another site when someone registers on my site. I will use it once in batch mode to extract all of the data from the site, then use it in realtime to extract any changes/updates.

I prefer xpath/xslt because I don’t want to continually update a custom coded parser as the target site changes…

Categories: Java, MySQL, XHTML, XML Tags: , , , , , ,

Content Delivery System

August 29th, 2009 Comments off

I’m looking for some software which can be installed on systems (Windows 2000 / 2003 / XP / Vista / 7) by subscribers and will automatically deliver requested content by launching their default web browser… in essence, a more intelligent, remotely configurable version of the DeskTopPop product.

Content delivery can occur:

1) after a pre-determined period of time (hours), or

2) at a pre-set UTC time

…provided that a period of recent and continued user activity has been detected.

For example, I might decide to have the user’s browser display a URL every 8 or 12 hours, provided that their computer is currently being used and has been continuously used for a short period of time i.e. 5 minutes.

I do not want to have browser windows open simply based on a timer so some monitoring of the keyboard and/or mouse will be required.

The actual current “waiting period” between browser launches and the required period of user activity (both in minutes) before triggering will be specified within the string returned by my server script which also specifies the target URL.

Please also note that the “waiting period” for “time delayed” URLs is the minimum time to wait since the previous URL was launched and is not cumulative i.e. if the waiting time is set to 8 hours but the user does not use their computer for 20 hours then only one URL should be launched (after the required “continuous use” period) and the next URL should not trigger for at least another 8 hours.

The utility should be unobtrusive to the user i.e. must install as an application but be invisible (nothing on the task bar, in the system tray or in the Alt-Tab window / Task Manager) during normal operation.

It is very important that the utility is able to work with all the major browsers and should not trigger false-positives for anti-virus / spyware / adware / malware systems – it should also be firewall-friendly.

A unique, system generated ID should be created during the 1st run process and passed to my server (when appropriate) during communications so that duplicate content can be avoided for each user.

The overall process should be something along the following lines:

a) at 1st run, generate and store a unique “user” ID in the registry, along with the current UTC time (indicating the “last launch” time)

b) immediately contact my server via an http post, passing the user ID

c) server will return the appropriate “waiting” and “continuous use” periods (both as minutes) followed by the “time delayed” URL in the following format: 10|3|yahoo.com

– the returned URL, waiting and continuous use periods should be stored in the registry

d) immediately contact my server via an http post, passing NO user ID

e) server will either return the UTC “activation time” and “continuous use” period (as minutes) followed by the “time specific” URL in the following format: 200911281457|2|google.com OR a “nothing scheduled” instruction in the following format: ||

– if a time-specific instruction was returned, the URL, UTC activation time and continuous use period should be stored (or replaced) in the registry (separately to the “time delayed” information)

f) monitor the time passed since 1st run / last URL launch and most recent period of continuous user activity until:
i) 60 minutes have passed, in which case go to step d)
ii) the pending “time delayed” URL should be launched, in which case go to step g)
iii) the pending “time specific” URL should be launched, in which case go to step h)

g) launch the “time delayed” URL in the default browser, update the “last launch” time in the registry, then go to step b)

h) launch the “time specific” URL in the default browser, update the “last launch” time in the registry, then go to step d)

Notes:

1) the initial “time delayed” URL should not be launched until “waiting” period minutes after the UTC time stored during the 1st run

2) “time specific” URLs should be ignored (i.e. not stored in the registry) unless the launch time is in the future

3) “time specific” URLs take precidence over “time delayed” URLs so if a “time specific” URL is scheduled to launch within the next 24 hours (note that it may have been scheduled for several days already) then any pending “time delayed” URL launch should be postponed until “waiting” period after the “time specific” launch takes place

4) the registry location should be configurable to allow multiple copies of the system to run concurrently and deliver different scheduled content

The following PHP script can be used for testing purposes:

<?PHP
if (isset($_REQUEST['id']))
{
echo “10|3|yahoo.com”;
}
else
{
if (rand(0, 1) == 0)
echo gmdate(“YmdHi”, time() + 480) . “|2|google.com”;
else
echo “||”;
}
exit;
?>

Delphi is the preferred development language but not a necessity.

All, fully commented, source code should be provided.

Any 3rd party code included in the project must be public domain / GNU or similar i.e. no cost for commercial use.

Size and speed / simplicity of installation is important so any potential 3rd party downloads / code extensions i.e. dotNET, are not acceptable.

Confirmation of successful testing on Windows 2000, 2003, XP, Vista & 7 is a requirement.

Load Flv From Xml

August 27th, 2009 Comments off

Load multiple flv stored in xml file stored on webesver using flash WITHOUT using FLV playback. Use video object from the library. The flv movie should play in sequence. No controls is needed (PLAY, STOP, PAUSE E.T.C) Just the video player to play the movie from the XML file stored on a webserver (dont use flash comm. sever). Each flv is 4seconds. I want 2 parts. One should play the multiple FLV video once. The second part should play the multiple FLV video continiously. (No list interface is needed)

Simple Access Analysis Program

August 22nd, 2009 Comments off

Hi,
I need software to analyze my company mobile bills. And do the following.
1.Create a set of reports for each mobile user
a. Each set will report the following
i. Separate SMS cost from voice calls from internet usage

Xbox360 Gamer Tracking Script

August 22nd, 2009 Comments off

I am after a script that will gather all the available information about my XBOX360 Gamertag and store it in a database on my site. I would like the information to be gathered from http://www.xbox.com/

I understand that you need to be logged in in order view this information so the script would have to be able to handle this.

I would like two tables “games” and “achievements” with all the information about the game stored in one and then all the achievement information stored in the other.

For the “games” I would like the following information stored:

Game Icon
Game Title
Last Played Online
My Achievement Score
Maximum Achievement Score
Amount Of Achievements I Have Won
Total Amount Of Achivements That Can Be Won

For the “achievements” I would like the following information stored:

Game Title
Achievement Icon
Achievement Title
Achievement Description
Achievement Score
When Achievement Was Won (if available)

When you log in all this information is made available and the link is http://live.xbox.com/en-GB/profile/Achievements/ViewAchievementSummary.aspx

On each scan if any of this info has changed I would like it to be updated and if anything is new to be added.

Food Coupon Order Site

August 11th, 2009 Comments off

Need programming for site. ________________________________________
Please indicate 3 questions before PM me about job. Don’t show me that you didn’t read this. If you can’t read, obviously you can’t program. It seems like no one reads the description and everyone can do this in 3-5 days so here is the offer.

1. Time you estimate to be completed/Read/Read/Time/Time
2. Complexity to you, if this is difficult, easy, etc.,
3. What you can offer via msg. When you indicate what you can offer, meaning, your skills and level of expertise include yrs, 3 of your best designs. I do not need a list of 20 mini sites. Or one

Food Coupon Order Site

August 10th, 2009 Comments off

Need programming for site. ________________________________________
Please indicate 3 questions before PM me about job. Don’t show me that you didn’t read this. If you can’t read, obviously you can’t program.

1. Time you estimate to be completed
2. Complexity to you, if this is difficult, easy, etc.,
3. What you can offer via msg. When you indicate what you can offer, meaning, your skills and level of expertise include yrs, 3 of your best designs. I do not need a list of 20 mini sites. Or one

Food Coupon Order Site

August 10th, 2009 Comments off

Need programming for site. ________________________________________
Please indicate 3 questions before PM me about job. Don’t show me that you didn’t read this. If you can’t read, obviously you can’t program.

1. Time you estimate to be completed
2. Complexity to you, if this is difficult, easy, etc.,
3. What you can offer via msg. When you indicate what you can offer, meaning, your skills and level of expertise include yrs, 3 of your best designs. I do not need a list of 20 mini sites. Or one

Food Coupon Order Site

August 10th, 2009 Comments off

Need programming for site. ________________________________________
Please indicate 3 questions before PM me about job. Don’t show me that you didn’t read this. If you can’t read, obviously you can’t program.

1. Time you estimate to be completed
2. Complexity to you, if this is difficult, easy, etc.,
3. What you can offer via msg. When you indicate what you can offer, meaning, your skills and level of expertise include yrs, 3 of your best designs. I do not need a list of 20 mini sites. Or one

Development Of Integration

July 7th, 2009 Comments off

We are looking for a programmer to develop the integration between MS Office/Open Office documents (word, excel, etc) and Enterprise Forms (http://www.longnhi.com/), which is a web based workflow engine written in C#.

This integration should be done according to the following requirements:

1.In the application Enterprise Forms we have a Parameters Form where certain parameters of the documents are defined and one of these parameters is an attachment (word, excel, open office, etc) that contains predefined fields

2.When we create a new document in the application Enterprise Forms (which gets the revision number defined in the corresponding parameters document) it should have a button named “Launch Attachment” that when clicked should launch the attachment defined in the corresponding parameters document (described in point 1.)

3.The attachment launched (word, excel, open office, etc) should inherit the values of the fields from the Enterprise Forms document (the fields to be inherited are predefined in a table and are for example Title, Number, Revision Number, Author, Date Created, Date Approved)

4.After completing all the content of the attachment and saving and closing it, the attachment should be stored in a field of the Enterprise Forms document

5.From here on, every time the “Launch Attachment” button is clicked it should open the attachment stored in the Enterprise Forms document (not the one from the parameters document anymore) and the previously inherited fields should be validated with the content of the corresponding fields in the Enterprise Forms document and updated if necessary (as for example Revision Number), and when closing the attachment it should update/replace the attachment previously stored on the Enterprise Forms document

6.The Enterprise Forms document has an approval workflow and after being approved it should become available for the users in read only mode. In case there is a previous revision of the Enterprise Forms document the status of that document must then be changed to “Archived”

7.From here on when opening the Approved Enterprise Forms document or the previous revisions of that document (which are archived), the attachment should be opened automatically in a new window, using a corresponding viewer

8.On the Approved Enterprise Forms documents a “New Revision” button should be available, which should make a copy of the complete document (including the attachment), and this copy should become available for editing again, with the status “In Process” and with the functionalities and workflow described in previous points. In this new copy the field Revision must be incremented by 1.

Large Integer

May 31st, 2009 Comments off

The Problem

The unsigned int type in C requires 4 bytes of memory storage. With 4 bytes we can store integers as large as 232-1; but what if we need bigger integers, for example ones having hundreds of digits? If we want to do arithmetic with such very large numbers we cannot simply use the unsigned data type. One way of dealing with this is to use a different storage structure for integers, such as an array of digits. We can represent an integer as an array of digits, where each digit is stored in a different array index. Since the integers are allowed to be as large as we like, a dynamically-sized array will prevent the possibility of overflows in representation. However we need new functions to add, subtract, compare, read and write these very large integers.

Write a program that will manipulate such arbitrarily large integers. Each integer should be represented as an array of digits, where the least significant digit is stored in index 0. Your program should we able to read in a string of digits and create a struct that stores the big integer.

Your program should store each decimal digit (0-9) in a separate array element. In order to perform addition and subtraction more easily, it is better to store the digits in the array in the reverse order. For instance, the value 1234567890 would be stored as:

index 0 1 2 3 4 5 6 7 8 9
array 0 9 8 7 6 5 4 3 2 1

Note: Although this seems counter-intuitive, it makes the code slightly easier, because in all standard mathematical operations, we start with the least significant digits. It also makes sense that the digit at the place 10i is stored in index i.

Your program should include the following functions:

Development Of Integration

May 25th, 2009 Comments off

We are looking for a programmer to develop the integration between MS Office/Open Office documents (word, excel, etc) and Enterprise Forms (http://www.longnhi.com/), which is a web based workflow engine written in C#.

This integration should be done according to the following requirements:

1.In the application Enterprise Forms we have a Parameters Form where certain parameters of the documents are defined and one of these parameters is an attachment (word, excel, open office, etc) that contains predefined fields

2.When we create a new document in the application Enterprise Forms (which gets the revision number defined in the corresponding parameters document) it should have a button named “Launch Attachment” that when clicked should launch the attachment defined in the corresponding parameters document (described in point 1.)

3.The attachment launched (word, excel, open office, etc) should inherit the values of the fields from the Enterprise Forms document (the fields to be inherited are predefined in a table and are for example Title, Number, Revision Number, Author, Date Created, Date Approved)

4.After completing all the content of the attachment and saving and closing it, the attachment should be stored in a field of the Enterprise Forms document

5.From here on, every time the “Launch Attachment” button is clicked it should open the attachment stored in the Enterprise Forms document (not the one from the parameters document anymore) and the previously inherited fields should be validated with the content of the corresponding fields in the Enterprise Forms document and updated if necessary (as for example Revision Number), and when closing the attachment it should update/replace the attachment previously stored on the Enterprise Forms document

6.The Enterprise Forms document has an approval workflow and after being approved it should become available for the users in read only mode. In case there is a previous revision of the Enterprise Forms document the status of that document must then be changed to “Archived”

7.From here on when opening the Approved Enterprise Forms document or the previous revisions of that document (which are archived), the attachment should be opened automatically in a new window, using a corresponding viewer

8.On the Approved Enterprise Forms documents a “New Revision” button should be available, which should make a copy of the complete document (including the attachment), and this copy should become available for editing again, with the status “In Process” and with the functionalities and workflow described in previous points. In this new copy the field Revision must be incremented by 1.

Website Archiver

May 22nd, 2009 Comments off

Summary:

This project is a website archiver and spider. This archiver will store full websites it has crawled in our database. It will then crawl each website periodically, check updates to those pages (based upon our archived version), and store any pages with updated information (pages with changes).

Details:

In the database, there will be a list of URLs for the spider. The URLs would be similar to: www.scriptlance.com, www.domain.com.

The spider’s purpose is to crawl each website and retrieve it’s HTML code for replication (similar to archive.org). Every page of the website should be archived (i.e., crawl each page for internal URLs and then log the HTML to the database).

Once a website is fully crawled and archived into the database, subsequent crawls will be for the purpose of evaluating changes. If there is a change to any one of the pages on the site, then the spider will archive the latest version by storing the current HTML code.

The archiver will store the following from each page:

Page Title, Page URL, Date Archived, HTML Code (for the purpose of replication on our website).

Replication:
For our purpose, replication means that we will be able to use the information stored in the database (HTML Code) to show a version of this website to our users. The stored page should look near-exact to what the spider stored. If images are no longer around, that is fine. Take a look at the wayback machine at archiver.org to see what I mean by this.

Website Member Area

May 5th, 2009 Comments off

We run a website (www.zameermusic.com). We would like to create a

Justin.tv Exact Clone With Mod

April 3rd, 2009 Comments off

JUSTIN.TV exact clone with modifications, language: croatian

Needs to have all (and I mean ALL) the functions of justin.tv: live Broadcasting, watching, commenting, recording a stream, users can create a clean URL channel. By stopping the broadcast, the URL is still saved, with all comments and recordings. A broadcast URL can be public, private, or user restricted. So that means different types of user accounts also (a free one, a premium one, and one payed commercial type). Everything in Croatian (Bosnian) language.

User sign (registration, e-mail password confirmation, forgot password option etc.) in and watch (in regular size, or full screen), comment on the video stream page (Ajax, no page refreshes to see the updated comments), record a stream, report abuse, share with friends, and use the video stream buffer (can rewind and fastforward the full length of the broadcast).

New backend control panel (controlling all (I mean ALL) functions, features, designs, membership, content, etc) and a backend admin page that will allow me to change the bitrate of the video/audio transfer, so that if I need to accomodate more users, I can decrease bandwidth. We should also be able to easily place ads or related links intro the pages and to menage payed comercial advertising banners on site (size, location etc.).

Each user have a profile page (with unique customable design like it offer justin.tv with predefined templates). User can record own live video webcam sessions broadcasted on mysite and store it in the profile (I can in admin panel specify the max. allowed clips for storing and max. clip size). The free members are not able to upload to profile their stored videos from hard drive or some external websites and store it on their profiles, the members can only store clips that they recorded in a live session on mysite. But, payed gold-member accounts should be able to upload also harddrive stored videos and external videos (because this members pay for advertising and can upload their promo clips). A picture section that allows picture albums, add friends, gifts from other users (the gifts are buyed due points that can be purchased or get free for good profile rating), profile ratings, comments section. The user-stored-video section, if the user has more then one clip, should be in a caroussel player style, see example on www.flashden.net/item/3d-carousel-image-gallery/35967 (their for 10usd to buy, but can also be found for free download).

Good search function for all parts of site. Users are searched by location, male, female, years, picture etc.. Videos are searched by cathegory, user name etc..

I should be able to integrate into every video a add-link on bottom or a banner or advertising text.
All user uploaded pics and videos hould be benchmarked with mysite logo. I should be able in admin panel to manualy upgrade a free member to a gold-member i.e. and to manipulate and higher the members popularity points and live number-counter of beeing watched right now.

The user should be able to send invitation to their friends on myspace and facebook accounts, myspace and facebook should be full supported.

Additionaly, there should be a service which to website-owners offers to integrate the live video service and possibilty to their websites, due some specificated payment plan. Due this service, every website-owner can offer his website an integrated video live chat that uses our services. For example and further details look for Stickam API option on STICKAM.COM.

It is also necessary to provide to users a free mobile streaming option that allows members to stream live videos from there cell phones

Filemaker Database Update

March 30th, 2009 Comments off

Hello, I’m looking for specific design &amp; functionality updates to a custom law enforcement reporting database (designed in FM 9). 25 Users create reports (Standard Incident Reports, BIA Serious Incident Reports) each with its own custom report layouts. These Users have custom permission sets. i.e. Users cannot view each others reports, Supervisors can view all, Captains can make changes and delete records.

The solution runs on a Windows environment hosted by Filemaker Advanced Server 10 solution. Disable startup script from file options this will unlock status area and layout browsing.

New features will include the following:

1. My Forms

Digital Signature Web Site

March 16th, 2009 No comments

Description of Management System of Digital Signatures

We are looking for much secured system based on PKI to be installed on web server which would provide Digital Signatures services online.

Administration

System should have powerful administration panel. Administrator should have a full access to all databases. Administrator should also be able to create, delete, and modify users/sub-users assign different roles and freeze accounts.

System should include the possibility to collect fees for sending signed documents, possibility to give a bonus fee when both sides sign the document. Possibility to store documents and collect fee for that.

Billing should be done automatically on a monthly or annual basis.

System possibilities:

Supported file formats:
WORD, Exel, PDF

User should be able to upload document (Word, Exel, PDF) to the system, sign it and send it to the other part to sign. After another part signs the document, user should see all the contracts in the list (pending, signed, stored, and downloaded).

System should also record all possible data, such as time spend for reviewing the document, date ant time the document was signed, when the document was send, stored, downloaded, and signed.

System should be multilingual. It should be possible to translate and add new languages on the need.

Log in procedure (system should be able to generate user name from numbers and issue code card).

Code card it should be card with 36 codes (codes should be generated by the system and the way it generates the codes can not be guessable)

Password requirements

Password for the first time log in should also be generated by the system in an ungues able way.

Signature requirements.

Signature should be collected from the client of the system. Client signs on the white paper with a blue pencil. Signature is scanned and stored in the system. Signature should include: First name, Last name, id code, scanned signature, date of signature 14 digits reference code of the signature.

If document has to be signed by the company, it should include official scanned stamp. And other additional info about the company (reg. number, VAT code, address, name, bank account number ect.)

After customer fills in the form, administrator should be able to upload all the data to the system and approve the customer.

User log in procedure:

After user enters username and correct password, system should ask user to fill in one of the 36 codes from the code card.

If you have any further questions, please do not hesitate to contact me.

System should be made according to European Union laws: http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=CELEX:31999L0093:EN:HTML

Bear