Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

EasyPopulate 2.3 Released


wasson65

Recommended Posts

I will persevere and get that file to you ASAP if the offer is still open.  again sorry for not getting back to you earlier.

 

First, I'd upgrade my ep to the latest and greatest: 2.41beta7.

 

There have been quite a few bug fixes in the mean time.

 

So you're saying that if you edit an item in the admin section and then dl with EP, the file doesn't change?

 

Odd....

 

Tim

 

Ok Tim thanks for that to save you worry I had misread what you wrote above and have done some more tests today.

 

When I woke up this morning I edited an item and the changes showed in the next EP text file download. But still the new categories and sub categories do not show up.

So I added a kit to one of these categories that do not show and yippee the category and the subcategory appeared. I then noticed that a category that has two sub categories in it BUT also some products in the root category does not show the empty subcategories but displays the products.

 

So my conclusion is that an export via EP does not include any empty categories or indeed subcategories. I am sure I am not the frist one to realsie this and you will now tell me that I should RTFM a bit better next time............if not is there any way of changing it so empty categories and sub categories are also exported/downloaded so that an empty text file with categories can be filled up in excel etc.

 

Thanks in advance

 

You are correct, EP only downloads products, and if there's no product in a category, it doesn't exist as far as EP is concerned. I've never thought of it in that way, I've always been more product centric in my head... 8-)

 

I've thought about having a separate download of just the category information, but haven't gotten there yet. I need a whole lot of those "round-to-its", and then I'd get this stuff really slicked up!

 

Tim

Link to comment
Share on other sites

  • Replies 86
  • Created
  • Last Reply

Top Posters In This Topic

[quote name="wasson65You are correct' date=' EP only downloads products, and if there's no product in a category, it doesn't exist as far as EP is concerned. I've never thought of it in that way, I've always been more product centric in my head... 8-)

 

I've thought about having a separate download of just the category information, but haven't gotten there yet. I need a whole lot of those "round-to-its", and then I'd get this stuff really slicked up!

 

Tim[/quote]

 

As long as its not me doing anything wrong.

 

Its just loads of work filling it up with dummy data just so you can download it and then fill it up with the real data. The biggest problem is until you download the file and see how EP lays it all out you dont really understand it!

 

A lot of the contribs assume too much knowlege and OS itself is harder than it looks........I am starting to wish I had never taken the project on as its taken over my life and its only a favour.

:x

 

 

BTW any chance you can get EP to see empty fields and download them with thefile??

 

Also what would happen if you tried to populate a field with a different category than was already in place??

 

Thanks for your reply Tim

Link to comment
Share on other sites

BTW any chance you can get EP to see empty fields and download them with thefile??

 

Also what would happen if you tried to populate a field with a different category than was already in place??

 

Thanks for your reply Tim

 

All you reakky have to do is enter one product to see how EP lays it all out. And if you change the category to a different one without changing the product number it over writes the current category with the new one. But it doesn't erase the category that was originally there.

 

You can create all the categories and subcategories you want, right in the spreadsheet. I can email you a sample sheet if you want to see how it works and still don't understand.

 

Debbie

[no external urls in signatures please, kthanks]

Link to comment
Share on other sites

BTW any chance you can get EP to see empty fields and download them with thefile??

 

Also what would happen if you tried to populate a field with a different category than was already in place??

 

Thanks for your reply Tim

 

All you reakky have to do is enter one product to see how EP lays it all out. And if you change the category to a different one without changing the product number it over writes the current category with the new one. But it doesn't erase the category that was originally there.

 

You can create all the categories and subcategories you want, right in the spreadsheet. I can email you a sample sheet if you want to see how it works and still don't understand.

 

Debbie

 

Yes please that would be nice.

 

I do think I sort of understand it quite well BUT my problem comes from trying to make it easy for my mate and in the future. MRtt was gonna try and help I believe so I was trying to get all the categories I needed in place before I sent that file and I have been ill so am getting behind now.

 

What I am trying to come up with is a simple front end to EP with a number of boxes so a non computer literate user can input data without seeing the sheet behind it. SO as I say it was because I was trying to see how many boxes I needed before I tried to populate it! It just did not make sense to a new users why the category fileds aer ingored if they are empty they might well need populating and as I said to tim what happens if I try to populate a category already named with a different name etc.

 

Thanks for your reply!

Link to comment
Share on other sites

  • 3 weeks later...

As a programmer, I see that there's often an inverse relationship between how much effort it is to program something, and how much effort it is to use.

 

In other words, to write something that 10% of the people would think is easy, is very easy.

 

To write something that 90% of the people would think is very easy, is very hard.

 

My hat's off to you for all the work you're doing for your friend!

 

If this works, I'd be happy to include it in the contrib.

 

Tim

Link to comment
Share on other sites

Have the problem with the upload mod. Here is the information. It is a WINNT server, iuser has all permissions, also find my admin configure.php

 

Warning: move_uploaded_file(/inetpub/airsoftupgrades/catalog/temp/EP1044936485.txt) [function.move-uploaded-file]: failed to create stream: No such file or directory in C:Inetpubairsoftupgradesadminincludesfunctionsgeneral.php on line 808

 

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move 'C:WINNTTEMPphp18.tmp' to '/inetpub/airsoftupgrades/catalog/temp/EP1044936485.txt' in C:Inetpubairsoftupgradesadminincludesfunctionsgeneral.php on line 808

 

 

File uploaded.

Temporary filename: C:WINNTTEMPphp18.tmp

User filename: EP1044936485.txt

Size: 1449

 

Warning: file(/inetpub/airsoftupgrades/catalog/temp/EP1044936485.txt) [function.file]: failed to create stream: No such file or directory in C:Inetpubairsoftupgradesadmineasypopulate.php on line 621

 

Warning: Invalid argument supplied for foreach() in C:Inetpubairsoftupgradesadmineasypopulate.php on line 625

 

Upload complete

 

 

web files at c:inetpubairsoftupgrades

located at http://localhost

 

CONFIGURE.PHP

 

define('HTTP_SERVER', 'http://localhost'); // eg, http://localhost - should not be NULL for productive servers

define('HTTPS_SERVER', 'https://'); // eg, https://localhost - should not be NULL for productive servers

define('HTTP_CATALOG_SERVER', 'http://localhost/airsoftupgrades');

define('HTTPS_CATALOG_SERVER', 'https://');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/inetpub/airsoftupgrades'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/inetpub/airsoftupgrades/admin/'); // absolute pate required

define('DIR_WS_CATALOG', '/airsoftupgrades/'); // absolute path required

define('DIR_FS_CATALOG', '/inetpub/airsoftupgrades/'); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

Link to comment
Share on other sites

  • 2 years later...
  • 5 weeks later...
Thank you very much!  That did it...

 

 

 

 

...but!

 

I downloaded the file and then went and re-uploaded the file without making changes. It deleted my inventory(new store-2 items...no biggie)! But it said it updated OK... My first thought is a problem with description and tabs....will check, but someone could chime in if they have any thoughts.

 

---------------------------------------------------------

Filename: EP2005Aug25-2210.txt

| C68 | c68.jpg | Duck Hoode | 12-ounce, | | Duck Hoode | | | Duck Hoode | | | 105.93 | 0.00 | | 2005-08-25 | 0 | 1 | Color | Farbe | Color | 16 | Carhartt B | | | +0.0000 | 17 | Dark Brown | | | +0.0000 | 18 | Dark Green | | | +0.0000 | 19 | Dark Red | | | +0.0000 | 22 | MED - REG | | | | 23 | LRG - REG | | | | 24 | LRG - TLL | | | | 25 | XL - REG | | | | 26 | XL - TLL | | | | 27 | 2XL - REG | | | | 28 | 2XL - TLL | | | | 29 | 3XL - REG | | | | 30 | 3XL - TLL | | | | 31 | 4XL - REG | | | | 32 | red | | | | 2 | Size | Gr??e | Talla | 20 | Tall | | | | 21 | SML - REG | | | +0.0000 | 3 | Model | Modell | Modelo | 5 | Version | Version | Version | Carhartt | Outerwear | Coats | | Taxable Go | Active Updated

| C03 | C03.jpg | Duck Tradi | li>12-ounc | | Duck Tradi | | | Duck Tradi | | | 95.23 | 0.00 | | 2005-08-25 | 0 | 1 | Color | Farbe | Color | 16 | Carhartt B | | | +0.0000 | 17 | Dark Brown | | | +0.0000 | 18 | Dark Green | | | +0.0000 | 19 | Dark Red | | | +0.0000 | 22 | MED - REG | | | | 23 | LRG - REG | | | | 24 | LRG - TLL | | | | 25 | XL - REG | | | | 26 | XL - TLL | | | | 27 | 2XL - REG | | | | 28 | 2XL - TLL | | | | 29 | 3XL - REG | | | | 30 | 3XL - TLL | | | | 31 | 4XL - REG | | | | 32 | red | | | | 2 | Size | Gr??e | Talla | 20 | Tall | | | | 21 | SML - REG | | | | 3 | Model | Modell | Modelo | 5 | Version | Version | Version | | Outerwear | Coats | | Taxable Go | Active Updated

| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

 

No products_model field in record. This line was not imported

 

-----------------------------------------------------------

Link to comment
Share on other sites

  • 4 weeks later...

File uploaded.

Temporary filename: /tmp/php2icWef

User filename: EP2005Sep18.txt

Size: 7542

| 2005 | statie_rad | Statie rad | Clic pentr | http://www | Statie rad | | http://www | Statie rad | | http://www | Statie rad | Clic pentr | http://www | 149 | 0.00 | | 17/09/2005 | 5 | 1 | Download: | Download: | Download: | Download: | | 13 | Box: Windo | Box: Windo | Box: Windo | Box: Windo | | | Two Way Ra | | | Taxable Go | Active Updated

| 2005 | Cobra_7080 | Detector r | Acest rada | http://ele | Detector r | | http://ele | Detector r | | http://ele | Detector r | Acest rada | http://ele | 89 | 0.00 | | 17/09/2005 | 10 | 1 | Download: | Download: | Download: | Download: | | 13 | Box: Windo | Box: Windo | Box: Windo | Box: Windo | | Cobra | Radar dete | | | Taxable Go | Active Updated

| 2005 | CANON_350D | Canon EOS | Descriere | www.magazi | Canon EOS | | | Canon EOS | | | Canon EOS | Descriere | www.magazi | 1229.43 | 2.00 | | 16/09/2005 | 0 | 1 | Download: | Download: | Download: | Download: | | 13 | Box: Windo | Box: Windo | Box: Windo | Box: Windo | | Cobra | Radar dete | | | Taxable Go | Active Updated

| 2005 | sony_dcr-t | Sony DCR-T | Descriere | http://www | Sony DCR-T | | http://www | Sony DCR-T | | http://www | Sony DCR-T | Descriere | http://www | 694.43 | 0.00 | | 17/09/2005 | 0 | 1 | Download: | Download: | Download: | Download: | | 13 | Box: Windo | Box: Windo | Box: Windo | Box: Windo | | Cobra | Radar dete | | | Taxable Go | Active Updated

| 2005 | sony_dcr-t | Sony DCR-T | Descriere | http://www | Sony DCR-T | | http://www | Sony DCR-T | | http://www | Sony DCR-T | Descriere | http://www | 694.43 | 0.00 | | 16/09/2005 | 1 | 1 | Download: | Download: | Download: | Download: | | 13 | Box: Windo | Box: Windo | Box: Windo | Box: Windo | | Cobra | Radar dete | | | Taxable Go | Active Updated

| 2005 | E910_l.jpg | Bel Expres | Bel Expres | http://www | Bel Expres | Bel Expres | http://www | Bel Expres | Bel Expres | http://www | Bel Expres | Bel Expres | http://www | 139.99 | 0.00 | | 16/09/2005 | 1 | 1 | Download: | Download: | Download: | Download: | | 13 | Box: Windo | Box: Windo | Box: Windo | Box: Windo | | Cobra | Radar dete | | | Taxable Go | Active Updated

| 2005 | E925_l.jpg | Bel Expres | Bel Expres | http://www | Bel Expres | Bel Expres | http://www | Bel Expres | Bel Expres | http://www | Bel Expres | Bel Expres | http://www | 149.99 | 0.00 | | 16/09/2005 | 1 | 1 | Download: | Download: | Download: | Download: | | 13 | Box: Windo | Box: Windo | Box: Windo | Box: Windo | | Cobra | Radar dete | | | Taxable Go | Active Updated

| 2005 | E935_l.jpg | Bel Expres | Bel Expres | http://www | Bel Expres | Bel Expres | http://www | Bel Expres | Bel Expres | http://www | Bel Expres | Bel Expres | http://www | 199.99 | 0.00 | | 16/09/2005 | 1 | 1 | Download: | Download: | Download: | Download: | | 13 | Box: Windo | Box: Windo | Box: Windo | Box: Windo | | Cobra | Radar dete | | | Taxable Go | Active Updated

| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

 

No products_model field in record. This line was not imported

 

This all the message and I see now it is messing a line from the end with ?All your products was updated?.In the DB was imported only 1 product.

Help

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...