Cannot import large CSV files

[GoogleCodeExporter]

= What steps will reproduce the problem?
1. Try to import a properly formatted CSV file that is 65,000 terms
2.
3.

= What is the expected output? What do you see instead?
Should import the terms.  Instead I get the following error:

Notice: Undefined index: terms in C:\Program
Files\xampplite\htdocs\glossword\inc\a.import.inc.php on line 718

Warning: array_flip() [function.array-flip]: The argument should be an
array in C:\Program Files\xampplite\htdocs\glossword\inc\a.import.inc.php
on line 1199

Notice: Undefined variable: str in C:\Program
Files\xampplite\htdocs\glossword\inc\a.import.inc.php on line 718

Notice: Undefined index: memory_spend in C:\Program
Files\xampplite\htdocs\glossword\inc\a.import.inc.php on line 1567

Notice: Undefined index: int_items_total in C:\Program
Files\xampplite\htdocs\glossword\inc\a.import.inc.php on line 1614

Notice: Undefined index: int_items_total in C:\Program
Files\xampplite\htdocs\glossword\inc\a.import.inc.php on line 1634

= What version of the product are you using? On what operating system?
1.8.11, on apache, XAMPP, also on CentOS Apache

= Please provide any additional information below.

Original issue reported on code.google.com by clalc...@gmail.com on 15 Apr 2009 at 10:35

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

I have tried this with a CSV having 15,000 terms, and 40,000 terms.  However, it
appears to be working up to around 10,000 terms.  Is there anyway to increase 
the
limit?  I have several CSV databases that are more than 1,000,000 terms, and 
deviding
it into 100 parts will be tedious!!  Or is there a way to convert the csv to the
proper XML schema and upload it that way?  direct import into mySQL does not 
seem to
work either

Original comment by clalc...@gmail.com on 15 Apr 2009 at 10:43

[GoogleCodeExporter]

I see in the Wiki it says the limit is 10000 terms.  Why?  Is there a way to 
increase
this?  Is there a way to import directly into the MySql table?

Original comment by clalc...@gmail.com on 15 Apr 2009 at 11:22

[GoogleCodeExporter]

Please read my comment #2. Issue 33.

To increase the limit, edit file `/inc/config.inc.php`
and change `$sys['max_lines_csv'] = 10000;` where `10000` is the current value.

Original comment by dmitry.s...@gmail.com on 16 Apr 2009 at 9:54

• Added labels: Type-Question
• Removed labels: Type-Defect

[GoogleCodeExporter]

Original comment by dmitry.s...@gmail.com on 29 Jan 2010 at 2:21

• Changed state: WontFix
• Added labels: Milestone-1.8.11