Import products

Hi !

I got a problem when I try to import product from cli.
I had run the clank server and message queue.

So when I import my csv file from web interface, my products are sucessfully imported, but when I try from cli, the job got status success but my products are not in products list.

However, I got some PHP warning because of sprintf

PHP

PHP Warning: sprintf(): Too few arguments in orocommerce-application-1-stable/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Command/ImportCommand.php on line 95 PHP Warning: sprintf(): Too few arguments in orocommerce-application-1-stable/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Async/Import/CliImportValidationMessageProcessor.php on line 101 PHP Notice: Undefined index: message in orocommerce-application-1-stable/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Async/Import/CliImportValidationMessageProcessor.php on line 113

1 2 3 4

PHP Warning:  sprintf(): Too few arguments in orocommerce-application-1-stable/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Command/ImportCommand.php on line 95   PHP Warning:  sprintf(): Too few arguments in orocommerce-application-1-stable/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Async/Import/CliImportValidationMessageProcessor.php on line 101 PHP Notice:  Undefined index: message in orocommerce-application-1-stable/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Async/Import/CliImportValidationMessageProcessor.php on line 113

It seem the code miss some parameters.

I made the test in my local machine and on the virtual machine downloaded on https://oroinc.com/b2b-ecommerce/download.

Maybe I have to create some issue on oroplatform/orocommerce or some people got the solution ?

Thx for answers.

Topic

[dandriesParticipant]

Hi Tyler,

Can you please tell me which version of the virtual machine have you downloaded and used? Latest orocommerce stable, or development?

I’ve tried on a latest development version, on my local machine (not with virtual) and the operation works with this command:

PHP

app/console oro:import:file ~/oro_product_product_2017_02_23_16_06_45_58aeec75772d8.csv Choose Processor: [0] oro_entity_config_entity_field.add_or_replace [1] oro_translation_translation.add_or_replace [2] oro_translation_translation.reset [3] oro_product_product.add_or_replace [4] oro_tracking.processor.data [5] oro_pricing_product_price.add_or_replace [6] oro_pricing_product_price.reset [7] oro_tax_tax_rule [8] oro_tax_tax [9] oro_inventory.inventory_level > 0 Choose Job: [0] entity_fields_import_from_csv [1] attribute_import_from_csv [2] entity_import_from_csv [3] language_translations_import_from_csv [4] import_log_to_database [5] import_request_to_database [6] price_list_product_prices_entity_import_from_csv > 2 Scheduled successfully. The result will be sent to the email

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

app/console oro:import:file ~/oro_product_product_2017_02_23_16_06_45_58aeec75772d8.csv   Choose Processor:   [0] oro_entity_config_entity_field.add_or_replace   [1] oro_translation_translation.add_or_replace   [2] oro_translation_translation.reset   [3] oro_product_product.add_or_replace   [4] oro_tracking.processor.data   [5] oro_pricing_product_price.add_or_replace   [6] oro_pricing_product_price.reset   [7] oro_tax_tax_rule   [8] oro_tax_tax   [9] oro_inventory.inventory_level > 0 Choose Job:   [0] entity_fields_import_from_csv   [1] attribute_import_from_csv   [2] entity_import_from_csv   [3] language_translations_import_from_csv   [4] import_log_to_database   [5] import_request_to_database   [6] price_list_product_prices_entity_import_from_csv > 2 Scheduled successfully. The result will be sent to the email

[TylerParticipant]

Hi Dandries,

Thx for answer.

Yes I’m using orocommerce 1.0 stable and I had only one choice for the VM.

I dont use this command because she is not in my app/console list

app/console oro:import:file ~/oro_product_product_2017_02_23_16_06_45_58aeec75772d8.csv

So I use

PHP

php app/console oro:import:csv ~/Documents/Projets/ORO/mycsv.csv --email=tyler@example.com -e=prod Choose Processor: [0 ] oro_entity_config_entity_field.add_or_replace [1 ] oro_translation_translation.add_or_replace [2 ] oro_translation_translation.reset [3 ] oro_contact.add_or_replace [4 ] oro_contact.add [5 ] oro_product_product.add_or_replace [6 ] oro_account.add_or_replace [7 ] oro_pricing_product_price.add_or_replace [8 ] oro_pricing_product_price.reset [9 ] oro_sales_lead.add_or_replace [10] oro_sales_opportunity.add_or_replace [11] oro_sales_b2bcustomer [12] oro_inventory.inventory_level > 5 PHP Warning: sprintf(): Too few arguments in orocommerce-application-1-stable/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Command/ImportCommand.php on line 95

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

php app/console oro:import:csv ~/Documents/Projets/ORO/mycsv.csv  --email=tyler@example.com -e=prod Choose Processor:   [0 ] oro_entity_config_entity_field.add_or_replace   [1 ] oro_translation_translation.add_or_replace   [2 ] oro_translation_translation.reset   [3 ] oro_contact.add_or_replace   [4 ] oro_contact.add   [5 ] oro_product_product.add_or_replace   [6 ] oro_account.add_or_replace   [7 ] oro_pricing_product_price.add_or_replace   [8 ] oro_pricing_product_price.reset   [9 ] oro_sales_lead.add_or_replace   [10] oro_sales_opportunity.add_or_replace   [11] oro_sales_b2bcustomer   [12] oro_inventory.inventory_level > 5 PHP Warning:  sprintf(): Too few arguments in orocommerce-application-1-stable/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Command/ImportCommand.php on line 95

I got this exactly this packages :

PHP

oro/calendar-bundle 2.0.0 OSL-3.0 oro/commerce 1.0.0 OSL-3.0 oro/commerce-crm 1.0.0 OSL-3.0 oro/crm 2.0.0 OSL-3.0 oro/crm-call-bundle 2.0.0 OSL-3.0 oro/crm-task-bundle 2.0.0 OSL-3.0 oro/doctrine-extensions 1.0.13 MIT oro/marketing 2.0.0 OSL-3.0 oro/platform 2.0.0 MIT oro/platform-serialised-fields 2.0.0 OSL-3.0 oro/redis-config 2.0.0-beta.1 MIT

1 2 3 4 5 6 7 8 9 10 11

oro/calendar-bundle                         2.0.0               OSL-3.0                             oro/commerce                                1.0.0               OSL-3.0                             oro/commerce-crm                            1.0.0               OSL-3.0                             oro/crm                                     2.0.0               OSL-3.0                             oro/crm-call-bundle                         2.0.0               OSL-3.0                             oro/crm-task-bundle                         2.0.0               OSL-3.0                             oro/doctrine-extensions                     1.0.13              MIT                                 oro/marketing                               2.0.0               OSL-3.0                             oro/platform                                2.0.0               MIT                                 oro/platform-serialised-fields              2.0.0               OSL-3.0                             oro/redis-config                            2.0.0-beta.1        MIT

[dandriesParticipant]

Hei Tyler,

I’ve tried also on a first stable 1.0.0 version, and indeed it is bug there.
In newer versions though, this problem is fixed.

Let me know if there’s anything else I can help with.

[TylerParticipant]

Ok, thanks, I’m waiting for the next version.

[TylerParticipant]

@dandries, So maybe you can help me for the API :
I’m trying to POST a product, I generate my wsse header but I dont know the expected content json data to the API. The sandbox is not avaible in POST.

Can you help me on this point ?

[dandriesParticipant]

Hi,

There is a blog post for the new oro API: https://www.orocrm.com/blog/product-updates/new-oro-web-api-now-available .
Also, there is the documentation of the API bundle which can help https://github.com/orocrm/platform/blob/master/src/Oro/Bundle/ApiBundle/Resources/doc/index.md.

For using the WSSE header, there is a documentation article: https://www.orocrm.com/documentation/current/cookbook/how-to-use-wsse-authentication .

Another resource can be found in the application at this route : http://[your_application_base_url]admin/api/doc/rest_json_api . Here you can find the REST api for a lot of entities, including Product, and you can see and test them.

[Author]

Replies