1. PaddyThorne
  2. RO CSVI
  3. Thursday, 04 July 2013
  4.  Subscribe via email
Hi Roland,
Thanks for getting back to me.
I have managed to get the extension installed. I did a clean install of Joomla and then installed CSVI.
Now, I have set up my CSV file with the headers available and when I try to import it the process doesn't get past line 1.
I've checked the Debug log and it doesnt give me any information about why it isn't working.
Would you be able to have a look at the attached files and let me know if there is something I am doing wrong?
I've had a good read through all of the tutorials and haven't managed to find the information that I need to get going.
Basically, all I want to do, is import some categories (which were originally created in a different CMS) and then I would like to import some articles (which were again created in a different CMS).
Attached are 4 files:

  • articles and categories CSV files

  • com_csvi.log.1372938961

  • com_csvi.log.1372938570


Any help you could give me with this would be greatly appreciated.
All the best,
Paddy Thorne




com_csvi.log.1372938961.zip

com_csvi.log.1372938570.zip
Accepted Answer Pending Moderation
Hmmm, I cant seem to send you the CSV files.
Anything I am doing wrong?
Paddy
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Roland,
A quick update.
I changed the headings on the CSV file to match those on your website and the processing now seems to going through the motions... Only the time limit seems to be reached before any data has been imported and then a screen comes up with lots of error messages All matching the below:

Oops something went wrong.

Let me try to show the warning below here. If nothing shows up then I didn't get any data, sometimes this is caused by faulty plugins.

Cancel the import and check if all settings are correct and try the import again. Status error: 200 Status message: OK
( ! ) Notice: Undefined property: stdClass::$tags in G:\wamp\www\languagesoutthere\libraries\cms\helper\tags.php on line 177
Call Stack
# Time Memory Function Location
1 0.0006 383008 {main}( ) ..\index.php:0
2 3.3473 5843280 JAdministrator->dispatch( ) ..\index.php:56
3 3.3489 5911768 JComponentHelper::renderComponent( ) ..\application.php:166
4 3.3698 6263672 JComponentHelper::executeComponent( ) ..\helper.php:339
5 3.3718 6366712 require_once( 'G:\wamp\www\languagesoutthere\administrator\components\com_csvi\csvi.php' ) ..\helper.php:359
6 3.4795 7823616 JControllerLegacy->execute( ) ..\csvi.php:135
7 3.4795 7823672 CsviControllerImportfile->doImport( ) ..\legacy.php:722
8 3.6134 10599472 CsviViewImportFile->display( ) ..\importfile.json.php:134
9 3.6135 10599560 JViewLegacy->get( ) ..\view.json.php:37
10 3.6135 10599648 CsviModelImportfile->getProcessData( ) ..\legacy.php:394
11 3.6660 11626464 CsviModelCategoryimport->getProcessRecord( ) ..\importfile.php:423
12 3.6886 11769376 JTableCategory->store( ) ..\categoryimport.php:186
13 3.6901 11772752 JHelperTags->preStoreProcess( ) ..\category.php:255
14 3.6901 11772752 JHelperTags->createTagsFromMetadata( ) ..\tags.php:713

It seems as though the file is being processed, but no records are imported.
Can you help?
Paddy
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
And this is the debug log from the same import attempt...


com_csvi.log.1372942574.zip
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Paddy,

I separated this from the main thread as it is a different issue. Now I see a number of things happening in the logs. Mostly the issue seems to be the fields you are importing. Did you have a look at this category import tutorial it specifies which fields you need to use.

Let's start with the basics of any import, do not use the fields ending with _id, these are usually database fields used for data integrity and linking. No need to use them unless you really have to and know what they do.

As for the notices you see, you can disable them by going to the Global Configuration and set Error reporting to none. I am going to have a look at it to see what needs to be done to prevent them from happening.

Let's focus on the category import first and take it from there.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hi Roland,
Thanks for getting back to me.
I have now managed to import all of my categories :)
I am now moving onto importing my articles and I have hit the next problem.
I have set up the CSV file with headers like so:
id,category_path,alias,title,introtext,fulltext,created,publish_up,modified,state
The data that each column holds seems to be OK...
Any idea what might be happening here?
Here is the Debug log:


com_csvi.log.1372951658.zip

It seems to be working, but then only gets to line 10 and doesn't add anything at all to the database.
Is it something i am doing wrong?
Thanks,
Paddy
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Paddy,

Is it something i am doing wrong?
from my previous comment
Let's start with the basics of any import, do not use the fields ending with _id,
I meant to say it also includes fields called ID ;)

CSVI determines the content ID based on the category path and alias supplied in the import file.

Did you see the Import Joomla content tutorial?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hey Paddy,

( ! ) Notice: Undefined property: stdClass::$tags in G:\wamp\www\languagesoutthere\libraries\cms\helper\tags.php on line 177
This notice that you saw, Joomla has it fixed in the upcoming 3.1.2 release.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!