I'm using Download DataSubset plugin and I'm trying to follow the exampl

guozhangy over 9 years ago

I'm using Download DataSubset plugin and I'm trying to follow the example from forum.appian.com/.../Download_DataSubset_Plugin.html
I'm using this plugin from Tempo Reports SAIL,
First, I have a Query Rule, getAllEmployees, which returns all Records from Emplyee CDT.
Then, I create an Export Rule (exact the same as the example): exportAllEmployees: =type!ExportableDataSubset(
datasubset: rule!getAllEmployees(topaginginfo(startIndex: 1, batchSize: -1)),
fieldNames: {"NAME"},
fieldLabels: {"NAME"},
filename: "employee"
)
when I test this rule directly from Rule Designer, it returns a lots of records.

Then I create a link:

with(
local!exportUri: getdatasubsetdownloadlinkfromrule(rule: rule!exportAllEmployees),
...........
a!dashboardLayout(
if(isNull(local!exportUri),
{},
a!linkField(
links: {
a!safeLink(
label: "Click Here to Export This Data to Excel",
uri: local!exportUri
...

Discussion posts and replies are publicly visible

0 guozhangy over 9 years ago

... )
}
)
),

The SAIL Report shows but the link to EXCEL is never showing and I checked the sysout file from Websphere and there is no error, so what might go wrong? Please help. Thank you in advance.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tim
Certified Lead Developer
over 9 years ago

Is this the exact code? If so you are missing attribute labels in your a!dashboardLayout, add the "firstcolumncontents{}" identifier, without it no fields will render.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 guozhangy over 9 years ago

Thanks, Tim. I have all those. The link field is inside firstColumnContents, and there is a gridfield after the link. I just posted the essential one to save the space. In fact, the grid is displayed successfully, just the link is not showing up. I don't know what's wrong. I don't have any input for getdatasubsetdownloadlinkfromrule, will this cause problem. Also it seems getdatasubsetdownloadlinkfromrule generate an Excel file as an Appian document, does anyone know which Appian KC or Folder will this document get stored? Maybe the access issue to this Appian KC/Folder?

Thanks.

Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tim
Certified Lead Developer
over 9 years ago

The documentation states that your rule must include a parameter called "input" and that when calling the plugin rule you must pass a value of type text as the 2nd parameter. Your code doesn't look like it does this...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tim
Certified Lead Developer
over 9 years ago

So where you're calling the rule is fine but I think your getAllEmployees rule still needs to have the input parameter even if it's not used. That's my experience with the cloud version and it's process model
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 guozhangy over 9 years ago

I tried the input parameter (input: "") and it's not helping :(
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandhinir over 9 years ago

Hi,
Just to confirm about the field name used in the Export Rule.Did you use the column name specified in the CDT or is it any other text?
You should use the element name specified in the CDT for the fieldNames attribute.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 guozhangy over 9 years ago

chandhinir :
I double/triple checked and the value in fieldNames is the column name in CDT and the case also matches. I also tried lower case/upper case and I still can't get the link. Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandhinir over 9 years ago

Hi Guozhangy,
I was able to export the data.Please find the attached code ad let me know if you have any questions
exportToExcel_code.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 guozhangy over 9 years ago

I tried and it's not working. I'm not sure it's somehow related to the version or not.

So I downloaded the jar file and trying to compile it, and I get this error: The type com.appiancorp.process.expression.ServiceMatch cannot be resolved. It is indirectly referenced from required .class files.

Also I don't know why the systemOut file has no output from this plugin, even though the log4j properties file has an entry for com.appiancorp.ps.plugins
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel