Jump to content

evisions

Members
  • Content count

    9
  • Joined

  • Last visited

Profile Information

  • Real Name
    Chad Stephens
  1. evisions

    Wishlist 3.0 Support Thread

    Hi, I just downloaded and installed the wishlist on my site - it looks pretty good so far. I see that a few people are working on wishlist_help.php - does anyone have an ETA on that? I'd be willing to take hubcap's version without clean code if that is available, I'll have to change it to fit in with BTS anyway. All I really need is some well written text.... Thanks, Chad
  2. I found the solution to my problem with the Date Added field being zeroed. The issue was with excel (which I expected). Aparently excel decides that it is smarter then the user and switches the date format on the date added field. The solution is fairly simple (unfortunately it has to be done every time you export). In excel, Select the date added column click format->cells click Custom on the left if it isn't already selected Enter the following in the Type: field: yyyy-mm-dd hh:mm:ss That's it - then it works like a charm. -Chad
  3. The date exports just fine, it is in the export file. So, I think the issue is on the import side.... So here is the code which comes from the incoming side.... if ($v_date_added == '') { $v_date_added = "CURRENT_TIMESTAMP"; } else { // we put the quotes around it here because we can't put them into the query, because sometimes // we will use the "current_timestamp", which can't have quotes around it. $v_date_added = '"' . $v_date_added . '"'; } I don't believe any change has been made to that area. All the products end up with a date added of "0000-00-00 00:00:00". Here is the INSERT statement: $query = "INSERT INTO ".TABLE_PRODUCTS." ( products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '$v_products_image',"; // chad added for image support $query .="'$v_products_image_med', '$v_products_image_lrg', '$v_products_image_sm_1', '$v_products_image_xl_1', '$v_products_image_sm_2', '$v_products_image_xl_2', '$v_products_image_sm_3', '$v_products_image_xl_3', '$v_products_image_sm_4', '$v_products_image_xl_4', '$v_products_image_sm_5', '$v_products_image_xl_5', '$v_products_image_sm_6', '$v_products_image_xl_6', "; // end chad added for image support $query .="'$v_products_model', '$v_products_price', '$v_db_status', CURRENT_TIMESTAMP, $v_date_added, $v_date_avail, '$v_tax_class_id', '$v_products_weight', '$v_products_quantity', '$v_manufacturer_id') "; Here is the export line from Excel, which includes a date added: 234 products/bracelets/th/flowered-byz2.jpg Flowered Byzantine Copper Bracelet "This copper bracelet combines the Byzantine pattern with the unique flowered chainmail pattern to create a stunning new bracelet. The Byzantine used here is our Micro size and together with the simple flowers we create a beautiful, dainty design fit for any lady with style." 35 0 7/8/2005 18:00 0 2 Beads 7 Faux Pearl 8 None 9 Faceted Glass Ball Black 15 Black Tear Drop 16 Copper Finished Fire Polished Glass Ball 17 Antique Copper Finished Glass Ball 18 Black Jade Ball 19 Hemitite Ball 20 Hemitite & Blue Glass Balls 3 Bells 1 Brass 2 Copper 4 Ear Wire 10 Niobium (Copper Finish) 11 Surgical Steel 12 14k Gold Fill 13 Sterling Wire 14 Sterling Post 5 Length 21 16 Inches 22 18 Inches 23 20 Inches 24 6.5 Inches 0 25 7 Inches 0 26 7.5 Inches 0 27 8 Inches 0 28 8.5 Inches 0 Copper Bracelets Taxable Goods Active products/bracelets/med/flowered-byz2.jpg products/bracelets/flowered-byz2.jpg products/bracelets/th/flowered-byz4.jpg products/bracelets/flowered-byz4.jpg products/bracelets/th/flowered-byz.jpg products/bracelets/flowered-byz.jpg EOREOR Everything looks correct to me, unless excel has messed with the date format, but that appears correct too...
  4. I just discovered, that when using Easy Populate, my Date Added field get's blanked. This isn't a big deal, but it screws up the "What's New" section of my site. Has anyone dealt with this issue? Is it created by manipulating the file with Excel, or is it from EP? Thanks, Chad
  5. I just discovered, that when using Easy Populate, my Date Added field get's blanked. This isn't a big deal, but it screws up the "What's New" section of my site. Has anyone dealt with this issue? Is it created by manipulating the file with Excel, or is it from EP? Thanks, Chad
  6. evisions

    SECPay 2.2 error

    Did you guys ever get this issue solved? I'm setting up a secpay site and I seem to be having the same issue with the default module.
×