Cannot import csv with YAML
Description
Environment
Macbook Air OSX Mountain Lion 10.8.3
Activity
Show:
Nathan Voxland June 24, 2013 at 9:05 PM
Previous to the above yaml, there was:
- changeSet:
id: sampleCSVData
author: nvoxland
changes:
- loadData:
tableName: csvdata
file: changelogs/sample.data1.csv
Nathan Voxland June 24, 2013 at 9:05 PM
My tested yaml:
- changeSet:
id: sampleTSVData
author: nvoxland
changes:
- loadData:
tableName: csvdata
file: changelogs/sample.data1.tsv
separator: \t
- changeSet:
id: sampleDataCheck
author: nvoxland
preConditions:
- sqlCheck:
expectedResult: 4
sql: select count(*) from csvdata;
Nathan Voxland June 24, 2013 at 9:04 PM
It is working for me. Possibly fixed as part of https://liquibase.jira.com/browse/CORE-1320#icft=CORE-1320
Fixed
Details
Details
Created June 21, 2013 at 4:10 PM
Updated June 24, 2013 at 9:05 PM
Resolved June 24, 2013 at 9:04 PM
When I try to do a loadData with YAML, I get Null changeSet Error; however my code was copied straight from the site:
databaseChangeLog: - preConditions: - runningAs: {username: app} - changeSet: id: Fill Factor Table author: Edmund Fung changes: - loadData: encoding: UTF-8 file: factor.csv schemaName: app separator: ',' tableName: factor
I tried the XML method and it worked fine so I think there is an issue with loading data with YAML