I used log manager in BaseConnector to find the problem: in IE7, the server is not receiving the data in the same format as sent from FF. In IE7 (again the version with ‘CO’ at the end), the log is incomplete:
====================================
Log started, Mon Dec 06 17:07:22 CST 2010
====================================
Key --- project; Value --- 6663
Key --- username; Value --- John-Doe
Key --- editing; Value --- true
Key --- domain; Value --- VIKING
Key --- table; Value --- basic_project_info_input
Error during data processing
Incorrect incoming data, ID of incoming records not recognized
Done in : 31ms
But in FF, the log is much longer and of course complete:
====================================
Log started, Mon Dec 06 17:03:59 CST 2010
====================================
Key --- 1_gr_id; Value --- 1
Key --- 1_c2; Value --- 1
Key --- 1_c1; Value --- 6663
Key --- 1_c4; Value --- Region 1
Key --- username; Value --- John-Doe
Key --- 1_c3; Value --- 1
Key --- 1_c0; Value --- 1
Key --- 1_c20; Value --- 2010-11-24 00:00:00.0
Key --- domain; Value --- VIKING
Key --- editing; Value --- true
Key --- ids; Value --- 1
Key --- table; Value --- basic_project_info_input
Key --- 1_c6; Value --- Y
Key --- 1_c5; Value --- 1
Key --- project; Value --- 6663
Key --- 1_c8; Value --- 2011-03-07 00:00:00.0
Key --- 1_c7; Value --- 2010-12-02 00:00:00.0
Key --- 1_c13; Value --- 90.00000000
Key --- 1_c12; Value --- 300000
Key --- 1_c9; Value --- 250.00
Key --- 1_c11; Value --- 762.00
Key --- 1_c10; Value --- 50.00
Key --- 1_c17; Value --- System
Key --- 1_c16; Value --- ACTIVE
Key --- 1_c15; Value --- 1
Key --- 1_c14; Value --- 762000.00
Key --- 1_!nativeeditor_status; Value --- updated
Key --- 1_c19; Value --- 1
Key --- 1_c18; Value --- 2010-11-18
DB query
UPDATE basic_project_info_input SET basic_project_info_id='1',project_id='6663',project_case_region_key='1',project_case_region_id='1',project_case_region='Region 1',project_info_version='1',current_project_info_flag='Y',data_collect_begin_week='2010-12-02 00:00:00.0',data_collect_end_week='2011-03-07 00:00:00.0',budget_hours_per_case='250.00',budget_expense_per_case='50.00',budget_loaded_cost_per_case='762.00',budget_total_cases='300000',budget_completion_percent='90.00000000',budget_total_loaded_cost='762000.00',version_nbr='1',record_status='ACTIVE',entered_by='System',entered_on_date='2010-11-18',etl_status='1',etl_process_timestamp='2010-11-24 00:00:00.0' WHERE basic_project_info_id='1'
Done in : 47ms
I also captured the info sent from IE7 with DebugBar - it doesn’t look like normal form submission - the separator is “
,” not the “&”. But when I capture it in either Fiddler2 or Firebug Lite, it appears to be “&”:
DataProcessor :: row 1 marked [updated,valid]DataProcessor :: Initiating data sending for all rows DataProcessor :: Sending all data at onceDataProcessor :: Server url: griddata?table=basic_project_info_input&project=6663&domain=VIKING&username=John-Doe&editing=true <a onclick='this.parentNode.nextSibling.firstChild.style.display="block"' href='#'>parameters</a>DataProcessor :: <blockquote style='display:none;'>1_gr_id=1<br/>1_c0=1<br/>1_c1=6663<br/>1_c2=1<br/>1_c3=1<br/>1_c4=Region%201<br/>1_c5=1<br/>1_c6=Y<br/>1_c7=2010-12-02%2000%3A00%3A00.0<br/>1_c8=2011-03-07%2000%3A00%3A00.0<br/>1_c9=250.00<br/>1_c10=50.00<br/>1_c11=762.00<br/>1_c12=300000<br/>1_c13=90.00000000<br/>1_c14=762000.00<br/>1_c15=1<br/>1_c16=ACTIVE<br/>1_c17=System<br/>1_c18=2010-11-20<br/>1_c19=1<br/>1_c20=2010-11-24%2000%3A00%3A00.0<br/>1_!nativeeditor_status=updated<br/>ids=1<blockquote>DataProcessor :: Server response received <a onclick='this.nextSibling.style.display="block"' href='#'>details</a><blockquote style='display:none'><code><?xml version='1.0' encoding='utf-8' ?><data>Operation error</data></code></blockquote>
It’s an urgent matter - I wonder if you can either make the dataprocessor more generic (such as creating a regular form - not sure if that’s what you have already done), or make the server end more robust so it can read different formats of data. Thanks!