我有导入工具,就是不合管家婆辉煌Ⅱ++版本。有什么办法可以把基本资料导入到管家婆辉煌Ⅱ++里。
或者谁会这种程序的也可以帮我改改也就行了
<?xml version="1.0" encoding="GBK"?>
<!-- Source属性定义源类型,目前只支持xsl即Excel文件;Target定义目标类型,gj即管家婆系列 -->
<ProfileImport Source="xsl" Target="fx" Desc="从Excel导入分销3.5(辉煌.Net 3.0)">
<Validations>
<UnionUniqueValidation Source="商品" FieldName="商品全名" Desc="商品全名与第 %d 行类别名重复">
<UnionUniqueValidationField Source="一级类别" Unique="True"/>
<UnionUniqueValidationField Source="二级类别" Unique="True"/>
<UnionUniqueValidationField Source="三级类别" Unique="True"/>
<UnionUniqueValidationField Source="四级类别" Unique="True"/>
</UnionUniqueValidation>
<UniqueValidation Source="商品" UniqueFieldList="商品编号" Desc="商品编号与第 %d 行重复"
NotNullFieldList="商品全名,商品编号"/>
<UnionUniqueValidation Source="地区" FieldName="地区全名" Desc="地区全名与第 %d 行类别名重复">
<UnionUniqueValidationField Source="一级类别" Unique="True"/>
<UnionUniqueValidationField Source="二级类别" Unique="True"/>
<UnionUniqueValidationField Source="三级类别" Unique="True"/>
<UnionUniqueValidationField Source="四级类别" Unique="True"/>
</UnionUniqueValidation>
<UnionUniqueValidation Source="地区" FieldName="地区全名" Desc="地区全名与第 %d 行地区编号重复">
<UnionUniqueValidationField Source="地区编号"/>
</UnionUniqueValidation>
<UniqueValidation Source="地区" UniqueFieldList="地区全名" Desc="地区全名与第 %d 行重复"
NotNullFieldList="地区全名,地区编号"/>
<UniqueValidation Source="地区" UniqueFieldList="地区编号" Desc="地区编号与第 %d 行重复"/>
<UnionUniqueValidation Source="往来单位" FieldName="往来单位全名" Desc="往来单位全名与第 %d 行类别名重复">
<UnionUniqueValidationField Source="一级类别" Unique="True"/>
<UnionUniqueValidationField Source="二级类别" Unique="True"/>
<UnionUniqueValidationField Source="三级类别" Unique="True"/>
<UnionUniqueValidationField Source="四级类别" Unique="True"/>
</UnionUniqueValidation>
<UnionUniqueValidation Source="往来单位" FieldName="往来单位全名" Desc="往来单位全名与第 %d 行往来单位编号重复">
<UnionUniqueValidationField Source="往来单位编号"/>
</UnionUniqueValidation>
<UniqueValidation Source="往来单位" UniqueFieldList="往来单位全名" Desc="往来单位全名与第 %d 行重复"
NotNullFieldList="往来单位全名,往来单位编号"/>
<UniqueValidation Source="往来单位" UniqueFieldList="往来单位编号" Desc="往来单位编号与第 %d 行重复"/>
<UnionUniqueValidation Source="仓库" FieldName="仓库全名" Desc="仓库全名与第 %d 行类别名重复">
<UnionUniqueValidationField Source="一级类别" Unique="True"/>
<UnionUniqueValidationField Source="二级类别" Unique="True"/>
<UnionUniqueValidationField Source="三级类别" Unique="True"/>
<UnionUniqueValidationField Source="四级类别" Unique="True"/>
</UnionUniqueValidation>
<UnionUniqueValidation Source="仓库" FieldName="仓库全名" Desc="仓库全名与第 %d 行仓库编号重复">
<UnionUniqueValidationField Source="仓库编号"/>
</UnionUniqueValidation>
<UniqueValidation Source="仓库" UniqueFieldList="仓库全名" Desc="仓库全名与第 %d 行重复"
NotNullFieldList="仓库全名,仓库编号"/>
<UniqueValidation Source="仓库" UniqueFieldList="仓库编号" Desc="仓库编号与第 %d 行重复"/>
<UnionUniqueValidation Source="部门" FieldName="部门全名" Desc="部门全名与第 %d 行类别名重复">
<UnionUniqueValidationField Source="一级类别" Unique="True"/>
<UnionUniqueValidationField Source="二级类别" Unique="True"/>
<UnionUniqueValidationField Source="三级类别" Unique="True"/>
<UnionUniqueValidationField Source="四级类别" Unique="True"/>
</UnionUniqueValidation>
<UnionUniqueValidation Source="部门" FieldName="部门全名" Desc="部门全名与第 %d 行部门编号重复">
<UnionUniqueValidationField Source="部门编号"/>
</UnionUniqueValidation>
<UniqueValidation Source="部门" UniqueFieldList="部门全名" Desc="部门全名与第 %d 行重复"
NotNullFieldList="部门全名,部门编号"/>
<UniqueValidation Source="部门" UniqueFieldList="部门编号" Desc="部门编号与第 %d 行重复"/>
<UnionUniqueValidation Source="职员" FieldName="职员姓名" Desc="职员姓名与第 %d 行类别名重复">
<UnionUniqueValidationField Source="一级类别" Unique="True"/>
<UnionUniqueValidationField Source="二级类别" Unique="True"/>
<UnionUniqueValidationField Source="三级类别" Unique="True"/>
</UnionUniqueValidation>
<UnionUniqueValidation Source="职员" FieldName="职员姓名" Desc="职员姓名与第 %d 行职员编号重复">
<UnionUniqueValidationField Source="职员编号"/>
</UnionUniqueValidation>
<UniqueValidation Source="职员" UniqueFieldList="职员姓名" Desc="职员姓名与第 %d 行重复"
NotNullFieldList="职员姓名,职员编号"/>
<UniqueValidation Source="职员" UniqueFieldList="职员编号" Desc="职员编号与第 %d 行重复"/>
</Validations>
<Tables>
<Table Source="商品" Target="ptype" FieldName="FullName" KeyField="TypeID" UniqueField="FullName"
BeforeImport="INSERT INTO PType(TypeID,Parid,Leveal,SonNum,SonCount,CanModify,UserCode,FullName,Name,Standard,Type,Area,Unit1,Unit2,UnitRate1,UnitRate2,preprice1,preprice2,preprice3,preprice4,UsefulLifeMonth,UsefulLifeDay,Comment,recPrice,Deleted,ColorGroupID,SizeGroupID,EntryCode,IfSerial)
VALUES('00000','root',0,0,0,'0','0','库存商品','','','','','','',0,0,0,0,0,0,null,null,'',0,0,0,0,'',0)">
<Field Source="${'00000'}" Target="ParID"/>
<Field Source="${AutoInc(5)}" Target="TypeID"/>
<Field Source="一级类别" Target="FullName" UseLastValueIfEmpty="True"/>
<Field Source="${GetPY(Target('FullName'))}" Target="PyCode"/>
<Field Source="${Target('PyCode')}" Target="UserCode"/>
<Field Source="${0}" Target="SonCount"/>
<Field Source="${0}" Target="SonNum"/>
<Field Source="${1}" Target="Leveal"/>
</Table>
<Table Source="商品" Target="ptype" FieldName="FullName" KeyField="TypeID" UniqueField="FullName" KeepOldData="True">
<Field Source="一级类别" Target="ParID" UseLastValueIfEmpty="True" NotNull="True" Default='00000'>
<RefTable Target="ptype" FieldName="FullName" KeyField="TypeID" LookupOnly="True"/>
</Field>
<Field Source="${AutoIncWithPrefix(5,Target('ParID'))}" Target="TypeID"/>
<Field Source="二级类别" Target="FullName" UseLastValueIfEmpty="True"/>
<Field Source="${GetPY(Target('FullName'))}" Target="PyCode"/>
<Field Source="${Target('PyCode')}" Target="UserCode"/>
<Field Source="${0}" Target="SonCount"/>
<Field Source="${0}" Target="SonNum"/>
<Field Source="${1}" Target="Leveal"/>
</Table>
<Table Source="商品" Target="ptype" FieldName="FullName" KeyField="TypeID" UniqueField="FullName" KeepOldData="True">
<Field Source="二级类别" Target="ParID" UsePriorFieldsIfEmpty="一级类别" NotNull="True" Default='00000'>
<RefTable Target="ptype" FieldName="FullName" KeyField="TypeID" LookupOnly="True"/>
</Field>
<Field Source="${AutoIncWithPrefix(5,Target('ParID'))}" Target="TypeID"/>
<Field Source="三级类别" Target="FullName" UseLastValueIfEmpty="True"/>
<Field Source="${GetPY(Target('FullName'))}" Target="PyCode"/>
<Field Source="${Target('PyCode')}" Target="UserCode"/>
<Field Source="${0}" Target="SonCount"/>
<Field Source="${0}" Target="SonNum"/>
<Field Source="${1}" Target="Leveal"/>
</Table>
<Table Source="商品" Target="ptype" FieldName="FullName" KeyField="TypeID" UniqueField="FullName" KeepOldData="True">
<Field Source="三级类别" Target="ParID" UsePriorFieldsIfEmpty="二级类别,一级类别" NotNull="True" Default='00000'>
<RefTable Target="ptype" FieldName="FullName" KeyField="TypeID" LookupOnly="True"/>
</Field>
<Field Source="${AutoIncWithPrefix(5,Target('ParID'))}" Target="TypeID"/>
<Field Source="四级类别" Target="FullName" UseLastValueIfEmpty="True"/>
<Field Source="${GetPY(Target('FullName'))}" Target="PyCode"/>
<Field Source="${Target('PyCode')}" Target="UserCode"/>
<Field Source="${0}" Target="SonCount"/>
<Field Source="${0}" Target="SonNum"/>
<Field Source="${1}" Target="Leveal"/>
</Table>
<Table Source="商品" Target="ptype" FieldName="FullName" KeyField="TypeID" KeepOldData="True"
AfterImport="update ptype set ParID='00000' where TypeID<>'00000' and (ParID is null or ParID='');
update ptype set SonNum=(select count(1) from ptype as b where b.ParID=ptype.TypeID);
update ptype set SonCount=SonNum">
<Field Source="四级类别" Target="ParID" UsePriorFieldsIfEmpty="三级类别,二级类别,一级类别" NotNull="True" Default='00000'>
<RefTable Target="ptype" FieldName="FullName" KeyField="TypeID" LookupOnly="True"/>
</Field>
<Field Source="${AutoIncWithPrefix(5,Target('ParID'))}" Target="TypeID"/>
<Field Source="商品编号" Target="UserCode"/>
<Field Source="商品条码" Target="EntryCode"/>
<Field Source="商品全名" Target="FullName"/>
<Field Source="${GetPY(Target('FullName'))}" Target="PyCode"/>
<Field Source="${0}" Target="SonCount"/>
<Field Source="${0}" Target="SonNum"/>
<Field Source="${1}" Target="Leveal"/>
<Field Source="简名" Target="Name"/>
<Field Source="小单位" Target="Unit1"/>
<Field Source="大单位" Target="Unit2"/>
<Field Source="换算关系" Target="UnitRate1"/>
<Field Source="规格" Target="Standard"/>
<Field Source="型号" Target="Type"/>
<Field Source="产地" Target="Area"/>
<Field Source="预设售价1" Target="preprice1"/>
<Field Source="预设售价2" Target="preprice2"/>
<Field Source="预设售价3" Target="preprice3"/>
<Field Source="预设售价4" Target="preprice4"/>
<Field Source="预设进价" Target="preprice5"/>
<Field Source="备注" Target="Comment"/>
</Table> |