Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

can't import product #48

Open
cgcmart opened this issue Sep 28, 2015 · 4 comments
Open

can't import product #48

cgcmart opened this issue Sep 28, 2015 · 4 comments

Comments

@cgcmart
Copy link

cgcmart commented Sep 28, 2015

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
Copy link
Owner

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

@autotelik
Copy link
Owner

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

@cgcmart
Copy link
Author

cgcmart commented Sep 29, 2015

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
Copy link
Owner

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants