Guest Posted March 15, 2010 Share Posted March 15, 2010 求救版主，CSV导入界面里的categories栏目混乱了，看图片，急求帮忙。谢谢！ Link to comment Share on other sites More sharing options...
21846657 Posted March 16, 2010 Share Posted March 16, 2010 表格里没有内容的单元格不要留有“空白”，填入分号即可。 Link to comment Share on other sites More sharing options...
Guest Posted March 16, 2010 Share Posted March 16, 2010 版主，结果是一样的。而我把categories里的ID 用 ;分割 时，在导入界面可以正确显示，但点 import csv file 时 页面提示 hack attempt. 结果没有导入，无法导入！ Link to comment Share on other sites More sharing options...
21846657 Posted March 16, 2010 Share Posted March 16, 2010 PS版本多少？试试field separator用逗号和multiple value separator用分号。 Link to comment Share on other sites More sharing options...
Guest Posted March 16, 2010 Share Posted March 16, 2010 PS版本多少？>>版本是1.3.0.3，最新的版本，试试field separator用逗号和multiple value separator用分号。>>试过了，一样的结果.我现在就在线等答案啊，什么事情都没法做了。 Link to comment Share on other sites More sharing options...
21846657 Posted March 16, 2010 Share Posted March 16, 2010 请把.csv文件附上。 Link to comment Share on other sites More sharing options...
Guest Posted March 16, 2010 Share Posted March 16, 2010 非常感谢，请见附件。并附上1.3.0.3 版本的AdminImport.php( prestashop_1.3.0.3\prestashop\admin\tabs 文件夹下).我用最新版本是因为我从原来的1.2.5升级到1.3.0.2时数据库全被破坏了，presta在1.3.0.3 的changelog里也说 这两个版本间的升级会出现数据库错误并在最新版本里改过来了。所以我重新建了数据库，但不幸新版本连CSV都没法导入。请帮忙查看，谢谢！ Products-quid-armani.csv AdminImport.php Link to comment Share on other sites More sharing options...
21846657 Posted March 16, 2010 Share Posted March 16, 2010 你的.csv文件是以逗号作为“field separator”，而.csv文件里采用的delimiter应该和prestashop的field separator一致，也就是说，prestashop里的field separator（默认的）分号，那么，.csv文件也应该是以分号来分隔。所以，请尝试重新生成以分号为delimiter的.csv文件。 Link to comment Share on other sites More sharing options...
Guest Posted March 16, 2010 Share Posted March 16, 2010 请问怎么生成 以分号为delimiter的.csv文件？我之前都是用上面附件的CSV格式导入的。如果用前一个版本1.3.0.2的AdminImport.php，覆盖最新版本的，可以完全正确显示.这是新版本的BUG吗？提交BUG REPORT 后一般多久会有回复？ Link to comment Share on other sites More sharing options...
21846657 Posted March 16, 2010 Share Posted March 16, 2010 首先，如果OS是win xp，工具是MS Excel 2003之类的，那么到OS的control panel >> Regional and Language Options >> Regional Options >> Customize >> List Separator改为; （如附图）接下来，在这里可以生成符合要求的.csv文件：Back Office >> Modules >> Tools >> Newsletter v2.0 >> Configure >> Export .CSV file用excel打开这个文件，把结构改为用来导入产品的结构，填入data后再尝试导入。[uPDATE 1]如果用的是OpenOffice来生成或编辑.csv文件，那就简单多了。[uPDATE 2].csv可以有空白的单元格，就是什么都不填。 Link to comment Share on other sites More sharing options...
Guest Posted March 16, 2010 Share Posted March 16, 2010 万分感谢，谢谢你的耐心和详细的解释现在可以导入，但是只导入记录，没导入图片，已尝试多次，图片地址无误。附上CSV，谢谢！ customers_export_546613195.csv Link to comment Share on other sites More sharing options...
21846657 Posted March 16, 2010 Share Posted March 16, 2010 使用的还是13b1（1.3.0.3）的AdminImport.php吗？图片都是大图，你需要Regenerate thumbnails：Back Office >> Preferences >> Image >>Regenerate thumbnails Link to comment Share on other sites More sharing options...
Guest Posted March 16, 2010 Share Posted March 16, 2010 用的是1.3.0.3的 AdminImport.php.但为什么要Regenerate thumbnails呢？我用的都是默认大小，不曾改过。我之前传的图片都是上面附件的CSV里的图片一样大小的。 Link to comment Share on other sites More sharing options...
21846657 Posted March 16, 2010 Share Posted March 16, 2010 Regenerate thumbnails应该是（理论上）不用的，考虑到AdminImport有增加对link rewrite的支持，以及其他改进，所以建议你试试看。 Link to comment Share on other sites More sharing options...
Guest Posted March 16, 2010 Share Posted March 16, 2010 操作了regenerate thumbnails,一段时间后网页显示不过来就无法显示了，但问题还是没解决。 Link to comment Share on other sites More sharing options...
21846657 Posted March 16, 2010 Share Posted March 16, 2010 你的图片是存在/images里面吧？该目录权限多少？是不是用13a2的AdminImport.php能正常显示图片？ Link to comment Share on other sites More sharing options...
Guest Posted March 16, 2010 Share Posted March 16, 2010 是存在/images，权限没有任何问题，之前我都是这样传的。我是按你在9楼的提示操作后就没办法导入了。 Link to comment Share on other sites More sharing options...
21846657 Posted March 16, 2010 Share Posted March 16, 2010 请试试附件。 customers_export_546613195.csv Link to comment Share on other sites More sharing options...
Guest Posted March 16, 2010 Share Posted March 16, 2010 试了你的CSV附件，请看附件操作结果：Error copying image。 Link to comment Share on other sites More sharing options...
Guest Posted March 17, 2010 Share Posted March 17, 2010 这个问题我已经解决，办法是用以前版本的后台来传图片，再用最新版本的后台来传ATTRIBUTES，这样可以同时避免新老版本的问题。另外一个问题也想请教版主，请看：http://www.prestashop.com/forums/viewthread/47661/谢谢！ Link to comment Share on other sites More sharing options...
Cheney Posted April 8, 2010 Share Posted April 8, 2010 你好，我也是遇到了这个问题，请问到底怎么解决啊？也按上面方法弄了，导入成功但是没有图片显示，请问怎么回事啊？？？ 急！ Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now