运行数据导入任务时出现“标题中有空白/空字段”错误
I receive the following error message when running a data import task:
Header has an empty/null field.
This causes the import task to fail.
The following are three possible causes of this error message:
- The comma-separated values (CSV) file contains an extra comma at the end of the column headers, which leads the site to expect an additional column name. When a null value appears for an expected column name, the data import task fails automatically.
- The entire row of column headers in the CSV file is encapsulated in double quotation marks ("). This also causes immediate failure of the data import task, as the site expects the full list of required columns for that CSV file; the site cannot recognize the long, encapsulated string as a column header.
- There is a FileColumnName included on the CSV which is not supported by the task per the realm's the Data Dictionary. There are values under the invalid header and the system cannot recognize the change requirement.
运行数据导入任务时收到以下错误消息:
标题具有空白/空字段。
这导致导入任务失败。
以下两个原因可能导致此错误消息出现:
- 您的逗号分隔值 (CSV) 文件在列标题结尾处包含额外的逗号,导致站点认为这是其他列的名称。当预计的列名显示为空值时,数据导入将自动失败。
- 您 CSV 文件中列标题的整个行都包含在双引号 (") 中。因为您的站点预期需要该 CSV 文件中所需列的完整列表,所以这也会立即导致数据导入任务失败;您的站点无法将此双引号中的一长串字符串识别为列标题。
执行以下一项操作以解决错误:
- 在文本编辑器中打开 CSV 文件,并将多余的逗号从列标题行的末尾删除。
- 从列标题的行中删除双引号。
也请确保检查每行数据的结尾,以确保您在重新导入该文件之前删除了多余的逗号或双引号。
开发票
核心采购 > 核心管理 > 核心管理导入/导出
目录管理