search

elhh82 / 3tab

Automatically exported from code.google.com/p/3tab
0 stars 0 forks source link

Importing Adjudicator.csv throws error #7

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
To set-up a new round, I 

1-cleared the database by loading lib.model.schema.sql
2-emptied cache by running ./symfony cc in my project folder
3-created rounds. I created 4 rounds, round 1 was type 1, round 2 and 3 type 2 
and no type set for round 4 (so type 0)
4-I then imported the .csv files, starting with institution, then venue, then 
team then adjudicator. It all goes well until I get to adjudicator, when I get 
this error

"[Exception]
The following error occured on line number 2: The institution with the code '' 
does not exist.

stack trace
at ()
in SF_ROOT_DIR/apps/3tab/modules/import/actions/actions.class.php line 112 ...
        {

            $propelConn->rollback();

            unlink(sfConfig::get('sf_upload_dir') . DIRECTORY_SEPARATOR . $realFileName);

            throw new Exception("The following error occured on line number " . ($number + 2) . ": " . $e->getMessage());

        }

        $this->getRequest()->setParameter("messages", array($this->getRequestParameter('target_model') . " import: $insertedCount row(s) inserted.  $updatedCount row(s) updated. $ignoredCount row(s) ignored."));
at importActions->executeImport()"

There is no extra line in the csv file.

Original issue reported on code.google.com by logani...@gmail.com on 30 Jun 2011 at 11:04

Attachments:

GoogleCodeExporter commented 9 years ago 
Tabs instead of commas are being used to separate cells in the CSV file, hence 
the error.

Original comment by sut...@gmail.com on 30 Jun 2011 at 11:16