SQL or PHP for sqlite import


My skills in PHP and SQL are equally low.I want to create a scheduled import of a table in a sqlite database into my MySQL/SuiteCRM.

Which option would you say will be easiest?..

1)creating a SQL event to import data from the SQLite on a schedule
2)a cronjob with a php script
3)an easier way?

There are several ways to trigger this, and they are fairly equivalent, you can choose the one you prefer as a matter of taste :slight_smile:

The cron job with PHP script sounds like a good option. If you want to manage this from within SuiteCRM, make it a SuiteCRM custom Scheduler job (there is a chapter in docs about Scheduler jobs that explains this) and set it’s regularity in Admin / Schedulers.

1 Like

thank you Sir…will try this then