magicexport.xml

windows下各种数据转换工具

			<SourceField FieldCode="ShipRegion" FieldName="ShipRegion" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipPostalCode" FieldName="ShipPostalCode" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="ShipCountry" FieldName="ShipCountry" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<DestinationDB Name="MyTestDB" ConnectionString="Provider=SQLOLEDB.1;Password=qq;Persist Security Info=True;User ID=sa;Initial Catalog=MyTest" DbType="2">
				<DestinationTable TableCode="OrdersTest" TableName="" SQLScript="" Trigger="0">
					<MapItem FieldCode="OrderID" MapField="OrderID" FieldName="OrderID" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="CustomerID" MapField="CustomerID" FieldName="CustomerID" DataType="STRING" DataSize="5" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="EmployeeID" MapField="EmployeeID" FieldName="EmployeeID" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="OrderDate" MapField="OrderDate" FieldName="OrderDate" DataType="DATETIME" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="RequiredDate" MapField="RequiredDate" FieldName="RequiredDate" DataType="DATETIME" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShippedDate" MapField="ShippedDate" FieldName="ShippedDate" DataType="DATETIME" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipVia" MapField="ShipVia" FieldName="ShipVia" DataType="INTEGER" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="Freight" MapField="Freight" FieldName="Freight" DataType="DOUBLE" DataSize="0" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipName" MapField="ShipName" FieldName="ShipName" DataType="STRING" DataSize="40" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipAddress" MapField="ShipAddress" FieldName="ShipAddress" DataType="STRING" DataSize="60" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipCity" MapField="ShipCity" FieldName="ShipCity" DataType="STRING" DataSize="15" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipRegion" MapField="ShipRegion" FieldName="ShipRegion" DataType="STRING" DataSize="15" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipPostalCode" MapField="ShipPostalCode" FieldName="ShipPostalCode" DataType="STRING" DataSize="10" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ShipCountry" MapField="ShipCountry" FieldName="ShipCountry" DataType="STRING" DataSize="15" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
				</DestinationTable>
			</DestinationDB>
		</SourceTable>
		<SourceTable SqlStatement="SELECT * FROM pub_info_test" Name="pub_info_test">
			<SourceField FieldCode="pub_id" FieldName="pub_id" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="logo" FieldName="logo" DataType="BINARY" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="pr_info" FieldName="pr_info" DataType="TEXT" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<DestinationDB Name="MyTestDB" ConnectionString="Provider=SQLOLEDB.1;Password=qq;Persist Security Info=True;User ID=sa;Initial Catalog=MyTest" DbType="2">
				<DestinationTable TableCode="pub_info_test" TableName="" SQLScript="" Trigger="0">
					<MapItem FieldCode="pub_id" MapField="pub_id" FieldName="pub_id" DataType="STRING" DataSize="4" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="logo" MapField="logo" FieldName="logo" DataType="BINARY" DataSize="2147483647" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="pr_info" MapField="pr_info" FieldName="pr_info" DataType="TEXT" DataSize="2147483647" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
				</DestinationTable>
			</DestinationDB>
		</SourceTable>
	</SourceDB>
	<SourceDB Name="SourceDb2" ConnectionString="Provider=MSDASQL;Password=zongsoft;Persist Security Info=True;User ID=admin;Data Source=DocCollector" DbType="1">
		<SourceTable SqlStatement="SELECT * FROM DOCUMENTCLASS" Name="DOCUMENTCLASS">
			<SourceField FieldCode="DC_CODE" FieldName="DC_CODE" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="DC_NAME" FieldName="DC_NAME" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="DC_DESCRIPTION" FieldName="DC_DESCRIPTION" DataType="TEXT" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="DC_TYPE" FieldName="DC_TYPE" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="DC_PATHNAME" FieldName="DC_PATHNAME" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="DC_DOCTALBE" FieldName="DC_DOCTALBE" DataType="STRING" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="DC_ENTRYDATE" FieldName="DC_ENTRYDATE" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
			<SourceField FieldCode="DC_ENTRYTIME" FieldName="DC_ENTRYTIME" DataType="INTEGER" PrimaryKey="0" DataSize="0" IsNull="0"/>
		</SourceTable>
	</SourceDB>
	<SourceDB Name="SourceDb3" ConnectionString="Provider=OraOLEDB.Oracle.1;Password=sqc;Persist Security Info=True;User ID=sqcuser;Data Source=sqcdemo" DbType="3">
		<SourceTable SqlStatement="SELECT * FROM TBLCOMPANY" Name="TBLCOMPANY">
			<SourceField FieldCode="CMPCODE" FieldName="CMPCODE" DataType="STRING" PrimaryKey="0" DataSize="30" IsNull="0"/>
			<SourceField FieldCode="CMPNAME" FieldName="CMPNAME" DataType="STRING" PrimaryKey="0" DataSize="30" IsNull="0"/>
			<SourceField FieldCode="CMPALIAS" FieldName="CMPALIAS" DataType="STRING" PrimaryKey="0" DataSize="40" IsNull="0"/>
			<SourceField FieldCode="CMPFULLNAME" FieldName="CMPFULLNAME" DataType="STRING" PrimaryKey="0" DataSize="30" IsNull="0"/>
			<SourceField FieldCode="CMPTYPE" FieldName="CMPTYPE" DataType="STRING" PrimaryKey="0" DataSize="40" IsNull="0"/>
			<SourceField FieldCode="CMPSTATUS" FieldName="CMPSTATUS" DataType="DOUBLE" PrimaryKey="0" DataSize="19" IsNull="0"/>
			<SourceField FieldCode="CMPDOWNDATE" FieldName="CMPDOWNDATE" DataType="DOUBLE" PrimaryKey="0" DataSize="19" IsNull="0"/>
			<SourceField FieldCode="CMPDOWNUSER" FieldName="CMPDOWNUSER" DataType="STRING" PrimaryKey="0" DataSize="30" IsNull="0"/>
			<SourceField FieldCode="OID" FieldName="OID" DataType="STRING" PrimaryKey="0" DataSize="40" IsNull="0"/>
			<SourceField FieldCode="LMUSER" FieldName="LMUSER" DataType="STRING" PrimaryKey="0" DataSize="30" IsNull="0"/>
			<SourceField FieldCode="LMDATE" FieldName="LMDATE" DataType="DOUBLE" PrimaryKey="0" DataSize="19" IsNull="0"/>
			<SourceField FieldCode="LMTIME" FieldName="LMTIME" DataType="DOUBLE" PrimaryKey="0" DataSize="19" IsNull="0"/>
		</SourceTable>
		<SourceTable SqlStatement="SELECT * FROM TBLDATAPOINTS" Name="TBLDATAPOINTS">
			<SourceField FieldCode="DATAPOINTID" FieldName="DATAPOINTID" DataType="STRING" PrimaryKey="0" DataSize="40" IsNull="0"/>
			<SourceField FieldCode="OID" FieldName="OID" DataType="STRING" PrimaryKey="0" DataSize="255" IsNull="1"/>
			<SourceField FieldCode="POINTTYPE" FieldName="POINTTYPE" DataType="STRING" PrimaryKey="0" DataSize="255" IsNull="1"/>
			<SourceField FieldCode="CPK" FieldName="CPK" DataType="DOUBLE" PrimaryKey="0" DataSize="8" IsNull="1"/>
			<SourceField FieldCode="STATUS" FieldName="STATUS" DataType="STRING" PrimaryKey="0" DataSize="255" IsNull="1"/>
			<SourceField FieldCode="MNIDS" FieldName="MNIDS" DataType="TEXT" PrimaryKey="0" DataSize="1073741823" IsNull="1"/>
			<SourceField FieldCode="POINTVALUES" FieldName="POINTVALUES" DataType="TEXT" PrimaryKey="0" DataSize="1073741823" IsNull="1"/>
			<SourceField FieldCode="PRODUCETIME" FieldName="PRODUCETIME" DataType="STRING" PrimaryKey="0" DataSize="40" IsNull="1"/>
			<SourceField FieldCode="IMPORTTIME" FieldName="IMPORTTIME" DataType="STRING" PrimaryKey="0" DataSize="40" IsNull="1"/>
			<SourceField FieldCode="DATAVALUE" FieldName="DATAVALUE" DataType="DOUBLE" PrimaryKey="0" DataSize="8" IsNull="1"/>
			<SourceField FieldCode="CREATEORDER" FieldName="CREATEORDER" DataType="DOUBLE" PrimaryKey="0" DataSize="19" IsNull="1"/>
			<SourceField FieldCode="CONTROLOBJECTID" FieldName="CONTROLOBJECTID" DataType="STRING" PrimaryKey="0" DataSize="40" IsNull="0"/>
			<SourceField FieldCode="ACT_CODE" FieldName="ACT_CODE" DataType="STRING" PrimaryKey="0" DataSize="255" IsNull="1"/>
			<DestinationDB Name="SqlServer" ConnectionString="Provider=SQLOLEDB.1;Password=qq;Persist Security Info=True;User ID=sa;Initial Catalog=MyTest" DbType="2">
				<DestinationTable TableCode="TBLDATAPOINTS" TableName="" SQLScript="IF EXISTS (SELECT 1 FROM sysobjects WHERE id = object_id('TBLDATAPOINTS') AND type = 'U') 
 	 DROP TABLE TBLDATAPOINTS;

CREATE TABLE TBLDATAPOINTS (
	DATAPOINTID 	VARCHAR(40) 	NOT NULL,
	OID 	VARCHAR(255) 	NULL,
	POINTTYPE 	VARCHAR(255) 	NULL,
	CPK 	FLOAT 	NULL,
	STATUS 	VARCHAR(255) 	NULL,
	MNIDS 	TEXT 	NULL,
	POINTVALUES 	TEXT 	NULL,
	PRODUCETIME 	VARCHAR(40) 	NULL,
	IMPORTTIME 	VARCHAR(40) 	NULL,
	DATAVALUE 	FLOAT 	NULL,
	CREATEORDER 	FLOAT 	NULL,
	CONTROLOBJECTID 	VARCHAR(40) 	NOT NULL,
	ACT_CODE 	VARCHAR(255) 	NULL,
	CONSTRAINT PK_TBLDATAPOINTS PRIMARY KEY (DATAPOINTID)
);" Trigger="0">
					<MapItem FieldCode="DATAPOINTID" MapField="DATAPOINTID" FieldName="DATAPOINTID" DataType="STRING" DataSize="40" PrimaryKey="1" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="OID" MapField="OID" FieldName="OID" DataType="STRING" DataSize="255" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="POINTTYPE" MapField="POINTTYPE" FieldName="POINTTYPE" DataType="STRING" DataSize="255" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="CPK" MapField="CPK" FieldName="CPK" DataType="DOUBLE" DataSize="8" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="STATUS" MapField="STATUS" FieldName="STATUS" DataType="STRING" DataSize="255" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="MNIDS" MapField="MNIDS" FieldName="MNIDS" DataType="TEXT" DataSize="1073741823" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="POINTVALUES" MapField="POINTVALUES" FieldName="POINTVALUES" DataType="TEXT" DataSize="1073741823" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="PRODUCETIME" MapField="PRODUCETIME" FieldName="PRODUCETIME" DataType="STRING" DataSize="40" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="IMPORTTIME" MapField="IMPORTTIME" FieldName="IMPORTTIME" DataType="STRING" DataSize="40" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="DATAVALUE" MapField="DATAVALUE" FieldName="DATAVALUE" DataType="DOUBLE" DataSize="8" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="CREATEORDER" MapField="CREATEORDER" FieldName="CREATEORDER" DataType="DOUBLE" DataSize="19" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="CONTROLOBJECTID" MapField="CONTROLOBJECTID" FieldName="CONTROLOBJECTID" DataType="STRING" DataSize="40" PrimaryKey="0" IsNull="0" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
					<MapItem FieldCode="ACT_CODE" MapField="ACT_CODE" FieldName="ACT_CODE" DataType="STRING" DataSize="255" PrimaryKey="0" IsNull="1" FieldType="0" DefaultValue="" LookupStatement="" Parameters="" Enabled="1"/>
				</DestinationTable>
			</DestinationDB>
		</SourceTable>