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
10 replies
Subscribers
5 subscribers
Views
3102 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Hi all, I'm using Export CDT To Excel smart service. Let
Mihai-Octavian Tudose
Certified Lead Developer
over 8 years ago
Hi all,
I'm using Export CDT To Excel smart service.
Let's say my demo cdt has 10 fields, and I want to export first two fields and last two fields, if I set the node input Cdt_fields_to_export to ={"field1","field2","field9","field10"} in the excel I will find always the first four fields from 1 to 4, same if I try to change the order,
It seems to me that it will always export to excel sheet a number of fields equal to the no. of elements in that text array starting from the first field.
See the snipe from the documentation provided with the plug-in. My goal is to export a number of fields that I desire and in a order I prefer to avoid loading the project with another CDT just for this node.
Many thanks!
OriginalPostID-198163
OriginalPostID-198163
Discussion posts and replies are publicly visible
Parents
0
sikhivahans
over 8 years ago
@mihaioctaviant Just to confirm from a custom ordering and data types perspective, we have 22 fields in the CDT out of which many of them are Text and few are Number Integer. And as of now we are using 17 fields as of now in the 'Cdt_fields_to_export' attribute and that too in a entirely different order from the order, the CDT maintains. We have been using the smart service for more than one and a half year and neither there is a single issue till date in the data being exported (the plugin is also tested to work on huge datasets) nor with the configurations. Further I also remember that the plugin worked well when there are fields of type Boolean in the CDT. And I have to say that all the fields in the CDT are single and there aren't any nested CDTs, that is, the CDT is flat.
What I have noticed in my implementation is, if there are any fields of type multiple or nested CDTs in the main CDT, the plugin doesn't work in a desired manner. So I have gone for creation of a formatted CDT which is flat (no nested CDTs) and only contains fields of single type.
It might be worth focusing on the other configurations in the smart service and the structure of the CDT as well.
It might seem like a weird thought - but is there a chance of any influence on the working of smart service because of the number in the name of CDT fields?
Hope the above information will be of some use to you and we have extensively implemented the same smart service in one of our projects and I would be happy to contribute just in case if you come back with questions.
As said by other practitioner, it hasn't got to do anything with the template (such as n column based) and your understanding re the same is correct.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 8 years ago
@mihaioctaviant Just to confirm from a custom ordering and data types perspective, we have 22 fields in the CDT out of which many of them are Text and few are Number Integer. And as of now we are using 17 fields as of now in the 'Cdt_fields_to_export' attribute and that too in a entirely different order from the order, the CDT maintains. We have been using the smart service for more than one and a half year and neither there is a single issue till date in the data being exported (the plugin is also tested to work on huge datasets) nor with the configurations. Further I also remember that the plugin worked well when there are fields of type Boolean in the CDT. And I have to say that all the fields in the CDT are single and there aren't any nested CDTs, that is, the CDT is flat.
What I have noticed in my implementation is, if there are any fields of type multiple or nested CDTs in the main CDT, the plugin doesn't work in a desired manner. So I have gone for creation of a formatted CDT which is flat (no nested CDTs) and only contains fields of single type.
It might be worth focusing on the other configurations in the smart service and the structure of the CDT as well.
It might seem like a weird thought - but is there a chance of any influence on the working of smart service because of the number in the name of CDT fields?
Hope the above information will be of some use to you and we have extensively implemented the same smart service in one of our projects and I would be happy to contribute just in case if you come back with questions.
As said by other practitioner, it hasn't got to do anything with the template (such as n column based) and your understanding re the same is correct.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data