Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Empty Excel file , after changing the view name #47

Open
NouhaGHA opened this issue May 10, 2020 · 5 comments
Open

Empty Excel file , after changing the view name #47

NouhaGHA opened this issue May 10, 2020 · 5 comments

Comments

@NouhaGHA
Copy link

Hi,
I'm working with POI for a while , i've changed the view name used as a resource, and the Excel report now is generated blank with empty clns, even when i put back the old configurations from a backup data base, i still have the same problem. i've verified the clns and the view names 20 times, is there any thing that i should do ?
Thanks

@guedeWebGate
Copy link
Member

Can you pleases share you XPages Code / the version of POI4XPages. Btw. does the view contains data to export for the given user?

@NouhaGHA
Copy link
Author

Of course , im working Domino 9.0.1 FP8
POI 1.2.6.201312211419
Of course the view contains data ,
Actualy, my code was working fine , when i changed the view's name , nothing is working again

<xp:view xmlns:xp="http://www.ibm.com/xsp/core"
xmlns:wgpoi="http://www.webgate.biz/xsp/poi">
xp:br</xp:br>
<wgpoi:spreadsheet id="shContacts"
downloadFileName="listeCongés.xlsx">
wgpoi:this.templateSource
<wgpoi:resourcetemplate fileName="Book1.xlsx">
</wgpoi:resourcetemplate>
</wgpoi:this.templateSource>
wgpoi:this.spreadsheets
<wgpoi:table name="Congés" create="false">

			<wgpoi:this.exportDefinitions>
				<wgpoi:data2rowExport stepSize="1" var="row"
					index="index" startRow="2">
					<wgpoi:this.dataSource>
						<wgpoi:dominoViewSource
							viewName="EtatContact">
						</wgpoi:dominoViewSource>
					</wgpoi:this.dataSource>
					<wgpoi:this.columns>
						<wgpoi:columnDefinition columnNumber="0"
							columnTitle="Name" rowShift="0">



							<wgpoi:this.cellStyle>
								<wgpoi:cellStyle
									alignment="ALIGN_LEFT">
								</wgpoi:cellStyle>
							</wgpoi:this.cellStyle>
						</wgpoi:columnDefinition>
						<wgpoi:columnDefinition columnNumber="1"
							columnTitle="startDate" rowShift="0">
						</wgpoi:columnDefinition>
						<wgpoi:columnDefinition columnNumber="2"
							columnTitle="EndDate" rowShift="0">
						</wgpoi:columnDefinition>
						<wgpoi:columnDefinition columnNumber="3"
							columnTitle="Period" rowShift="0">
						</wgpoi:columnDefinition>
						<wgpoi:columnDefinition columnNumber="4"
							columnTitle="Motif" rowShift="0">
						</wgpoi:columnDefinition>


					</wgpoi:this.columns>
				</wgpoi:data2rowExport>
			</wgpoi:this.exportDefinitions>
		</wgpoi:table>
	</wgpoi:this.spreadsheets>
</wgpoi:spreadsheet>
<xp:br></xp:br>
<xp:button value="Générer Rapport des congés" id="button1"><xp:eventHandler event="onclick" submit="true" refreshMode="complete">
<xp:this.action>
	<wgpoi:generateWorkbook workbookId="shContacts"></wgpoi:generateWorkbook>
</xp:this.action></xp:eventHandler></xp:button></xp:view>

Regards,

@guedeWebGate
Copy link
Member

Was your code changed bevor you did go to FP8? I had the same issue, with 1.2.6 and FP8. The Designer was no longer capable to compile the XPages correctly. Can try it with POI4XPages 1.3.1. You have to update Designer and Server

@NouhaGHA
Copy link
Author

Non, i didn't change the domino version, it is the same from the beginning , I appreciate your help i will download it and keep you in touch

@NouhaGHA
Copy link
Author

Hi, sorry for taking so long to give you my feedback, i've downloaded the 1.3.1 version from the following link :
https://www.openntf.org/main.nsf/project.xsp?r=project/POI%204%20XPages/releases/E80C4FC9FB07E1E4852580E3006E02C7

But the library was empty , when i integrated the library to the updatesite base,it was empty , any idea ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants