Translations:Nhập tệp CSV vào Kiu ERP/47/en

Từ Kiu Wiki

Bước tới: chuyển hướng, tìm kiếm

company_3,Boum,True

To create the CSV file for persons, linked to companies, we will use the following SQL command in PSQL:

> copy (select 'person_'||id as "External ID",person_name as "Name",'False' as "Is a Company",'company_'||company_id as "Related Company/External ID" from persons) TO '/tmp/person.csv' with CSV

It will produce the following CSV file:

Lấy từ “https://docs.kiuglobal.com/w/index.php?title=Translations:Nhập_tệp_CSV_vào_Kiu_ERP/47/en&oldid=13525”