经销商数据采平集台使用培训.ppt

使用流程 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 一、EXCEL模板的使用 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 概述 需要上传的数据类别 EXCEL模板的文件名格式 EXCEL模板内的数据格式 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 1.1-EXCEL模板 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 1.2-EXCEL模板文件名格式 文件名格式： 客户库存 客户编码_KC_年月日(年月日例 客户进货 客户编码_JH_年月日 客户零售 客户编码_LSXS_年月日 客户批发 客户编码_PFXS_年月日 店铺库存 客户编码_DKC_年月日 店铺进货 客户编码_DJH_年月日 店铺销售 客户编码_DXS_年月日 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 1.3-EXCEL模板内数据文件格式 表内相关格式 销售日期格式：xxxx-x-x（例：2011-5-16） 货号格式：进销存货品资料库中存在 库存日期格式：月末最后一天 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 二、客户端工具的安装和使用 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 概 述 运行环境 证书导入 EXCEL模板存放路径 数据的提取和上传 日志查询 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 2.1-运行环境 安装在本地电脑使用 本地机器必须安装.net frame work 2.0 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 2.2-证书导入 1.首次登入系统，自动提示导入授权证书，单击确定，选择已下载下来的授权证 书导入客户端。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 2.3-Excel模板存放路径设置 打开客户端查看-查看路径信息（必须放在指定文件夹） Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 2.4-Excel模板提取 提取数据 打开客户端单击提取数据 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 红色框处代表数据提取成功或失败 绿色框处查看数据提取详细信息，若提取失败可点击查看原因 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Prof