News:

alphaMELTS 2.3 standalone & for MATLAB/Python is now open source and available on GitHub (https://github.com/magmasource/alphaMELTS).
alphaMELTS 1.9 is available at the legacy download and information site.
For news of all MELTS software see the MELTS Facebook page.

Main Menu

Recent posts

#1
Hi Kai,

The output from column-pick.command is a comma- or text-delimited text file that can be easily imported into Excel. It is not an actual Excel file. If you take the ">aaa.xlsx" off what you are typing then you will be able to see the output of column-pick.command, including any error messages.

The input to column-pick.command is mostly a list of files, tables, and columns. For example:

Name: col_custom.txt
Header: Excel
Format: csv              ! output a comma-delimited table that can be opened in Excel automatically by double-clicking in Finder/Explorer
!Format: txt              ! output a tab-delimited table that can be opened in Numbers (Mac) automatically from the terminal command line
!Padding: '0.0'

File: System_main_tbl.txt
Table: System
Columns: index Pressure Temperature

! custom expressions need to be at the end and are processed left to right; avoid special characters like in FeO* or Mg#
File: Liquid_comp_tbl.txt
Table: "Liquid Composition"
Columns: SiO2 TiO2 Al2O3 Fe2O3 Cr2O3 FeO MnO MgO NiO CaO Na2O K2O P2O5 H2O CO2 FeOtot={FeO}+0.9*{Fe2O3} Mgnum=({MgO}/40.3044)/(({MgO}/40.3044)+({FeO}/71.8464)) Mgpc=100*{Mgnum}

File: Phase_mass_tbl.txt
Table: Phase
Columns: liquid1 clinopyroxene1 clinopyroxene2 fluid1 olivine1 plagioclase1 spinel1

Delimiter: comma        ! default input delimiter is space, but .tbl files are comma-delimited

File: olivine.tbl
Columns: fayalite,forsterite

File: plagioclase.tbl
Columns: albite,anorthite,sanidine


For this example you would type:

column_pick.command col_custom.txt > aaa.csv
Or you can use the "-c col_custom.txt" switch to the run-alphamelts.command script, in which case the output will go to "alphaMELTS_tbl.txt". You would need the "Output: both" line in your .melts file to make sure the .tbl files are written.


Paula
#2
Dear Paul,
I open column-pick command after installing perl. It could produce a excel, but it told me can not download information, the new excel is just 1 Kb. My code is Liquid_comp_tbl.txt>aaa.xlsx, is there any thing wrong? Or need a comparable excel version?
Best,
Kai
#3
alphaMELTS for MATLAB/Python / Re: How to solve 'Can not find...
Last post by ll863628123 - October 12, 2025, 07:30:46 PM
Thank you very much, the code worked.
#4
Windows / Re: Nothing seems to work
Last post by victor_13 - October 12, 2025, 07:06:42 AM
Hi,

I'm experiencing the same issue that others have reported. I've been trying to use MELTS_Excel for several days, but I keep getting the following error message:

''Server returned no results, giving up''

I've tried using different versions of the MELTS_Excel spreadsheet, but I always get the same error.

At this point, I'm not sure what else to try to make it work properly. Any advice or suggestions would be greatly appreciated.
#5
Windows / Re: Nothing seems to work
Last post by Paula - October 09, 2025, 08:39:19 AM
I wonder if there is a restriction on access from outside the U.S. for the new server. I'll see if I can find out more and get back to you.
#7
Windows / Re: Nothing seems to work
Last post by CHN_L - October 08, 2025, 06:55:37 PM
Quote from: CHN_L on October 08, 2025, 06:47:40 PMI'm sorry i have clicked the "unlock" checkbox but it still not work, maybe I should add a websites?


Calculation number: 1
InputXML: <MELTSinput><initialize><modelSelection>MELTS_v1.0.x</modelSelection><SiO2>74.39</SiO2><TiO2>0.18</TiO2><Al2O3>13.55</Al2O3><Fe2O3>0.360480704996108</Fe2O3><FeO>0.975635492235283</FeO><MgO>0.5</MgO><CaO>1.43</CaO><Na2O>3.36</Na2O><K2O>5.09</K2O><H2O>10</H2O></initialize><calculationMode>equilibrate</calculationMode><title>MELTS Web Service called from Excel. [created 2014Apr23] (version 1.0.3)</title><sessionID></sessionID><constraints><setTP><initialT>800</initialT><initialP>2000</initialP><fo2Path>nno</fo2Path><fo2Offset>0</fo2Offset></setTP></constraints><suppressPhase>amphibole</suppressPhase><suppressPhase>biotite</suppressPhase><fractionationMode>fractionateNone</fractionationMode></MELTSinput>
Request sent: 2025/10/9 9:52:36
Current server state: 1
Time limit reached: 2025/10/9 9:52:38
Calculation failed, trying again...
Request sent: 2025/10/9 9:52:38
Current server state: 1
Time limit reached: 2025/10/9 9:52:58
Two consecutive failures. Aborting...
#8
Windows / Re: Nothing seems to work
Last post by CHN_L - October 08, 2025, 06:47:40 PM
I'm sorry i have clicked the "unlock" checkbox but it still not work, maybe I should add a websites?
#9
alphaMELTS for MATLAB/Python / Re: How to solve 'Can not find...
Last post by ll863628123 - October 08, 2025, 01:34:51 AM
Thank you for your reply, Paula. The system PATH variable should be set correctly, but I couldn't find any .dll files on https://github.com/magmasource/alphaMELTS. Perhaps the libalphamelts.dll file needs to be downloaded from somewhere else. Could you please tell me where to get it?
#10
alphaMELTS for MATLAB/Python / Re: How to solve 'Can not find...
Last post by Paula - October 07, 2025, 06:39:07 PM
You might need to set the Path, as well as the PYTHONPATH. See the RUNNING alphaMELTS for Python part of the Windows installation guide:

https://github.com/magmasource/alphaMELTS/wiki/alphaMELTS-installation-and-testing#installing-on-windows-2

Substitute 'MELTS_Matlab\package' with the name of the folder that you extracted the python and .dll files to.