EasyPopulate 4.0 Support Thread

Jatty:

Question, all my copyright and single quote characters get converted to the "?" in the black diamond symbol. I have tried every setting in the configuration and nothing works to correct this.

I am running EP 4.22... What to do now?

This is a character encoding issue. You likely loaded your data from a iso-8859-1 source, but failed to let Open Office know before exporting and selecting UTF-8. This is hard to fix once it's messed up.

At this point you're better off doing a search and replace in your data. Also, depending of the source encoding, some single quote representations can potentially break EP4's import. Char(092) is a funky one.

Also, converting "smart" quotes between character encoding can also cause problems. Open Office CAN do it correctly for you, but you must let it know the source data's encoding when you first open the csv.

Excel will not give you this option and will totally FUBAR you data ...

-chadd

Chadd - Yes, Pull the image from the remote location. There are images both uploaded to images as well the URL of the client's manufacturer...it's a pain! =) Thank you in advance!

acrenshaw:

There are images both uploaded to images as well the URL of the client's manufacturer
One can not have it both ways
Best to grab images and host on your account

Ok i'm stuck , I upload a test product very easily, So then i uploaded attributes for that single product, It never said any errors were found, But didn't add anything at all, not sure how to attach the file for someone to see ,

Thanks

I upload a test product very easily, So then i uploaded attributes for that single product
In your second upload, was the test product also part of the file

kobra:

In your second upload, was the test product also part of the file

Not quite sure what you mean, The model number was the same as uploaded product,

I added the example attributes,

**v_products_model v_products_options_type v_products_options_name_1 v_products_options_values_name_1
**

And i always get the same results, Been at it all day, changing bits and get the same results

sash,
Try exporting your products
Open resulting file and locate product and add attributes to it

The attributes are a pain in the ########, Some have three main Attribute categorys , Different sizes within them and then whatever combination chosen has a price to match, UUGhh !!

I went back to the basic last night and tried uploading attributes than i already had manually input into admin, and it still came up blank ??

Do you mean this file as the others don't have as much attribute info

chadderuski:

This is a character encoding issue

-chadd

Would there be any advantage to the good Zen Cart folks offering a UTF-8-encoded version? I work either in TextMate or inside vi. The default ISO encoding makes diff take longer whenever I upgrade. It wouldn't take all that long to convert all the files to UTF-8 but is it worth the effort?

Ok, I am sure that this may already be posted here but I don't feel like scanning through all 71 pages of the EP help forum. Anyways I am trying to upload some inventory and when I do I get the error messages "No Model Field In Record. This line was not imported" What does that mean. I have on my cvs a place for v_products_model. I also did a different upload that I saved earlier with the same data and it uploaded fine but it did not upload any prices eventhough there are clearly prices that I placed under v_products_price. What is my problem and how do I fix the problem. I worked for about a month getting the files ready to upload and now this.

Thanks
Mark

firstcapitalfirearms:

when I do I get the error messages "No Model Field In Record. This line was not imported" What does that mean
Did you have a model entered??

firstcapitalfirearms:

I also did a different upload that I saved earlier with the same data and it uploaded fine

Thanks
Mark

I got that aswell , I uploaded a few tests, Checked it then deleted, When i tried to upload the exact same data i got the message "No model number found, Was not imported"

It's seems to hold onto it the first time, and if you try it again it doesn't see it the second time,

I never got to the bottom of it, maybe try clearing out "Optimise" Debug" in store manager and see if clears it ???

sash:

The name of your file is this screenshot does not begin correctly. You have "attrib-ep."

Must be "Attrib-Basic-EP" (and "Attrib-Detailed-EP" for the detailed later step).

You may have already corrected this, but it will result in no import.

firstcapitalfirearms:

I am trying to upload some inventory and when I do I get the error messages "No Model Field In Record. This line was not imported" What does that mean. I have on my cvs a place for v_products_model.

Look at the lines of output that show the errors. Do any import? If so, look at some of the ones that do not. Do they involve special characters that are not being escaped? When you get such an error it throws the file off and a blank field ends up where the model number is being read.

There are several reasons for "no model number" errors.

I do have models listed I believe. I was able to upload an older file that I did earlier and had prices on the older file but the prices did not upload. I can send an attachment to someone if it may help.

Thanks
Mark

firstcapitalfirearms:

I can send an attachment to someone if it may help.

I sent you a pm to send a file.

sash:

The attributes are a pain in the ########, Some have three main Attribute categorys , Different sizes within them and then whatever combination chosen has a price to match, UUGhh !!

I went back to the basic last night and tried uploading attributes than i already had manually input into admin, and it still came up blank ??

Do you mean this file as the others don't have as much attribute info

SASH!

Sorry you're struggling with attributes. Did you follow the File Naming Convention for Attribute Imports? This is VITAL! Otherwise EP4 will not know what to do with the file.... basically IGNORING your attributes!

The file naming convention is explicitly documented, use:

Attrib-Basic-EP + what ever you want + .csv
Attrib-Detailed-EP + what ever you want + .csv

You should be first creating your Basic attributes before attempting to modify the Detailed settings (if any).

-chadd

HOW TO ATTACH FILES TO YOUR POST

When you want to attach a file for us to look at, you will first need to ZIP it. You cannot attach .csv files without first doing this.

After you click Reply or Reply to Thread, you will need to click "Go Advanced" ....

Scroll down a bit and you will see a box titled "Additional Options", and under this Attachments.

Click "Manage Attachments" and you will be able to upload your ZIP file.

You don't need to attached every item in your data base. You should NOT be using more than just a FEW record items when you are first learning to do data imports.

Attach your .csv (zipped) exactly how you are uploading it. 95% (or more) of all problems I have helped with are data format related.

-chadd

might be a strange question, but i'd love to convert straight over to EP4 (am running 1.5 with 1.2.5.4,a nd have the new EP installed)...

However my main issue is that my business database (75 tables with ~90,000 records) is currently arranged with exports to feed directly to the older EP.

IS there a way to set up EP 4 to accept (or export) files in the same config (1 record per row, with attribs in the same record by field name) as is setup in EP 1.2.5.4?

currently my database exports in a single MER file wiht the record (ie., model#) as the identifier, and with all attribs in the same record.. It can take quite some time for it to install in the site, but it usually works quite well.

I'd love to be able to take advantage of a few things with EP4, IF I can get past this hurdle.

Thx for any thoughts....

I posted here a couple of pages ago about a GST problem Im having with easy populate.
Basically I need the export to include more decimals, it gets cut off at 2, when adding 10% to that, we dont get back to the correct full retail price.

Heres the link to my full question, be great if someone could point me in the right direction.

http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1161780#post1161780