Author: mcantelon
Date: Fri Dec 30 11:30:37 2011
New Revision: 10487

Log:
Updated mapping in CSV import script to reflect latest Pentaho export.

Modified:
   trunk/lib/task/csvImportTask.class.php

Modified: trunk/lib/task/csvImportTask.class.php
==============================================================================
--- trunk/lib/task/csvImportTask.class.php      Fri Dec 30 00:03:36 2011        
(r10486)
+++ trunk/lib/task/csvImportTask.class.php      Fri Dec 30 11:30:37 2011        
(r10487)
@@ -61,11 +61,6 @@
       throw new sfException('You must specify a valid filename');
     }
 
-$actor = new QubitActor;
-$actor->parentId = QubitActor::ROOT_ID;
-$actor->save();
-
-
     $defaultStatusId = sfConfig::get(
       'app_defaultPubStatus',
       QubitTerm::PUBLICATION_STATUS_DRAFT_ID
@@ -77,32 +72,28 @@
       'columns' => fgetcsv($fh, 60000), // 1st row supplies column names/order
       'defaultStatusId' => $defaultStatusId,
       'defaultStatusTypeId' => $defaultStatusTypeId,
-      'ignoreColumns' => array(
-        'THUMBNAIL',
-        'TIFF and JPEG Number',
-        'TIFFIMAGE',
-        'Type'
-      ),
+      'ignoreColumns' => array(),
       'columnMap' => array(
-        'TITLE' => 'title',
+        'title' => 'title',
         'Accruals' => 'accruals',
-        'RECORD ID' => array(
+        'RECORD_ID' => array(
           'column' => 'sources',
           'transformationLogic' => function(&$self, $text)
           {
             return 'CS-Records ID: '. $text;
           }
         ),
-        'SCOPE AND CONTENT' => 'scopeAndContent',
-        'Extent and medium' => 'extentAndMedium',
-        'Acquisition' => 'acquisition',
-        'Access conditions' => 'accessConditions',
-        'Location of copies' => 'locationOfCopies',
-        'Location of originals' => 'locationOfOriginals',
-        'Related units of description' => 'relatedUnitsOfDescription',
-        'Archival history' => 'archivalHistory',
-        'Arrangement' => 'arrangement',
-        'FINDING AIDS' => 'findingAids',
+        'scopeAndContent' => 'scopeAndContent',
+        'extentAndMedium' => 'extentAndMedium',
+        'acquisition' => 'acquisition',
+        'accessConditions' => 'accessConditions',
+        'locationOfCopies' => 'locationOfCopies',
+        'locationOfOriginals' => 'locationOfOriginals',
+        'relatedUnitsOfDescription' => 'relatedUnitsOfDescription',
+        'edition' => 'edition',
+        'archivalHistory' => 'archivalHistory',
+        'arrangement' => 'arrangement',
+        'findingAids' => 'findingAids',
 /*
         'Revision history' => array(
           'column' => 'revision',
@@ -125,11 +116,11 @@
           }
         ),
 */
-        'Physical characteristics' => 'physicalCharacteristics'
+        'physicalCharacteristics' => 'physicalCharacteristics'
       ),
       'propertyMap' => array(
         'titleStatementOfResponsibility' => 'titleStatementOfResponsibility',
-        'RAD note - statements of responsibility' => 
'statementOfResponsibilityRelatingToPublishersSeries',
+        'radNoteStatementOfResponsibility' => 
'statementOfResponsibilityRelatingToPublishersSeries',
         'titleProperOfPublishersSeries' => 'titleProperOfPublishersSeries'
       ),
       'noteMap' => array(
@@ -186,12 +177,12 @@
       }
     ));
 
-    $import->addColumnHandler('Level of description', function(&$self, $data)
+    $import->addColumnHandler('levelOfDescription', function(&$self, $data)
     {
       $self->informationObject->setLevelOfDescriptionByName($data);
     });
 
-    $import->addColumnHandler('Creator history', function(&$self, $data)
+    $import->addColumnHandler('creatorHistory', function(&$self, $data)
     {
       $self->rowStatusVars['creatorHistory'] = $data;
     });
@@ -201,9 +192,9 @@
       $self->rowStatusVars['startYear'] = $data;
     });
 
-    $import->addColumnHandler('START YEAR', function(&$self, $data)
+    $import->addColumnHandler('END YEAR', function(&$self, $data)
     {
-      $self->rowStatusVars['startYear'] = $data;
+      $self->rowStatusVars['endYear'] = $data;
     });
 
     $import->csv($fh);

-- 
You received this message because you are subscribed to the Google Groups 
"Qubit Toolkit Commits" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/qubit-commits?hl=en.

Reply via email to