load data into an EAV table from a CSV file

Question

How do I load data into an EAV table from a CSV file in MYSQL database?

My CSV file is like this:

"ID",    "attr1",    "attr2",    "attr3",
"ID1",   "value1",   "value2",   "value3",

I tried using a script to change the CSV file into EAV CSV file but I think that won't be scalable.

Duplicate: http://stackoverflow.com/questions/3635166/how-to-import-csv-file-to-mysql-table — rags, Jul 29 '13 at 09:44
@rags The question you specified is not exactly the one I am asking. — user1471283, Jul 29 '13 at 09:48

score 0 · Answer 1 · answered Jul 29 '13 at 09:50

0

Have you tried making use of fgetcsv function in PHP ?. Manual

Without showing what you have tried we could not able to help.

answered Jul 29 '13 at 09:50

Shankar Narayana Damodaran

68,075
43
96
126

I tried using a script to change the CSV file into EAV CSV file but I think that won't be scalable. – user1471283 Jul 29 '13 at 09:54
@user1471283, EAV model breaks referential integrities and other complexities such as this. Is your MySQL DB designed on that way ? – Shankar Narayana Damodaran Jul 29 '13 at 10:05
Yes. It is built in that way. – user1471283 Jul 29 '13 at 11:46

score 0 · Answer 2 · edited May 07 '15 at 12:58

You should transform your usually CSV

Max;Mustermann;Hamburg;Am Elbufer 123
Jens;Mander;Manderscheid;Eisgasse 99

into another CSV with exact 3 fields like this:

addr01=name=Mustermann
addr01=vname=Max
addr01=ort=Hamburg
addr01=str=Am Elbufer 123
addr02=name=Mander
addr02=vname=Jens
addr02=ort=Manderscheid
addr02=str=Eisgasse 99

Now, always having 3 fields: Entity, Attribute, Value.

By the way, in Perl a Hash of Hashes, also means EAV:

$EAV = {
    addr01 = {
        name  => 'Mustermann',
        vname => 'Max',
        ort   => 'Hamburg',
        str   => 'Am Elbufer 123',
    },
    addr02 = {
        name  => 'Mander',
        vname => 'Jens',
        ort   => 'Manderscheid',
        str   => 'Eisgasse 99',
    },
};

load data into an EAV table from a CSV file

2 Answers2