From: Nathan G. <nat...@gm...> - 2011-06-27 14:07:18
|
On Sat, Jun 25, 2011 at 12:55 PM, hansa <ha...@ha...> wrote: > Hi all, > > could someone give me some coding help... > > I regularly receive excel files containing time schedules for some users of > my egw installation. > Up to now workflow was: open, find out own appointments and insert them into > the egw-calendar. > > To get rid of this time consuming process I wrote some short php scripts to > upload the content of the xls files to several mysql tables. > Next step would be to insert them into EGW... Unfortunately I don't know how > to do this. > Calendar-Data look very complex to me within the EGW db (egw_cal, > egw_cal_dates, ...). > > So what I would need is a mysql statement that covers all the needs of EGW > to insert an accurate appointment. Consider importing from CSV. You can save the spreadsheet as a CSV, then use import/export to get the records in. Nathan |