Hi When I am creating cell keys and cell values and adding in Export to exc

siddharthg521 over 11 years ago

Hi
When I am creating cell keys and cell values and adding in Export to excel smart service it works fine if the keys are till Z. However after that when key reaches AA, then it works incorrect. I mean , if the key is "AA1", then the data is rendred in the cell "A1" in excel instead of "AA1". Similarly if the key is "BB1", the data is getting populated in cell "B1". Why is this happening? Any special reason which I am missing out.

Thanks in advance...

Discussion posts and replies are publicly visible

0 Sathya Srinivasan
Appian Employee
over 11 years ago

Thanks for bringing this up Siddharth. I'll look into this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 siddharthg521 over 11 years ago

@Sathya: Sure. Just to inform you we have older version of Export to Excel Smart service deployed in our org.

Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sathya Srinivasan
Appian Employee
over 11 years ago

Updated the code to address this issue. Please download the latest version.
@Siddharth, I have done the change to V2 as this version contains additional bug fixes from the older version. I suggest you plan migrating to the newer version.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 siddharthg521 over 11 years ago

@sathya:I am using export to excel which is cloud compatible(my org is cloud compatible). However the smart service V2 is not cloud compatible as I could see in shared components. Can you please provide more insight on this.
Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sathya Srinivasan
Appian Employee
over 11 years ago

V2 is also cloud compatible. Since I uploaded the new version just a few minutes before, it needs to be reviewed by the cloud community team in Appian before showing up as cloud compatible. This should happen very soon.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 siddharthg521 over 11 years ago

@sathya: Hey just to confirm, weather this smart service will work fine only for Appian 7.0 or later versions? We are currently working on 6.7.1 version. Will it work fine for 6.7.1 too?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sathya Srinivasan
Appian Employee
over 11 years ago

This will work on 7.x and 6.7.1
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 siddharthg521 over 11 years ago

@sathya: Thanks for the update. There is actually two smart services mentioned under plugin named 'Export SQL and Report Data to EXCEL - V2 ' in Shared components.
1) Export SQL to Excel Usage: 2) Export to Excel Usage (Report):. However, we will be needing the second one and NOT the SQL one.
So in order to do the same, shall I ask the support team to deploy the plug in named 'Export SQL and Report Data to EXCEL - V2 ' or specefically 'Export to Excel Usage (Report)'. or is that on deploying the plugin 'Export SQL and Report Data to EXCEL - V2 ', both the smart services under this will both be deployed in the org?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sathya Srinivasan
Appian Employee
over 11 years ago

The plugin contains two smart services. One to export report data to excel and another to export SQL data into excel. You need 'V2' as this is the latest version.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sushilk307 over 11 years ago

Helo.. I am new to this Service. I am trying Export to Excel Smart Service. I have all data in CDT. Can you please let me know how to configure data in Smart Service. I also Want to add Column name?... Please let me know other suitable way to do the same....?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel