I have an organisation which maintains a member list in an Access database, we would like to ensure that the website member list matches that held by the organisation secretariat. Rather than reinventing the wheel does anyone have a routine to synchronize an Access table with a matching custom table in Modx?
Thanks
Jim
Give a man the answer, and he’ll only have a temporary solution. Teach him the principles that led you to that answer, and he will be able to create his own solutions in the future.
-
☆ A M B ☆
- 24,524 Posts
Probably the best thing would be to save the Access (Access??) database as a .csv file, then import that into your MODx table. Usually a cron job automates such a process. Any script can load the .csv into the MODx table, I'd be inclined to use a perl script for that.
Thanks Susan
That was my inclination, but wanted to fly it past the forum and see what other ideas might be out there.
Jim
Give a man the answer, and he’ll only have a temporary solution. Teach him the principles that led you to that answer, and he will be able to create his own solutions in the future.
