Easy Populate 1.2.5.4 support

[freshstart]

:) That did it ! ;)

Only problem is the images are not showing still ...

Hello Makeuo4brides

Glad I was of help (was a surprise for me) with your EP issue. Did you manage to get your images issue sorted?

Best wishes,

Freshstart

[freshstart]

Makeup4Brides,
FreshStart was correct, EOREOR denotes End of Row/End of Record. That helps EP know when one record/row ends and another begins. As for the images, did you upload them before trying to import the EP file?

Makeup4Brides and FreshStart,
Take a look at http://www.zen-cart.com/forum/showpo...&postcount=856. It was a post I did a few pages back as a quick and ugly FAQs for EP. A couple post below it is another one for attributes by another user. I am updating my sig to provide quick links that should show up on all of my posts.

Hello Awev

Many thanks for your previous advice and support. I have just been introduced to EP and as you will have seen from a recent post I am not the sharpest tool in the box when it comes to understanding it.

Would you be willing to outline for me (very simply) what it is that you actually have to do to get stock information onto your website. I am having difficulty understanding your previous post and how to put that advice into practice

What I am trying to eventually do is download stock information via a XML live feed from a supplier, import that into a spreadsheet, since the info will not transfer directly to Zencart. Then from the spreadsheet to Zencart in the form of a tab delimited text file.

Up to now I have installed EP onto a test site with no issues. I have saved the XML info to a Excel text file. I am unsure of exactly what to do with it from there?

As with Makeup4brides example I understand that I would need to place stock information underneath a line of text, produced within a downloaded EP file, then upload that to my site?

Do you think you can offer me further simple advice?, or refer me to a source of further information. I am a total beginner

Best wishes,

Freshstart

[awev]

Hello FreshStart,
Open your XML live feed in Excel as you have, and check the info. Is it all there? Can you tell what is what? Would you mind sending me a copy so I can look at it and tell what is going on?

Have you entered a couple products manually yet into ZC? If so then download that info using EP so you have a template to use, and something to refer to. Open it as a new spreadsheet in Excel. You will be switching between the XML and the EP spreadsheets, copying info from one and pasting into another.

What you will do is copy the stock level info from the XML live feed and paste it into the EP spreadsheet under v_products_quantity.

If you have a database that supports the importing/exporting of XML info you may be able to just use that, along with an update command.

Myself, I use OpenOffice for a number of reasons, so I may not be the best one to help you. I don't care to us Micro$oft products if I can help it. I prefer open source, and that includes Linux. I haven't used Excel, Access, or even M$ Word for close to a decade. I did get a copy of M$ Office 97 when I built a computer back in 1998, yet I haven't used it since (came as a bundled package with windoze 98 for cheap.)

[awev]

Well Kia920,
What was the answer? Did you need help on entering the HTML code, the style of the text, the tools to use, or what? That last question was so open-ended that it did make it hard to answer. So, what have you come up with? A little more feedback would be nice. Ok, I just want to know what details you are thanking me for.

You set out a plan on how you would go about uploading your images, and product info using EP. Did that work out for you? And what about IM2? Was the people over on the IM2 forums able to help you as well?

I can wait another three (3) weeks for an answer. I know real life makes demands of all of us, and we can't be here all of the time (my cable internet was out for the weekend - real life stinks at times).

Hope all is going well.

[freshstart]

Hello Awev,

Hello FreshStart,
Open your XML live feed in Excel as you have, and check the info. Is it all there? Can you tell what is what? Would you mind sending me a copy so I can look at it and tell what is going on?

I have sent you a PM with the information you requested.

Best wishes,

Freshstart

[tj1]

Hi Awev, I know how to add additional fields to EP thanks to your other post.

I was wondering if you know how to add additional fields (ex. alias, catalog_page_no, sku, etc) to the database.

There's this post http://www.zen-cart.com/forum/showthread.php?t=57924 that explains how to add additional fields to the same products table, but I think putting the additional fields on a different table would be better when the time to upgrade comes.

[awev]

Hello TJ1,
That is an easy thing, just go to the Patch SQL Install and issue a couple commands.

First, we will start with a simple command,

SHOW DATABASES;

This tells us the database name that we will use. Next, issue the

SHOW TABLES FROM db_name;

We use the database name(s) returned from the SHOW DATABASE command in place of db_name in the above command. This lets us see if there is a prefix that we need to use.

Next, we use the CREATE TABLE like the following, what I lifted from the address book part of ZC:

DROP TABLE IF EXISTS "zencart"."zc1_address_book";
CREATE TABLE  "zencart"."zc1_address_book" (
  "address_book_id" int(11) NOT NULL auto_increment,
  "customers_id" int(11) NOT NULL default '0',
  "entry_gender" char(1) NOT NULL default '',
  "entry_company" varchar(32) default NULL,
  "entry_firstname" varchar(32) NOT NULL default '',
  "entry_lastname" varchar(32) NOT NULL default '',
  "entry_street_address" varchar(64) NOT NULL default '',
  "entry_suburb" varchar(32) default NULL,
  "entry_postcode" varchar(10) NOT NULL default '',
  "entry_city" varchar(32) NOT NULL default '',
  "entry_state" varchar(32) default NULL,
  "entry_country_id" int(11) NOT NULL default '0',
  "entry_zone_id" int(11) NOT NULL default '0',
  PRIMARY KEY  ("address_book_id"),
  KEY "idx_address_book_customers_id_zen" ("customers_id")
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Things to note: 1) CREATE TABLE "zencart"."zc1_address_book" means create the table zc1_address_book in the database zencart. In this case I am using the prefix zc1_ so we would use that in creating a new table. 2) I don't know if you need a crash course in MySQL syntext or not, yet I'll cover a couple basic things. For more info you can go to http://mysql.org. 3) int(11) means an integer value extending to 11 places left of the decimal point, while varchar means up to 32 charters in the field. 4) PRIMARY KEY ("address_book_id") indicates what field will be the primary key, while it shows a second key being created called "idx_address_book_customers_id_zen" that is based on the field customers_id.

The easy part is done. Now you have to insert the needed code in the correct pages in the correct areas, with the correct fields to be displayed and for data entry.

Just some questions to ask yourself:
A) What fields do you need in the table?
B) What type of fields - decimal, charter, integer, text, blob, etc, and how much information will be contained in each field.
C) What areas do you need the info displayed in? Is is just for the administrator, the administrator and customer?
D) Will you use the new data in calculations, and if so, how? Do you have any test data where you already know the answers to that you can use to test the new code with?

Good luck with your project.

[Dionysian]

Hi, I greatly appreciate any help anyone can give with the problem I'm experiencing.

I have a .txt file of categories/subcats and their corresponding images and descriptions that was generated by Easy Populate Advanced. I'm trying to import that list on a fresh site using Easy Populate Basic, the last release. I keep getting a "Model not found, line was not imported" error message when trying this.

Is this just a compatibility issue? What can I do to work around this? Thanks.

[tj1]

I haven't really used EP advanced, so I'm not sure I may be able to help. I used it once but found it a bit more complicated and just dropped it.

Anyway, with EPA I think you first create categories before being able to upload any products.
EP standard works differently, categories can only be created if there's an associated product model. Or, for the same matter, you cannot update/create anything if there's no product model in the file you upload.

[Dionysian]

Thanks. How can I work around this?