Drupal教程:批量导入XML数据

如果你想把其它网站的数据批量导入到drupal系统中，下面代码对你有可能适用。前提条件是，你要把原来网站的数据生成XML格式！
4 e) q5 `$ I6 \& F3 g! L生成XML的工具有很多，有个叫 xml.class.php的类，可以试用一下，你也可以自己写PHP代码来实现。
- [9 O% \/ u: e生成XML文件后，通过这个模块，直接上传，就可以把它导入到drupal系统了。
3 p6 V" B: J1 x* @8 B# R/ ?2 [该模块还可以对你导入的数据进行自动分类(Taxonomy整合)。
以下为该模块的部分精华源代码，欢迎发信问问题和提出各种修改建议。
4 o6 X# T. a4 h3 R% A如需要完整模块，请向站长索取。

1 E4 K: @  ?2 y3 v2 p1 c4 @<?php
3 h# e( I1 h7 ^; w* Wfunction import_form_submit($form, &$form_state) {
; ?: o. Y9 D( t; P  u/ c7 f6 z
4 J+ w1 ~0 ^# f' t, X9 {2 x) L: i?????????? $validators = array('file_validate_extensions' => array('upload_file'),);
?????????? if ($file = file_save_upload('upload_file', $validators)) {
?????????????? $fd = fopen($file->filepath, "rb");
5 g& B; a5 {8 {6 h+ F- Y1 S+ k?????????????? if (!$fd) {
, J/ L5 D4 ~; L6 @?????????????????? form_set_error('upload_file', t('Import failed: file %filename cannot be read.', array('%filename' => $file->filename)));
?????????????? }
?????????????? else {
4 I' w7 Q* f( O5 Y3 @2 p( J?????????????????? $info = fstat($fd);
4 E5 e1 y  ~; ?/ j7 h$ q?????????????????? $len = $info["size"];
?????????????????? $text = fread($fd, $len);
( k  J6 o/ w6 s" S* e?????????????????? fclose($fd);
! c! ?3 Z- c& o5 q4 [- h?????????????????? drupal_set_message(t('Loaded file %filename. Now processing it.', array('%filename' => $file->filename)));
?????????????????? $form_state['values']['file'] = $file;

9 u& @* q" r4 P, e6 B?????????????????? import_xml_invoke_import($text, $form_state['values']);
?????????????? }
?????????? }
?????????? else {
7 |+ R) a5 A0 }?????????????? form_set_error('upload_file', t('Import failed: file was not uploaded.'));
?????????? }
" s5 b% C0 M+ F+ @6 |% B* c}

& F1 g8 B0 `' f8 [- X3 H. ?8 O0 O


function parseMol($mvalues) {
???? for ($i=0; $i < count($mvalues); $i++)
???????????? $mol[$mvalues[$i]["tag"]] = $mvalues[$i]["value"];
, n5 V, f6 b* [3 i???? return new ImportXml($mol);
}
* U6 {1 k& I2 E; o+ \

class ImportXml {
% p' h% S7 m, r2 J2 J??
???? var $tushushangpin;??
; D: _8 ?* n' f7 E8 Y- b???? var $shangpindaima;??????
???? var $shuming;
???? var $congshuming;
???? var $fushucongshuming;
+ X- L' h0 t& }, R4 }???? var $zhuzuozhe;
???? var $chubanzhe;??
???? var $benbanbanci;??????
/ K6 `4 l  m+ J( \0 n???? var $yinci;
???? var $dingjia;
) w# k/ P2 t9 h+ }9 b; o+ l' {. x

' |' ]& ]7 b/ q# [, c9 D???? function ImportXml ($aa) {
& K" D& Y# K' H, h' A???????????? foreach ($aa as $k=>$v)
???????????????????? $this->$k = $aa[$k];
???? }
6 {1 a" |% Z& w; e}
0 O) `9 t0 t7 H: p" U2 J
  h: \0 E- N( P0 i  [" |4 a

% y2 d+ h: @  Y, L+ b
function import_xml_invoke_import(&$text) {

// parse the data:
?? $xml_parser = drupal_xml_parser_create($text);
3 g" C& k! s% `1 F( a1 X7 G?? xml_parser_set_option($xml_parser,XML_OPTION_CASE_FOLDING,0);
: i! i8 v* l% f2 p' P8 H) s6 Y?? xml_parser_set_option($xml_parser,XML_OPTION_SKIP_WHITE,1);
" P4 Z& i8 U0 H6 g+ `$ I) J?? xml_parse_into_struct($xml_parser,$text,$values,$tags);
?? xml_parser_free($xml_parser);

// now begin fetch the value

( k/ g. j' K9 n1 d' ?8 D# l7 yforeach ($tags as $key=>$val) {
6 J# Y: z4 C" u) c+ ^
???????????? if ($key == "tushushangpin") {
$ L: _& r* w: t* E$ V
???????????????????? $molranges = $val;
5 s" x5 @3 Q9 _* b- S5 G???????????????????? for ($i=0; $i < count($molranges); $i+=2) {
" L) W2 _9 t" `1 o???????????????????????????????????? $offset = $molranges[$i] + 1;
???????????????????????????? $len = $molranges[$i + 1] - $offset;
8 \$ @8 T8 s( k$ c# l???????????????????????????? $tdb[] = parseMol(array_slice($values, $offset, $len));
& Z% z% y+ a% o???????????????????? }
???????????? } else {
" Y/ \: A7 p! t4 w7 s2 w5 v???????????????????? continue;
???????????? }
???? }

: F( X, j7 Y3 l% m7 ?) _% eforeach($tdb as $value){

! \% @! O) l% x- C9 P9 i?? $node = array();
?? $node = new stdClass;
?? $node->type = "product";
?? $node->status = 1;
?? $node->uid = 1;
?? $node->title = $value->shuming;
// $node->body = $value->neirongtiyao;
8 J( k/ v) B, f" H2 P
" M& n3 I. \0 i( h5 N?? $node->field_product_shangpindaima[0]['value'] = $value->shangpindaima;??
?? $node->field_product_shuming[0]['value'] = $value->shuming;?????????????????????? // use ubercart
9 c) D- S( f6 }8 X- G0 d( y?? $node->field_product_congshuming[0]['value'] = $value->congshuming;
; q/ K3 W/ I& c. T8 [& ^" Y?? $node->field_product_fushucongshuming[0]['value'] = $value->fushucongshuming;
?? $node->field_product_zhuzuozhe[0]['value'] = $value->zhuzuozhe;
2 e/ K$ {5 K1 l?? $node->field_product_chubanzhe[0]['value'] = $value->chubanzhe;
?? $node->field_product_benbanbanci[0]['value'] = $value->benbanbanci;
?? $node->field_product_yinci[0]['value'] = $value->yinci;
?? $node->field_product_dingjia[0]['value'] = $value->dingjia;
# s  }# P" K: i" }+ r??
// if $value->tongjifenlei is not null then :
( i/ b2 F3 _0 X$ |- a
?? if($value->tongjifenlei){

?? $tj_vid = 1;
, P/ P- G& E- G3 I; w
?? if($tid = (int) db_result(db_query('SELECT tid FROM {term_data} WHERE name = "%s" AND vid = %d', $value->tongjifenlei,$tj_vid))){????
, z. r7 M( m: l: p???????? $tj_tid = $tid;
???? }else{

/ \% u; ^8 I  u' M3 L2 W???????????? // vocabulary ID is hard coded for this example
7 `0 E% n6 ^4 H/ U- J) J?????? $autoterm = array(
???????? 'name' => $value->tongjifenlei,?? // or whatever you want the auto-term to be named
! E3 p7 P8 N& c  M???????? 'parent' => 0,
???????? 'vid' => $tj_vid,
1 p' n; ], G4 u1 Y?????? );
0 @! G6 i* P) t! w$ n6 R3 Q  D???????? taxonomy_save_term($autoterm);
???????? $tj_tid = (int) db_result(db_query('SELECT MAX(tid) FROM {term_data} WHERE vid = %d', $vid));
???? }
???? $node->taxonomy[$tj_vid][$tj_tid] = $tj_tid;
7 }' l1 T, O- N8 Y2 K( m
?? }

4 Z0 [8 I- m- W9 Y' D/ m?? node_save($node);

& D4 u% {; D% G6 o. ~}??

drupal_set_message("Import Successful!");
}
?>
0 x1 ?3 x4 T$ m! ]) ?% c


$ L4 b0 d8 Z  [/ U# t

% M! i/ \( u- E8 o6 f