none
Invalid Format? Upload Data to data source (.CSV) RRS feed

  • Question

  • Bing Spatial Data Services, 1.0, MyMedPages
    EntityID(Edm.String,primaryKey),LastName(Edm.String),FirstName(Edm.String),BizName(Edm.String),Addressline(Edm.String),AddressLine2(Edm.String),PrimaryCity(Edm.String),Subdivision(Edm.String),PostalCode(Edm.String),Countryregion(Edm.String),HospitalName(Edm.String),Phone(Edm.String),Fax(Edm.String),Email(Edm.String),websiteparm(Edm.String),PhysicianId(Edm.Int64),PhysicianType(Edm.String),Notes(Edm.String),Website(Edm.String),RankOverride(Edm.String),PhysUpdateDate(Edm.String),PhysUpdatedBy(Edm.String),AddressUpdateDate(Edm.String),AddressUpdateBy(Edm.String),Latitude(Edm.Double),Longitude(Edm.Double),MatchCode(Edm.String),MatchedMethod(Edm.String),MatchedAddress(Edm.String),EditedLocationUTC(Edm.String),EditedPropertyUTC(Edm.String),InputModified(Edm.String)
    [--Rest of data follows----]
    -----------------------------------
    • The entity does not have a valid format.

      Trying to import a .CSV (with Waypoint data) and receiving this message.  
    • Moved by Ricky_Brundritt Saturday, March 10, 2012 11:29 AM (From:Bing Maps: Map Control and Web services Development)
    Friday, October 14, 2011 9:51 PM

Answers

  • I've isolated the issue on why it's a incorrect format.  It happens to be that the application doesn't accept double-quotes (") in .CSV format.

    With the example data (which is public info)

    -->Header information<--


    Bing Spatial Data Services,1.0, MyMedPages
    EntityID(Edm.String,primaryKey),LastName(Edm.String),FirstName(Edm.String),BizName(Edm.String),Addressline(Edm.String),AddressLine2(Edm.String),PrimaryCity(Edm.String),Subdivision(Edm.String),PostalCode(Edm.String),Countryregion(Edm.String),HospitalName(Edm.String),Phone(Edm.String),Fax(Edm.String),Email(Edm.String),websiteparm(Edm.String),PhysicianId(Edm.Int64),PhysicianType(Edm.String),Notes(Edm.String),Website(Edm.String),RankOverride(Edm.String),PhysUpdateDate(Edm.String),PhysUpdatedBy(Edm.String),AddressUpdateDate(Edm.String),AddressUpdateBy(Edm.String),Longitude(Edm.Double),Latitude(Edm.Double),MatchCode(Edm.String),MatchedMethod(Edm.String),MatchedAddress(Edm.String),EditedLocationUTC(Edm.String),EditedPropertyUTC(Edm.String),InputModified(Edm.String)

    -->Data<--

    2,singla,ajayk,"Ajay Singla, MD",4160 John R Rd,Suite 1021,Detroit ,MI,48201,USA,Harper University Hospital ,313.833.3320,313.993.8178,,interstim.com,5445,,,,,3/5/2002,Randy Davis,,,-83.058458,42.352325,Good,Address,"4160 John R St, Detroit, MI 48201-2020",,,
    3,aaron,mark,Dr. Mark Aaron,4230 Harding Pike,,Nashville,TN,37205,USA,St. Thomas Heart Institute,615.269.4545,615.565.6798,,hf,3334,,,,,1/16/2003,Jeanine Grandstrand,,,-86.843841,36.127591,Good,Address,"4230 Harding Pike, Nashville, TN 37205-2013",,,

    --------

    Apologize for the wrong format (copying and pasting from the text file isn't working well). But is there any alternative way to not use the double quotes in order for this to be processed?

    Tuesday, October 18, 2011 1:02 PM

All replies

  • That error usually indicates that one of your rows has data in acolumn that is notvalid. i.e. String value in an Int64 column, or empty value for a Int64 or double column (these are non-nullable types and should be defaulted to 0).
    http://rbrundritt.wordpress.com
    Monday, October 17, 2011 8:30 AM
  • Thanks for the reply, checking into it. 

    Receiving this error after very little changes, "The version information in the input data header is not correct" 

     

    • Edited by comrade2k7 Monday, October 17, 2011 1:13 PM
    Monday, October 17, 2011 12:54 PM
  • For non-XML files, the first line must look like this:

    Bing Spatial Data Services, 1.0, FourthCoffeeShops

     

    Replace FourthCoffeeShops with your data's entity name.

    Monday, October 17, 2011 3:41 PM
  • I've isolated the issue on why it's a incorrect format.  It happens to be that the application doesn't accept double-quotes (") in .CSV format.

    With the example data (which is public info)

    -->Header information<--


    Bing Spatial Data Services,1.0, MyMedPages
    EntityID(Edm.String,primaryKey),LastName(Edm.String),FirstName(Edm.String),BizName(Edm.String),Addressline(Edm.String),AddressLine2(Edm.String),PrimaryCity(Edm.String),Subdivision(Edm.String),PostalCode(Edm.String),Countryregion(Edm.String),HospitalName(Edm.String),Phone(Edm.String),Fax(Edm.String),Email(Edm.String),websiteparm(Edm.String),PhysicianId(Edm.Int64),PhysicianType(Edm.String),Notes(Edm.String),Website(Edm.String),RankOverride(Edm.String),PhysUpdateDate(Edm.String),PhysUpdatedBy(Edm.String),AddressUpdateDate(Edm.String),AddressUpdateBy(Edm.String),Longitude(Edm.Double),Latitude(Edm.Double),MatchCode(Edm.String),MatchedMethod(Edm.String),MatchedAddress(Edm.String),EditedLocationUTC(Edm.String),EditedPropertyUTC(Edm.String),InputModified(Edm.String)

    -->Data<--

    2,singla,ajayk,"Ajay Singla, MD",4160 John R Rd,Suite 1021,Detroit ,MI,48201,USA,Harper University Hospital ,313.833.3320,313.993.8178,,interstim.com,5445,,,,,3/5/2002,Randy Davis,,,-83.058458,42.352325,Good,Address,"4160 John R St, Detroit, MI 48201-2020",,,
    3,aaron,mark,Dr. Mark Aaron,4230 Harding Pike,,Nashville,TN,37205,USA,St. Thomas Heart Institute,615.269.4545,615.565.6798,,hf,3334,,,,,1/16/2003,Jeanine Grandstrand,,,-86.843841,36.127591,Good,Address,"4230 Harding Pike, Nashville, TN 37205-2013",,,

    --------

    Apologize for the wrong format (copying and pasting from the text file isn't working well). But is there any alternative way to not use the double quotes in order for this to be processed?

    Tuesday, October 18, 2011 1:02 PM