Easy Populate & Products Attributes

[Guest]

look in the category description you have for those products, could be apostrophes, etc.

[ishtek]

Nope no apostrophies. I had a problem with those that stopped things from importing but that was for other products that seem to be fine now.

 

What flags the products as new vs updates?

[PhilPoxon]

first thing i see there, is your server load average, you must be on a shared server and you will be having numerous problems with slow load of pages, peope will complain, etc.  it needs to be below 1.00 (this doesnt fix your ep problem tho).

set in your admin/includes/configure.php file document_root to $DOCUMENT_ROOT

you also have " in your text, what is that from?

<{POST_SNAPBACK}>

 

 

The quote is from the format of the csv.txt save function in the spreadsheet program

using OpenOffice 1.1.4. it allows for saving a spreadsheet as a text file using tab character as a separator and to mark text using either a single(') or double (") quote.

Seeing all the problems discussed in this thread about the sinlge quote or apostrophe, I decided to use the double quote (")

 

I have set the document_root to $DOCUMENT_ROOT which on my installation is "define('DIR_FS_DOCUMENT_ROOT', '/home/ipocnug/public_html');" If I leave the $tempdir = /catalog/temp/ i get the following error:

 

Warning: file(/home/ipocnug/public_html/catalog//catalog/temp/EP_Split1.txt) [function.file]: failed to open stream: No such file or directory in /home/ipocnug/public_html/catalog/admin/easypopulate.php on line 666

 

When I change $tempdir = /temp/ the problem disappears

 

For some reason in easypopulate.php, the DIR_FS_DOCUMENT_ROOT define appends /catalog/ to the information stored there

 

As i asked before, should there be LF between each row (Unix format) or does it matter that the Windows format for a text file adds CR/LF and CR between each row

In viewing the sample_output_file.txt I see that the rows are separated by a single LF. It appears that after the first line of the uploaded file is processed, the separator value (\t) is ignored or thrown out of sequence by extra characters the program does not recognize

[tommyz]

Hi,

 

this thread is so huge, I cannot find what I am looking for...

 

The option to download/create file with Model/Attribute in the easypopulate admin page does not work. I get the file but only with model name listed. I am using latest version of easy populate.

 

Is this feature suppose to work with the default install of easypopulate or is there a tweak that I need to apply?

 

If someone could point me at a howto or a thread or post with in this mega-thread. Please please do so.

 

thanks

 

Tom

[Guest]

Hello, I am havng a little trouble with javascript and easypopulate. When I put this code into osCommerce it works fine. I then export the items and get this code in the easypopulate spreadsheet:

<script LANGUAGE="JavaScript">    <!-- Begin  function popUp(URL) {  day = new Date();  id = day.getTime();  eval("page" + id + " = window.open(URL, '" + id + "', \'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,width=55
0,height=374\');");  }  // End -->  </script>  <A HREF="javascript:popUp('http://www.2dogrc.com/ecommerce/os/catalog/images/gwspics/expanded400.jpg')"><font size=2>Expanded View</A>

 

As you can see the apostrohes have slashes except for the ones at the end. If I upload this withouout changine a thing using Easypopulate I get this error:

 

test | gwspics/po | test | GW/EPS-400 | www.gws.co | 12 | 0.5 | | 2005-07-03 | 5 | 1 | 9 Gram ser | 1 | 1 | | 2 | 2 | | GWS | GWS Power | EPS (Elect | EPS-400C | Taxable Go | Active Updated
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'http://www.2dogrc.com/ecommerce/os/catalog/images/gwspics/expan

INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '1705', 1, 'test', '

 

If I insert the slashes then in front of the remaining apostrophes, it will upload fine. HOWEVER, the javascript does not work:( By this I mean when I put the mouse over the link the address is correct, but unclickable.

 

Any ideas form the wise? Thanx in advance!

2dogrc

[PhilPoxon]

Hello, I am havng a little trouble with javascript and easypopulate.  When I put this code into osCommerce it works fine.  I then export the items and get this code in the easypopulate spreadsheet:

<script LANGUAGE="JavaScript">    <!-- Begin  function popUp(URL) {  day = new Date();  id = day.getTime();  eval("page" + id + " = window.open(URL, '" + id + "', \'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,width=55
0,height=374\');");  }  // End -->  </script>  <A HREF="javascript:popUp('http://www.2dogrc.com/ecommerce/os/catalog/images/gwspics/expanded400.jpg')"><font size=2>Expanded View</A>

 

As you can see the apostrohes have slashes except for the ones at the end.  If I upload this withouout changine a thing using Easypopulate I get this error:

 

test | gwspics/po | test | GW/EPS-400 | www.gws.co | 12 | 0.5 | | 2005-07-03 | 5 | 1 | 9 Gram ser | 1 | 1 | | 2 | 2 | | GWS | GWS Power | EPS (Elect | EPS-400C | Taxable Go | Active Updated
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'http://www.2dogrc.com/ecommerce/os/catalog/images/gwspics/expan

INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '1705', 1, 'test', '

 

If I insert the slashes then in front of the remaining apostrophes, it will upload fine.  HOWEVER, the javascript does not work:(  By this I mean when I put the mouse over  the link the address is correct, but unclickable.

 

Any ideas from the wise?  Thanx in advance!

2dogrc

<{POST_SNAPBACK}>

 

You also need to escape (\) the apostrophes in the a href statement also.

 

The A HREF statement needs to read: <A HREF="java script:popUp(\'http://www.2dogrc.com/ecommerce/os/catalog/images/gwspics/expanded400.jpg\')"><font size=2>Expanded View</A>

 

Have you tried going into the page for that item in Admin and editing it there to remove the \ in the description if they are still there after you have uploaded the file

 

t

[Naegle]

I'm stuck at this point. I upgraded easypopulate to EP_v2_76_MS2 and now nothing is uplolading to the database. My old version would import the files from my computer, now it appears it imports from the temp directory, right?

 

I'll select the file to import from temp, but nothing gets imported to my store.

It just sits there, no streaming data, no error. It just gives me a blank stare and says

 

ANY IDEAS?

 

Thanks

<{POST_SNAPBACK}>

 

Found the error. It took a little searching through previous posts to find it. It was a simple change of easypopulate.php back to a tab delimited file, instead of a colon.

Thanks Mibble!

I do admit that its difficult to sort through the hundreds of posts, but I think that most any question has already been answered. It just takes a little time, and use of the search function. I should have searched more before I cried for help. :-"

[Guest]

You also need to escape (\) the apostrophes in the a href statement also.

 

The A HREF statement needs to read: <A HREF="java script:popUp(\'http://www.2dogrc.com/ecommerce/os/catalog/images/gwspics/expanded400.jpg\')"><font size=2>Expanded View</A>

 

Have you tried going into the page for that item in Admin  and editing it there to remove the \ in the description  if they are still there after you have uploaded the file

 

t

<{POST_SNAPBACK}>

 

Yes I have tried that. But that really defeats the purpose of "easy"populate. If I have to edit the files each time I upload them. I can upload the code with the \ slashes in, but when exporting the file, the code is changed.

Thanx

2dogrc

[wasztar]

This what I am getting when I try to uploaded file

 

File uploaded.

Temporary filename: /var/tmp/phpp4UPbq

User filename: EP2005Jun27-2109.txt

Size: 539707

| K8MM-ILSR | ms-6741-03 | MSI K8MM-I | CPU • Su | www.msicom | 123 | 3 | | 6/4/2005 2 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | MSI | Motherboar | | | --none-- | Active Updated

| K8MM-ILSR | ms-6741-03 | MSI K8MM-I | CPU • Su | www.msicom | 123 | 3 | | 6/4/2005 2 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | MSI | Motherboar | AMD Socket | MSI | --none-- | Active Updated

| K8N Diamon | BMS6764-D. | MSI K8N DI | CPU • | www.msi.co | 330 | 3.5 | | 6/4/2005 2 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | MSI | Motherboar | | | --none-- | Active Updated

| K8N Diamon | BMS6764-D. | MSI K8N DI | CPU • | www.msi.co | 330 | 3.5 | | 6/4/2005 2 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | MSI | Motherboar | AMD Socket | MSI | --none-- | Active Updated

| 865M01G6LS | BFO865M01G | FOXCONN 86 | Intel 865G | | 112 | 3 | | 6/4/2005 2 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Foxconn | Motherboar | Intel Sock | Foxconn | --none-- | Active Updated

| NF4K8AB-RS | BFONF4K8AB | FOXCONN NF | Processor: | www.foxcon | 125 | 3 | | 6/4/2005 1 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Foxconn | Motherboar | | | --none-- | Active Updated

| NF4K8AB-RS | BFONF4K8AB | FOXCONN NF | Processor: | www.foxcon | 125 | 3 | | 6/4/2005 1 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Foxconn | Motherboar | AMD Socket | Foxconn | --none-- | Active Updated

| CULCK1007- | CULCK1007- | CASETEK CK | Black colo | www.casete | 128 | 7 | | 6/4/2005 0 | 4 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Casetek | Cases | ATX | Casetek | --none-- | Active Updated

| CULCK1016- | CULCK1016- | CASETEK CK | Side Panel | www.casete | 0 | 9.5 | | 6/4/2005 1 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Casetek | Cases | ATX | Casetek | --none-- | Active Updated

| CULCK1016- | CULCK1016- | CASETEK CK | Side Panel | www.casete | 0 | 9.5 | | 6/4/2005 1 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Casetek | Cases | ATX | Casetek | --none-- | Active Updated

| 760GXK8MB- | BFO760GXK8 | FOXCONN 76 | Processor: | www.foxcon | 100 | 3 | | 6/4/2005 1 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Foxconn | Motherboar | AMD Socket | Foxconn | --none-- | Active Updated

| 661MX | BFO661MX.j | FOXCONN 66 | Processor: | www.foxcon | 66 | 3 | | 6/4/2005 2 | 2 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Foxconn | Motherboar | Intel Sock | Foxconn | --none-- | Active Updated

| K7S741GXMG | BFOK7S741G | FOXCONN AM | Processor: | www.foxcon | 62 | 2.5 | | 6/4/2005 1 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Foxconn | Motherboar | | | --none-- | Active Updated

| K7S741GXMG | BFOK7S741G | FOXCONN AM | Processor: | www.foxcon | 62 | 2.5 | | 6/4/2005 1 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Foxconn | Motherboar | AMD Socket | Foxconn | --none-- | Active Updated

| K7S741MG6L | BFOK7S741M | FOXCONN AM | Support AM | www.foxcon | 69 | 2.8 | | 6/4/2005 1 | 2 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Foxconn | Motherboar | AMD Socket | Foxconn | --none-- | Active Updated

| 865A01PE6L | BFO865A01P | FOXCONN 86 | Processor: | www.foxcon | 115 | 3 | | 6/4/2005 2 | 2 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Foxconn | Motherboar | Intel Sock | Foxconn | --none-- | Active Updated

| CULCK1020- | CULCK1020- | CASETEK CK | CASETEK CK | www.casete | 262 | 15.7 | | 6/2/2005 4 | 5 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Casetek | Cases | ATX | Casetek | --none-- | Active Updated

| CK-1008-3A | CULCK1008- | CASETEK CK | Model CK-1 | casetek.co | 97 | 7.82 | | 6/2/2005 4 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Casetek | Cases | ATX | Casetek | --none-- | Active Updated

| CULCK1020- | CULCK1020- | CASETEK CK | CASETEK CK | www.casete | 300 | 16 | | 6/4/2005 0 | 4 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Casetek | Cases | ATX | Casetek | --none-- | Active Updated

| CULCK1007- | casetek.jp | CASETEK CK | CASETEK CK | www.casete | 85 | 8 | | 6/4/2005 0 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Casetek | Cases | ATX | Casetek | --none-- | Active Updated

| CULCK1007- | casetek.jp | CASETEK CK | CASETEK CK | www.casete | 89 | 8 | | 6/4/2005 0 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Casetek | Cases | ATX | Casetek | --none-- | Active Updated

| CULCK1007- | casetek.jp | CASETEK CK | CASETEK CK | www.casete | 89 | 8 | | 6/4/2005 0 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Casetek | Cases | ATX | Casetek | --none-- | Active Updated

| 121I | 120i.jpg | Altec Lans | Quality st | www.altecl | 59 | 4.2 | | 6/14/2005 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | Altec Lans | Speakers | Altec Lans | | --none-- | Active Updated

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 're up and running in seconds and, with a built-in power supply,

 

INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '44', 1, 'Altec Lansing 121i, 3 Pices, Speaker/Subwoofer, 20Watts RMS, 140-20kHz, Black, Silver', 'Quality stereo… Gaming, music or movies… your PC will come alive! Quality bass… The ported wood subwoofer adds a new level in gaming realism! Improved sound imaging… Two separate satellite speakers improve perception of both gaming action and stereo recordings. Distinctive Styling… Elegant design with cloth grilles looks great anywhere in your home. Not just for your PC… Easily connects to video gaming systems*, portable CD players, MP3 players, and more! Built-in Controls... Power, volume, bass and tone are all at your fingertips. Easy Set-up... You're up and running in seconds and, with a built-in power supply, you can plug in anywhere. Shielded Satellites... For use near video monitors.

 

Specifications

 

Total Power Output : 20 Watts RMS

 

Satellite Speaker Power Output : 5.5 Watts RMS @ 8 ohms

 

Subwoofer Power Output : 9 Watts @ 4 ohms

 

Frequency Response :

 

Satellite : 140 Hz - 20 KHz

 

Subwoofer : 20-140 Hz

 

Package : Retail package

 

Dimension : Satellite : 86 mm (W) X 90 mm (D) X 127 mm (H)

 

Subwoofer : 150 mm (W) X 275 mm (D) X 220 mm (H)

 

Warramty : 1 year Weight : 3.8 kg', 'www.alteclansing.com/product_details_intl.asp?pID=120i&region=asiapac&country_code=au' )

 

[TEP STOP]

 

 

 

I Have imported about 13 products into my database and everytime I try to uploaded a file I am getting that message.

 

Any Ideas?

[Guest]

You're up

to

You\'re up

[wasztar]

You're up

to

You\'re up

<{POST_SNAPBACK}>

Now I am getting this

 

File uploaded.

Temporary filename: /var/tmp/phpp4UPbq

User filename: EP2005Jun27-2109.txt

Size: 546366

| K8MM-ILSR | ms-6741-03 | "MSI K8MM- | | | | | DR40 | "CPU • S | | | | | 3200+, | | | | | 3400+, | | | | | 3700+ | | | | | 2800+, | | | | | 3000+, | | | | | 3100+(CG), | | | | | 3300+ | | | | | AID 1 | www.msicom | 123 | 3 | | 6/4/2005 2 | 3 | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | 6 | Warranty | MSI | Motherboar | | | --none-- | Active Updated

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CPU

 

• Supports 64-bit AMD? Athlon™ 64 processor (Sock

 

UPDATE products SET products_price="0" ,products_image="ms-6741-030.jpg", products_weight="", products_tax_class_id="", products_date_available= "DR40", products_date_added= ""CPU

 

• Supports 64-bit AMD? Athlon™ 64 processor (Socket 754)

• Supports 3000+, ", products_last_modified=CURRENT_TIMESTAMP , products_quantity="1" ,manufacturers_id=15 , products_status=1 WHERE (products_id = "28")

[Guest]

i am surprised it got that far, because of the quotes:

 

"MSI K8MM- | | | | | DR40 | "CPU ? S

[wasztar]

i am surprised it got that far, because of the quotes:

 

"MSI K8MM- | | | | | DR40 | "CPU • S

<{POST_SNAPBACK}>

Any ideas how to fix it?

[Guest]

is your program you are using, (excel, openoffice, quattropro) inserting them? without seeing that line, kind of tough to know

[wasztar]

is your program you are using, (excel, openoffice, quattropro) inserting them?  without seeing that line, kind of tough to know

<{POST_SNAPBACK}>

Thanks Mibble for your help now everything seems to be ok. I just uploaded 80 products without any problems. I used notepad to edit my file, excel was the one to blame.

[Guest]

in your setting when you save as a tab delimited file, all the items are there for setting the data properly

[Gil_e_n]

Hi. I apologize for this, but I can absolutely not get EP to work. No matter what I do, all I get when I upload a file is this:

 

File uploaded.

Temporary filename: /tmp/php717996

User filename: sample_output_file2.txt

Size: 74713

 

I have created a temp file in catalog, and set its permissions to 777. My $tempdir is set to /catalog/temp/. At the moment, I'm using the sample output file that came with EP to try to upload, because of a boring and irrelevant story that sums down to I don't have access to the company database to create my own. I don't think there would be any errors in that to prevent it from uploading properly. I have tried creating my own sample files, just in case, using the tab-delimited files that I can download from the admin page, but those just give me the exact same error. I'm really kind of stuck here.

 

The only contribution I have installed is Linda's Header Controller. I followed the instructions to make it work with that.

 

Please help.

[Guest]

try setting document root in your admin/includes/configure.php file from its current setting to $DOCUMENT_ROOT

also try uploading one line only at a time perhaps you have data errors

[Gil_e_n]

I just tried both suggestions, and it still didn't work, I'm afraid.

[Rutilia]

I just tried both suggestions, and it still didn't work, I'm afraid.

<{POST_SNAPBACK}>

 

Did you try checking what the default is in configure.php for the uploaded files? I found that in my case the default was set to semicolon delimited instead of tab-delimited, and once I changed this it worked. Hope this helps. :thumbsup:

[heisl1903]

please tell me if you know

Why does easy populate produce this (bold) path?? and forces the whole thing not to work?

 

Warning: move_uploaded_file(/www/htdocs/xxxxx/osShop/catalog//catalog/temp/EP2005Jul08-1503.txt: failed to open stream: No such file or directory in /www/htdocs/xxxxxx/osShop/catalog/admin/easypopulate_functions.php on line 32

[Guest]

default in the easypopulate.php, not configure.php, see whether it is semicolon or tab, you will need to edit the file.

[Gil_e_n]

Thanks. I already changed that, though. (And then changed it back, to see if it'd work that way. And then tried all the bloody settings there, just in case.) And it still doesn't seem to want to work.

[Gil_e_n]

default in the easypopulate.php, not configure.php, see whether it is semicolon or tab, you will need to edit the file.

<{POST_SNAPBACK}>

 

Thanks, but I've tried it as both tab and semi-colon (changing the output file to be separated with semi-colons when it was set to semi-colon, of course), and it doesn't work. It's currently set to tab.

[Jack_mcs]

It looks like a valid path. What do yu think is wrong with it?

 

Jack