Laravel with function to upload Excel file, verify and save data into tables

$250-750 USD

Terminado

Publicado

hace alrededor de 2 meses

$250-750 USD

Pagado a la entrega

The successful candidate will create a function that serves to upload and validate data from an excel file to a database. This function should be equipped with the following features: 1. Data Type Validation 2. Data Format Validation This task requires proficiency in database structures, data validation methods, and experience working with Excel file manipulation. The ideal candidate, consequently, should be able to display capabilities in these areas. Their experience in similar projects would be a bonus. Here is the main flow: 1. User upload excel file 2. System will check and validate the data 3. System saves record into multiple tables in a database 2 types of excel files involved. Please check attachments. 3 types of data will be stored into database 1. User profile 2. User farm 3. User plant Detailed flow: 1. User upload excel file and save records in a temporary table with a batch number (Eg: 20240318A) 2. System will check data format for 1 row. If data format passed, proceed step 3. If failed, state which cell has wrong format in the temporary table and jump to step 6. 3. System will check if user profile exists in database. If not exist, insert new record for user profile (3 tables involved). If exist, skip. Proceed for user farm 4. System will check if farm ID exists in database. If not exist, insert new record for user farm. If exist, skip. Proceed for user plant 5. System will check if plant ID exists in database. If not exist, insert new record for user plant. If exist, skip. Proceed step 6. 6. Repeat step 2 for the next row from excel file until the last row. Need to develop using latest Laravel. Display record from the temporary table in a datatable with ajax pagination, can be filtered by batch number, valid/invalid status. Able to export records from the temporary table with invalid status to excel.

ID del proyecto: 37892637

Información sobre el proyecto

67 propuestas

Proyecto remoto

Activo hace 2 meses

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@ismailrehman0331

Hello there, I'm an expert in Laravel development and I can create the function you need to upload and validate data from Excel files to a database. I have extensive experience in database structures, data validation methods, and Excel file manipulation. I understand the main flow of the task and I'm capable of implementing it efficiently. I can ensure data type and format validation, as well as saving records into multiple tables in the database. Let's connect to discuss further details and get started on this project right away. Best regards, Ismail S

$450 USD en 10 días

4,9

(107 comentarios)

6,7

67 freelancers están ofertando un promedio de $463 USD por este trabajo

@mohamedfawzy1996

Greetings, As a Microsoft Excel expert with 10 years of experience, I can help you achieve all your goals! Effortless Automation: I specialize in developing VBA macros to automate repetitive tasks, saving your team valuable time and resources. Advanced Data Analysis: Through powerful formulas and pivot tables, I can transform data into actionable insights that drive informed decision-making. Enhanced Data Management: My expertise in data cleaning, sorting, and filtering ensures your data is always accurate and ready for analysis. Compelling Visualizations: I create impactful charts and graphs that clearly communicate data trends and stories for a wider audience. Improved Workflows: I can customize Excel functionalities to fit your specific needs, improving your team's overall workflow and productivity. I am an expert at the mentioned skills (PHP, Microsoft SQL Server, Laravel and Data Processing) With my dedication to efficiency and results, I am confident in becoming a valuable asset to your team. Let's discuss your specific challenges and how I can leverage Excel's power to streamline your workflows and unlock the value hidden within your data. Thank you for your time and consideration. Sincerely, Mohamed Fawzy

$500 USD en 1 día

5,0

(169 comentarios)

10,0

@n2rtechnologies

Hi there, I checked your requirements and it looks like something we can easily make. I have a few questions regarding the requirements. Can we discuss it in detail? I am flexible in prices, as quality & long-term relationships are more important.

$750 USD en 20 días

4,9

(272 comentarios)

8,4

@raoasghar

With over a decade's worth of experience as a Full Stack Developer and a specialization in Laravel and PHP, I strongly believe I am your best bet for this project. I've handled projects similar to yours which revolve around efficient data management and utilizing Excel files. Bearing expertise in data type, structure and format validations, I can proficiently create the Laravel function to not only upload and verify data from an Excel file but also organize it accurately into multiple tables in your database. For your specific project details, my proficiency in managing databases, validating data format/type and manipulating Excel files will guarantee optimal results. Having accomplished various web solutions from scratch, worked with several content management systems including Laravel, quick turnaround time without compromising quality is my forte. Additionally, my skills extend to displaying records through datatable with Ajax pagination, filtering positional records with a specific batch number or valid/invalid status, and exporting invalid record details back to an Excel file - all important features outlined in your project description. Therefore, I encourage you to hire me today so we can make this happen with swiftness and precision.

$600 USD en 7 días

5,0

(432 comentarios)

8,2

@gauravgargcs

Hello, Hope you are doing great, I have a 8+ year experience in Laravel development, I can do your work as per your work requirements, Let's connect through chat for detailed discussion, Thanks Gaurav D.

$500 USD en 7 días

4,9

(324 comentarios)

8,2

@nabeelawais83

" create a function that serves to upload and validate data from an excel file to a database sir i read your project brief and I will do your project Please review my similar portfolio https://www.freelancer.com/u/nabeelawais83 My Experience in this field for last 10 years and i m very consistent in my work i work almost 20 hours a day i am highly professional and master in Web designing and developing field and i will do a great job on your project if you give me the chance and will make you 100% satisfy from my work . Please come to chat for discuss in details. I'm ready to start your project now. Nabeel

$250 USD en 2 días

5,0

(405 comentarios)

7,9

@globaltechnosys

With over 11 years of web development experience and strong proficiencies in Laravel, Microsoft SQL Server, and PHP, I am firmly equipped to deliver on your project needs. Past projects have leveraged my data validation skills, excel file manipulation knowledge, and ability to build web applications featuring data upload, verification, and storage. My in-depth command of database structures will ensure reliable storage of user profiles, farms, and plants with minimal errors. Where I particularly thrive is in ensuring a seamless flow between different database tables as required in this task. For instance, my expert understanding of the Laravel framework will allow me to create a function that stores records from an uploaded excel file in temporary files batched by date and time before validating them for format and data type compliance. In addition to inserting necessary records for user profiles, farms, and plants into their respective tables with elegantly written queries. Furthermore, you'll enjoy a distinctive advantage in working with me given my proficiency with frontend technologies such as ReactJS, which will allow me to create the custom datatable you require with dynamic AJAX pagination and filtering functionalities based on batch numbers and valid/invalid status. I'll also add convenience by incorporating a tool that exports records marked invalid from the temporary table directly into an excel document while maintaining their integrity.

$500 USD en 7 días

4,9

(223 comentarios)

8,0

@einnovention

Hi there! I'm Asif, and I lead Einnovention, a team of 25 experts with a strong track record on Freelancer.com. Our extensive experience in Laravel and PHP will ensure we can develop the function you need to upload, validate, and save data from Excel files into multiple database tables, just as you've described. We have significant expertise in database structures and validation methods that will be incredibly valuable for this project. In addition to our technical capabilities, we bring a customer-centric approach that prioritizes communication and flexibility. We offer free consultations before hiring so that we can better understand your project's unique needs and tailor our work to meet them effectively. With our "Unlimited repetitions" policy, your satisfaction and project success are guaranteed.

$400 USD en 7 días

4,9

(199 comentarios)

7,7

@AITSoft

Hello,I have read the job description and I am interested in this job. I have 8 years experience in developing products using PHP, Laravel, Data Processing and Microsoft SQL Server. I have read your requirements and am ready to start working for you. My Portfolio: https://www.freelancer.com/u/AITSoft Regards, Shamshad

$750 USD en 12 días

5,0

(15 comentarios)

6,6

@ClearPoint

hi there I would love to utilize php excel dependency and it is pretty simple to me please send me a quick message and let's start working on it now thanks Adam

$500 USD en 1 día

5,0

(76 comentarios)

6,4

@asifalimzd

Hi there, With robust experience exceeding a decade in web development and database management, including Laravel and Microsoft SQL Server, I have consistently delivered high-quality projects on time and within budgetary confinements. I pride myself on my ability to develop creative, efficient solutions to intricate problems, such as the one presented in your project. In my previous engagements, I have frequently worked with Excel files, validating, manipulating data, and saving records efficiently into multiple tables. I understand that your project comprises various layers of validation before saving data into different tables in the database and I can assure you of my competencies in every step of this process. From validating data types and formats to ensuring profiles, farms, and plants already exist or inserting new records as necessary, all functions will be designed to be seamless. Furthermore, as an added benefit of my proficiency in JavaScript and RESTful API Integration can offer a hands-on approach with regards to creating an AJAX paginated table that can be filtered by batch number or validity status while also providing an export option for invalid records. Being adept at all these various technologies adds great value to your project's requirement making it a cake walk for me to build this function for you.

$250 USD en 7 días

5,0

(16 comentarios)

6,0

@b0b90

With over a decade of experience in software development, I believe my skills in Laravel, Microsoft SQL Server, PHP, and Data Processing are a perfect fit for your project. As an experienced professional, I have executed various applications involving complex data manipulations similar to your requirement. My expertise will ensure that I can effectively validate the uploaded Excel file's data type and format before saving them into multiple tables. Additionally, my proficiency with the latest version of Laravel will streamline the development process and deliver an efficient and secure system that you seek. In terms of database structures and data validation methods, I am well-versed to effectively implement each step of the flow you've specified. My profound understanding of the Laravel framework will allow me to save each record according to its respective table quickly while ensuring data integrity through robust checks. This extensive experience not only guarantees a high-quality solution but also ensures a smooth collaboration as I deliver on time and meet or exceed expectations.

$500 USD en 7 días

5,0

(59 comentarios)

6,1

@Hadiibaba

Dear Client, Our proposal outlines the development of a function to facilitate the seamless upload and validation of data from Excel files to a database, incorporating essential features such as data type and format validation. The function will enable users to upload Excel files, which will be validated row by row. Upon successful validation, the system will save records into multiple tables in the database, including user profiles, farms, and plants. Each uploaded file will be assigned a unique batch number for tracking. Validation will occur iteratively, with any formatting errors highlighted and recorded in a temporary table. Utilizing Laravel, we will create a user-friendly interface featuring a datatable with Ajax pagination, allowing users to view and manage records efficiently. Additionally, users will have the option to export records with invalid status to Excel for further review. Our solution emphasizes efficiency, accuracy, and ease of use, ensuring a seamless data upload and validation process for your organization. Cheers, Muhammad H

$500 USD en 2 días

5,0

(57 comentarios)

5,9

@DGM999

Hello Mohd Hairi H., I am Sadat Saeed with 8 years of experience in PHP and Laravel. I have carefully read the requirements for the project involving the creation of a function to upload Excel files, validate the data, and save it into tables. I will develop a robust function that includes data type and format validation, as well as handling user profile, farm, and plant data. I have a proven track record of successfully delivering similar projects. You can review my portfolio here: https://www.freelancer.ca/u/DGM999 Let's discuss this project further in a chat. Looking forward to working with you. Best regards, Sadat Saeed

$250 USD en 3 días

4,8

(41 comentarios)

5,9

@phpmaestro20

Hello, I'm Nitin, a seasoned freelance developer with a dedicated team of professionals. I specialize in Web App, boasting a portfolio of stunning projects with top-notch UX/UX design. My expertise spans Flutter (for both Android and iOS), Laravel, PHP, and Larval, and I bring over 7 years of experience to the table. I've got you covered whether it's websites, applications, or e-commerce platforms. Best, Nitin P

$500 USD en 7 días

4,9

(49 comentarios)

5,7

@UmairAnwar93

Hi Mohd Hairi H. After reading in detail the requirements of your project and concluding that they match my areas of knowledge and skills, I would like to introduce myself. My name is Umair Anwar and I am the lead engineer for Data Processing, PHP, Laravel and Microsoft SQL Server. I have worked for over 08 years in development/Engineering and have successfully done multiple jobs on this and other Freelance platforms. It will be a pleasure to work together to make your project a reality. Please feel free to contact me. I´m looking forward to working with you. I really appreciate your time and remain attentive to any request or question. Greetings Regards Umair Anwar Awan

$700 USD en 20 días

5,0

(5 comentarios)

5,4

@jeghalef

Hello. I am Imad. I have read the description carefully. I believe this project is good fit for me because I have rich experience in this field. I can handle the excel data in web application. Could you provide the example excel file? Thank you

$500 USD en 7 días

5,0

(7 comentarios)

5,6

@ARTICLEYOUWANT

Hello. I am a proficient Laravel developer with extensive experience in database management and Excel file manipulation. I propose to create a robust function tailored to your needs. This function will facilitate uploading, validating, and saving Excel data into your database. It will feature meticulous data type and format validation, ensuring data integrity. Please get in touch with me to discuss more; I look forward to working with you. Thanks.

$250 USD en 7 días

5,0

(41 comentarios)

5,3

@macrolinktech

I can do this function, gone through the project description, I have worked on few similar projects, so I am confident enough to deliver the project in tight deadline. I can start the work right away.

$250 USD en 2 días

5,0

(15 comentarios)

4,8

@abubakarrafi81

⭐⭐FROM EXCEL TO DB DATA SAVING AND UPLOAD IN LARAVEL... MY ALMOST DAILY ROUTINE JOB..I have already did this 2 months ago for my client ... ⭐⭐ Just feel free to discuss ,⭐⭐ i have 5️⃣ Years of experience in this field.⭐⭐If you will work with me i will surprise you with quality of work.

$600 USD en 7 días

5,0

(8 comentarios)

4,5

@amitbhs

With more than 16 years of experience in PHP and Laravel, I am well-equipped to tackle your data upload and validation project. My knowledge and skills in programming match your requirements exceptionally well, having handled similar tasks in the past. I understand that you need a vigilant system that can diligently check the data type and format before saving it into multiple tables. My familiarity with the Laravel framework allows me to create functions that can do exactly that efficiently and accurately. In addition, I've worked extensively on form validation, especially with Excel files, which would certainly come handy for this task. Another crucial requirement you have is showcasing records from the temporary table in a datatable with pagination. I have ample hands-on experience in using AJAX pagination for Laravel DataTables, allowing easy filtering by batch number or valid/invalid status. Moreover, I can provide a feature to export records with invalid status to excel for further analysis. With my skillset, I commit to delivering a system adhering precisely to the flow you've described. When you choose me as your Laravel developer, you get not just my expertise but also a comprehensive understanding of securing websites. My proficiency in JWT ensures that your data is kept safe throughout the uploading and saving process.

$250 USD en 7 días