autotelik / datashift_spree

Comprehensive import and export tools for Spree and Spree Products
Other
90 stars 104 forks source link

can't import product #48

Open cgcmart opened 9 years ago

cgcmart commented 9 years ago

I did generate spree product template and export spree product. But could not import spree product. I used this command line: bundle exec thor datashift:import:excel -i --input=spree_product.xls -m --model=Spree::Product -a

response is No value provided for option '--input' datashiftclip1

autotelik commented 9 years ago

thor options are shown in short form/long form .. you have used BOTH -i and --input .. you only need one of them

autotelik commented 9 years ago

same for the others either -m or --model not both

cgcmart commented 9 years ago

I tried 1 row data, but failed. Report summary as follows: Processing Column 0 Current value to assign : Huan Lian Su Coated Tablets Failed to process row [1] ["C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/datashift-0.15.0/lib/datashift/populator.rb:125:in assign'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/datashift-0.15.0/lib/loaders/loader_base.rb:342:inprocess'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/datashift-0.15.0/lib/loaders/excel_loader.rb:125:in block (3 levels) in perform_excel_load'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/datashift-0.15.0/lib/loaders/excel_loader.rb:113:ineach'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/datashift-0.15.0/lib/loaders/excel_loader.rb:113:in block (2 levels) in perform_excel_load'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/spreadsheet-1.0.5/lib/spreadsheet/worksheet.rb:147:inblock in each'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/spreadsheet-1.0.5/lib/spreadsheet/worksheet.rb:146:in upto'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/spreadsheet-1.0.5/lib/spreadsheet/worksheet.rb:146:ineach'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/spreadsheet-1.0.5/lib/spreadsheet/excel/worksheet.rb:47:in each'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/datashift-0.15.0/lib/loaders/excel_loader.rb:84:ineach_with_index'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/datashift-0.15.0/lib/loaders/excel_loader.rb:84:in block in perform_excel_load'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:213:inblock in transaction'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/transaction.rb:184:in within_new_transaction'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:213:intransaction'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/activerecord-4.2.4/lib/active_record/transactions.rb:220:in transaction'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/datashift-0.15.0/lib/loaders/excel_loader.rb:82:inperform_excel_load'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/datashift-0.15.0/lib/loaders/excel_loader.rb:204:in perform_load'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/datashift-0.15.0/lib/thor/import.thor:79:inexcel'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/lib/thor/command.rb:27:in run'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/lib/thor/invocation.rb:126:ininvoke_command'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/lib/thor.rb:359:in dispatch'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/lib/thor/base.rb:440:instart'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/lib/thor/runner.rb:36:in method_missing'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/lib/thor/command.rb:29:inrun'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/lib/thor/command.rb:126:in run'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/lib/thor/invocation.rb:126:ininvoke_command'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/lib/thor.rb:359:in dispatch'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/lib/thor/base.rb:440:instart'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/thor-0.19.1/bin/thor:6:in <top (required)>'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/bin/thor:23:inload'", "C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/bin/thor:23:in `

'"]

autotelik commented 9 years ago

sorry this is an open source project, I do not have the time to provide support for individual data issues. I would suggest you fork the project and try to debug the code. Could maybe be a data format issue, as something being thrown from the spreadsheet gem .... e.g C:/inetpub/vhosts/99chinesemedicine.com/httpdocs/App_Data/Ruby22-x64/lib/ruby/gems/2.2.0/gems/spreadsheet-1.0.5/lib/spreadsheet/worksheet.rb