public function uploadProcessAction(Request $request)
 {
     /* @var $uploadedFile \Symfony\Component\HttpFoundation\File\UploadedFile */
     $uploadedFile = $request->files->get('upfile');
     $inputFileName = $uploadedFile->getPathname();
     $inputFileType = \PHPExcel_IOFactory::identify($inputFileName);
     $objReader = \PHPExcel_IOFactory::createReader($inputFileType);
     $objReader->setReadDataOnly(true);
     $objPHPExcel = $objReader->load($inputFileName);
     $objWorksheet = $objPHPExcel->getActiveSheet();
     $enableCardCreation = $request->request->has('create');
     // analysis of first row
     $colNames = [];
     $cards = [];
     $firstRow = true;
     foreach ($objWorksheet->getRowIterator() as $row) {
         // dismiss first row (titles)
         if ($firstRow) {
             $firstRow = false;
             // analysis of first row
             foreach ($row->getCellIterator() as $cell) {
                 $colNames[$cell->getColumn()] = $cell->getValue();
             }
             continue;
         }
         $card = [];
         $cellIterator = $row->getCellIterator();
         foreach ($cellIterator as $cell) {
             $col = $cell->getColumn();
             $colName = $colNames[$col];
             //$setter = str_replace(' ', '', ucwords(str_replace('_', ' ', "set_$fieldName")));
             $card[$colName] = $cell->getValue();
         }
         if (count($card) && !empty($card['code'])) {
             $cards[] = $card;
         }
     }
     /* @var $em \Doctrine\ORM\EntityManager */
     $em = $this->get('doctrine')->getManager();
     $repo = $em->getRepository('AppBundle:Card');
     $metaData = $em->getClassMetadata('AppBundle:Card');
     $fieldNames = $metaData->getFieldNames();
     $associationMappings = $metaData->getAssociationMappings();
     $counter = 0;
     foreach ($cards as $card) {
         /* @var $entity \AppBundle\Entity\Card */
         $entity = $repo->findOneBy(array('code' => $card['code']));
         if (!$entity) {
             if ($enableCardCreation) {
                 $entity = new Card();
                 $now = new \DateTime();
                 $entity->setDateCreation($now);
                 $entity->setDateUpdate($now);
             } else {
                 continue;
             }
         }
         $changed = FALSE;
         $output = ["<h4>" . $card['name'] . "</h4>"];
         foreach ($card as $colName => $value) {
             $getter = str_replace(' ', '', ucwords(str_replace('_', ' ', "get_{$colName}")));
             $setter = str_replace(' ', '', ucwords(str_replace('_', ' ', "set_{$colName}")));
             if (key_exists($colName, $associationMappings)) {
                 $associationMapping = $associationMappings[$colName];
                 $associationRepository = $em->getRepository($associationMapping['targetEntity']);
                 $associationEntity = $associationRepository->findOneBy(['name' => $value]);
                 if (!$associationEntity) {
                     throw new \Exception("cannot find entity [{$colName}] of name [{$value}]");
                 }
                 if (!$entity->{$getter}() || $entity->{$getter}()->getId() !== $associationEntity->getId()) {
                     $changed = TRUE;
                     $output[] = "<p>association [{$colName}] changed</p>";
                     $entity->{$setter}($associationEntity);
                 }
             } else {
                 if (in_array($colName, $fieldNames)) {
                     $type = $metaData->getTypeOfField($colName);
                     if ($type === 'boolean') {
                         $value = (bool) $value;
                     }
                     if ($entity->{$getter}() != $value || $entity->{$getter}() === NULL && $entity->{$getter}() !== $value) {
                         $changed = TRUE;
                         $output[] = "<p>field [{$colName}] changed</p>";
                         $entity->{$setter}($value);
                     }
                 }
             }
         }
         if ($changed) {
             $em->persist($entity);
             $counter++;
             echo join("", $output);
         }
     }
     $em->flush();
     return new Response($counter . " cards changed or added");
 }