search

quantrocket / planlogiq

Automatically exported from code.google.com/p/planlogiq
0 stars 0 forks source link

Add all information to import from immo #26

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
SOURCE OBJEKT target tm_organisation

Original issue reported on code.google.com by Philipp.Frenzel@googlemail.com on 5 Jan 2010 at 6:36

GoogleCodeExporter commented 8 years ago 
added ta_bankkonto for konto information
linked to organisation over idtm_organisation

Original comment by Philipp.Frenzel@googlemail.com on 5 Jan 2010 at 6:51

GoogleCodeExporter commented 8 years ago 
added ta_objekt for additional information
linked to organisation with idtm_organisation

Original comment by Philipp.Frenzel@googlemail.com on 5 Jan 2010 at 7:23

GoogleCodeExporter commented 8 years ago 
DIFF for SQL Server

Original comment by Philipp.Frenzel@googlemail.com on 5 Jan 2010 at 7:35

Attachments:

GoogleCodeExporter commented 8 years ago 
ALTER TABLE `pl`.`ta_bankkonto` CHANGE COLUMN `idta_bankkonto` `idta_bankkonto` 
INT(11) 
NOT NULL AUTO_INCREMENT  ;

ALTER TABLE `pl`.`ta_objekt` CHANGE COLUMN `idta_objekt` `idta_objekt` INT(11) 
NOT NULL 
AUTO_INCREMENT  ;

Original comment by Philipp.Frenzel@googlemail.com on 5 Jan 2010 at 9:41

GoogleCodeExporter commented 8 years ago 
ALTER TABLE `pl`.`tm_organisation_has_ta_adresse` CHANGE COLUMN 
`idtm_organisation_has_ta_adresse` `idtm_organisation_has_ta_adresse` INT(11) 
NOT NULL 
AUTO_INCREMENT  ;

Original comment by Philipp.Frenzel@googlemail.com on 5 Jan 2010 at 9:42

GoogleCodeExporter commented 8 years ago 
On Update don't forget the PWCWindow Component!!

Original comment by Philipp.Frenzel@googlemail.com on 6 Jan 2010 at 9:17

GoogleCodeExporter commented 8 years ago 
public $org_fk_internal;

Original comment by Philipp.Frenzel@googlemail.com on 6 Jan 2010 at 1:43

GoogleCodeExporter commented 8 years ago 
For the communication the contact information is required, it will be put into 
ta_kommunikation, similar to ta_adresse

Original comment by Philipp.Frenzel@googlemail.com on 6 Jan 2010 at 2:09

GoogleCodeExporter commented 8 years ago 
It´s working, changed some minor things in date handling, now it´s working!

Original comment by Philipp.Frenzel@googlemail.com on 13 May 2010 at 8:36