Bulk data import and export with cron tasks

System Information
  • Strapi Version: 3.3.4
  • Operating System: ubuntu 20.04
  • Database: Mysql
  • Node Version: 14.15.1
  • NPM Version: 6.14.9
  • Yarn Version: N/A

I want to import data from my local excel file and create entry one by one in specific time. is it possible? also, it would be great to have import data feature for good.

This is a feature I needed too.

I started by following this tutorial - How to create your own plugin on strapi (1/4) - it lets you import a CSV file and map your column headers to existing content fields. Its works okay, but has no update functionality, the media (images, etc) feature no longer works since the plugin was created before breaking changes, and it provides no logic for relations.

All that being said, it did provide a good starting point for me to create my own plugin more closely tailored to my needs.

My version uses the Google Sheets API. After the import completes I write the ID back to the sheet, I also save the sheet ID to the database so future updates are easier. I also wrote in custom logic that allow me to create relations.

In terms of setting something like this up as a CRON job, I am sure it is possible, but I haven’t used that feature yet.

brilliant, im using google sheet too, and trying to sync the data from google sheet to Strapi, but stuck on datetime format, thank you for your suggestion.