Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
20 replies
Answers
4 answers
Subscribers
9 subscribers
Views
18715 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Bulk Upload of Data into Appian DB(Dealing with Lakhs of Records)
harshav
over 7 years ago
Hi All,
I would be getting data from External system in an Excel sheet where I need to insert all the data into Appian DB
OriginalPostID-231862
Discussion posts and replies are publicly visible
Top Replies
brettf
over 7 years ago
+1
To tag onto colton's post above, I would recommend using an external tool to generate the SQL insert statements. The website sqlizer.io can take in an excel file and generate the code, as long as the excel…
Parents
0
Alok Patro
over 6 years ago
Use the Appian DB import feature to import the data from excel to a table if the data structure in excel is in par with the table.
It makes your job quick, a lot easier and would not impact appian performance.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel
0
rp_balaji
A Score Level 1
over 6 years ago
in reply to
Alok Patro
Hi Alok,
Thanks for your response, I agree with your point of using the DB import feature which is available but if in case there is a requirement of providing a user interface to the end user and the user may upload excel sheet with data around 10K to 20K rows then do we have any effective way of handling this in Appian or the existing excel smart service can handle this wisely?
Regards,
Balaji.R
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
rp_balaji
A Score Level 1
over 6 years ago
in reply to
Alok Patro
Hi Alok,
Thanks for your response, I agree with your point of using the DB import feature which is available but if in case there is a requirement of providing a user interface to the end user and the user may upload excel sheet with data around 10K to 20K rows then do we have any effective way of handling this in Appian or the existing excel smart service can handle this wisely?
Regards,
Balaji.R
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data