Getting error while implementing the Export to Excel in VC

[Former Member]

Hi

By refering the following link, i have implemented Export To Excell functionality in VC.

When i copied the following formula in the respective formula window, then it is giving the following error. can any body awareof what is the problem.

copied formula :

"pcd!3aportal_content!2fcom.sap.pct!2fplatform_a

dd_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.b

ex?QUERY=" & STORE@REPTNAME &

"&BI_COMMAND_1-

BI_COMMAND_TYPE=EXPORT&BI_COMMAND

1-EXPORTFORMAT=XLS&BI_COMMAND_1-

null="

Occurred Error:

Field "REPTNAME" does not exist in DataStore parameters.

Referred link to implement

2) Another one that's in the Visual Composer WIKI:

https://wiki.sdn.sap.com/wiki/display/VC/Exportingdatafrom+VC

Regards

Vijay

[ankur_garg5 · Accepted solution]

Hi Vishal,

According to page no 8 on this doc:

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/47fe4fef-0d01-0010-6f87-ed8ecb479123">https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/47fe4fef-0d01-0010-6f87-ed8ecb479123</a>

where it asks to add a field "REPTNAME" to the data store, and then map that field to the output from the BI query, have you used the same BI query which is used in the doc? I think that is important, because if the BI query is different, then there wouldn't be any output named REPTNAME. Just check everything once, if you are using the same BI query.

Bye

Ankur

[Former Member · Accepted solution]

Hi Anukur,

Thanks for the reply,

I have copied same formula which is given in that doc. now i have added one field

REPTNAME. Now i have come from that problem. Formula showin as valid. when i click on check button.

Now when i compile , i havnt got any any but when click on deploy i am getting the following error.

Error in compiling Flex application: Error 1002: String literal was not properly terminated

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:265)

Error 1033: ')' expected

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:266)

Error 1205: The statement 'dd_ons' is incomplete.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:266)

Error 1025: Left side of assignment operator must be variable or property.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:268)

Error 1033: ':' expected

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:269)

Error 1025: Left side of assignment operator must be variable or property.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:270)

Error 1033: ';' expected

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:271)

Error 1205: The statement '' is incomplete.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:269)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:271)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:272)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:273)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:281)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:293)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:298)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:299)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:301)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:323)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:336)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:337)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:338)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:340)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:347)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:370)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:393)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:425)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:470)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:479)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:489)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:509)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:521)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:535)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:543)

Error 1128: Attribute used outside class.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:559)

Error 1030: Statement block must be terminated by '}'

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:19)

Error 1000: Syntax error.

(D:\usr\sap\EPD\JC01\j2ee\cluster\server0\GUIMachine_Business_Packages\NewTestModel_28609\FLEX_COMPILATION_FOLEDR\AADMV.mxml:570)

Failed to compile AADMV.mxml

Can u tell what is the problem here

Regards

Vijay

[ankur_garg5 · Accepted solution]

Hi Vishal,

Can you tell me which BI query or Bapi you are using?

Bye

Ankur

[Former Member · Accepted solution]

Hi Ankur,

I am using the RFC in R3. I didnt understand what is the BI query. Please can u elabrate your question

Regards

Vijya

[Former Member · Accepted solution]

The code from the PDF file contains page breaks. Copy paste the code in Notepad, disable Wordwrap and place all the code into a single line by removing the pagebreaks. Copy-paste the single line into your VC model.

[Former Member]

Hi Vishal, as you can write from this document

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/47fe4fef-0d01-0010-6f87-ed8ecb47...

the export data works only for BI query.

Regards

Gianfranco