I have a very large model (20 LVs) and data set (10,000 obs) and when I attempt to export results to Excel nothing happens. Program runs fine, exporting doesn't. It works for smaller models and data sets. No error rmessage, nothing. I get the dialog box about saving the file, then nothing. Exporting individual output screen works fine via export button. Exporting to HTML is fine too. I turn off the graphs and exportation of large matrices. My smartppls.ini file has memory set for the following:
-startup
plugins/org.eclipse.equinox.launcher_1.3.100.v20150511-1540.jar
--launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.300.v20150602-1417
-clean
-data
@user.home/.smartpls3
-clearPersistedState
-vmargs
-DcheckForUpdates=true
-Xmx8192m
-Xms4096m
I have a dual Xeon PC running Windows 7 64 bit with 32 gigabytes of memory. So I don't think my machine is running out of memory. Is there a limit on the Java memory set in the ini file?
Thanks,
Tom Eagle
Large model exporting to Excel issue
-
- SmartPLS Developer
- Posts: 1284
- Joined: Tue Mar 28, 2006 11:09 am
- Real name and title: Dr. Jan-Michael Becker
Re: Large model exporting to Excel issue
Do you use the Streaming API?
Dr. Jan-Michael Becker, BI Norwegian Business School, SmartPLS Developer
Researchgate: https://www.researchgate.net/profile/Jan_Michael_Becker
GoogleScholar: http://scholar.google.de/citations?user ... AAAJ&hl=de
Researchgate: https://www.researchgate.net/profile/Jan_Michael_Becker
GoogleScholar: http://scholar.google.de/citations?user ... AAAJ&hl=de
Re: Large model exporting to Excel issue
Sorry to take so long to reply.
I've tried both with and without Streaming API. I have also tried excluding large matrices, using simple layout, and turning off the graphs. Nothing works. I get no error message after the dialog box about saving the file name. I can export using HTML, but that is a pain to copy into Excel.
Tom
I've tried both with and without Streaming API. I have also tried excluding large matrices, using simple layout, and turning off the graphs. Nothing works. I get no error message after the dialog box about saving the file name. I can export using HTML, but that is a pain to copy into Excel.
Tom
-
- SmartPLS Developer
- Posts: 1284
- Joined: Tue Mar 28, 2006 11:09 am
- Real name and title: Dr. Jan-Michael Becker
Re: Large model exporting to Excel issue
Do you have data groups?
We found a small problem in the excel export that it crashes when non alpha-numeric characters are used in group names, because these group names are used as names for excel tabs and excel does not allow all possible characters.
We found a small problem in the excel export that it crashes when non alpha-numeric characters are used in group names, because these group names are used as names for excel tabs and excel does not allow all possible characters.
Dr. Jan-Michael Becker, BI Norwegian Business School, SmartPLS Developer
Researchgate: https://www.researchgate.net/profile/Jan_Michael_Becker
GoogleScholar: http://scholar.google.de/citations?user ... AAAJ&hl=de
Researchgate: https://www.researchgate.net/profile/Jan_Michael_Becker
GoogleScholar: http://scholar.google.de/citations?user ... AAAJ&hl=de
Re: Large model exporting to Excel issue
Yes I have a lot of data groups and some of those names are quite long. I am only using a '-', a '+', ':', and a '*' in those names in addition to alphabetic characters. I suppose I should remove the use of all those characters and shorten the group names a lot.
Tom
Tom
Re: Large model exporting to Excel issue
I have shortened all my data group names to less than 20 characters and they use nothing but alphabetic characters. The export still bombs. Does the length and wording of the model name also cause the same problem?
Tom
Tom
Re: Large model exporting to Excel issue
Shortening the model names did not work either... I shortened a model name to 'A' and the export to excel still does not work.
I have no problem with smaller data files... Is the dialog trying to exclude large matrices broken. Am I exceeding my Excel 32bit # of row limit. Even when I run a smaller sub-group by itself (9,144 obs) the Excel export does not work.
Tom
I have no problem with smaller data files... Is the dialog trying to exclude large matrices broken. Am I exceeding my Excel 32bit # of row limit. Even when I run a smaller sub-group by itself (9,144 obs) the Excel export does not work.
Tom
-
- PLS Junior User
- Posts: 1
- Joined: Fri Mar 17, 2017 1:39 pm
- Real name and title: Frank Douglas
Re: Large model exporting to Excel issue
I came across the same qestion.
- cringle
- SmartPLS Developer
- Posts: 818
- Joined: Tue Sep 20, 2005 9:13 am
- Real name and title: Prof. Dr. Christian M. Ringle
- Location: Hamburg (Germany)
- Contact:
Re: Large model exporting to Excel issue
Using very short variable names always is a good idea. Also, we suggest excluding large matrices and API streaming. See the the attached screenshot of setting.
Best
Christian
Best
Christian
- Attachments
-
- excel export settings
- excel export.PNG (32.48 KiB) Viewed 8221 times
Prof. Dr. Christian M. Ringle, Hamburg University of Technology (TUHH), SmartPLS
- Literature on PLS-SEM: https://www.smartpls.com/documentation
- Google Scholar: https://scholar.google.de/citations?use ... AAAJ&hl=de
- Literature on PLS-SEM: https://www.smartpls.com/documentation
- Google Scholar: https://scholar.google.de/citations?use ... AAAJ&hl=de