Parse data from uploaded CSV files into fields
Requirement
When users upload CSV files, their data is parsed and the values are inserted into the required fields of another form.
Use case
An order management app contains two forms, one to store purchased product details, and the other to store purchase list as CSV files. When a
n admin uploads a purchase list file in
the Upload Purchase List
form, its data will be parsed and inserted into the respective fields of
Products
form.
Steps to follow
|
Form
|
Form Link Name
|
Field Type
|
Field Name
|
Field Link Name
|
|
Upload purchase list
|
Upload_purchase_list
|
File Upload
|
Purchase List
|
Purchase_List
|
|
Products
|
Products
|
Single Line
|
Product Name
|
Product_Name
|
|
Single Line
|
Unit Of Measure
|
Unit_Of_Measure
|
||
|
Number
|
Quantity
|
Quantity
|
||
|
Currency
|
Selling Price
|
Selling_Price
|
The workflow is to be triggered when
Upload purchase list
form is successfully submitted,
so
we are selecting the
Form Event
as "Successful form submission".
3. Save the following Deluge script in the Deluge editor:
- //Extract the content from the uploaded input file and store in the variable fileContent as text
- fileContent = input.Purchase_List.content;
- // Parse the file content so the rowsList variable is structured such that each of its element is a text that corresponds to a row of the input CSV file
- rowsList = fileContent.tolist("\n");
- // Define a counter to keep track of the iteration
- count = 0;
- // Iterate through the rowsList to parse the elements of each row.
- for each rl in rowsList
- {
- if(count > 0)
- {
- // Split elements of the row and convert into a list
- elementsList = rl.tolist(",");
- // Add record into the Products form
- response = insert into Products
- [
- Added_User = zoho.loginuser
- Product_Name = elementsList.get(2)
- Unit_Of_Measure = elementsList.get(3)
- Quantity = elementsList.get(4)
- Selling_Price = elementsList.get(3)
- ];
- }
- // Increment the counter at the end of each iteration
- count = count + 1;
- }
See how it works
Points to note
-
The Deluge script provided in this tutorial is specific to the CSV files whose rows are separated with new lines and the first row contains header of the columns, which are in the order of Product Name, Unit Of Measure, Quantity, and Selling Price. Using this script for a CSV file of different format may not work as expected.
Please check the attachments for the sample file on which the provided Deluge script works.
-
This tutorial works best on files that usually contain only text values ( for example, .txt or .csv ).
Related links
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Add data to a different application
Requirement Automatically add a record to a form of one application when a record is added in a different application. Use Case A Zoho creator account has two applications: Contact Management and Order Management. All the customer details maintained ...Understanding emailing data to form
This feature is currently supported only in the .com (US data center) and .eu (EU data center). A form is the component of your app (that you’ve built using Zoho Creator), through which your users can submit data. In addition to the default method of ...Extract contents of a ZIP file and email the extracted files
Requirement Use Deluge to extract a ZIP file and email the extracted files with the click of a button. Use Case An HR management application contains three forms: Add Employee, Employee Payslips, and Download My Payslips. The Add Employee form ...Check for the type of the file uploaded
Requirement Only allow the file upload field to accept file types PDF, XLS, or XLXS. Display an alert message when any other file type is detected. Use case A restaurant app contains a form to store supplier receipts as files. When an admin uploads a ...Add subform rows with dynamic data from another subform
Requirement Automatically add rows to a subform and populate it with dynamic data fetched from another subform. Use Case A form named Orders Database contains customer details and their frequent orders in a subform. We have another ...
New to Zoho LandingPage?
Zoho LandingPage Resources