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
Hi Dan, Apologies for raising it in the same thread as it is related to the same example which i was trying. it works good, but i have 2 small queries , which i have no clue how to handle.
1)- How can I encode the columns as in some cases, the data contains special characters. Since my data has text columns with special characters, my data gets split and goes in multiple columns rather than the column i intend to. is there a encode or escape character i can use ?
2)- How can i import user email address into user fields. As of my know my feed has a user column which has user's email address, which i thought will automatically assign to the user field. I presumed this from my experience on using Quickbase API _AddRecord which automatically assigns to user based on the email address, but somehow this is not happening ?
Thanks a lot.
dinesh
1)- How can I encode the columns as in some cases, the data contains special characters. Since my data has text columns with special characters, my data gets split and goes in multiple columns rather than the column i intend to. is there a encode or escape character i can use ?
2)- How can i import user email address into user fields. As of my know my feed has a user column which has user's email address, which i thought will automatically assign to the user field. I presumed this from my experience on using Quickbase API _AddRecord which automatically assigns to user based on the email address, but somehow this is not happening ?
Thanks a lot.
dinesh