problem in csv import

[vijendra sisodiya]

I have a problem for CSV import ,it not permitted me for insert a single record.

please see the error when i am importing csv--
Unable to execute INSERT statement. [wrapped: Could not execute update [Native Error: Cannot add or update a child row: a foreign key constraint fails (`cemetery/funeral_director`, CONSTRAINT `funeral_director_ibfk_6` FOREIGN KEY (`cemetery_id`) REFERENCES `cemetery` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE)] [User Info: INSERT INTO funeral_director (COUNTRY_ID,CEMETERY_ID,CODE,COMPANY_NAME,ADDRESS1,ADDRESS2,ADDRESS3,STATE,POST,CONTACT_NAME,PHONE,FAX_NUMBER) VALUES (1,2,'102','ASHES11','','','','','','','','')]]

please give me reply fast.

[claudia_k]

Hi there

It looks like the record you try to import contains a cemetery_id, but the corresponding record in the cemetery table does not exist yet. So first import your cemetery records, then these records.

Claudia

[vijendra sisodiya]

Thanx claudia_k
your suggesstion relly true ,csv file for inserting row is successfully import.