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
I have a limited time today to answer questions but you should investigate using the libraries listed below. Accounting JS will allow you to format your currency, Date JS will allow you to format your dates, Underscore JS will allow you to manipulate your data in parallel and D3 has a CSV parser.
Accounting JS
http://openexchangerates.github.io/accounting.js/
https://cdnjs.cloudflare.com/ajax/libs/accounting.js/0.4.1/accounting.min.js
Date JS
http://www.datejs.com/
https://cdnjs.cloudflare.com/ajax/libs/datejs/1.0/date.min.js
Underscore JS
http://underscorejs.org/
https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.7.0/underscore-min.js
D3 JS
http://d3js.org/
https://github.com/mbostock/d3/wiki/CSV
https://cdnjs.cloudflare.com/ajax/libs/d3/3.4.13/d3.min.js
Underscore and DatesJS are used by QuickBase and can be drawn from URLs to their CDN, but drawing the libraries from their CDN will force you to occassionally edit the URLS a the version number is built into the URL.
I will come back to your question later in the week. Or perhaps we could devise a scheme where we break your question up into dozens of smaller questions so I can earn more points.
Accounting JS
http://openexchangerates.github.io/accounting.js/
https://cdnjs.cloudflare.com/ajax/libs/accounting.js/0.4.1/accounting.min.js
Date JS
http://www.datejs.com/
https://cdnjs.cloudflare.com/ajax/libs/datejs/1.0/date.min.js
Underscore JS
http://underscorejs.org/
https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.7.0/underscore-min.js
D3 JS
http://d3js.org/
https://github.com/mbostock/d3/wiki/CSV
https://cdnjs.cloudflare.com/ajax/libs/d3/3.4.13/d3.min.js
Underscore and DatesJS are used by QuickBase and can be drawn from URLs to their CDN, but drawing the libraries from their CDN will force you to occassionally edit the URLS a the version number is built into the URL.
I will come back to your question later in the week. Or perhaps we could devise a scheme where we break your question up into dozens of smaller questions so I can earn more points.