如何使用导入导出模版导入数据？
<H2 style="MARGIN: 13pt 0cm"><SPAN style="FONT-FAMILY: 黑体; mso-ascii-font-family: Arial">用模版导入数据</SPAN></H2><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN lang=EN-US>1 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在</SPAN><SPAN lang=EN-US>Sage X3 系统</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中参数菜单下 修改导入导出模版。</SPAN></FONT></P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN lang=EN-US>2 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在</SPAN><SPAN lang=EN-US>xls</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">文件中按照模版准备数据，然后另存为</SPAN><SPAN lang=EN-US> .cvs </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">文件。</SPAN></FONT></P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN lang=EN-US>3 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">用</SPAN><SPAN lang=EN-US>UltraEdit </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">打开</SPAN><SPAN lang=EN-US>.cvs</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">文件，在第一行数据前键入</SPAN> <SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">回车，空一行。</SPAN></FONT></P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN lang=EN-US>4 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将文本全选，</SPAN><SPAN lang=EN-US>Ctrl+H ,</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">变为十六进制的文本。</SPAN></FONT></P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN lang=EN-US>5 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将各条记录的分割符变为十六进制符号。例如：</SPAN> <SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将</SPAN><SPAN lang=EN-US>0D<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /><st1:chmetcnv w:st="on" UnitName="a" SourceValue="0" HasSpace="False" Negative="False" NumberType="1" TCSC="0">0A</st1:chmetcnv> </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">替换为</SPAN><SPAN lang=EN-US> <st1:chmetcnv w:st="on" UnitName="a" SourceValue="0" HasSpace="False" Negative="False" NumberType="1" TCSC="0">0A</st1:chmetcnv>, </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将表缩写</SPAN><SPAN lang=EN-US>s </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的</SPAN><st1:chmetcnv w:st="on" UnitName="C" SourceValue="2" HasSpace="False" Negative="False" NumberType="1" TCSC="0"><SPAN lang=EN-US>2C</SPAN></st1:chmetcnv><st1:chmetcnv w:st="on" UnitName="C" SourceValue="732" HasSpace="False" Negative="False" NumberType="1" TCSC="0"><SPAN lang=EN-US>732C</SPAN></st1:chmetcnv><SPAN lang=EN-US> </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">替换为</SPAN><st1:chmetcnv w:st="on" UnitName="a" SourceValue="0" HasSpace="False" Negative="False" NumberType="1" TCSC="0"><SPAN lang=EN-US>0A</SPAN></st1:chmetcnv><st1:chmetcnv w:st="on" UnitName="C" SourceValue="732" HasSpace="False" Negative="False" NumberType="1" TCSC="0"><SPAN lang=EN-US>732C</SPAN></st1:chmetcnv><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">。</SPAN></FONT></P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"></SPAN></FONT> </P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">其中小写s对应的码 是 73，大写S是53，小写a是61，大写A是41， 2C是逗号。</SPAN></FONT></P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"></SPAN></FONT> </P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN lang=EN-US>7 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将后</SPAN><SPAN lang=EN-US>cvs</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">文件的缀名改为</SPAN><SPAN lang=EN-US>.txt</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">。</SPAN></FONT></P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN lang=EN-US>8 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">用文本方式打开文件，另存为</SPAN> <SPAN lang=EN-US>UTF-8</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">格式。</SPAN></FONT></P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN lang=EN-US>9 在功能菜单下，</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">用导入模版导入数据。</SPAN></FONT></P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"></SPAN></FONT> </P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">下载 ：</SPAN></FONT></P><P style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd" class=MsoNormal><FONT color=#f73809 size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><A target=_blank href="http://pickup.mofile.com/1941504594420998" target=_blank>http://pickup.mofile.com/1941504594420998</A></SPAN></FONT></P><P> </P><P> </P><P>［此帖子已被 LiYa 在 2008-6-30 10:51:30 编辑过］</P><P>［此帖子已被 LiYa 在 2008-8-29 17:21:12 编辑过］</P><p>［此帖子已被 LiYa 在 2008-8-29 17:31:48 编辑过］Re:如何使用导入导出模版导入数据？
<P>Good!</P>Re:如何使用导入导出模版导入数据？
xiexieRe:如何使用导入导出模版导入数据？
<P><FONT style="BACKGROUND-COLOR: #c7edcc">？</FONT></P>Re:如何使用导入导出模版导入数据？
<P><SPAN lang=EN-US><FONT size=3>UltraEdit是一个十六进制转换工具</FONT></SPAN></P><P><SPAN lang=EN-US><FONT size=3><SPAN lang=EN-US>5 </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将各条记录的分割符变为二进制符号。例如：</SPAN> <SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将</SPAN><SPAN lang=EN-US>0D<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /><st1:chmetcnv TCSC="0" NumberType="1" Negative="False" HasSpace="False" SourceValue="0" UnitName="a" w:st="on">0A</st1:chmetcnv> </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">替换为</SPAN><SPAN lang=EN-US> <st1:chmetcnv TCSC="0" NumberType="1" Negative="False" HasSpace="False" SourceValue="0" UnitName="a" w:st="on">0A</st1:chmetcnv>, </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将表缩写</SPAN><SPAN lang=EN-US>s </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的</SPAN><st1:chmetcnv TCSC="0" NumberType="1" Negative="False" HasSpace="False" SourceValue="2" UnitName="C" w:st="on"><SPAN lang=EN-US>2C</SPAN></st1:chmetcnv><st1:chmetcnv TCSC="0" NumberType="1" Negative="False" HasSpace="False" SourceValue="732" UnitName="C" w:st="on"><SPAN lang=EN-US>732C</SPAN></st1:chmetcnv><SPAN lang=EN-US> </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">替换为</SPAN><st1:chmetcnv TCSC="0" NumberType="1" Negative="False" HasSpace="False" SourceValue="0" UnitName="a" w:st="on"><SPAN lang=EN-US>0A</SPAN></st1:chmetcnv><st1:chmetcnv TCSC="0" NumberType="1" Negative="False" HasSpace="False" SourceValue="732" UnitName="C" w:st="on"><SPAN lang=EN-US>732C</SPAN></st1:chmetcnv><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">。----》 0D0A 这个是十六进制吧，不好意思不太明白哪里跟二进制有关。</SPAN></FONT></SPAN></P><P><SPAN lang=EN-US><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">谢谢请指教</SPAN></FONT></SPAN></P>Re:如何使用导入导出模版导入数据？
<P>的确是 16 进制的，我写错了。 已经在原帖更正了。</P><P> </P><P><FONT color=#ff0000 size=3>谢谢 123的指教。我会增10个金币给你。</FONT></P>Re:如何使用导入导出模版导入数据？
<P>在V5中按此操作可能有问题，请大家测试后说说自己的测试结果。</P><P>我按此在V5中进行数据导入，结果是报错，无法导入。</P>Re:如何使用导入导出模版导入数据？
<P> </P><P>没问题的。我已经测试过了。</P>Re:如何使用导入导出模版导入数据？
<P> </P><P>在V5中，将模板-结构中的文件类型选‘定界’，字段分隔符输入‘,’，记录分隔符输入‘\010’，字段分隔符输入‘"’,文件格式选UTF8，</P><P>按照导出的CSV文件格式在EXCEL中整理数据，保存为CSV文件，如果文件中没有中文，直接可以导入。如果有中文，用<SPAN lang=EN-US><FONT size=3>UltraEdit转换 ‘ASCII--UTF8’，保存之后直接导入就可以了。</FONT></SPAN></P><P><SPAN lang=EN-US><FONT size=3>注意：转换完后，如果再打开CSV文件进行修改，中文导入后有部分可能是乱码。</FONT></SPAN></P><P> </P>页:
[1]