StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POcakeDC utils csvImport use?
primarykey
Id
6644758
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-07-11T00:49:33.633
FavoriteCount
0
LastActivityDate
2017-03-01T16:29:15.480
LastEditDate
2017-03-01T16:29:15.480
LastEditorUserId
15168
OwnerUserId
836343
ParentId
0
PostTypeId
1
Score
2
ViewCount
1005
LastEditorDisplayName
text
Body
I am looking to use the cakeDC CSVimport behaviour. However, I cannot work out how to set it up and there doesn't seem to be any documentation or instructions around. I am uploading a csv then I need to insert the data into the a MySQL table. I have the upload working as required. NOTE: the csvimport behaviour is part of the cakeDC utils plugin: <a href="https://github.com/CakeDC/utils" rel="nofollow noreferrer">https://github.com/CakeDC/utils</a> I have this in my upload model <pre><code>var $actsAs = array('Utils.CsvImport'); </code></pre> Within my upload controller I have this (after the file is uploaded successfully) <pre><code>$this->Upload->importCSV('/maslayout/files/'. $thefilename); </code></pre> I am then getting this error: <pre><code>Fatal error: Uncaught exception 'RuntimeException' with message 'SplFileObject::__construct(/maslayout/files/customers_aussievets_24092010.csv) [<a href='http://php.net/splfileobject.--construct'>splfileobject.--construct</a>]: failed to open stream: No such file or directory' in E:\xampp\htdocs\maslayout\app\plugins\utils\models\behaviors\csv_import.php:105 Stack trace: #0 E:\xampp\htdocs\maslayout\app\plugins\utils\models\behaviors\csv_import.php(105): SplFileObject->__construct('/maslayout/file...', 'rb') #1 E:\xampp\htdocs\maslayout\cake\libs\model\model_behavior.php(169): CsvImportBehavior->importCSV(Object(Upload), '/maslayout/file...') #2 E:\xampp\htdocs\maslayout\cake\libs\model\model_behavior.php(467): ModelBehavior->dispatchMethod(Object(Upload), 'importCSV', Array) #3 E:\xampp\htdocs\maslayout\cake\libs\model\model.php(496): BehaviorCollection->dispatchMethod(Object(Upload), 'importCSV', Array) #4 E:\xampp\htdocs\maslayout\cake\libs\overloadable_php5.php(50): Model->call__('importCSV', Array) #5 E:\xampp\htdocs in E:\xampp\htdocs\maslayout\app\plugins\utils\models\behaviors\csv_import.php on line 105 </code></pre> Can you explain what I'm doing wrong? =========================================================================== UPDATE: I worked out I simply had the path incorrect, now that I have this right it seems to be uploading however I don't really understand what to do next. I am not sure if I need to set the CSV document up somehow and how do I get the model set so the import will work and match up. Any help would be appreciated. I have it on my uploads model and this is basically insert empty rows into the uploads table. Even when I have the right headers on the form this still happens.
Tags
<csv><import><cakephp-1.3>
Title
cakeDC utils csvImport use?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJonathan Leffler
UserOwnerUserId
1. USsluggerdog
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POcakeDC utils csvImport use?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POcakeDC utils csvImport use?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.