Easy Populate 1.2.5.4 support

[rufusclc]

Hi - regarding my post earlier today re categories not showing up. Thanx to some-one whose name I cannot remember but in the forum suggested if the EZ file does not load up - look at it in Notepad++. Bingo; my vendor uses tabs in the description file which threw out the columns.
But one thing leads to another: 4 items loaded up, one crashed and at the top of the EZ Pop screen got this message:
Warning: explode() [function.explode]: Empty delimiter in /...../......./......../admin/includes/functions/extra_functions/easypopulate_functions.php on line 241
Can any-one tell me what this means
thanx

[uruharacosplay]

This may be a stupid question, but what is the layout for an Excel Spreadsheet in order to perform this? Is it exactly as the product window is?

What fields do I need to have in order for this to work properly? =/

Thank you!
~Indi

[awhfy99]

Not sure what kind of spreadsheet app your are using (if any) as I do not see any kind of formatting on what you have. I can't see any EOREOR at the end of any line, either. Also, it must saved is a tab-delimited text file.

You need to verify that in every v_model field, the data is unique. If any are repeated, the product will be overwritten with the info from the other one(s).

excel97 works for me but some do not care for it.

I suggest that you download a full text tab-delimited file from your install. Open it with the spreadsheet. Copy/Paste the EOREOR into every line in that column that you will need to upload.

Input your data into the correct fields and then sort (excel has a w/header row as a sort option. Verify that no v_model entry has been duplicated. Then save it to a tab-delimited text file and upload it. Until you are familar with how it all works, do not delete any unused columns.

If all of this is correct and it still fails, go back to the first entry on this topic and read the instructions.

BTW, I upload files with over 3000+ lines without any glitches, so the amount of products is NOT your problem.

[uruharacosplay]

My site is currently down on purpose. I'm purchasing a special template for it and I don't intend to work on the layout until the template is purchased. So, I'm trying to upload all of my products in the meantime.

You will not see any information up there at this time.

What I am asking is this:
My Excel Spreadsheet should look like?

Products ID# | Product Name | Product Type | Weight | IMG SRC

What fields do I need to have so that this works properly and in what order?

Sincerely,
Indi

[uruharacosplay]

I'd be willing to email someone the spreadsheet I currently have. It is not completed yet, but I want to make sure I have all of the fields of information necessary for it to upload properly.

So far my fields are:
Model No: | Series | Genre | Character | Color | Wholesale Price | Retail Price

Do I need to have the fields listed on the products form such as:
Date Available | Description | Quantity | Taxable Goods | etc.

Thank you for your time. =)
~Indi

[awhfy99]

I'd be willing to email someone the spreadsheet I currently have. It is not completed yet, but I want to make sure I have all of the fields of information necessary for it to upload properly.

So far my fields are:
Model No: | Series | Genre | Character | Color | Wholesale Price | Retail Price

Do I need to have the fields listed on the products form such as:
Date Available | Description | Quantity | Taxable Goods | etc.

Thank you for your time. =)
~Indi

Mine looks like this if you are using the Langler version and not the cvs one.

Attributes don't do very well using ep.

If you downloaded a complete tab-delimited text file from your site, the fields will look like the ones in the above image. Some can be left out but it's not a good idea if you are a newbie.

[awhfy99]

i am trying to use easy populate to split my rather large inventory list and import it. I followed the instructions from the INSTALL file and read the read me, but when i go to browse and choose my tab deliminated .txt file, it goes through the long process of what i assume is uploading/splitting the file, but at the end i have nothing added to my product list and no option to import the split up files.

what i do have is a message underneath the create your own / upload your file that says "

Upload split files in turn

All done!

Upload Results

Upload Complete
"

but i have no options to do anything further and nothing is added to my store inventory. I hope someone can help me.

Send me a PM with your email address, I will contact you and then you can attach the first 4 lines of your file to your reply.

[tankdfm]

Just like to say thanks for your help guys I'm sure I making newby mistakes.

I'm going to leave it till after the weekend and see if going at ti with a fresh mind and the information you have supplied makes a differance.

It'll probably be realy obvious when I find what I'm doing wrong.

Any way thanks for not getting the A with my stupid questions.

[flatlanderoutfitters]

I would like to put in for two requests for a new version, and for now, some advice on how to get done what I want to do (Hacking EP to make it work like I want)

First off, reading the code, it looks like it would be fairly easy to add a feature where users can customize a "map" so they can upload a spreadsheet from a supplier's inventory list (without it needing to be zencart compatible) and the headings from that .csv would be "mapped" to the correct fields (I.E. ProdImage => v_products_image )

That way in admin user can set up their own mapping for the data files they wish to upload (or even better a simple point and click interface)

for example, have an area (probably in config) that users can upload a truncated spreadsheet (headings plus 1 row of data) and the code would parse it and display it in a couple of rows, with the required rows for easypopulate below or above , and take the number value from easypopulate fields and enter it to the new spreadsheet rows , indicating which column matches which (it's easier to visualize than to explain) and when everything is set, save the values, with a name they choose - and use that map to parse data from the user's uploads, and they could select the "format name" from a drop down list , default easypopulate .. and easypopulate could simply use that "map info" to parse the given spreadsheet and match it up with what's required.

it would save a massive amount of time. (I'm currently digging around in the code to figure out how to make this happen to direct upload a Doba spreadsheet without altering it)

and Secondly, add a couple of fields to easypopulate for "cost" and "markup" so the user could also include their cost price of the item and customize the markup % , rather than having to figure it for each item, or use the list price. - even better, make it so that markups can be calculated based on a formula set in config (I.E. < $10, markup 40% , $10.01 - $100 markup 30%, $100.01+ , markup 20%) - (I actually have a script that I run commandline right now to parse a "updates" file from supplier with quantity,price,available date, minimum advertised price, and list price, on which I do that sort of operation - but it would be nice to be able to simply upload a fresh spreadsheet with updated data and letting easypopulate calculate the price according to formula)



Now, as for the above two features, I am going to be developing this for myself and a client as well (and probably others that will also want this feature, once they find out about it) an I would like some advice from developers on where the important stuff of the code is- namely - which file and where is the parsing done that reads in the easypopulate csv file and pushes it into the database - and also where is the actual updates to database being done.

It'd help immensely in reading unfamiliar code..

[coolglobal]

How do you upgrade/uninstall EP 1.2.5.4?

I wish to change to: easy_populate_csv_1-2-5-5-csv-2