CSV to WordPress Core Block

[krishnathakurwp]

Many times, we come across web platforms that are not very popular. However, data can be exported in CSV or JSON format from these platforms.

Therefore, there is a need for a built-in solution that can convert CSV or JSON files into a core block. This would broaden the scope of data liberation.

[jordesign]

Hey @krishnathakurwp - this is a really interesting idea. Can you explain a little more about what you mean about it being turned into a core block?

[krishnathakurwp]

Hi @jordesign

Let me explain this with an example.

I have worked for some of the schools who use their own custom CMS or LMS developed by some developer or local agency for storing various custom post types with custom fields. That CMS allows exporting data in structured format like CSV or JSON.

For example a school has a custom post type named Lesson Plan with various custom fields.
Now if a school wants to switch from their old CMS to WordPress so that they can create or edit their lesson plan using block editor then what is the solution?

My proposal is, there should be a native tool for WordPress which can map CSV data into WordPress Post using core blocks.

The workflow could be something like this.

1. Export data from old CMS into CSV or JSON.
2. Create a post category (or custom post type) named Lesson Plan.
3. Create a custom post template using core blocks to display a single post for Lesson Plan.
4. Upload & Map CSV data with core block attributes as per custom post template for lesson plan.
5. Run the import process.
6. Now enjoy editing your Lesson Plan inside the block editor.

This workflow can be applied to any type of data which can be exported into CSV or JSON.

[jordesign]

Hi @krishnathakurwp - just looping back to this idea and thinking on it a little more. I do know there are third-party plugins that do more specific mapping of CSV fields to post meta - but I'll leave this open as an idea for future consideration.