MDXMan

I got the UPS XML up and running sort of. It seems to be working ok without error but I only get 1 choice when the shipping page comes up is UPS Express Saver even though I have other choices checkmarked in the admin. Any help please I am using 1.1.4 by the way

Its not EP's fault nor is it mine. It turns out that its good old microcrap excel thats modifying the date to something it cant use. I was looking at an already saved file when i said the txt file was the same. Any ideas on how to get around this problem other than manually editing the txt file

I am putting it in exactly as the in the same format as what it exports as. It exports from EP as 4/21/2005 0:00 and i use the same format. Even if i change an already good value it doesnt update at all. So the best I can think is that in order to import it has to be changed to that of how mysql sees it (ie 0000-00-00 00:00:00) so it could possibly be Excel that is screwing it up but if i textedit the txt file it comes up like this 4/21/2005 0:00 as well so I am at a loss

One more question if you guys dont mind. I got the hang of it mostly but I added in an existing field from the products table but this time its a datetime field rather than a varchar as in the example but it doesnt import that specific date for that field but does everything else. Is there a change in that to that example in the contrib when using datetime fields?

Forget it looks like I got it working. Still those instructions for that contrib are not for a noob.

I have only added the 1 field to a stock easypopulate.php So then as per the files instructions all should be fine if they are correct. Then what would be the proper order?

Thanks Rob123, that fixed that issue but now I have another | MAR05 FFFF | | testing | | | 100 | 0.02 | | 2/10/2005 | 1000 | Marvel | TPB | | | GST/HST/PS | Active | Testing !New Product! 1048 - Column 'products_date_added' cannot be null INSERT INTO products ( products_arrive, products_image, 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 ( '', 'MAR05 FFFF', '100', '1', CURRENT_TIMESTAMP, "2/10/2005 0:00", NULL, '3', '0.02', '1000', 'Testing', '10')

Ok having a tad bit of a problem hopefully you guys can help I have read through about 30 some odd pages in this thread before posting this but maybe I am missing something. Anyways I am using Easy Populate 2.74 MS2 and with stock easypopulate.php file everything works like a charm. Now I read and did exactly what this contribution has said for adding fields to easy populate. http://www.oscommerce.com/community/contributions,2779 But when I do this it exports fine but when I go to import I get this | MAR05 FFFF | | testing | | | 100 | 0.02 | | | 1000 | Marvel | TPB | | | GST/HST/PS | Active | Testing !New Product! 1136 - Column count doesn't match value count at row 1 INSERT INTO products ( products_arrive, products_image, 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 ( '', 'MAR05 FFFF', '100', '1', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, '3', '0.02', '1000', 'Testing' '10') Now are the instructions correct? and if so what have I done wrong. If they are wrong then can someone please direct me to some proper directions

Thanks henri for replying But thats just it, I'm not seeing it. Here are 2 screenshots of my admin. Please let me know where I am suppose to see them and possibly what the problem might be Admin Page 1 Admin Page 2

Where is it that you can add/delete admins and departments as Im not seeing it. Everything else seems to be working fine

Got another problem. In the account_history_info.php I can see the button to push but its not doing anything. Any ideas?

Nevermind I figured it out thanks

From the category's section when I select "order tracking" the page comes up without the left column and everything is pushed off to one side. Here is the /catelog/tracking.php file. Could you tell me whats wrong as I'm not seeing the problem (not fluent in php either) <?php /* tracking.php,v 1.0 2002/05/05 12:00:01 The Exchange Project - Community Made Shopping! http://www.theexchangeproject.org Copyright (c) 2000,2001 The Exchange Project Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_TRACKING); $location = ' » <a href="' . tep_href_link(FILENAME_TRACKING, '', 'NONSSL') . '" class="headerNavigation">' . NAVBAR_TITLE . '</a>'; ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <script language="JavaScript" src='./js/zisa_popup.js'></script> <script> function validate(input) { if (input=="") return true; var bad = "!?#$%^&*';:,~`<>\|[]{}()[email protected]"; var doubleQ = '"'; var okay = true; if (input.indexOf(doubleQ)>-1) { okay = false; } for (i=0;i<=input.length;i++) { var c = input.substr(i,1); if (c!="" && bad.indexOf(c)>-1) { okay = false; } } return okay; } function submitPIN(obj) { if (obj=="") return; var formObj = eval("document." + obj); if (!validate(formObj.temp_trkid1.value)) { alert('Invalid characters in the input fields. Please check your entries and try again.'); return; } if (formObj.temp_trkid1.value=="") { alert('No Item number was submitted. Please enter a number and click Submit.'); return; } formObj.trackingId.value=formObj.temp_trkid1.value; formObj.trackingCode.value='PIN'; formObj.submit(); } </script> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body onload="getFocus('basicPinForm')" marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="760" cellspacing="0" cellpadding="0" align="center"> <tr> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_specials.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td align="center" class="main"><?php echo TEXT_INFORMATION_CANADAPOST; ?></td> </tr> <tr> <td align="center" class="main"> <form name="basicPinForm" method="post" action="https://obc.canadapost.ca/emo/basicPin.do" target="_blank"> <input type="hidden" name="trackingId"> <input type="hidden" name="trackingCode"> <input type="hidden" name="action" value="query"> <input type="hidden" name="fromPage" value="basicPin"> <input type="text" name="temp_trkid1" maxlength="35" size="35" value=""><br> <input type="button" value="<?php echo TEXT_BUTTON_CANADAPOST; ?>" onclick="submitPIN('basicPinForm');"> <input type="reset" value="<?php echo TEXT_BUTTON_CLEAR; ?>"> </form> </td> </tr> </table></td> </tr> <tr> <td align="right" class="main"><br><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT, '', 'NONSSL') . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> </tr> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>