Em Andamento

ASP file manipulation script

This needs to be an **ASP script** and I am looking for someone to **have it done by 11:00 AM EST on Wednesday**.

You are working with two different data sets;

The first is a SQL server table:

CREATE TABLE [dbo].[RejectRecords](

[OrderID] [int] NOT NULL)

GO

Then you have a text file called [url removed, login to view]

In [url removed, login to view] each line will be a separate record and look something like this:

<Package ID=''><MailClass>FIRST</MailClass><WeightOz>6.5</WeightOz><Services DeliveryConfirmation='OFF'/><ReferenceID>6583<ReferenceID/><ToName>John Doe</ToName><ToCompany></ToCompany><ToAddress1>123 Any St</ToAddress1><ToCity>Big City</ToCity><ToState>CA</ToState><ToPostalCode>94583</ToPostalCode><ToDeliveryPoint/><DateAdvance>1</DateAdvance><ToCarrierRoute/><ToReturnCode/><ToReturnCode/><Status/><PIC/><FinalPostage/><TransactionID>6583</TransactionID><TransactionDateTime/></Package>

The file will have thousands of lines (up to about 4000) with each Package container on a new line.

Your job is to walk through the data and create two new files. [url removed, login to view] and BadPostage.xml.

You will need to evaluate each line of the XML file and look at the number inside the <ReferenceID> tag. In the example above it is 6583. Now, if 6583 is in the SQL RejectRecords table (as [url removed, login to view]) then this <Package> line should be moved to the BadPostage.xml. If 6583 is NOT in the table, then it should be in the [url removed, login to view] file.

There may be records in RejectRecords table that do not exist anywhere in postage.xml.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

ASP, SQL 2005

Habilidades: Vale Tudo, ASP

Ver mais: may 11. 2008, container hire, script installation services, st place, asp sql, text manipulation, number manipulation, asp xml sql, line asp, sql create script, file exist, script xml file sql, party anywhere, 2008 asp sql, text file create form data, script sql table, xml form script, null software, xml job site script, file manipulation program, install sql script, pic coder hire, pic web example, need someone null script, table create script

Acerca do Empregador:
( 111 comentários ) scottsdale, United States

ID do Projeto: #3011227

Premiar a:

hwanghendra

See private message.

$46.75 USD em 1 dia
(245 Avaliações)
6.2

6 freelancers estão ofertando em média $51 para este trabalho

trustedcoder

See private message.

$51 USD em 1 dia
(40 Comentários)
5.3
khamoshmujahidvw

See private message.

$68 USD em 1 dia
(4 Comentários)
1.4
mindworksolution

See private message.

$68 USD em 1 dia
(1 Comentário)
0.5
ashishbharti

See private message.

$8.5 USD em 1 dia
(3 Comentários)
0.0
ultracodersl

See private message.

$63.75 USD em 1 dia
(0 Comentários)
0.0