Скачать или смотреть Converting dd/mm/yy Format to yyyy/mm/dd in Laravel-Excel 3.1 Importing CSV Files

Learn how to effectively import a date column from a CSV file in Laravel-Excel 3.1 and convert it from `dd/mm/yy` format to `yyyy/mm/dd`.
---
This video is based on the question https://stackoverflow.com/q/67633504/ asked by the user 'Pallab' ( https://stackoverflow.com/u/7532254/ ) and on the answer https://stackoverflow.com/a/67733932/ provided by the user 'Pallab' ( https://stackoverflow.com/u/7532254/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Laravel-Excel 3.1 csv import Date column not converting

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Understanding the Issue: Importing Dates in Laravel-Excel 3.1

When working with CSV imports in Laravel using the Laravel-Excel package, developers often encounter challenges, especially with date formats. One typical issue arises when your CSV file contains a date column formatted as dd/mm/yy (e.g., "24/07/20"), and you need to convert this into a format suitable for your database, such as yyyy/mm/dd (e.g., "2020/07/24").

This post will guide you through a practical solution for converting date formats while importing CSV files using Laravel-Excel 3.1.

Problem Statement

In a typical import scenario, the file may look like this:

[[See Video to Reveal this Text or Code Snippet]]

Your existing method for importing models using ToModel may look something like this:

[[See Video to Reveal this Text or Code Snippet]]

As it stands, this method would store the date as it appears in the CSV, which is not the desired format for your database.

Solution: Manual Date Conversion

To solve this issue, we will utilize the Carbon library, which is already included with Laravel for date manipulations. The following steps demonstrate how to convert the date format effectively.

Step 1: Use Carbon to Parse the Date

You can extract the year, month, and day components from the dd/mm/yyyy format like so:

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Reformat the Date

After extracting these components, you can use them to concatenate and format your date into the required yyyy/mm/dd format:

[[See Video to Reveal this Text or Code Snippet]]

This line combines our extracted parts into a single string and reinterprets it as a Carbon date object in the correct format.

Complete Example of the Import Class

Your complete import class should look like this:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

Although the method provided may seem manual and a bit primitive, it effectively resolves the issue of format conversion for importing date columns in Laravel-Excel 3.1. As with many programming challenges, there are often several valid solutions, and the best one will depend on your specific project's requirements.

Feel free to reach out if you have any questions or further ideas on improving this method. Happy coding!