New Calculator to try

Status
Not open for further replies.

HotRod19579

Super Member
ECF Veteran
Nov 8, 2011
897
979
67
Round Rock, Texas
When trying to create the Import from Excel Template Spreadsheet
Ran from Portable on Dropbox.

C:/Users/????? = Profile name removed by me.

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified
at System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at CoreRecords.ImportFromExcel.OpenTemplate()
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
EJuiceCalculator
Assembly Version: 6.0.3.5
Win32 Version: 6.0.3.5
CodeBase: file:///C:/Users/?????/Dropbox/EJuiceCalculator/EJuiceCalculator.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
CoreRecords
Assembly Version: 6.0.3.5
Win32 Version: 6.0.3.5
CodeBase: file:///C:/Users/??????/Dropbox/EJuiceCalculator/CoreRecords.DLL
----------------------------------------
System.Deployment
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Deployment/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.6.1038.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
 

Mikla

Senior Member
Nov 21, 2015
189
428
67
Boca Raton, FL
Great updates!
(minor bug?) When opening a XML file (File==>Open), if there is a problem opening the file you will get a messagebox:

---------------------------
Error
---------------------------
Error loading XML Document:There is an error in XML document ([line], [position]).
---------------------------
OK
---------------------------

After hitting OK, the file does not load (expected) but the application does keep a lock on the file until another file is opened or the application is closed. This prevents the user from opening the file in another app (say Notepad) to see what the problem with the XML file might be. Expected behavior: Application releases (disposes) of the file (stream?) after pressing "OK", acknowledging the problem.

Work around: 1) Close application or, 2) Load a different XML file

Keep up the great work!
 

HotRod19579

Super Member
ECF Veteran
Nov 8, 2011
897
979
67
Round Rock, Texas
Great updates!
(minor bug?) When opening a XML file (File==>Open), if there is a problem opening the file you will get a messagebox:

---------------------------
Error
---------------------------
Error loading XML Document:There is an error in XML document ([line], [position]).
---------------------------
OK
---------------------------

After hitting OK, the file does not load (expected) but the application does keep a lock on the file until another file is opened or the application is closed. This prevents the user from opening the file in another app (say Notepad) to see what the problem with the XML file might be. Expected behavior: Application releases (disposes) of the file (stream?) after pressing "OK", acknowledging the problem.

Work around: 1) Close application or, 2) Load a different XML file

Keep up the great work!
I wasn't aware that I wasn't closing and disposing the file. I will make a change to properly close the file.


Sent from my iPhone using Tapatalk
 

skineedog

Senior Member
ECF Veteran
Oct 29, 2015
94
50
49
Do you have Word or another application installed that is able to open and .docx files? Also, when the document is created the calculator will launch the file (such as "RecipesTemplate.docx"). In order for the document to launch your Windows installation needs to have the file association setup. Make sure that you can use windows explorer and double click a file with a .docx extension and see if it launches the application and displays the document.

The issue I think is mostly related to my setup. Running Vista inside a Parallels VM. I sorta have it sorted out enough to use the features although not as you intended.

After installing Office inside the VM and associating the DOCX and XLSX extensions with the VM's version of Office, I am able to generate custom reports that open in the local version of Word as expected. When I attempt to export to Excel, I get an error that Excel is not installed. If I export "Using Open XML, the file is generated and opened in the VM's install of Excel. Peculiar but it works.

Parallels shares the Mac's applications with the VM so that when a link or file is opened, it is opened on in the Mac's application rather than the VM. It seems this doesn't work with the juice Calculator? Probably not enough users with this issue/setup, just an FYI.

Odd thing is, when I go to Import from Excel > Create template spreadsheet, the import template is opened in the Mac's install of Excel?.....

On another (sort of related) topic, is there a way to export the inventory to a spreadsheet? If not, please do not worry trouble yourself on my account. Copy and pasting from the ingredient editor to Excel is sufficient.

Thanks Rod!
 

Mikla

Senior Member
Nov 21, 2015
189
428
67
Boca Raton, FL
Another nit bug?

After doing a Edit==>Find & Replace Ingredients the "Replace With" value will change to the next value in the list. If I change it back, it does not do it on subsequent "replaces". This occurs when needing to change multiple items to a replaced single name. Danger is not noticing it and making another change to to wrong replace value.
Ex:
I want to change Banana (TFA) and Banana TFA to Banana - TFA,
Banana (TFA) will change OK but Banana TFA runs the risk of changing to the next "Replace" value after Banana - TFA.

Thanks!
 

V43L1N

Super Member
ECF Veteran
Verified Member
Jul 29, 2014
314
551
So. MD
First I'd like to say, thank you so much for all the work you've put into this calculator, it works amazingly well.

Unfortunately, I'm having an issue adding my nicotine base to my recipes. The nicotine drop down is blank after adding it to my ingredients list. :confused:

When I added the Ingredient I followed these steps:
-Clicked "Ingredients"
-Clicked "New"
-Added the name, and selected the manufacturer
-Selected "Nicotine" under the ingredient type and set the PG/VG ratio, as well as the cost/ML ratio.
-Added the inventory amount
-Clicked Save, and "Add to inventory"

Using version number: 6.0.3.6

Am I missing something? I read the "ReadMe" and I feel like I'm following the directions. Not having issues with any other ingredients. Thank you all in advance for any troubleshooting advice/tips!
 

HotRod19579

Super Member
ECF Veteran
Nov 8, 2011
897
979
67
Round Rock, Texas
First I'd like to say, thank you so much for all the work you've put into this calculator, it works amazingly well.

Unfortunately, I'm having an issue adding my nicotine base to my recipes. The nicotine drop down is blank after adding it to my ingredients list. :confused:

When I added the Ingredient I followed these steps:
-Clicked "Ingredients"
-Clicked "New"
-Added the name, and selected the manufacturer
-Selected "Nicotine" under the ingredient type and set the PG/VG ratio, as well as the cost/ML ratio.
-Added the inventory amount
-Clicked Save, and "Add to inventory"

Using version number: 6.0.3.6

Am I missing something? I read the "ReadMe" and I feel like I'm following the directions. Not having issues with any other ingredients. Thank you all in advance for any troubleshooting advice/tips!
Go back into the ingredient and mark the ingredient as a nicotine ingredient. I am guessing it is marked as a flavor.



Sent from my iPhone using Tapatalk
 

V43L1N

Super Member
ECF Veteran
Verified Member
Jul 29, 2014
314
551
So. MD
Go back into the ingredient and mark the ingredient as a nicotine ingredient. I am guessing it is marked as a flavor. Sent from my iPhone using Tapatalk

It is correctly marked as nicotine, not sure what I'm doing incorrectly. Screenshots attached:
Troubleshooting.JPG
Troubleshooting2.png
 

67Tele

Ultra Member
ECF Veteran
Verified Member
Jun 23, 2014
2,868
8,947
Austin
I have been using this calculator for a few years and I love it! I have a co-worker getting started and I want to recommend this to him. Can someone post the link where we can download it. The link I have from years ago does not work.
Thanks!

Current version is linked on the first page: New Calculator to try
 
Status
Not open for further replies.

Users who are viewing this thread