Hello,
first of all – because it’s my first contribution – I want to thank the seblod team for their masterpiece, which empowered me to build the bones and muscles of a whole site.
Thank you very much.
On importing csv bulk data, I faced the problem, that sometimes a row is broken, building a new data record with the rest of the broken record (corrupting the fields mapping).
With trial and error I found out, that this is the case, when around 997 characters are reached in one row.
Is this a bug or a restriction?
Regards,
Hans-Georg
Thank you for your post and your kind feedback.
Can you please prepare a basic CSV file with 4/5 rows and one specific row (with 998 chars) in the middle, and then report this issue on our Tracker.
We'll have a try as soon as possible.
Thanks & Regards,
Saba.
Hi Saba,
thank you for your reply. I’ll do that and in addition I can send you the old log-csv, that your importer created (…a tool, without I would have been lost in that Problem ;-) There you can see, where the row breaks.
Regards,
Georg
Hello Georg,
Edit line 52 in administrator\components\com_cck_importer\models\cck_importer.php,
change 1000 in a higher number.
while ( ( $data = fgetcsv( $handle, 1000, $options['separator'] ) ) !== false ) {
Hello Johnyboy,
thank you very much. Indeed, this was the restriction and now it works like a charm!
Thank you, once again.
Regards,
Hans-Georg
Johnyboy, Thank you! thank you! thank you! I was going crazy with this limitation of 1000 char. It's a shame that it is not documented...
I replace 1000 by 0 in the following code to have no limitation.
while ( ( $data = fgetcsv( $handle, 0, $options['separator'] ) ) !== false ) {Thank you again
I like it, netoale
universally valid solutions have a certain appeal :)
Hi,
this is now fixed with the relase of seblod 3.5. and new version of importer tool http://www.seblod.com/community/blog/new-release-seblod-3-5