Easy Populate is not Importing Correctly

[Guest]

I have checked my data. I have checked all over the EP thread for this problem. What happens is, EP reads through all of my data, but only properly read the first line, no mater what that happens to be. For example, if I delete the first item, and resave the file, it imports the next item just fine, and jumbles the rest.I t doesn't appear that my data is the problem, so now what?

 

here is a link to my my data:www.brewstergraphics.com/junk.htm

Here is what EP says (truncated):

 

Easy Populate 2.76-MS2 - Default Language : English(1)

 

Filename: gremlin3.txt

| kb18 | kb18.jpg | Kodak KB18 | Product Sp | | | | | | | | 19.95 | 3 | | | | Kodak | 35mm Camer | Taxable Go | Active Updated

| BH506 bh | WP300 WP | bigview3 | vivitar3 | q1purple | af3580 a | C-7AU C- | C-6AU C- | cam500 c | D1000 D1 | CV-R80 C | CV-M28 C | CA-M900 | FRS1000 | u514 u51 | E-TRAVEL | provite | spamKill | Ghost Re | sc-21 sc | DCRV01ta | DAVL15t | sc7bc sc | lk46 lk4 | jxm11 JX | dpcr1 dp | at6727 a | 6754 675 | dr306 dr | whp150 w | rqsw48vp | r24 r24. | MB0035 m | pr3500-2 | cv790 cv | TE438 te | TM341 tm | portabou | wsp150 w | cxr188 c | tsu500 t | ibp-900 | whp160T | icd-b200 | madkatzu | shfx50 0 | jlcd809 | JL-507 j | jl707 jl | jlcd805 | sc380 sc | jl616 jl | mcr230 m | jl708 jl | jl705 jl | aj3160 a | cdra185 | jcr425 j | sc390 sc | dcr5000b | JL-722 j | cra78 cr | jcr560 j | cdra195 | aj3136 a | aj3260 a | rp3740 r | ipodshuf | ipodshuf | kdg210 2 | cqc5110u | kdar200 | deh1700 | deh4700 | F5515X F | cdxt69 c | CDX-F500 | RM-X114 | XSGT6930 | XS-L1090 | rmx6 rmx | BX1605D | BX1000D | 04kx250. | 04kx350. | PD-1444T | CDV-7004 | ....................................................................A larger view of the EP output shows that the data is 'fubared' after that.

 

You can see in the above, after 'Active Updated' it goes to the next product, but, it's run together after the products_model ('BH506' is the products_model, and 'bh506.jpg', the next column, is being run into it-It's as if EP is ignoring that second-row tab, strange??). I have checked my data, and there definitely is a tab there. Also, each time I delete the first item, the next item imports fine into the database (so I know I am very close). I don't know how it's my data, since EP works, but line by line...

 

Help?

Edited November 7, 2005 by morrie

[th1nk3r]

I've got exactly the same problem.

 

I'm running Apache 2.0.54, PHP 5.0.4-10.4 and MySQL 4.1.14.

 

I've tried changing the delimited character and am currently using tabs.

Still getting the same error.

 

It works fine for te headers and one product but as soon as you add a third line it generates an expression of the first two fields, namely v_products_model & v_products_image.

 

I have manually constructed files to ensure that Excel is not screwing them up with no success.

 

I am currently looking through the code to try and work out what the heck is going on.

 

Any help greatly appreciated.

 

Luke

Edited November 8, 2005 by th1nk3r

[Guest]

What version of EP are you using? I am running these versions:

 

Apache version : Apache/1.3.33 (Win32)

PHP version : 5.0.4

MySQL version : 4.1.10a-nt - extension : mysqli

I have also tried Easy Populate Version 2.75 and 2.76b1, and get the same result.

 

It seems like there is a missing comma or + in the code (I have looked, but PHP isn't my first language).

 

Here are the steps I am taking:

-Configure EP.php (my longest product_model is 30 digits, so $model_size=30, quote repl. is , attributes are off.

-Download Complete Tab-Delim. file (by choosing "Open with Excel")

-Put my info into the fields provided by the EP download (by copying and pasting the entire column(1468 records), and carefully reanaming the column headers to original EP)

-Save from Excel as Text (Tab delim.) into my catalog/temp folder.

-Go back to EP, and attempt to upload the file (you know the rest).

 

I really don't know what else to try: maybe we both have the same bad version (the moderator here, Mibble, seems to think that most problems are caused by-people posting "non-standard" contrib's. I am going to look into some other versions of EP.

[th1nk3r]

I'm running 2.76b1 at the moment.

 

It's strange how it's displaying a truncated version of the first two vars and then the next lines.

Trying to work out why it doesn't display all the vars on each line.

It's almost like it's missing a delimiter.

 

Luke

Edited November 8, 2005 by th1nk3r

[th1nk3r]

Find:

 

array_walk($readed, 'walk');

 

and change it to

 

//array_walk($readed, 'walk');
foreach ($readed as $readed_record) {
  walk($readed_record);
}

 

This works on my version.

 

Cheers, Luke

[Guest]

Whoa, great job, th1nk3r!!

 

Thanks for posting that solution; it works for me as well.

 

I am glad you're on our team!!

 

(Out of curiousity, how did you figure that out (what does your fix mean)?)

 

Thanks again,

 

morrie