Easy Populate 1.2.5.4 support

[DrByte]

File Import Failed! Primary index column v_products_model missing from uploads file. Please consult the readme.html file for more information

v_products_model ... must exist. EP cannot run without it.

[DrByte]

/home/content/a/p/i/apinkpony/html/shop/temp/Full-EP2006Aug12-1111.txt): failed to open stream: No such file or directory

Is this the name of the file you were uploading?: Full-EP2006Aug12-1111.txt

Not sure why it would have trouble splitting the file. Haven't used that feature much.

While I realize it's a bit of a pain, can you split the file manually on your PC, and then upload the separate files manually?

[apinkpony11]

Yeah. That's what I originally did was split in manually, but that's before I realized it could split it, it self.

It worked fine the first time, but I had to like, start over because I had a lot of ugly stuff going on with categories.

Anyway, yeah, guess it's back to manually splitting. No biggie, thank you.

[wtashby]

v_products_model ... must exist. EP cannot run without it.

Look, I said earlier, and I'll say it again, I HAVE v_products_model in my files. I also said that this is a file I have succesfully uploaded with earlier versions of EP. The problem seems to be that many of the header names for the advanced version are different than previous versions, causing errors, unless you updated your header names as well.

However, I have learned that support for the advanced version can be found elsewhere, as Langer was kind enough to tell me where to find it. Thank you.

Therefore, please consider my issue resolved and closed. Thanks.

[Woodymon]

It is strange why one table would get updated but the other table would not. Any other tables I should look at?

Wonder if the mod_security filtering on server is contributing to this isssue?

Hosting provider reported that all is well with mod_security configuration.

I'm out of ideas.

Anyone else observe similar issues of EP updating the products table but NOT the products_description table?

Anyone here know this mod well enough to explain if an internal EP log file is maintained, which records the INSERT SQL attempts which should be occurring during the HTTP upload process?

I've heard of a possible EP debug file but don't know where to find it. I have Admin > Config > EP > Debug Logging set to "true". Or maybe that feature refers to the "Upload Results" written to screen during the upload?

And/or is there would be a server log file (MySQL or Apache or otherwise) that might provide useful troubleshooting info?

If not able to solve this will just have to give up on EP and begin the long process of enter hunderds of products and categories manually. Or maybe enter via phpmyadmin

Thanks for any ideas.

Woody

[petteriu]

...Anyone here know this mod well enough to explain if an internal EP log file is maintained, which records the INSERT SQL attempts which should be occurring during the HTTP upload process?....
Woody

EP log is in the uploads folder. I see it only when there are problems during operation, not continiously for all activities I don't know if ZC admin log would be any use for you ?

Petteri

[Woodymon]

EP log is in the uploads folder. I see it only when there are problems during operation, not continiously for all activities I don't know if ZC admin log would be any use for you ?

Petteri

Thanks. Where would the EP "uploads" folder be located?

Or are you referrring to the directory on the client PC which we are uploading from? No log files appear there.

Where is ZC admin log located?

[petteriu]

I was referring to EP advanced, but it seems that you aren't using advanced, are you ? There should be uploads directory defined in either EP configuration settings or easypopulate_config.php file.
Not sure if there is a place to view Zencart admin log, except going to databse itself (table admin_activity_log, note possible prefix in table name)

Petteri

Thanks. Where would the EP "uploads" folder be located?

Or are you referrring to the directory on the client PC which we are uploading from? No log files appear there.

Where is ZC admin log located?

[Woodymon]

I was referring to EP advanced, but it seems that you aren't using advanced, are you ?

No. v.1.2.5.4

There should be uploads directory defined in either EP configuration settings or easypopulate_config.php file.

I am uploading directly from client so not directly observing the temp directory. I see now the upload directory points to the /temp directory on the server.

I assume this refers to /public_html/shop/temp. That directory contains copies of the *.txt files I processed via HTTP upload from the EP client. But no log or debug files appear in that directory.

Not sure if there is a place to view Zencart admin log, except going to databse itself (table admin_activity_log, note possible prefix in table name)

via phpyadmin looked in admin_activity_log table and page accessed column shows entries for easypopulate.php with page_parameters of "split=0&", corresponding to the times when I processed my various test uploads. No other info displayed.

I suspect I need to check the Apache logs. I'm not sure if I have access to DB server logs on this particular host.

Would you know if EP Advanced has the debugging and logging tools that might assist?

Any server confguration settings that I should investigate which might apply to my issue?

[DrByte]

Woody,

If you download a fresh TXT file from EP for your products, then delete all but 5 records, edit their descriptions, and then re-upload to test whether their descriptions get updated, what happens?

Also, what tools are you using to do your edits?