Keyword

K2 CSV import tool

More
13 years 9 months ago #83338 by Thanos
Replied by Thanos on topic K2 CSV import tool
Hi,

I just installed the component, i tried the import with example.csv and it works.

But if I press export nothing happens, i get a blank screen. I tried with selecting a file (in case this was needed) and then press Export, I get again blank screen. Why is that?

In the component page, I get only a text field to select file and the import/export button. is this normal?

Thanks

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago #83339 by Thanos
Replied by Thanos on topic K2 CSV import tool
About my last post above. I turned error reporting to maximum and here's the error I get

 

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 5918721 bytes) in /Applications/MAMP/htdocs/xxxxxxx/administrator/components/com_k2import/views/export/tmpl/default.php on line 111

Please Log in or Create an account to join the conversation.

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
13 years 9 months ago #83340 by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
The component page you describe is  100% OK.

And at the moment there is no selective sync, all items from K2 are exported.

Your only problem seems to be to less allowed memory for a big export.

 

If you have the possiblity to access your php.ini you can change the line that looks like this:

memory_limit = 32M

try to set it e.g to 64M

 

If you don't have access to the php.ini edit the file administrator/components/com_k2import/k2import.php and insert this line in the function export() about line 555

 

ini_set('memory_limit', '32M');

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago #83341 by shani
Replied by shani on topic K2 CSV import tool
Hello Artur,

I'm wonder if it possible, through your tool, to import data to certain extra field (not item):

I just want to make Countries field with all the Countries in the world, and there is no way I would go country by country manually (and then state by state..)

I want to import form my CSV all the data (in this case Countries..)

 

Thanks.

Please Log in or Create an account to join the conversation.

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
13 years 9 months ago #83342 by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
Hi shani,

this is not possible at the moment.

But if this is just a one-time job I could write a small script that generates a SQL statement from the CSV.

Please write a short email and then I could tell you how much it would cost.

Please Log in or Create an account to join the conversation.

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
13 years 8 months ago #83343 by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
At the moment I'm working on an export from Wordpress and import to K2. Of course I do the import with my Import tool. Because I needed some more features for this job I implemented them. The actual beta has till now three new features:
support for the trash fieldyou can import items that are set automatically to "trashed" - I'm sure there are just very few people who need that :-)
support for user comments
automatically association of fieldsif the columns in the CSV and the fields has the same name they are associated automatically. e.g. name your columns in the CSV.e.g. "Title","Introtext","Fulltext","Tags","Published","Created","User ID","Meta Description","Meta Keywords","Trash","Comments","Image","Image caption","Image credits","Images for the Gallery","Attachment0","Attachment title0","Attachment1","Attachment title1"

If you buy the actual stable the beta is included: K2 Import / Export Tool

P.S. I included a update-support on my site. For every EUR you pay you can download updates for 10 days. So if you pay e.g. 3EUR you can download every update for one month.

Please Log in or Create an account to join the conversation.

More
13 years 8 months ago #83344 by odeh.quraan
Replied by odeh.quraan on topic K2 CSV import tool
Hi Artus,

I purchased this tool, I installed it, when I import i get everything successful. But when I check in K2 items there is no changes, I tested it heavily for more than 10 hours, on localhost and on live server.

I exported the k2 items, change the csv file and re-uploaded it and nothing changes.

I notice that when I export, the csv file that i get does not have a column for "Image" path!! Also I expoted the k2_items table from PhpMyAdmin as a csv and also there is no "Image" field!! Is this the normal case or I do have problems with my installation??

I use Joomla 1.5.22 with K2 2.4.1.

Please help

Thanks

Please Log in or Create an account to join the conversation.

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
13 years 8 months ago #83345 by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
Hi,

what version of the import tool do you use? Please try the actual 0.7_beta2 www.individual-it.net/en/Joomla/#27

You should be able to download it for free with the link you got after payment.

 

And did you check the "overwrite" box when trying to import again? The overwrite function overwrites existing items with the items from CSV which have the same name

 

odeh.quraan said:

Hi Artus,
I purchased this tool, I installed it, when I import i get everything successful. But when I check in K2 items there is no changes, I tested it heavily for more than 10 hours, on localhost and on live server.

I exported the k2 items, change the csv file and re-uploaded it and nothing changes.

I notice that when I export, the csv file that i get does not have a column for "Image" path!! Also I expoted the k2_items table from PhpMyAdmin as a csv and also there is no "Image" field!! Is this the normal case or I do have problems with my installation??

I use Joomla 1.5.22 with K2 2.4.1.

Please help

Thanks

Please Log in or Create an account to join the conversation.

More
13 years 8 months ago #83346 by odeh.quraan
Replied by odeh.quraan on topic K2 CSV import tool
Hi Artur,

 

Thanks for the quick reply.

 

I was using version 0.6a stable.

I installed version 0.7_beta2, after I upload the csv file, i follow the steps, when i get to this step "

importing items, please stand by"
I get "Error" and nothing is added to the items!

 

 

 

Artur Neumann said:

Hi,

what version of the import tool do you use? Please try the actual 0.7_beta2 www.individual-it.net/en/Joomla/#27

You should be able to download it for free with the link you got after payment.

 

And did you check the "overwrite" box when trying to import again? The overwrite function overwrites existing items with the items from CSV which have the same name

 

odeh.quraan said:

Hi Artus, I purchased this tool, I installed it, when I import i get everything successful. But when I check in K2 items there is no changes, I tested it heavily for more than 10 hours, on localhost and on live server.

I exported the k2 items, change the csv file and re-uploaded it and nothing changes.

I notice that when I export, the csv file that i get does not have a column for "Image" path!! Also I expoted the k2_items table from PhpMyAdmin as a csv and also there is no "Image" field!! Is this the normal case or I do have problems with my installation??

I use Joomla 1.5.22 with K2 2.4.1.

Please help

Thanks

Please Log in or Create an account to join the conversation.

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
13 years 8 months ago #83347 by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
Could you provide me an admin access to your joomla instance, so I could debug on your server?

Send me an mail via my contact formular

Please backup everything before.

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum