Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
2 replies
Subscribers
5 subscribers
Views
3438 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
We need to generate a pipe delimited text file from data available in My SQL. We
harishn
over 10 years ago
We need to generate a pipe delimited text file from data available in My SQL. We are trying the following solutions: Have a view in MySQL, query data to process in Appian, use generate file from template doc smart service to generate file. Total Data is around 4MB as of now. The query fails if we query more than 500 records otherwise this solution works.
1. Can I append to a text file? If yes, then we can create a loop based process to query and append to the text file.
2. Do we have an option (like smart service) similar to Database Table to CSV. As I found this service works fine with 4MB of data. As we have pipes (|) in our views, the DB Table to CSV creates a file having " " to the data in single column we have in the view. Alternatevly is it possible to remove the char - ".
We are open to other possible solution. Thanks in advance for your help....
OriginalPostID-92429
OriginalPostID-92429
Discussion posts and replies are publicly visible
Parents
0
harishn
over 10 years ago
Does CDTs have a limit in size apart from System Memory size? ie. would it be able to hold 4MB of data?
Also we cannot use excel output. We need a text/csv output.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
harishn
over 10 years ago
Does CDTs have a limit in size apart from System Memory size? ie. would it be able to hold 4MB of data?
Also we cannot use excel output. We need a text/csv output.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data