In Progress

Import attendance

Hi I need to imprt the attendance iin mysql database using codeigniter. below is my table structure and attached excel file

CREATE TABLE `prl_attendence` (

`id` int(11) NOT NULL,

`branch_id` int(11) NOT NULL,

`emp_id` int(11) NOT NULL,

`attendance_date` date NOT NULL,

`in_time` varchar(100) NOT NULL,

`out_time` varchar(100) NOT NULL,

`leave_status` int(11) NOT NULL COMMENT '1=present,0=absent,2=leave,3=swap',

`shift_name` varchar(100) NOT NULL,

`late` varchar(100) NOT NULL,

`overtime` varchar(100) NOT NULL,

`leave_type` int(10) NOT NULL COMMENT '''1''=>''Late'',''2''=>''Short'',''3''=>''Half'',''4''=>''Absent''',

`is_deleted` int(11) NOT NULL,

`deleted_by` int(11) NOT NULL,

`deleted_date` datetime NOT NULL,

`ip_address` varchar(20) NOT NULL,

`created_by` int(11) NOT NULL,

`modified_by` int(11) NOT NULL,

`modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

`created_date` datetime NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--

-- Indexes for dumped tables

--

--

-- Indexes for table `prl_attendence`

--

ALTER TABLE `prl_attendence`

ADD PRIMARY KEY (`id`);

--

-- AUTO_INCREMENT for dumped tables

--

--

-- AUTO_INCREMENT for table `prl_attendence`

--

ALTER TABLE `prl_attendence`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

Skills: PHP, MySQL, Codeigniter, HTML, Software Architecture

See more: i have about 225 emails from which i need to have certain information transferred to an excel sheet there are 4 fields that i ne, logo design studio 4.0, paccad packing designs version 4.0, mobile attendance, zoho attendance, attendance report, zoho people, zoho attendance api, online attendance app, at my attendance, digital attendance, photoshop 4.0, using the design view of website 4.0, dotnet 4.0, expression web 4.0, mvc 4.0, rhinoceros 4.0, silverlight 4.0, 4.0 graphic design shoes, album design 4.0 for photoshop

About the Employer:
( 1 review ) GHAZIABAD, India

Project ID: #26544198

Awarded to:

ankitmalik05

Hi, I'm a web and Api(Python and Php) developer and have 7 years experience I will provide you quality work according to your instructions. So please award me the project or send me message so that we can discuss it mo More

₹1000 INR in 1 day
(0 Reviews)
0.0

8 freelancers are bidding on average ₹969 for this job

dpwebdeveloper

Hi I have 5+ years experience in web development . I can make function to import xls according to given table structure . we can discuss more about in chat Thanks

₹1500 INR in 1 day
(23 Reviews)
4.6
gbytesoft

Hi, I can Import your database , I am Codeigniter and laravel Expert having 10+ years of Experience Message me so we can discuss more. Thanks.

₹600 INR in 1 day
(20 Reviews)
4.2
shashilal

I am indivisual software developer having 7 + years exp in Php,cake,codiegnator and wp,I have completed many web based project in all areas like edu,real estate,insurance,ecommerce. etc.

₹1050 INR in 1 day
(27 Reviews)
3.7
GovindSinghMca

Hi professional developer here , i am interested in your project please sent me msg so that we can discuss more i can do this task in few minutes and i am immediately available for your help Thank you

₹1000 INR in 1 day
(2 Reviews)
2.7
awaisrafaqat2300

Hi,  I have gone through project description and understand it very well.  I have working experience in website developments using HTML, CSS, Bootstrap, JavaScript, PHP and phpMyAdmin. I can assure you to give my 100 More

₹1050 INR in 3 days
(2 Reviews)
2.1
anjna123

Hi, I see that you requireto import database. Let us know your details requirements so we could analyze it and start working. I have 7 years experince in PHP, 2.5 years experince in Codeigniter and 4.5 years in laravel More

₹700 INR in 1 day
(1 Review)
0.4
Englishtyper

I know all the things in SQL because am I studied in engineering college with cs branch and know programming languages.i don't have to change any errors. So, please hire me.

₹850 INR in 2 days
(0 Reviews)
0.0