Excel Exporter java error after upgrade
1
Hello, I have updated my application from version 8.18.24 to 9.12.5 and after upgradile my Mendix Excel Exporter module i am receiving the following error. Buildfile: M:\Mendix\Phoenix Ralph-202306 - Upgrade9\deployment\build_core.xml compile: [javac] Compiling 677 source files to M:\Mendix\Phoenix Ralph-202306 - Upgrade9\deployment\run\bin [javac] Note: Processing Log4j annotations [javac] Note: Annotations processed [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\actions\GenerateExcelDoc.java:22: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxCellStyle; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\actions\GenerateExcelDoc.java:23: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxColumn; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\actions\GenerateExcelDoc.java:24: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxData; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\actions\GenerateExcelDoc.java:25: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxSheet; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\actions\GenerateExcelDoc.java:167: error: cannot find symbol [javac] private boolean checkValidColumn(MxColumn mxColumn) throws CoreException [javac] ^ [javac] symbol: class MxColumn [javac] location: class GenerateExcelDoc [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\Export.java:6: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxSheet; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\Export.java:7: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxTemplate; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\Export.java:27: error: cannot find symbol [javac] abstract public void buildExportFile(MxSheet mxSheet, List<ColumnPreset> mxColumnList, Object[][] Table) throws Exception; [javac] ^ [javac] symbol: class MxSheet [javac] location: class Export [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:9: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.AggregateFunction; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:10: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxXPath; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\Export.java:31: error: cannot find symbol [javac] public static String getDatePresentation(MxTemplate template) [javac] ^ [javac] symbol: class MxTemplate [javac] location: class Export [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:18: error: cannot find symbol [javac] private MxXPath firstPath; [javac] ^ [javac] symbol: class MxXPath [javac] location: class ColumnPreset [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:22: error: cannot find symbol [javac] private AggregateFunction dataAggrFunction; [javac] ^ [javac] symbol: class AggregateFunction [javac] location: class ColumnPreset [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:24: error: cannot find symbol [javac] private AggregateFunction resultAggrFunction; [javac] ^ [javac] symbol: class AggregateFunction [javac] location: class ColumnPreset [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:36: error: cannot find symbol [javac] public ColumnPreset(String name, int columnNr, MxXPath firstPath, long styleGuid) [javac] ^ [javac] symbol: class MxXPath [javac] location: class ColumnPreset [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:50: error: cannot find symbol [javac] public ColumnPreset(String name, int columnNr, MxXPath firstPath) [javac] ^ [javac] symbol: class MxXPath [javac] location: class ColumnPreset [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:57: error: cannot find symbol [javac] public void addDataAggregation(AggregateFunction aggrFunction) [javac] ^ [javac] symbol: class AggregateFunction [javac] location: class ColumnPreset [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:68: error: cannot find symbol [javac] public AggregateFunction getDataAggrFunction() [javac] ^ [javac] symbol: class AggregateFunction [javac] location: class ColumnPreset [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:77: error: cannot find symbol [javac] public void addResultAggregation(AggregateFunction aggrFunction) [javac] ^ [javac] symbol: class AggregateFunction [javac] location: class ColumnPreset [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\ColumnPreset.java:149: error: cannot find symbol [javac] public MxXPath getFirstPath() [javac] ^ [javac] symbol: class MxXPath [javac] location: class ColumnPreset [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Aggregator.java:12: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxColumn; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Aggregator.java:13: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxStatic; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Aggregator.java:23: error: cannot find symbol [javac] private HashMap<Integer, MxStatic> positions; [javac] ^ [javac] symbol: class MxStatic [javac] location: class Aggregator [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Aggregator.java:31: error: cannot find symbol [javac] public void addColumn(int index, MxColumn column, MxStatic mxStatic) [javac] ^ [javac] symbol: class MxColumn [javac] location: class Aggregator [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Aggregator.java:31: error: cannot find symbol [javac] public void addColumn(int index, MxColumn column, MxStatic mxStatic) [javac] ^ [javac] symbol: class MxStatic [javac] location: class Aggregator [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Aggregator.java:37: error: cannot find symbol [javac] public boolean addValue(int index, double value, MxColumn column) [javac] ^ [javac] symbol: class MxColumn [javac] location: class Aggregator [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Aggregator.java:58: error: cannot find symbol [javac] public MxStatic getColumnPlace(int index) [javac] ^ [javac] symbol: class MxStatic [javac] location: class Aggregator [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\AttributeData.java:3: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.AggregateFunction; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\DataOQL.java:56: error: cannot find symbol [javac] public DataOQL(IContext context, MxTemplate template) throws CoreException [javac] ^ [javac] symbol: class MxTemplate [javac] location: class DataOQL [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\DataOQL.java:74: error: cannot find symbol [javac] public Object[][] getRowData(MxSheet mxSheet, IMendixObject inputObject, List<ColumnPreset> mxColumnList) throws CoreException [javac] ^ [javac] symbol: class MxSheet [javac] location: class DataOQL [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\DataOQL.java:100: error: cannot find symbol [javac] private String createOQLQuery(MxSheet mxSheet, IMendixObject inputObject, List<ColumnPreset> mxColumnLists) throws CoreException [javac] ^ [javac] symbol: class MxSheet [javac] location: class DataOQL [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\DataOQL.java:356: error: cannot find symbol [javac] private String addWhereValue(MxConstraint constraint) throws CoreException [javac] ^ [javac] symbol: class MxConstraint [javac] location: class DataOQL [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\DataOQL.java:389: error: cannot find symbol [javac] private void addAttribute(MxXPath attributePath, ObjectData objectData, ColumnPreset column) throws CoreException [javac] ^ [javac] symbol: class MxXPath [javac] location: class DataOQL [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\DataOQL.java:448: error: cannot find symbol [javac] private ObjectData getObject(MxXPath path, ObjectData fromObjectData) throws CoreException [javac] ^ [javac] symbol: class MxXPath [javac] location: class DataOQL [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\DataOQL.java:511: error: cannot find symbol [javac] private void addObject(MxXPath path, ObjectData fromObjectData, ColumnPreset column) throws CoreException [javac] ^ [javac] symbol: class MxXPath [javac] location: class DataOQL [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\DataOQL.java:617: error: cannot find symbol [javac] private void createOrder(MxSheet mxSheet, ObjectData mainObject) throws CoreException [javac] ^ [javac] symbol: class MxSheet [javac] location: class DataOQL [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\DataOQL.java:677: error: cannot find symbol [javac] private HashMap<String, String> getReferenceHandling(MxSheet sheet) throws CoreException [javac] ^ [javac] symbol: class MxSheet [javac] location: class DataOQL [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\AttributeData.java:11: error: cannot find symbol [javac] private AggregateFunction function; [javac] ^ [javac] symbol: class AggregateFunction [javac] location: class AttributeData [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\AttributeData.java:50: error: cannot find symbol [javac] public AggregateFunction getFunction() [javac] ^ [javac] symbol: class AggregateFunction [javac] location: class AttributeData [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\data\AttributeData.java:55: error: cannot find symbol [javac] public void setFunction(AggregateFunction function) [javac] ^ [javac] symbol: class AggregateFunction [javac] location: class AttributeData [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\DataOQL.java:19: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.*; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Styling.java:34: error: cannot find symbol [javac] public Styling(MxTemplate template) [javac] ^ [javac] symbol: class MxTemplate [javac] location: class Styling [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Styling.java:73: error: cannot find symbol [javac] public void setAllStyles(IContext context, MxTemplate TemplateObject, Workbook book) throws CoreException [javac] ^ [javac] symbol: class MxTemplate [javac] location: class Styling [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Styling.java:103: error: cannot find symbol [javac] public CellStyle createCellStyle(MxCellStyle MxStyle, Workbook book, boolean dateTimeFormat) [javac] ^ [javac] symbol: class MxCellStyle [javac] location: class Styling [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Styling.java:176: error: cannot find symbol [javac] private static short getColor(MxColor color) [javac] ^ [javac] symbol: class MxColor [javac] location: class Styling [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Styling.java:213: error: cannot find symbol [javac] private static HorizontalAlignment getAlignment(TextAlignment align) [javac] ^ [javac] symbol: class TextAlignment [javac] location: class Styling [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Styling.java:230: error: cannot find symbol [javac] private static VerticalAlignment getVerticalAlignment(TextVerticalAlignment align) [javac] ^ [javac] symbol: class TextVerticalAlignment [javac] location: class Styling [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\Styling.java:14: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.*; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportCSV.java:12: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxSheet; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportCSV.java:13: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxTemplate; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportCSV.java:30: error: cannot find symbol [javac] public ExportCSV(IContext context, MxTemplate template, IMendixObject inputObject) [javac] ^ [javac] symbol: class MxTemplate [javac] location: class ExportCSV [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportCSV.java:58: error: cannot find symbol [javac] public void buildExportFile(MxSheet mxSheet, List<ColumnPreset> mxColumnList, Object[][] table) throws Exception [javac] ^ [javac] symbol: class MxSheet [javac] location: class ExportCSV [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:20: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.CustomExcel; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:21: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxColumn; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:22: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxColumnSettings; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:23: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxData; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:24: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxRowSettings; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:25: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxSheet; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:26: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxStatic; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:27: error: package xlsreport.proxies does not exist [javac] import xlsreport.proxies.MxTemplate; [javac] ^ [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:45: error: cannot find symbol [javac] public ExportExcel(IContext context, MxTemplate template, IMendixObject inputObject) throws CoreException, IOException [javac] ^ [javac] symbol: class MxTemplate [javac] location: class ExportExcel [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:86: error: cannot find symbol [javac] public void buildExportFile(MxSheet mxSheet, List<ColumnPreset> ColumnPresetList, Object[][] table) throws CoreException [javac] ^ [javac] symbol: class MxSheet [javac] location: class ExportExcel [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:216: error: cannot find symbol [javac] private void processSheetPreferences(MxSheet mxSheet, Sheet sheet) throws CoreException [javac] ^ [javac] symbol: class MxSheet [javac] location: class ExportExcel [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:250: error: cannot find symbol [javac] private Row getRow(Sheet sheet, int index, MxSheet mxSheet) [javac] ^ [javac] symbol: class MxSheet [javac] location: class ExportExcel [javac] M:\Mendix\Phoenix Ralph-202306 - Upgrade9\javasource\xlsreport_modified\report\export\ExportExcel.java:267: error: cannot find symbol [javac] private Cell getCell(Row row, int index, MxData data) throws CoreException [javac] ^ [javac] symbol: class MxData [javac] location: class ExportExcel [javac] Note: Processing Log4j annotations [javac] Note: No elements to process [javac] 65 errors BUILD FAILED M:\Mendix\Phoenix Ralph-202306 - Upgrade9\deployment\build_core.xml:30: Compile failed; see the compiler error output for details. Total time: 29 seconds Can anyone advise?
asked
Talhah Perager
4 answers
0
Hi Talhah,
Could it be that you updated the module or that you have other marketplace modules within you application. Because it can be that the libraries conflict with eachother or are actually missing:
First steps to do:
1. check your userlibs for having two of the same userlibs
2. create a separate project where you only download the specific marketplace module, try to run the project and check these userlibs and compare them with your userlibs is there missing anything try to add it.
I anwered this text from to a similar kind of problem:
https://forum.mendix.com/link/space/databases/questions/129527
answered
Jelle van Leeuwen
0
If you're sure that you upgraded your Excel Exporter module to the latest version, it could help to clean your deployment directory and try to run the app again. Sometimes, Studio Pro is not able to detect changes like this.
answered
Jeroen Appel
0
Consider reverting to a version of your project where everything was working as expected. Then, step through your changes incrementally to pinpoint when the issue arises. I encountered a similar error when I had my files stored in OneDrive. It might be beneficial to save your project locally to see if that resolves the problem.
answered
John Chow
0
Hi all, thanks for your response. The way i was able to eventually resolve this was by deleting old libraries in the userlib folder. I have also seen a tool that cleans up the userlib folder. For anyone with the same issue it may be worth having a look into getting this installed and using it.
I unfortunately was not able to use this as i am working on my work computer. So not sure how great it is, but always worth a try!
answered
Talhah Perager