Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pgfutter issue when use fields "x,y,z" and delimiter ";" #58

Open
fcamargovalencia opened this issue Oct 19, 2018 · 1 comment
Open

Comments

@fcamargovalencia
Copy link

/opt/jboss/pgfutter --db database --table tableName --user userName--pass password --host local --schema public csv --fields "columna0,columna1,columna2,columna3,columna4,columna5,columna6,columna7,columna8,columna9,columna10,columna11,columna12,columna13,columna14,columna15,columna16,columna17,columna18,columna19,columna20,columna21,columna22,columna23,columna24,columna25,columna26,columna27,columna28,columna29,columna30,columna31,columna32" --delimiter ";" filename.csv

pgfutter reports "wrong number of fields in line" when execute command on windows it works, but when i run the same file with the same command i got this error

line 1, column 0: wrong number of fields in line: NO. OBLIGACION;CEDULA;NOMBRE DEUDOR;DIRECCION DEUDOR;PROYECTO1;DIRECCION CASA ADQUIRIDA;TELEFONO DOMICILIO;CIUDAD DOMICILIO;TELEFONO CONTACTO 1;TELEFONO CONTACTO 2;TELEFONO CONTACTO 3;NIT EMPRESA;NOMBRE EMPRESA;DIRECCION EMPRESA;TELEFONO EMPRESA;CIUDAD EMPRESA;VALOR VIVIENDA;MONTO INICIAL;PLAZO;SALDO EN PESOS;VALOR CUOTA;TASA DE INTERES;DIAS EN MORA;VALOR VENCIDO;NO. CUOTAS PENDIENTES;FECHA ULTIMO PAGO;CICLO FACT.;SALDO A IMPACTAR;FECHA DESEMBOLSO;FECHA PROX. PAGO;OBSERVACIONES;EXTRA1;EXTRA2;

@joallard
Copy link

I seem to run into a similar problem where there is an empty cell at the end of the row which might throw things off

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants