Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate Contribution


Guest

Recommended Posts

I created 3 new fields in the database and they are displayed on the admin product update page and show up on the product page. All works great, the fields update the database and product query makes the db info show up on the product page. That?s all cool! Then I installed the Easy Populate Contribution. (also a cool add-on B) ) My problem... I can download a (text-delimited) file with EP that I put into the catalog through the admin page, but when I upload the file using EP, the data in the (3) new fields have time/date/ and status (1) in place of the text information that was uploaded. All the other fields on the line is correct (including time /date/ and status (1)). The upload looks good to me ?

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

File uploaded.

Temporary filename: /var/tmp/php1X5RnW

User filename: test.txt

Size: 1268

| 890662363 | 0f.jpg | Truths Of | With the l | Tyndale | Hardback | Clean | | 12.75 | 0 | 0000-00-00 | 3/23/2004 | 1 | 0 | | 0 | | | RC Sproul | Religion & | | | --none-- | Active !New Product!

| 195355555 | 211.jpg | Golf | how to pla | SPI | Paperback | good | | 5.95 | 0 | 0000-00-00 | 3/23/2004 | 5 | 0 | | 0 | | | Larry Boy | Sports | | | --none-- | Active Updated

| | | | | | | | | | | | | | | | | | | | | | | | No products_model field in record. This line was not imported

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

I?m Trying to find out why it looks good going in but something changes it when it gets to the Dbase.

( My database)

+--------------------+---------------------+-------------+-------------------+----------------+----------------+----------------+---------------------+------------------------+-------------------------+-----------------+-----------------+-----------------------+------------------+------------------+--------------------+---------------------+

| products_dust_jack | products_binding | products_id | products_quantity | products_model | products_image | products_price | products_date_added | products_last_modified | products_date_available | products_weight | products_status | products_tax_class_id | manufacturers_id | products_ordered | products_publisher | products_pub_date |

+--------------------+---------------------+-------------+-------------------+----------------+----------------+----------------+---------------------+------------------------+-------------------------+-----------------+-----------------+-----------------------+------------------+------------------+--------------------+---------------------+

| Clean | Hardback | 161 | 1 | 0890662363 | 0f.jpg | 12.7500 | 2004-03-23 04:04:40 | 2004-03-24 21:15:15 | 0000-00-00 00:00:00 | 0.00 | 1 | 0 | 11 | 0 | Tyndale | 0000-00-00 00:00:00 | | 3/23/2004 4:04 | 2004-03-31 22:24:18 | 174 | 0 | 195355555 | 211f.jpg | 5.9500 | 0000-00-00 00:00:00 | 2004-03-31 22:31:28 | 0000-00-00 00:00:00 | 0.00 | 1 | 0 | 16 | 0 | 1 | 0000-00-00 00:00:00 |+--------------------+---------------------+-------------+-------------------+----------------+----------------+----------------+---------------------+------------------------+-------------------------+-----------------+-----------------+-----------------------+------------------+------------------+--------------------+---------------------+

 

Is EP doing this to the data?

 

 

Any help :blink: would be appreciated!!!

 

Thanks

Jerry

Edited by Greybeard
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...