NEED TO MANIPULATE CSV FILE PRIOR TO IMPORT
Hope dandiebolt wins the Hawaii trip. Maybe next one to Brazil. Think I am one of the few Brazilian happy quickbase customers.... My company imports 4 CSV files, regularly (Daily basis) to One...
Forum Discussion
Adapted working example to my needs
http://pastebin.com/HzXQ8tpz
Used ";" separator in d3
Has 6 fields: conta, Data_Mov, Nr_Doc, Historico, Valor, Deb_Cred,
I do 1 transformations
var valorFormat = row["Valor"].replace(".", ","); //replaces "." with ","
csv_line.push(valorFormat);
I create a new one concatenating
3 fields
csv_line.push(row["Conta"] + "-" + row["Nr_Doc"] + "-" + row["Valor"].replace(".", ","));// A new string.
It is working but I am terribly confused.
Some files are imported, some files are not. It seems that is something related with de size of the file.
Files higher than 800bytes are not imported??
I there a buffer or something similar I have to deal with?
Thanks
http://pastebin.com/HzXQ8tpz
Used ";" separator in d3
Has 6 fields: conta, Data_Mov, Nr_Doc, Historico, Valor, Deb_Cred,
I do 1 transformations
var valorFormat = row["Valor"].replace(".", ","); //replaces "." with ","
csv_line.push(valorFormat);
I create a new one concatenating
3 fields
csv_line.push(row["Conta"] + "-" + row["Nr_Doc"] + "-" + row["Valor"].replace(".", ","));// A new string.
It is working but I am terribly confused.
Some files are imported, some files are not. It seems that is something related with de size of the file.
Files higher than 800bytes are not imported??
I there a buffer or something similar I have to deal with?
Thanks