9 Posts
dodenau
10 years ago
Topic

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


Get a VIP membership
10 years ago
1
Level 1
Hi 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.

9 Posts
dodenau
10 years ago
0
Level 2

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


4 Posts
Johnyboy
10 years ago
4
Level 1

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 ) {




 

9 Posts
dodenau
10 years ago
3
Level 2

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

5 Posts
netoale
9 years ago
2
Level 3

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

9 years ago
1
Level 4

I like it, netoale

universally valid solutions have a certain appeal :)

4229 Posts
Kadministrator
9 years ago
0
Level 5

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

Get a Book for SEBLOD