CSV Mapping while importing products

Question

I am working on one custom module where i imported products from csv successfully.But i am doing like first field must be sku and second should be name.But the issue is if someone change the sequence then it creates issues.Is there any way i can map csv fields so that i can adjust fields with that.I am getting csv fields like this :

$file = $path."/".$_FILES['file_uplod']['name'];
      $csv = new Varien_File_Csv();
      $data = $csv->getData($file);
for($i=1; $i<count($data); $i++){
  $name = $data[$i][1];

}

I want to code some generic so fields map with DB fields name.

Answer 1

Not sure if this is an answer, but it looks ugly in the comments.
I don't know the code you use for import , but here is one that might work.
The code uses just 3 attributes but you can do the same for all of them.

The idea is to have the first row in the csv filled with attribute codes.
Here is an example:

sku        ,name        ,description
"some_sku" ,"Some name" ,"Some description"
"other_sku","Other name","Other description"

Now parse it like this:

$file = $path."/".$_FILES['file_uplod']['name'];
$csv = new Varien_File_Csv();
$data = $csv->getData($file);
//first line are the headers
$headers = $data[0];
$allProductData = array();
for($i=1; $i<count($data); $i++){
  $productData = array();
  foreach ($headers as $index=>$attributeCode) {
      $productData[$attributeCode] = $data[$i][$index];
  }
  $allProductData[] = $productData;
}

At the end, $allProductData should look like an array of arrays:

array(
    0 => array(
        'sku' => 'some_sku',
        'name' => 'Some Name',
        'description' => 'Some Description',
    );
    1 => array(
        'sku' => 'other_sku',
        'name' => 'Other Name',
        'description' => 'Other Description',
    );
);

You should be able to use this to import your data.