Help Needed with Easy Populate 4.0.35.

[soxophoneplayer]

This is the best "help" that I can find at the moment for saving files from Open Office. In last use, I think some minor changes were made in the interface, but that should guide to the correct settings needed. It appears that one of the current settings is to convert spaces to semi-colons, which is incorrect as well.

OMG - this link brought me success - particularly the part when "save as" edited file to check the 'edit filter settings' box. Checking this generates the dropdown to select utf-8. I had just been doing save as - csv without checking that box. Kept getting 'no model field in record, this line was skipped' when uploading/importing the edited file.

All this is with zc 1.5.5a, Responsive Sheffiled Blue 2.0 adapted of 1.5.5a, many mods, and Easy Populate 4.0.35

I haven't dared to try the Stock by Attributes facility on EP yet. Baby steps.

[LittleAngell52]

OMG - this link brought me success - particularly the part when "save as" edited file to check the 'edit filter settings' box. Checking this generates the dropdown to select utf-8. I had just been doing save as - csv without checking that box. Kept getting 'no model field in record, this line was skipped' when uploading/importing the edited file.

All this is with zc 1.5.5a, Responsive Sheffiled Blue 2.0 adapted of 1.5.5a, many mods, and Easy Populate 4.0.35

I haven't dared to try the Stock by Attributes facility on EP yet. Baby steps.

Well I am glad you had success cos so far I haven't had any as mine is full of semi-colons for the spaces. Right Yes it is for open office and I was doing the same as you was.

[mc12345678]

Well I am glad you had success cos so far I haven't had any as mine is full of semi-colons for the spaces. Right Yes it is for open office and I was doing the same as you was.

Do you have access or feel like you might be able to export say the products_description table from your phpmyadmin? You should be able to export to a csv file. I'd be interested to know if it includes the semi-colons that are reported to be inserted when EP4 captures the data and stores it in the file.

[LittleAngell52]

Do you have access or feel like you might be able to export say the products_description table from your phpmyadmin? You should be able to export to a csv file. I'd be interested to know if it includes the semi-colons that are reported to be inserted when EP4 captures the data and stores it in the file.

I have just downloaded Product_Description via PHP MyAdmin and everything is correct and no Semi-colons in the file. I have attached the file so you can see for yourself. zen_products_description.zip

[mc12345678]

I reviewed the above file (visually) didn't get a chance to put it through some editors that detect characteristics of the data.

I have three thoughts of things to try.
1. Export the categories listing.
2. Download the generated file.
3. Post the file (do not open the file with any software in this or the previous steps.)

2nd thing: in YOUR_ADMIN/easypopulate_4.php at line 6, change

$csv_delimiter = ",";

To:

$csv_delimiter = "\x2c";

(this is the UTF-8 equivalent to a comma. Then export the categories listing again, post it as a second "file" do not edit or open the file before posting the contents.

3rd thing to try is to read through and verify following the below or similar instruction for importing the CSV into Open Office. Note the expected delimiter is a comma.
https://wiki.openoffice.org/wiki/Doc...ning_CSV_Files

Kind of guessing, thinking that if the export help file helped soxophoneplayer, then perhaps the above would help you or another...

[LittleAngell52]

I reviewed the above file (visually) didn't get a chance to put it through some editors that detect characteristics of the data.

I have three thoughts of things to try.
1. Export the categories listing.
2. Download the generated file.
3. Post the file (do not open the file with any software in this or the previous steps.)

2nd thing: in YOUR_ADMIN/easypopulate_4.php at line 6, change

$csv_delimiter = ",";

To:

$csv_delimiter = "\x2c";

(this is the UTF-8 equivalent to a comma. Then export the categories listing again, post it as a second "file" do not edit or open the file before posting the contents.

3rd thing to try is to read through and verify following the below or similar instruction for importing the CSV into Open Office. Note the expected delimiter is a comma.
https://wiki.openoffice.org/wiki/Doc...ning_CSV_Files

Kind of guessing, thinking that if the export help file helped soxophoneplayer, then perhaps the above would help you or another...

OK Thank you mc12345678. I will give it a try once my site it up on the new server as I just waiting on the new hosting company to make my sites like.

[mc12345678]

OK Thank you mc12345678. I will give it a try once my site it up on the new server as I just waiting on the new hosting company to make my sites like.

Well, if that's the case, I wouldn't worry about the test of bullet 2 above, because 1) code should work out-of-the-box (to the extent that the 4.0.35.ZC.1 version downloaded is free of bugs). 2) have potentially new/different things to deal with so would suggest just trying to use the code again as originally provided and also for education to read the previous post. :)

[LittleAngell52]

Well, if that's the case, I wouldn't worry about the test of bullet 2 above, because 1) code should work out-of-the-box (to the extent that the 4.0.35.ZC.1 version downloaded is free of bugs). 2) have potentially new/different things to deal with so would suggest just trying to use the code again as originally provided and also for education to read the previous post. :)

Ok thank you. I am still setting up server side of the new hosting company once I have installed EP onto the new server I will be using that to get products up onto my store.

[mc12345678]

Ok thank you. I am still setting up server side of the new hosting company once I have installed EP onto the new server I will be using that to get products up onto my store.

You're going to import your "existing" database first though correct? And then add additional product using EP4 or similar, correct?

[LittleAngell52]

You're going to import your "existing" database first though correct? And then add additional product using EP4 or similar, correct?

I thought I might start from afresh as just to make sure everything is going smoothly. I have also found out that I have got broadband issues which don't help matters hopefully they can fix the problem via the telephone exchange. If they can't then they will have to come out to the home and test equipment in my home. I have to keep an eye on how the internet behave's and if no improvement I have to ring them back tomorrow (Mon) to book them coming out to the home.