Devam Ediyor

Import CSV file to MS SQL and search out matching posts

We need to import a CSV file containing bank payments.

The reference from the bankpayments must be matched with expected payments in our coresystem. The coresystem is accessed via a SOAP webservice.

The tricky part is the reference number, which is not always written in the right syntax. So the registered payments will have to be formatted so that the syntax is right.

Before listing some of the registered deviations the syntax of file number is to be defined: xxxxxx-y-zzzzz,

• xxxxxx, - can vary from three to six digits (defined from the customer number)

• y - a single figure can be numbers 1-4 (defined by the source of the case)

• zzzzz - a serial number that varies 00001-99999 (basically just en incremental value).

Below are listed some of the journal number formats that we have received (the list is not complete):

• xxxx-y00121 (no separator)

• xxxxx-y <line break> -19 (line break in the reference number, not enough numbers in the incremental value)

• x line breakfast xxxx-y 00003 (line break in the reference number, no separator)

• xxxxy02185 (no separators)

• xxxxx-y-0009 (not enough numbers in the incremental value)

• xxxx-y01550 (no separators)

• [url removed, login to view] (dots used as separator)

• y xxxxx 00006 (spaces used as separator)

• xxxxx-y-00036 +00035 (Two reference numbers written as one)

• Furthermore all numbers can be mistyped.

Name and address information

In cases where there is no matching file number - is the only option left to search any payer name and address information in the core system.

The following is a short list of registered discrepancies in payer information:

• Names and addresses do not match with the payer

• Sender Name X Address, Zipcode, City - Debtor: Name Y, Address, Zip code, City

• Name, line break, line break, Zip code, City


The message box gives obviously crucial information, most often here are the file number shown, but sometimes the messages are subject to challenges.

The project is ecpected to start at the end of August 2010.

We will supply a development environment - either on our location - or as a local setup. No SQL server setup needed.

Beceriler: .NET, AJAX, C# Programlama, SQL, XML

Daha fazlasını görün: import csv sql soap, value city, system challenges, single match, search, search here, search challenges, not always right, names and numbers, ms project xml import, ms project import xml, import ms project, import journal, development challenges, code search, code challenges, challenges in development, challenges development, c# challenges, all challenges, out right, out source net, zip code search, SQl server DEVELOPMENT, sql import

İşveren Hakkında:
( 3 değerlendirme ) Odense SO, Denmark

Proje NO: #758430

49 freelancers are bidding on average $878 for this job


Hi Please check PM for more details, regards - Frank

in 25 gün içinde1500$ USD
(6 Değerlendirme)

We are a professionally managed IS0 9001:2008 certified web development company. Our team has extensive experience and we have provided services to reputed companies in US, UK, CANADA & Europe. Currently we have around Daha fazlası

in 20 gün içinde1000$ USD
(2 Değerlendirme)

We have experts in our team who does excellent data import!! More details on PMB..

in 10 gün içinde750$ USD
(1 Değerlendirme)

Hello Sirs. I have more than 10 years in programing and currently work on system implementing where often we need to migrate data from old to new system. Also, I have been worked on data synchronization between system, Daha fazlası

in 7 gün içinde800$ USD
(1 Değerlendirme)

hi, please start a PMB for discussion.

in 20 gün içinde750$ USD
(7 Değerlendirme)

hi, i am having 5+ years of experience in .NET/SQL Server. thanks,

in 20 gün içinde750$ USD
(3 Değerlendirme)

Dear Michael, Hope you are doing well, I am Tushar from Appwriters. We are into business more then 4 years and developed several web and window application using microsoft technology, we are microsoft certified Daha fazlası

in 20 gün içinde1200$ USD
(1 Değerlendirme)

I like to undertake this project. For more information please Check PM.

in 14 gün içinde750$ USD
(1 Değerlendirme)

I have a 9 year experience with MS SQL ( 2k, 2k5 2k8 ). Since 2003 year I'm Microsoft Certificated Professional. Thanks.

in 10 gün içinde800$ USD
(6 Değerlendirme)

Dear Sir, we are expert team about php, mysql , java with 10 years experience Please contact with me by [s.k.p.e] : vietnamefreelancer Thanks

in 12 gün içinde750$ USD
(1 Değerlendirme)

Hi, I am interested to work on this project . Please find more details in your PMB. Thanks, Manoj.

in 25 gün içinde750$ USD
(3 Değerlendirme)

Please Check PMB

in 3 gün içinde750$ USD
(4 Değerlendirme)

I'm an experience Data Analyst with > 10 years experience in data analysis & data parsing. I hope my experience & skills can help you on the project.

in 7 gün içinde750$ USD
(0 Değerlendirme)

I have 3 years of experience in .net programming and ready to do your project.

in 12 gün içinde750$ USD
(0 Değerlendirme)

I possess 2 years of experience in Web Development. My strengths are in ASP.Net,,,VB 6.0, Sql Server 2005, AJAX, Silver Light, WCF, WPF, LINQ, MVC, 3-tier architecture, JQUERY,Java Script, Custom Control, Daha fazlası

in 20 gün içinde800$ USD
(0 Değerlendirme)

Dear Sir,I have more than 3 years of experience of [url removed, login to view] Server Programming. Previously i have completed the tasks similar to [url removed, login to view] give me the chance to show you my talent. You can view some of the sites i Daha fazlası

in 25 gün içinde800$ USD
(0 Değerlendirme)

Hi, Please check PM for more details, Mahesh

in 20 gün içinde1000$ USD
(0 Değerlendirme)

Please check PMB for details, Thank you

in 10 gün içinde800$ USD
(0 Değerlendirme)

I have previously developed an app that manipulated csv data for import into an accounting application. I would like to work on this project.

in 30 gün içinde750$ USD
(0 Değerlendirme)

i can complete this project from off site

in 30 gün içinde1150$ USD
(0 Değerlendirme)