malformed data - model name

[rrengamani]

Hello,

We are downloading wurfl data from http://www.scientiamobile.com/wurfl/xxxxx/wurfl.xml.gz

And we noticed the follow data point is causing some problem at our side due to the model name has "&quot" I beleive.

Code: Select all

  <device id="prontotec_tablet7_ver1" user_agent="Mozilla/5.0 (Linux; U; Android 4.2.2; es-es; Tablet 7" PERFORMANCE Build/JDQ39) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Safari/534.30" fall_back="generic_android_ver4_2" actual_device_root="true">
    <group id="product_info">
      <capability name="is_tablet" value="true"/>
      <capability name="model_name" value="ablet 7""/>
      <capability name="brand_name" value="Prontotec"/>
      <capability name="can_assign_phone_number" value="false"/>
      <capability name="release_date" value="2013_may"/>
    </group>
    <group id="display">
      <capability name="physical_screen_height" value="153"/>
      <capability name="physical_screen_width" value="92"/>
      <capability name="resolution_width" value="480"/>
      <capability name="resolution_height" value="800"/>
    </group>
  </device>

Though, the data gets loaded it issue below 5 warnings

Code: Select all

mysql> show warnings;
+---------+------+---------------------------------------------------------------------------------+
| Level   | Code | Message                                                                         |
+---------+------+---------------------------------------------------------------------------------+
| Warning | 1264 | Out of range value for column 'is_tablet' at row 1                              |
| Warning | 1264 | Out of range value for column 'is_wireless_device' at row 1                     |
| Warning | 1366 | Incorrect integer value: 'Android' for column 'physical_screen_height' at row 1 |
| Warning | 1261 | Row 1 doesn't contain data for all columns                                      |
| Warning | 1261 | Row 1 doesn't contain data for all columns                                      |
+---------+------+---------------------------------------------------------------------------------+
5 rows in set (0.00 sec)

When we queried the loaded data it looks like below

Code: Select all

mysql> select * from wurfl_device_capabilities \G;
*************************** 1. row ***************************
             device_id: prontotec_tablet7_ver1
            brand_name: Prontotec
            model_name: ablet 7",","201305
        marketing_name: 1
          release_date: 1
             is_tablet: 127
    is_wireless_device: 127
     resolution_height: 153
      resolution_width: 92
physical_screen_height: 0
 physical_screen_width: 4
             device_os: Android Webkit
     device_os_version: 
        mobile_browser: touchscreen
mobile_browser_version: 3600
       pointing_method: 2015-03-22 20:58:44
         max_data_rate: NULL
            updated_at: NULL
1 row in set (0.00 sec)

Could you take a look and fix accordingly?

-Ram

[Elliotfehr]

Ram,

Thank you for letting us know. We will make sure to correct the issue by the next wurfl.xml release (this upcoming Sunday). If you would like, I can provide you with an out of band snapshot?

Thank you,

Elliot

[rrengamani]

Thanks for the quick reply.

Snapshot is a good idea which will help us to keep moving. you can either attach to this ticket or email to my registered ID. Both xml and csv file will be helpful.

-Ram

[Elliotfehr]

Ram,

I have just uploaded the updated snapshot to your account on scientiamobile.com.

Thank you,

Elliot

[rrengamani]

Hello Elliot,

Thanks for the XML file. Can you also send the CSV file which has this same data?

-Ram

[Elliotfehr]

Ram,

The wurfl database is only distributed in an xml format. Are you able to let me know how you are processing it as a csv?

Thank you,

Elliot