Community mailing list archives

community@mail.odoo.com

RE: Request

by
Fekete Mihai
- 11/13/2014 04:26:27

Hi, why don’t you use this kind of question on help.odoo.com.

 

If you even search on youtube, help.odoo.com you will find a lot of answers.

 

Best way, create one customer, export the required fields, ussualy name, because the other ones mostly have a default value set, so even if you not add them, they will be set.

 

Mihai Fekete

OpenErp Specialist

 

E-Mail:       mihai.fekete@forbiom.eu
Mobile:     
+4(0) 746 – 028 477

Office:       +4(0) 356 – 173 953 

 

Forest and Biomass Services Romania S.A.

Address: 10 Coriolan Brediceanu | City Business Centre | Timisoara 300011 | Romania

 

From: vishal sharma [mailto:vish04.sharma@gmail.com]
Sent: Thursday, November 13, 2014 11:23 AM
To: Community
Subject: Re: Request

 

Dear Team,

 

Let me know which table is used  for customer related data .

 

Below is output for info.

 

openerp=# \dt

                              List of relations

 Schema |                       Name                        | Type  |  Owner  

--------+---------------------------------------------------+-------+---------

 public | account_account                                   | table | openerp

 public | account_account_consol_rel                        | table | openerp

 public | account_account_financial_report                  | table | openerp

 public | account_account_financial_report_type             | table | openerp

 public | account_account_tax_default_rel                   | table | openerp

 public | account_account_template                          | table | openerp

 public | account_account_template_tax_rel                  | table | openerp

 public | account_account_type                              | table | openerp

 public | account_account_type_rel                          | table | openerp

 public | account_addtmpl_wizard                            | table | openerp

 public | account_aged_trial_balance                        | table | openerp

 public | account_aged_trial_balance_journal_rel            | table | openerp

 public | account_analytic_account                          | table | openerp

 public | account_analytic_balance                          | table | openerp

 public | account_analytic_chart                            | table | openerp

 public | account_analytic_cost_ledger                      | table | openerp

 public | account_analytic_cost_ledger_journal_report       | table | openerp

 public | account_analytic_inverted_balance                 | table | openerp

 public | account_analytic_journal                          | table | openerp

 public | account_analytic_journal_name                     | table | openerp

 public | account_analytic_journal_report                   | table | openerp

 public | account_analytic_line                             | table | openerp

 public | account_automatic_reconcile                       | table | openerp

 public | account_balance_report                            | table | openerp

 public | account_balance_report_journal_rel                | table | openerp

 public | account_bank_accounts_wizard                      | table | openerp

 public | account_bank_statement                            | table | openerp

 public | account_bank_statement_line                       | table | openerp

 public | account_bank_statement_line_move_rel              | table | openerp

 public | account_cashbox_line                              | table | openerp

 public | account_central_journal                           | table | openerp

 public | account_central_journal_journal_rel               | table | openerp

 public | account_change_currency                           | table | openerp

 public | account_chart                                     | table | openerp

 public | account_chart_template                            | table | openerp

 public | account_common_account_report                     | table | openerp

 public | account_common_account_report_account_journal_rel | table | openerp

 public | account_common_journal_report                     | table | openerp

 public | account_common_journal_report_account_journal_rel | table | openerp

 public | account_common_partner_report                     | table | openerp

 public | account_common_partner_report_account_journal_rel | table | openerp

 public | account_common_report                             | table | openerp

 public | account_common_report_account_journal_rel         | table | openerp

 public | account_config_settings                           | table | openerp

 public | account_financial_report                          | table | openerp

 public | account_fiscal_position                           | table | openerp

 public | account_fiscal_position_account                   | table | openerp

 public | account_fiscal_position_account_template          | table | openerp

 public | account_fiscal_position_tax                       | table | openerp

 public | account_fiscal_position_tax_template              | table | openerp

 public | account_fiscal_position_template                  | table | openerp

 public | account_fiscalyear                                | table | openerp

 public | account_fiscalyear_close                          | table | openerp

 public | account_fiscalyear_close_state                    | table | openerp

 public | account_general_journal                           | table | openerp

 public | account_general_journal_journal_rel               | table | openerp

 public | account_installer                                 | table | openerp

 public | account_invoice                                   | table | openerp

 public | account_invoice_cancel                            | table | openerp

 public | account_invoice_confirm                           | table | openerp

 public | account_invoice_line                              | table | openerp

 public | account_invoice_line_tax                          | table | openerp

 public | account_invoice_refund                            | table | openerp

 public | account_invoice_tax                               | table | openerp

 public | account_journal                                   | table | openerp

 public | account_journal_account_vat_declaration_rel       | table | openerp

 public | account_journal_accounting_report_rel             | table | openerp

 public | account_journal_cashbox_line                      | table | openerp

 public | account_journal_group_rel                         | table | openerp

 public | account_journal_period                            | table | openerp

 public | account_journal_select                            | table | openerp

 public | account_journal_type_rel                          | table | openerp

 public | account_model                                     | table | openerp

 public | account_model_line                                | table | openerp

 public | account_move                                      | table | openerp

 public | account_move_bank_reconcile                       | table | openerp

 public | account_move_line                                 | table | openerp

 public | account_move_line_reconcile                       | table | openerp

 public | account_move_line_reconcile_select                | table | openerp

 public | account_move_line_reconcile_writeoff              | table | openerp

 public | account_move_line_relation                        | table | openerp

 public | account_move_line_unreconcile_select              | table | openerp

 public | account_move_reconcile                            | table | openerp

 public | account_open_closed_fiscalyear                    | table | openerp

 public | account_partner_balance                           | table | openerp

 public | account_partner_balance_journal_rel               | table | openerp

 public | account_partner_ledger                            | table | openerp

 public | account_partner_ledger_journal_rel                | table | openerp

 public | account_partner_reconcile_process                 | table | openerp

 public | account_payment_term                              | table | openerp

 public | account_payment_term_line                         | table | openerp

 public | account_period                                    | table | openerp

 public | account_period_close                              | table | openerp

 public | account_print_journal                             | table | openerp

 public | account_print_journal_journal_rel                 | table | openerp

 public | account_report_general_ledger                     | table | openerp

 public | account_report_general_ledger_journal_rel         | table | openerp

 public | account_sequence_fiscalyear                       | table | openerp

 public | account_state_open                                | table | openerp

 public | account_statement_from_invoice_lines              | table | openerp

 public | account_subscription                              | table | openerp

 public | account_subscription_generate                     | table | openerp

 public | account_subscription_line                         | table | openerp

 public | account_tax                                       | table | openerp

 public | account_tax_chart                                 | table | openerp

 public | account_tax_code                                  | table | openerp

 public | account_tax_code_template                         | table | openerp

 public | account_tax_template                              | table | openerp

 public | account_template_financial_report                 | table | openerp

 public | account_unreconcile                               | table | openerp

 public | account_unreconcile_reconcile                     | table | openerp

 public | account_use_model                                 | table | openerp

 public | account_use_model_relation                        | table | openerp

 public | account_vat_declaration                           | table | openerp

 public | account_voucher                                   | table | openerp

 public | account_voucher_line                              | table | openerp

 public | accounting_report                                 | table | openerp

 public | action_traceability                               | table | openerp

 public | alarm_attendee_rel                                | table | openerp

 public | base_action_rule                                  | table | openerp

 public | base_action_rule_ir_act_server_rel                | table | openerp

 public | base_action_rule_lead_test                        | table | openerp

 public | base_action_rule_res_partner_rel                  | table | openerp

 public | base_config_settings                              | table | openerp

 public | base_import_import                                | table | openerp

 public | base_import_tests_models_char                     | table | openerp

 public | base_import_tests_models_char_noreadonly          | table | openerp

 public | base_import_tests_models_char_readonly            | table | openerp

 public | base_import_tests_models_char_required            | table | openerp

 public | base_import_tests_models_char_states              | table | openerp

 public | base_import_tests_models_char_stillreadonly       | table | openerp

 public | base_import_tests_models_m2o                      | table | openerp

 public | base_import_tests_models_m2o_related              | table | openerp

 public | base_import_tests_models_m2o_required             | table | openerp

 public | base_import_tests_models_m2o_required_related     | table | openerp

 public | base_import_tests_models_o2m                      | table | openerp

 public | base_import_tests_models_o2m_child                | table | openerp

 public | base_import_tests_models_preview                  | table | openerp

 public | base_language_export                              | table | openerp

 public | base_language_import                              | table | openerp

 public | base_language_install                             | table | openerp

 public | base_module_configuration                         | table | openerp

 public | base_module_import                                | table | openerp

 public | base_module_update                                | table | openerp

 public | base_module_upgrade                               | table | openerp

 public | base_setup_terminology                            | table | openerp

 public | base_update_translations                          | table | openerp

 public | board_create                                      | table | openerp

 public | calendar_alarm                                    | table | openerp

 public | calendar_attendee                                 | table | openerp

 public | calendar_attendee_child_rel                       | table | openerp

 public | calendar_attendee_parent_rel                      | table | openerp

 public | calendar_event                                    | table | openerp

 public | calendar_event_res_partner_rel                    | table | openerp

 public | calendar_todo                                     | table | openerp

 public | calendar_todo_res_partner_rel                     | table | openerp

 public | cash_box_in                                       | table | openerp

 public | cash_box_out                                      | table | openerp

 public | change_password_user                              | table | openerp

 public | change_password_wizard                            | table | openerp

 public | crm_case_categ                                    | table | openerp

 public | crm_case_channel                                  | table | openerp

 public | crm_case_resource_type                            | table | openerp

 public | crm_case_section                                  | table | openerp

 public | crm_case_stage                                    | table | openerp

 public | crm_lead                                          | table | openerp

 public | crm_lead2opportunity_partner                      | table | openerp

 public | crm_lead2opportunity_partner_mass                 | table | openerp

 public | crm_lead2opportunity_partner_mass_res_users_rel   | table | openerp

 public | crm_lead_category_rel                             | table | openerp

 public | crm_lead_crm_lead2opportunity_partner_mass_rel    | table | openerp

 public | crm_lead_crm_lead2opportunity_partner_rel         | table | openerp

 public | crm_make_sale                                     | table | openerp

 public | crm_meeting                                       | table | openerp

 public | crm_meeting_partner_rel                           | table | openerp

 public | crm_meeting_type                                  | table | openerp

 public | crm_merge_opportunity                             | table | openerp

 public | crm_opportunity2phonecall                         | table | openerp

 public | crm_partner_binding                               | table | openerp

 public | crm_payment_mode                                  | table | openerp

 public | crm_phonecall                                     | table | openerp

 public | crm_phonecall2phonecall                           | table | openerp

 public | crm_segmentation                                  | table | openerp

 public | crm_segmentation_line                             | table | openerp

 public | decimal_precision                                 | table | openerp

 public | email_template                                    | table | openerp

 public | email_template_attachment_rel                     | table | openerp

 public | email_template_preview                            | table | openerp

 public | event_attendee_rel                                | table | openerp

 public | fetchmail_config_settings                         | table | openerp

 public | fetchmail_server                                  | table | openerp

 public | ir_act_client                                     | table | openerp

 public | ir_act_report_custom                              | table | openerp

 public | ir_act_report_xml                                 | table | openerp

 public | ir_act_server                                     | table | openerp

 public | ir_act_url                                        | table | openerp

 public | ir_act_window                                     | table | openerp

 public | ir_act_window_group_rel                           | table | openerp

 public | ir_act_window_view                                | table | openerp

 public | ir_act_wizard                                     | table | openerp

 public | ir_actions                                        | table | openerp

 public | ir_actions_configuration_wizard                   | table | openerp

 public | ir_actions_todo                                   | table | openerp

 public | ir_attachment                                     | table | openerp

 public | ir_config_parameter                               | table | openerp

 public | ir_cron                                           | table | openerp

 public | ir_default                                        | table | openerp

 public | ir_exports                                        | table | openerp

 public | ir_exports_line                                   | table | openerp

 public | ir_fields_converter                               | table | openerp

 public | ir_filters                                        | table | openerp

 public | ir_mail_server                                    | table | openerp

 public | ir_model                                          | table | openerp

 public | ir_model_access                                   | table | openerp

 public | ir_model_constraint                               | table | openerp

 public | ir_model_data                                     | table | openerp

 public | ir_model_fields                                   | table | openerp

 public | ir_model_fields_group_rel                         | table | openerp

 public | ir_model_relation                                 | table | openerp

 public | ir_module_category                                | table | openerp

 public | ir_module_module                                  | table | openerp

 public | ir_module_module_dependency                       | table | openerp

 public | ir_property                                       | table | openerp

 public | ir_rule                                           | table | openerp

 public | ir_sequence                                       | table | openerp

 public | ir_sequence_type                                  | table | openerp

 public | ir_server_object_lines                            | table | openerp

 public | ir_translation                                    | table | openerp

 public | ir_ui_menu                                        | table | openerp

 public | ir_ui_menu_group_rel                              | table | openerp

 public | ir_ui_view                                        | table | openerp

 public | ir_ui_view_custom                                 | table | openerp

 public | ir_ui_view_group_rel                              | table | openerp

 public | ir_ui_view_sc                                     | table | openerp

 public | ir_values                                         | table | openerp

 public | ledger_journal_rel                                | table | openerp

 public | mail_alias                                        | table | openerp

 public | mail_compose_message                              | table | openerp

 public | mail_compose_message_ir_attachments_rel           | table | openerp

 public | mail_compose_message_res_partner_rel              | table | openerp

 public | mail_followers                                    | table | openerp

 public | mail_followers_mail_message_subtype_rel           | table | openerp

 public | mail_group                                        | table | openerp

 public | mail_group_res_group_rel                          | table | openerp

 public | mail_mail                                         | table | openerp

 public | mail_message                                      | table | openerp

 public | mail_message_res_partner_rel                      | table | openerp

 public | mail_message_subtype                              | table | openerp

 public | mail_notification                                 | table | openerp

 public | mail_vote                                         | table | openerp

 public | mail_wizard_invite                                | table | openerp

 public | mail_wizard_invite_res_partner_rel                | table | openerp

 public | make_procurement                                  | table | openerp

 public | meeting_attendee_rel                              | table | openerp

 public | meeting_category_rel                              | table | openerp

 public | merge_opportunity_rel                             | table | openerp

 public | message_attachment_rel                            | table | openerp

 public | mrp_property                                      | table | openerp

 public | mrp_property_group                                | table | openerp

 public | multi_company_default                             | table | openerp

 public | osv_memory_autovacuum                             | table | openerp

 public | portal_crm_crm_contact_us                         | table | openerp

 public | portal_crm_crm_contact_us_res_company_rel         | table | openerp

 public | portal_payment_acquirer                           | table | openerp

 public | portal_wizard                                     | table | openerp

 public | portal_wizard_user                                | table | openerp

 public | pos_box_entries                                   | table | openerp

 public | pos_category                                      | table | openerp

 public | pos_config                                        | table | openerp

 public | pos_config_journal_rel                            | table | openerp

 public | pos_confirm                                       | table | openerp

 public | pos_details                                       | table | openerp

 public | pos_details_report_user_rel                       | table | openerp

 public | pos_discount                                      | table | openerp

 public | pos_ean_wizard                                    | table | openerp

 public | pos_make_payment                                  | table | openerp

 public | pos_open_statement                                | table | openerp

 public | pos_order                                         | table | openerp

 public | pos_order_line                                    | table | openerp

 public | pos_payment_report                                | table | openerp

 public | pos_payment_report_user                           | table | openerp

 public | pos_receipt                                       | table | openerp

 public | pos_sale_user                                     | table | openerp

 public | pos_sales_user_today                              | table | openerp

 public | pos_session                                       | table | openerp

 public | pos_session_opening                               | table | openerp

 public | pricelist_partnerinfo                             | table | openerp

 public | process_condition                                 | table | openerp

 public | process_node                                      | table | openerp

 public | process_process                                   | table | openerp

 public | process_transition                                | table | openerp

 public | process_transition_action                         | table | openerp

 public | process_transition_group_rel                      | table | openerp

 public | process_transition_ids                            | table | openerp

 public | procurement_order                                 | table | openerp

 public | procurement_order_compute                         | table | openerp

 public | procurement_order_compute_all                     | table | openerp

 public | procurement_orderpoint_compute                    | table | openerp

 public | product_category                                  | table | openerp

 public | product_packaging                                 | table | openerp

 public | product_price_list                                | table | openerp

 public | product_price_type                                | table | openerp

 public | product_pricelist                                 | table | openerp

 public | product_pricelist_item                            | table | openerp

 public | product_pricelist_type                            | table | openerp

 public | product_pricelist_version                         | table | openerp

 public | product_product                                   | table | openerp

 public | product_supplier_taxes_rel                        | table | openerp

 public | product_supplierinfo                              | table | openerp

 public | product_taxes_rel                                 | table | openerp

 public | product_template                                  | table | openerp

 public | product_ul                                        | table | openerp

 public | product_uom                                       | table | openerp

 public | product_uom_categ                                 | table | openerp

 public | project_account_analytic_line                     | table | openerp

 public | publisher_warranty_contract                       | table | openerp

 public | reconcile_account_rel                             | table | openerp

 public | rel_modules_langexport                            | table | openerp

 public | rel_server_actions                                | table | openerp

 public | res_alarm                                         | table | openerp

 public | res_bank                                          | table | openerp

 public | res_company                                       | table | openerp

 public | res_company_users_rel                             | table | openerp

 public | res_config                                        | table | openerp

 public | res_config_installer                              | table | openerp

 public | res_config_settings                               | table | openerp

 public | res_country                                       | table | openerp

 

 

 

Regards

Vishal sharma

 

On Thu, Nov 13, 2014 at 6:24 AM, vishal sharma <vish04.sharma@gmail.com> wrote:

Dear Team ,

 

I want to import customer record from cvs file automatically .

 

Let me know if there is any link that help me .

 

I have openerp version 7 on centos 6.5 

 

 

Regards

Vishals sharma 

 

 

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe