布尔字段"使用公司地址"的未知值'f'，假设第 2 行'yes'

Question

我有一个res_users和res_partner表的csv文件，并将其导入v7的openerp应用程序，但我收到以下错误：

Unknown value 'f' for boolean field 'Use Company Address', assuming 'yes' at row 2
Use '1' for yes and '0' for no
(665 more)
Unknown value 'f' for boolean field 'Opt-Out', assuming 'yes' at row 2
Use '1' for yes and '0' for no
(665 more)
No matching record found for name '235' in field 'Country' at row 2
Get all possible values
(35 more)
No matching record found for name '1' in field 'Company' at row 2
Get all possible values
(665 more)
Unknown value 'f' for boolean field 'Employee', assuming 'yes' at row 2
Use '1' for yes and '0' for no
(665 more)
Unknown value 'f' for boolean field 'Customer', assuming 'yes' at row 2
Use '1' for yes and '0' for no
(665 more)
Unknown value 'f' for boolean field 'Supplier', assuming 'yes' at row 2
Use '1' for yes and '0' for no
(665 more)
Unknown value 't' for boolean field 'Active', assuming 'yes' at row 2
Use '1' for yes and '0' for no
(665 more)
Unknown value 'f' for boolean field 'Is a Company', assuming 'yes' at row 2
Use '1' for yes and '0' for no
(665 more)
No matching record found for name '7' in field 'State' at row 2
Get all possible values
(31 more)
'1/29/2015' does not seem to be a valid date for field 'Latest connection' at row 3
Use the format '2012-12-31'
(3 more)
'2/6/2015' does not seem to be a valid date for field 'Latest connection' at row 9
Use the format '2012-12-31'
'9/9/2014' does not seem to be a valid date for field 'Latest connection' at row 14
Use the format '2012-12-31'
'1/22/2015' does not seem to be a valid date for field 'Latest connection' at row 15
Use the format '2012-12-31'
No matching record found for name '27' in field 'State' at row 26
Get all possible values
(2 more)
No matching record found for name '25' in field 'State' at row 34
Get all possible values

我该如何解决，请建议我。请建议我，等待答复。

感谢

Answer 1

在导入csv中，使用0 for false和1 for true 避免使用'f'进行布尔尝试

根据错误建议，csv中有很多错误的格式，请尝试使用该格式。之后它将成功导入。

例如：

1. 日期导入格式：

   使用此格式2012-12-31，而不是2015年6月2日，如2015-02-06

2. 对于布尔字段：

   0表示假，1表示真

3. 在第26行的字段"State"中找不到名称"27"的匹配记录获取所有可能的值

   转到csv文件并签出带有状态字段的记录行26。在OpenERP中检查该值是否正确。如果该状态不是创建状态，则尝试导入OpenERP中的第一个创建状态。