迷糊妖

永不停止追寻前进的脚步
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

kettle中Get Data from XML , Jason Input , 文本文件输入 使用示例

Posted on 2013-10-17 15:29  迷糊妖  阅读(6444)  评论(0)    收藏  举报

1、Get Data from XML

xml文件内容：

<head>
<img id="1">菜||焦溜丸子||2013-03-28/image/0/0001-thumb.jpg</img>
<img id="2">环境||门面||2013-03-28/image/0/0002-thumb.jpg</img>
<img id="3">环境||门面||2013-03-28/image/0/0003-thumb.jpg</img>
</head>

设置及结果：

2、Jason Input

{"store": {      "book": [ 
      { "category": "reference",
        "author": "Nigel Rees",
        "title": "Sayings of the Century",
        "price": 8.95
      },
      { "category": "fiction",
        "author": "Evelyn Waugh",
        "title": "Sword of Honour",
        "price": 12.99
      },
      { "category": "fiction",
        "author": "Herman Melville",
        "title": "Moby Dick",
        "isbn": "0-553-21311-3",
        "price": 8.99
      },
      { "category": "fiction",
        "author": "J. R. R. Tolkien",
        "title": "The Lord of the Rings",
        "isbn": "0-395-19395-8",
        "price": 22.99
      }
      { "category": "fiction",
        "author": "Samatar",
        "title": "La belle vie",
        "isbn": "0-395-19395-8",
        "price": 24.99
      }
    ],
    "bicycle": {
      "color": "red",
      "price": 19.95
    }
  }
}

3、文本文件输入(price字段)

name;posx;posy;url_addr;visited;price
天天周末(黄浦店)       ;121.5;31.2;http://www.dianping.com/shop/5193999;1,084,934;$10.2
唐人风尚美容美发沙龙      ;116.2;39.9;http://www.dianping.com/shop/5407383;888,984;$20.2
伊姿美甲(八佰伴店)      ;121.5;31.2;http://www.dianping.com/shop/5397997;1,047,051;$10.5
青浦区实验小学         ;121.1;31.1;http://www.dianping.com/shop/4127946;1,351,421;$13.2
千喜国际美容美发(世纪城店)  ;116.3;40;http://www.dianping.com/shop/4564623;873,159;$12.3
曼清瑜伽理疗馆         ;106.5;29.6;http://www.dianping.com/shop/5718907;1,410,166;$11.4
西海歌厅            ;116.4;39.9;http://www.dianping.com/shop/2101444;823,716;$12.6
弥奇博士美容排毒养生会所    ;116.3;39.9;http://www.dianping.com/shop/4038553;889,330;$16.4
新发展古华山庄酒店       ;121.5;30.9;http://www.dianping.com/shop/8688480;1,077,595;$11.2
世茂时尚欢乐影城        ;106.5;29.6;http://www.dianping.com/shop/5636995;1,409,593;$15.8