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:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
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
Limitations: Forms and Fields
To know more about forms, click here General The maximum size allowed for a multi-line and rich text field in a row is approximately 64 KB. Multi-column layouts are not supported in forms if the check-box/radio-button fields are added dynamically ...Import data to reports
Zoho Creator allows you to import data from into the reports in your Creator application. Creator supports importing data from .xls, .xlsx, .xlsm, .csv, .tsv, .ods, .accdb, .mdb, .json and numbers file formats. The required file can either be stored ...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 ...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 ...Export data from reports
Note: To optimize efficiency and security, support for XLS format has been deprecated, and instead, the XLSX format will be supported with effect from 21-March-2024. We insist you to replace any instance of .xls to .xlsx across Deluge scripts in your ...
New to Zoho LandingPage?
Zoho LandingPage Resources