Got CSV To Import?
I wanted to show you a simple way to read a CSV file and process it before sending it to QuickBase. Normally when a file input control is on a form you select a file from the local file system and th...
Forum Discussion
I have no experience in programming, but using the cut a paste technique (JavaScript, jquery etc.) with success, cause I do understand the logic.
I have learned a lot with your answers Daniel, and implemented most of your techniques (IOL , getscript and so). Thanks a lot on advance.
I do spend lot of time with language syntax cause sometimes things �obvious for the profs, are not so obvious for the newbies.
Automating Importing CSV files (or tab delimited) was something my process needed.
I have successfully implemented the lines of code in this thread and are working.
My dream is to be able to manipulate the CSV JavaScript object prior to importing to match my table. (before creating the csv_blob)
Starting with two features
1.-MY csv file has to columns
[Date]: YYYYMMDD, which I want to format DDMMYYYY
[Value]: xxxxxx.yy, which I want to format xxx.xxx,yy
2. - Want to create a new column in the object, so as to create a Unique Record, previous to importing, thus reducing the possibility of duplicating entries.
{New column] concatenating [NAME+Date+Value]. This creates a unique record in my configuration.
My idea is to include the code where you say �your code comes here�
Could you help me or assist me where to find something simple.
I have learned a lot with your answers Daniel, and implemented most of your techniques (IOL , getscript and so). Thanks a lot on advance.
I do spend lot of time with language syntax cause sometimes things �obvious for the profs, are not so obvious for the newbies.
Automating Importing CSV files (or tab delimited) was something my process needed.
I have successfully implemented the lines of code in this thread and are working.
My dream is to be able to manipulate the CSV JavaScript object prior to importing to match my table. (before creating the csv_blob)
Starting with two features
1.-MY csv file has to columns
[Date]: YYYYMMDD, which I want to format DDMMYYYY
[Value]: xxxxxx.yy, which I want to format xxx.xxx,yy
2. - Want to create a new column in the object, so as to create a Unique Record, previous to importing, thus reducing the possibility of duplicating entries.
{New column] concatenating [NAME+Date+Value]. This creates a unique record in my configuration.
My idea is to include the code where you say �your code comes here�
Could you help me or assist me where to find something simple.