This project is read-only.
1
Vote

Data schema checks should be made to ensure that we are not exeeding Bing SDS field limitations.

description

Data schema checks should be made to ensure that we are not exeeding Bing SDS field limitations. An error should be displayed if the data exceeds any of these limits:
 
  • Edm.String: 50 max
  • Edm.Boolean: 40 max
  • Edm.Double: 20 max
  • Edm.Int64: 20 max
  • Edm.DateTime: 20 max
     
    Other useful checks (each of which should generate an error message):
     
  • ERROR: Primary key is not specified
  • ERROR: More than one primary key is specified
  • ERROR: Latitude/Longitude must be specified
  • ERROR: The /toPipe or /toTab option should be used for fields containing embedded commas and must be enclosed between double quotes.
  • ERROR: <line #> Field width exceeds the maximum allowable field width
  • ERROR: <line #> Missing column
  • ERROR: <line #> Field does not match specified field type.
     
    Any additional errors should be displayed in order to ensure that Bing SDS will never complain about incorrect syntax.

comments