Jump to content

overspun

Members
  • Content count

    21
  • Joined

  • Last visited

  1. IT WORKED!!!!! Finally. :) thank you.
  2. So basically, all I would need to do is open the file that I posted as my import file in wordpad, and just save it from there and it'll work? No format changes or anything? I have another machine that is a PC that I can use for that.
  3. I'm back to using Excel Safe mode, and I made a file that is in CSV DOS format as the directions said. I also noted something though... it has special instructions for Mac users, which I am... I dont understand exactly what to do though. It says- SPECIAL INSTRUCTIONS FOR MAC USERS ---------------------------------- Because of the differences in the end-of-line characters used by Apple's operating systems, after editing and saving the tab-delimited file, you'll need to open the file in BBedit or equivalent and change the line endings to "Unix". When the product name contains characters with accents they are translated to other characters in the database. Û, for example becomes A with a ~ and a superscript 3. Saving the file as ISO-8859-1 solves the problem. (thanks for BenBogart for this!) Here is the newest file I made- http://racetec-us.com/storetest/temp/EP2008Sep25-1503.csv and settings once more- Settings & Info EP vers: 2.76g-MS2 osCommerce Online Merchant v2.2 RC2a OS: Linux 2.6.26.5-grsec HTTP: Apache/1.3.41 (Unix) mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a DB: MySQL 5.0.51a-community PHP: 5.2.5 (Zend: 2.2.0) Temp Directory: /home/racetec/public_html/storetest/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: on Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false Errors once more- File uploaded. Temporary filename: /tmp/phppyW76N User filename: EP2008Sep25-1503.csv Size: 146146 No products_model field in record. This line was not imported: | he lifespa | | | | | | | No products_model field in record. This line was not imported: | | | | | | | | No products_model field in record. This line was not imported: | iles. As a | 100% OEM f | Authentic | 100% OEM f | Authentic | DUKE DYNAM | OEM Fitmen | Fits both | UV protect | Re-use sto | Unique des | Using the | Highest-Ra | Smooth Rol | Easy Insta | Satisfacti | Double sid | Pack with | DUKE DYNAM | OEM Fitmen | Fits both | UV protect | Re-use sto | Unique des | Using the | Highest-Ra | Smooth Rol | Easy Insta | Satisfacti | Double sid No products_model field in record. This line was not imported: | | | | | | | |
  4. They all have product models. Some of them are the same because the product is linked to a few categories... would that cause a problem? Aside from that though... things I attempt to add are still not showing up at all...
  5. Ok, so I changed the EP_EXCEL_SAFE_OUTPUT to "false" and used the text (tab deliminted) format again after using a different save method from EP so that it didnt exceed the 255 row maximum and It is still not working properly. I'm getting this now- File uploaded. Temporary filename: /tmp/phpaxmFZu User filename: EP2008Sep25-1604.txt Size: 149874 No products_model field in record. This line was not imported: | rything is | | | | | | | No products_model field in record. This line was not imported: | | | | | | | | No products_model field in record. This line was not imported: | =""mailto: | 100% OEM f | Authentic | 100% OEM f | Authentic | DUKE DYNAM | OEM Fitmen | Fits both | UV protect | Re-use sto | Unique des | Using the | Highest-Ra | Smooth Rol | Easy Insta | Satisfacti | Double sid | Pack with | DUKE DYNAM | OEM Fitmen | Fits both | UV protect | Re-use sto | Unique des | Using the | Highest-Ra | Smooth Rol | Easy Insta | Satisfacti | Double sid No products_model field in record. This line was not imported: | | | | | | | |
  6. Whats interesting, is if I save anything other than the complete download of my database on EP, I see the "EOREOR" in the last column... but not this one. When opening the file in excel, I get some sort of message sometimes that says "File not Loaded Completely" Which I figured was disregardable since some of these programs like excel arent flawless with things like this.
  7. My mistake... I knew I was forgetting to do something... Heres all the info- Settings & Info EP vers: 2.76g-MS2 osCommerce Online Merchant v2.2 RC2a OS: Linux 2.6.26.5-grsec HTTP: Apache/1.3.41 (Unix) mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a DB: MySQL 5.0.51a-community PHP: 5.2.5 (Zend: 2.2.0) Temp Directory: /home/racetec/public_html/storetest/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: on Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false Error Messages- File uploaded. Temporary filename: /tmp/phpUFwnqW User filename: EP2008Sep24-2210.txt Size: 477434 No products_model field in record. This line was not imported: | es) 400lb- | Bar/Plate | Powder coa | Stainless | High quali | Scotch Bri | Bar/Plate | Powder coa | Stainless | High quali No products_model field in record. This line was not imported: No products_model field in record. This line was not imported: | A4 2.8 199 | Bar/Plate | Powder coa | Stainless | High quali No products_model field in record. This line was not imported: | (OFE Serie | Customizab No products_model field in record. This line was not imported: No products_model field in record. This line was not imported: No products_model field in record. This line was not imported: No products_model field in record. This line was not imported: No products_model field in record. This line was not imported: No products_model field in record. This line was not imported: No products_model field in record. This line was not imported: | 3" 27 E93 | 100% OEM f No products_model field in record. This line was not imported: | heel (Ligh | 100% OEM f | Authentic | DUKE DYNAM | OEM Fitmen | Fits both | UV protect | Re-use sto | Unique des | Using the | Highest-Ra | Smooth Rol | Easy Insta | Satisfacti | Double sid | Pack with | DUKE DYNAM | OEM Fitmen | Fits both | UV protect | Re-use sto | Unique des | Using the | Highest-Ra | Smooth Rol | Easy Insta | Satisfacti | Double sid No products_model field in record. This line was not imported: No products_model field in record. This line was not imported: File- http://racetec-us.com/storetest/temp/EP2008Sep24-2210.txt Please help!
  8. I'm having an issue where it says "No products_model field in record. This line was not imported:" a bunch of times, with mostly blank parts where it says whats missing, and a few of the ones it lists actually have product model tags in the sql. Also, it is not adding any of the things I add in. They way I tried to do it was copy the entire row of the item in the category that the new one is like, and pasting it, and change the model, and description. I'm doing all this on a test store, and not my real store to prevent any loss, so its not a huge deal to mess with it, but its not adding anything I'm trying to add. The way I tried to do it is this- I downloaded the "Complete" EP file from the menu in my admin panel, opened it up in excep, and saved it as a Text (Tab Delimited) file, and then tried importing it in normal mode in the "Upload and Import EP File" box. And it does not show any of the new things I added to test... What am I doing wrong here? I followed the installation guide carefully and put the 2 php files in the admin folder, and the other one in the other folder, wherever it was, so I'm pretty sure it was installed right since its relatively straight forward. Any help would be greatly appreciated! Thanks.
  9. overspun

    Adding MSRP + Savings?

    anyone? help. =/
  10. I have 2.2 MS2 (060817) and through my searching it seems like this contribution doesnt work well/at all with newer versions of OSC? Just wanted to see if I could get any guidance from anything that may have done it on the same version as I have because I'm pretty new to all this coding stuff. Thanks! Nick Also, it says to add a new field to the "products table" for step one... I have no idea where to find that. The other steps are explained a bit better, but it seems like people are having difficulty implementing this from some version changes of OSC.
×