Project

General

Profile

Bug #178

Properly handle special characters and invalid data types in Upload Worksheet function

Added by Jeff Mack over 10 years ago. Updated over 10 years ago.

Status:
Assigned
Priority:
Low
Assignee:
Jeff Mack
Start date:
12/07/2009
Due date:
% Done:

90%

Estimated time:
32.00 h
component:
base
Duration:

Description

Text fields containing the character ' in uploaded worksheets cause no data to be loaded. Also this happens when numeric fields such as Priority or Unit Cost contain text. Upload must be improved to automatically handle these problems where possible. (Note: Error message code has already been added to detect these cases, but cdde not implemented to correct them.)

History

#1 Updated by Jeff Mack over 10 years ago

  • Status changed from New to Assigned
  • Assignee set to Jeff Mack

Replaced single quote in text fields on upload with two single quotes. Recognized in ACcess and Oracle table as single quote.

#2 Updated by Jeff Mack over 10 years ago

  • Estimated time set to 32.00 h

#3 Updated by Jeff Mack over 10 years ago

Jeff Mack wrote:

Text fields containing the character ' in uploaded worksheets cause no data to be loaded. Also this happens when numeric fields such as Priority or Unit Cost contain text. Upload must be improved to automatically handle these problems where possible. (Note: Error message code has already been added to detect these cases, but code not implemented to correct them.)

#4 Updated by Jeff Mack over 10 years ago

  • Priority changed from Normal to Low
  • % Done changed from 0 to 90

' character was not handled properly in SQL Insert to Miser. This is now fixed.

#5 Updated by Jeff Mack over 10 years ago

ALl special characters are handled ok. However, the error message returned when number fields contain text, e.g. is unclear:

No value given for one or more required parameters. (Microsoft JET Database Engine)

Also available in: Atom PDF