VB Application and PHP script needed

IN PROGRESS
Bids
7
Avg Bid (USD)
$531
Project Budget (USD)
$250 - $750

Project Description:
Application number one

Language: Visual Basic 6.0
Database: MS SQl Server


Table definition MySql Server:

################################################################################################

USE [MyDatabaseName]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_MyTable](
[_OVERSKRIFT] [varchar](1348) COLLATE Danish_Norwegian_CI_AS NULL,
[_INGRESS] [varchar](5051) COLLATE Danish_Norwegian_CI_AS NULL,
[_URL] [varchar](255) COLLATE Danish_Norwegian_CI_AS NULL,
[_OWNER] [varchar](15) COLLATE Danish_Norwegian_CI_AS NULL,
[_CAT] [varchar](15) COLLATE Danish_Norwegian_CI_AS NULL,
[META_SRC_URI] [varchar](512) COLLATE Danish_Norwegian_CI_AS NULL,
[META_PKG_ID] [varchar](36) COLLATE Danish_Norwegian_CI_AS NULL,
[META_PKG_STRT] [varchar](24) COLLATE Danish_Norwegian_CI_AS NULL,
[ORDER_ON_PAGE] [varchar](10) COLLATE Danish_Norwegian_CI_AS NULL,
[PARENT_ORDER_ON_PAGE] [varchar](10) COLLATE Danish_Norwegian_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

################################################################################################

Preperation of database records before export.
In the table above you can see a field called META_SRC_URI. The content of this field will be of this format:

[url removed, login to view];hl=no&rls=com.microsoft%3A*%3AIE-SearchBox&rlz=1I7SUNA_en&num=10&btnG=Google-s%C3%
B8k&as_epq=myname&as_oq=mycity&as_eq=&lr=&cr=&as_ft=i&as_filetype=&as_qdr=all&id=1000111&cat=4703

The last two parameters "&id=1000111&cat=4703" will always be present, but with different values. The length of the parameters will always be the same.
We ned to do a substring(bla.. bla..) on those values and put them into the database table fields _OWNER and _CAT for each table row.

When the preperation of the database records is done, we need the application to extract the data from the MSSql database table into a text file.
The records in the text file must be of such character that they can be written into a MySql database later on. See the table definition for the MySql table and the sample file content below.
The file must be created in a spesific folder on the local server called "Assigned".

Then the application must fetch the files in the "Assigned" folder and upload them to a remote webserver using FTP.
After uploading a file, the file must be moved to another folder on the local server called "Closed" .
If the file upload fails, the file should not be moved.


The application must create a log file that contains; which files were attempted uploaded at what time, the upload status and number of rows in the file.

Example log file:

Filename Tranfercode Err code #Rows Date/time
----------------------------------------------------------------------------------------------------

2009-11-17MyServerName_TIMESTAMP Success 1098 2009-11-17 13:42:55
2009-11-17MyServerName_TIMESTAMP Failure 264 385 2009-11-17 19:12:36

-----------------------------------------------------------------------------------------------------

It must be possible to enter the server address, username and password for the remote webserver in the GUI to create the connection. This information can not be hard coded. This also applies for the path to the destination folder on the remote webserver.

It must also be possible to enter the path on the local server to the "Assigned" and "Closed" folders.
To make this easy, it is sufficient to store this information in a .ini file.

It must be possible to schedule the "file creation part" and the "file upload part" of the application to run at any give time using windows scheduler.

We require a setup package and the source code for this application.
The application name is csmAgent.


*************************************************************************************
Application number two

Language: PHP
Database: MySql

We need a PHP script that allows us to fetch the files that were uploaded to the webserver by the VB application and write the data from the text files into a MySql database table.
The new rows in the database must be marked as new with a "Y" in the "ftp" field.(See definition below)

The script must also initiate the PHP send mail function that will send several e-mails when the insert job is done. The e-mails will be sent to persons selected from the same table based on a distinct select on persons where the rows are new after the insert.

The script must also create two log files that shows the status of the sent e-mails and the status of the insert job. The logfile for the sent e-mails must contain; receivers address, timestamp and status of the sending.
The logfile for the insert job must contain the following:

Filename Create record Err code #Rows Date/time
----------------------------------------------------------------------------------------------------

2009-11-17MyServerName_TIMESTAMP Success 1098 2009-11-17 13:42:55
2009-11-17MyServerName_TIMESTAMP Failure 264 385 2009-11-17 19:12:36

-----------------------------------------------------------------------------------------------------

It must be possibel to schedule the script to run at any given time using the Cron Job panel in the Control Panel on the webserver.

Table definition MySql:

##############################################################################################

CREATE TABLE `class_products` (
`id` int(11) NOT NULL auto_increment,
`owner` int(11) default NULL,
`title` varchar(255) default NULL,
`section` int(11) default NULL,
`shortDescription` text,
`description` text,
`featured` char(1) default 'N',
`price` double default '0',
`display` char(1) default 'N',
`hitcount` int(10) default '0',
`dateadded` datetime NOT NULL default '0000-00-00 00:00:00',
`expiration` date NOT NULL default '0000-00-00',
`url` varchar(255) default NULL,
`notified` char(1) NOT NULL default 'N',
`searchcount` int(11) NOT NULL default '0',
`repliedcount` int(11) NOT NULL default '0',
`pBold` char(1) NOT NULL default '',
`pHighlighted` char(1) NOT NULL default '',
`postnr` varchar(4) NOT NULL default '',
`poststed` varchar(50) NOT NULL default '',
`gate` varchar(50) NOT NULL default '',
`kommunenr` varchar(5) default NULL,
`prePrice` varchar(255) default 'Aktiv',
`postPrice` varchar(255) default NULL,
`epost` varchar(50) default NULL,
`telefon` varchar(12) default NULL,
`navn` varchar(50) default NULL,
`latitude` varchar(255) NOT NULL default '0',
`longitude` varchar(255) NOT NULL default '0',
`tildelt` int(11) default NULL,
`planning` char(3) default NULL,
`planned` char(3) default NULL,
`closed` char(3) default NULL,
`ftp` char(1) default 'N',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=10009 ;

#############################################################################################

Sample file content for insert - one record.

**********************************************************************************************************************************************************

10003, The _OWNER field from the MS Sql server table goes here, 'The _OVERSKRIFT field from the MS Sql Server table goes here', The _CAT field from the MS Sql server table goes here, '', 'The _INGRESSFIELD from the MS Sql Server table goes here', 'N', 0, 'Y', 0, 'NOW()', 'NOW()+365 DAYS', '', 'N', 0, 0, 'N',
'N', '0', 'IKKE AKTIVT', 'IKKE AKTIVT', 'NULL', 'Aktiv', NULL, 'NULL', 'NULL', 'NULL', '0', '0', NULL, NULL, NULL, NULL,'N';

**********************************************************************************************************************************************************

Note! It is important that the auto_increment works when inserting records to the database table.
The last database field called 'ftp' should be set to 'Y' when the record is successfully inserted

Skills required:
PHP, SQL, Visual Basic
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 740
in 16 days
$ 750
in 10 days
Hire matharpa
$ 250
in 3 days
Hire YashpalSingh123
$ 250
in 5 days
Hire GlobalTechInc
$ 400
in 8 days
$ 730
in 12 days
Hire linilogic
$ 600
in 15 days