Copy Data From Bo to BO

4xjbh

So I created an import BO for Company and it maybe staring me right in the face but I have not worked out how to move the data from 'Company_Import' to 'Company'....apart from Exporting the Data out to file and importing it to the live BO.

DUPLICATE seems to duplicate to the same BO. The closest I have come to is exporting the data

Any suggestions?

customaware

Process 1: LoopThruCompanyImport

 FIND ALL Company_Import
 CREATECompanyFromCompanyImport

Process 2: CREATECompanyFromCompanyImport (Pass Company_Import as parameter)

CREATE Company WITH Company.Name=Company_Import.Name, etc etc etc   NO RULES

BenHayat

eagles9999 wrote

Process 1: LoopThruCompanyImport

 FIND ALL Company_Import
 CREATECompanyFromCompanyImport

Process 2: CREATECompanyFromCompanyImport (Pass Company_Import as parameter)

CREATE Company WITH Company.Name=Company_Import.Name, etc etc etc   NO RULES[/quote]

Mark, I bet he was missing passing the parameter. 😉

4xjbh

I think it should be FOR EACH instead of FROM for process 1

Strangely I ran the following and all of the data in company_import was moved. Upon investigation it looks like the original csv import process sets all columns that are empty to ' ' instead of 'null' when there is at least one row with a value in the column of data.

FIND Company_Import WHERE Company_Import.CompanyName IS DEFINED AND Company_Import.Telephone IS DEFINED 
CREATE Company FOR EACH Company_Import NO VALIDATION

Setting the following rule did not reset the column. (Which is really for input text)

If Company_Import.Telephone=' ' Then 
Company_Import.Telephone=UNDEFINED

But this did from the mysql console:

mysql> UPDATE bastestdomainaec_company_import SET Telephone = CASE Telephone WHEN '' THEN NULL ELSE Telephone END

I could not create a aim query as it needs to start with a SELECT statement. How do I reset these columns to null from AIM so I can make it part of the import process? Changing the column from mediumtext to varchar (40) DEFAULT NULL from mysql console did not work either.

Thanks

tford

I would use:

FIND ALL Company_Import IN BATCHES OF 1

4xjbh

I am assuming in batches of one will continue if the current record fails validation of the company bo.

As the telephone field is empty not null it will still be let through the rules of company bo whether its in batches or not.