		@@ -18,2 +18,6 @@ The goal of this project is to be able to import any exported CSV (comma or semi colon separated) data from any bank account into a standard format, with everything such as CSV separator and column headings auto-detected. It's a work in progress. Please try it, and if some CSV file doesn't work for you, let me know.
		typedRecords : [], // same as above but with some fields converted to Date or Number where possible
		numColumns,
		// For each column, whether all the typedRecords in that column are of the same type
		// Will be null if there are mixed types
		entireColumnTypes : ["String", "Number", "Date", null],
		headerGuesses : { // if any of these could not be guessed it will be null
		@@ -20,0 +24,0 @@ date : 0,

src/bankImport.js

		@@ -145,2 +145,14 @@ import {findTypes} from "./parseTypes.js";

		function getEntireColumnTypes(typedRecords) {
		const numColumns = typedRecords[0].length;

		return new Array(numColumns).fill(null).map((_columnType, i) => {
		const firstValueType = typedRecords[0][i].constructor.name;

		// Check if each value is of the same type
		return typedRecords.every(row => row[i].constructor.name === firstValueType) ?
		firstValueType : null;
		});
		}

		export default function(data, options = {headerKeywordMatching : true}) {
		@@ -228,4 +240,5 @@ let lines = getLines(data);
		numColumns : longestFieldCount,
		entireColumnTypes : getEntireColumnTypes(typedRecords),
		headerGuesses
		};
		}

test.js

		@@ -105,12 +105,12 @@ import fs from "fs";

		// Compare if entire columns match the type given by expected.entireRowTypes array
		// Compare if entire columns match the type given by expected.entireColumnTypes array
		result.typedRecords.forEach((row, index) => {
		for (let i = 0; i < expected.entireRowTypes.length; i ++) {
		if (expected.entireRowTypes[i] === null) {
		for (let i = 0; i < expected.entireColumnTypes.length; i ++) {
		if (expected.entireColumnTypes[i] === null) {
		continue; // skip null
		}

		if (row[i].constructor.name !== expected.entireRowTypes[i]) {
		errors.push(`Expected entire row type mismatch: ${testDataPath}: `
		+ "Expected " + expected.entireRowTypes[i] + " but got: "
		if (row[i].constructor.name !== expected.entireColumnTypes[i]) {
		errors.push(`Expected entire column type mismatch: ${testDataPath}: `
		+ "Expected " + expected.entireColumnTypes[i] + " but got: "
		+ `"${row[i]}" (${row[i].constructor.name})`
		@@ -117,0 +117,0 @@ + `\n Column: ${i}`

testdata/barclays-1.expected.json

		{
		"entireRowTypes" : [null, "Date", null, "Number", null, null],
		"entireColumnTypes" : [null, "Date", null, "Number", null, null],
		"headerGuesses" : {
		@@ -4,0 +4,0 @@ "date" : 1,

testdata/barclays-2.expected.json

		{
		"entireRowTypes" : [null, "Date", null, "Number", null, null],
		"entireColumnTypes" : [null, "Date", null, "Number", null, null],
		"headerGuesses" : {
		@@ -4,0 +4,0 @@ "date" : 1,

testdata/barclays-extra-comma-issue.expected.json

		{
		"entireRowTypes" : [null, "Date", null, "Number", null, null, null],
		"entireColumnTypes" : [null, "Date", null, "Number", null, null, null],
		"headerGuesses" : {
		@@ -4,0 +4,0 @@ "date" : 1,

testdata/fidor.expected.json

		{
		"entireRowTypes" : ["Date", null, null, "Number"],
		"entireColumnTypes" : ["Date", null, null, "Number"],
		"headerGuesses" : {
		@@ -4,0 +4,0 @@ "date" : 0,

testdata/natwest.expected.json

		{
		"entireRowTypes" : ["Date", null, null, "Number", "Number", null, null],
		"entireColumnTypes" : ["Date", null, null, "Number", "Number", null, null],
		"headerGuesses" : {
		@@ -4,0 +4,0 @@ "date" : 0,

testdata/no-header-test.expected.json

		{
		"entireRowTypes" : [null, "Date", null, "Number", null, null],
		"entireColumnTypes" : [null, "Date", null, "Number", null, null],
		"headerGuesses" : {
		@@ -4,0 +4,0 @@ "date" : 1,

testdata/output/barclays-1.output.json

testdata/output/barclays-2.output.json

testdata/output/barclays-extra-comma-issue.output.json

testdata/output/fidor.output.json

testdata/output/natwest.output.json

testdata/output/no-header-test.output.json

testdata/output/paypal-1.output.json

testdata/output/paypal-2.output.json

testdata/output/single-row-test.output.json

testdata/output/transferwise.output.json

testdata/paypal-1.expected.json

		{
		"entireRowTypes" : [
		"entireColumnTypes" : [
		"Date", null, null, null, null, null, null, "Number", "Number", "Number", null, null, null, null, null, null, null, "Number", null, "Number", null, null, null, null, null, null, null,
		@@ -4,0 +4,0 @@ "Number", null, "Number", null, null, null, null, null, null, null, null, null, null, null

testdata/paypal-2.expected.json

		{
		"entireRowTypes" : ["Date", null, null, null, null, null, null, "Number", null, "Number"],
		"entireColumnTypes" : ["Date", null, null, null, null, null, null, "Number", null, "Number"],
		"headerGuesses" : {
		@@ -4,0 +4,0 @@ "date" : 0,

testdata/single-row-test.expected.json

		{
		"entireRowTypes" : [null, "Date", null, "Number", null, null],
		"entireColumnTypes" : [null, "Date", null, "Number", null, null],
		"headerGuesses" : {
		@@ -4,0 +4,0 @@ "date" : 1,

testdata/transferwise.expected.json

		{
		"entireRowTypes" : [null, "Date", "Number", null, null, null, "Number", null, null, null, null, null, null, null, null, null, null, null, "Number"],
		"entireColumnTypes" : [null, "Date", "Number", null, null, null, "Number", null, null, null, null, null, null, null, null, null, null, null, "Number"],
		"headerGuesses" : {
		@@ -4,0 +4,0 @@ "date" : 1,

bank-csv-importer - npm Package Compare versions

New alerts