Import TXT/CSV into MSSQL Table with mapping of fields (PHP Portal)

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Hello all, I have an existing PHP portal. I am looking for a developer to code up my file import page. I have attached some reference files.

On import, it will get the mapping/rules from a table for that import scheme selected. You will see the rules for each field in MappingRules.txt.

This is specific to LoaderID=3. The "LoaderField" tells you which column in the TXT to use.

As an example take "+447542702658"

You will see 3 rules.

1. Remove "

2. Replace +44 or 44 with 0 at start of field

3. Replace all instances of Rule value 1 with value 2

This will convert the field to... 07542702658

After applying all the rules, it will then insert all rows into a MSSQL table. The table is already created. I can give you more details in PM.

Thanks

HTML MySQL PHP SQL Website Design

Project ID: #18754400

About the project

20 proposals Remote project Active 5 years ago

Awarded to:

RockStone435

Hello, Nice to see your project posted here. I have read details. As far as I am getting you, you want to create an import process which can be used to import the CSV/TXT file into your database. I understand that t More

£70 GBP in 3 days
(658 Reviews)
8.9

20 freelancers are bidding on average £154 for this job

widadsaghir1993

Hi there. As php and mssql expert, I am very glad to see your project. Just read your job description and attached files with care. and I think it's very suitable project for me. If you give me your project, I can More

£150 GBP in 3 days
(109 Reviews)
7.4
claudiu07

Hi, I have extensive experience working on custom CMS/web applications in PHP/MySQL. I'll be happy to help you out. Cheers.

£144 GBP in 3 days
(61 Reviews)
7.4
topithub

hello, We can create this import functionality for your website. We can create detail import feature so you can map csv fields with db fields and will also add other features that can ease your work.

£150 GBP in 3 days
(43 Reviews)
6.8
michealperfect

Hi Sir, I hope you are well. I have gone through your requirement we can do that for you. Please message me so we can discuss more. I am waiting for your reply. Thank you. Michael

£250 GBP in 5 days
(207 Reviews)
7.1
brightstar928

⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ Hi I read your job description carefully and I can do your job perfectly. I have developed many websites So I can know what you mean and I am ready for you now. If you hire me, I will finish your job A More

£100 GBP in 3 days
(54 Reviews)
6.5
asadrana91

Hi there, this is Asad. I have a vast experience in web development tasks. I have understood your requirements and I believe the task can be achieved with javascript/jquery. We can add a validation before the data is b More

£150 GBP in 5 days
(63 Reviews)
6.5
pakistansolution

Hello.! I'm a full stack web developer. I'm a great command on PHP. I have so many years of experience in core PHP. Please check my recently done project for PHP https://surmawala.pk. I'll do fast work and quality work More

£200 GBP in 3 days
(92 Reviews)
6.3
rabhardwaj

I mainly work with API Integration project.I have passion about API. I have been in this field for more than 7 years. i have experience in C#,php,Perl,wordpress,Html,postgress ,Ubuntu,Crontab,Web Services, Rest Api, More

£150 GBP in 1 day
(22 Reviews)
5.7
soshiv

Hi, I can help you to create a script according to this rule. please come over chat and discuss in details. Thanks. ....

£122 GBP in 3 days
(43 Reviews)
5.3
ludiac

Hi there, We have reviewed the details of your project. Really easy to understand, thanks for the technical description. It can be code within a couple of days. Please ping us anytime to get started with discussion. More

£150 GBP in 3 days
(18 Reviews)
5.6
naishodayo

How are you today? I have seen your proposal carefully, and I am very interested in your project. I am a senior full stack developer. I am confident to complete your project perfectly by your requirements. Please c More

£150 GBP in 7 days
(6 Reviews)
4.9
denimarfernandez

Hello, I'm an expert and efficient PHP developer. I could help you do a file import mapping to your MS SQL database. I could also add functionalities like to display the result of the imported file in table view before More

£222 GBP in 3 days
(1 Review)
1.0
artirajora

Hello We are team of smart developers working in IT industry from past 7-years have developed 200+ simple and complex Mobile phone apps for Android & iPhone, Hybrid app and many Websites in RubyOnRails,WordPress More

£250 GBP in 3 days
(4 Reviews)
0.0
rgill71

High-quality Link Building, Technical SEO audits, Comprehensive Niche Analysis, Keyword plans and Promotional campaigns. Over the last 10+ years I've improved rankings and reputation of a wide range of websites, 150 More

£150 GBP in 2 days
(0 Reviews)
0.0