TA的每日心情 | 无聊 2023-7-30 17:28 |
---|
签到天数: 60 天 [LV.6]常住居民II
|
楼主 |
发表于 2014-12-4 09:23:12
|
显示全部楼层
摸索了几天,终于能导入物料编码和BOM了。
用T6快速实施工具,导入基础资料,从原来系统把资料导出xls,编辑转换格式后再导入,终于成功了。
<导入失败原因 | 存货编码 | 存货名称 | 存货大类编码 | 计量单位组编码 | 主计量单位编码 | 计量单位组类别 | ok | 15101720 | KPS10-5 | 151 | 3 | 31 | 0 | ok | 21100010 | KPS12,1.6/CEM-1/1oz | 211 | 3 | 31 | 0 | ok | 2210152J | 1.5K 5% 1/8W CF | 221 | 3 | 31 | 0 | ok | 2210202J | 2K, 5% 1/8W CF | 221 | 3 | 31 | 0 | ok | 2210471J | 470R 5% 1/8W CF | 221 | 3 | 31 | 0 | ok | 22205R1J | 5.1R 5% 1/4W CF | 222 | 3 | 31 | 0 | ok | 2230154J | 150K 5% 1/2W CF | 223 | 3 | 31 | 0 | ok | 22910221 | VR-1K,白色,立式 | 229 | 3 | 31 | 0 | ok | 231106F1 | 10UF/50V,5*11 | 231 | 3 | 31 | 0 | ok | 231477C1 | 470UF/16V,8*11.5 KF | 231 | 3 | 31 | 0 | ok | 232104F0 | 104D 独石 | 232 | 3 | 31 | 0 | ok | 233223H1 | 223J/100V | 233 | 3 | 31 | 0 | ok | 232222P1 | 222K/1KV,P=5,蓝色 | 232 | 3 | 31 | 0 | ok | 234104K2 | 104/275V,X2,P=10 | 234 | 3 | 31 | 0 | ok | 241317D0 | KT317D | 241 | 3 | 31 | 0 | ok | 24301000 | LF010,UU9.8 | 243 | 3 | 31 | 0 | ok | 244R0020 | LR002,6*8工 | 244 | 3 | 31 | 0 | ok | 25140070 | 1N4007,1A/1KV | 251 | 3 | 31 | 0 | ok | 25300120 | VIPER12A,DIP-8 | 253 | 3 | 31 | 0 | ok | 25304310 | TL431,5%,TO-92 | 253 | 3 | 31 | 0 | ok | 25308170 | PC817B,DIP4 | 253 | 3 | 31 | 0 | ok | 26125031 | 3P2(2.54) | 261 | 3 | 31 | 0 | ok | 26125040 | 4P(2.54) | 261 | 3 | 31 | 0 | ok | 26407060 | J7.5/0.6 | 264 | 3 | 31 | 0 | ok | 26500100 | F1A/250V,3*10引线 | 265 | 3 | 31 | 0 | ok | 2270221J | 220R/1206 5% | 227 | 3 | 31 | 0 | ok | 231685L1 | 6.8UF/400V 10*21 | 231 | 3 | 31 | 0 | ok | 25126000 | SR260 | 251 | 3 | 31 | 0 | ok | 27402010 | 主标签 | 274 | 3 | 31 | 0 | ok | 27403010 | 条码 | 274 | 3 | 31 | 0 | ok | 27404010 | QC标签 | 274 | 3 | 31 | 0 |
这是编码导入。几天搞不定,原来编码要纯文本格式。我原来是复制过来的,是数字格式,总出错。
<导入失败原因 | 父项编码 | 子项编码 | 仓库编码 | 基本用量分子 | 基本用量分母 | ok | 15101720 | 21100010 | 2 | 1.00 | 1 | ok | 15101720 | 2210152J | 2 | 1.00 | 1 | ok | 15101720 | 2210202J | 2 | 2.00 | 1 | ok | 15101720 | 2210471J | 2 | 1.00 | 1 | ok | 15101720 | 22205R1J | 2 | 1.00 | 1 | ok | 15101720 | 2230154J | 2 | 1.00 | 1 | ok | 15101720 | 22910221 | 2 | 1.00 | 1 | ok | 15101720 | 231106F1 | 2 | 1.00 | 1 | ok | 15101720 | 231477C1 | 2 | 2.00 | 1 | ok | 15101720 | 232104F0 | 2 | 1.00 | 1 | ok | 15101720 | 233223H1 | 2 | 1.00 | 1 | ok | 15101720 | 232222P1 | 2 | 1.00 | 1 | ok | 15101720 | 234104K2 | 2 | 1.00 | 1 | ok | 15101720 | 241317D0 | 2 | 1.00 | 1 | ok | 15101720 | 24301000 | 2 | 1.00 | 1 | ok | 15101720 | 244R0020 | 2 | 1.00 | 1 | ok | 15101720 | 25140070 | 2 | 6.00 | 1 | ok | 15101720 | 25300120 | 2 | 1.00 | 1 | ok | 15101720 | 25304310 | 2 | 1.00 | 1 | ok | 15101720 | 25308170 | 2 | 1.00 | 1 | ok | 15101720 | 26125031 | 2 | 1.00 | 1 | ok | 15101720 | 26125040 | 2 | 1.00 | 1 | ok | 15101720 | 26407060 | 2 | 1.00 | 1 | ok | 15101720 | 26500100 | 2 | 1.00 | 1 | ok | 15101720 | 2270221J | 2 | 1.00 | 1 | ok | 15101720 | 231685L1 | 2 | 1.00 | 1 | ok | 15101720 | 25126000 | 2 | 1.00 | 1 | ok | 15101720 | 27402010 | 2 | 1.00 | 1 | ok | 15101720 | 27403010 | 2 | 1.00 | 1 | ok | 15101720 | 27404010 | 2 | 1.00 | 1 |
这是BOM导入。
|
|