Migration scripts between Xgest and Odoo ERPs
R and Python scripts that export customers, suppliers, articles and helpdesk tickets from the Xgest ERP (MySQL) as CSV files ready for Odoo.
Each R script reads one kind of Xgest record (customers, suppliers, or articles and stock) and writes it as CSV for Odoo. You need R with RMySQL, BBmisc and stringr, and MySQL access to the Xgest database. Set the dbConnect() host, user and password at the top of the script you need and the output path at its end, then:
Rscript ClientesSAF14.RcalcIBAN.py (Python 2) computes Spanish IBANs; tickets/importTickets.R converts a Web Help Desk ticket export.