The application was made using Visual Studio 2008 and was written in Visual Basic.
It primarily acts as an automation bot.
Since I do not know how to properly close an order by imputing the proper variables into magento. AND my php skills are not up to par I decided to go this route.
In a Nutshell the whole process involves:
1. Connecting to the magento database and pulling out the order #, and shipping information.
2. Displaying this is a list in which you select which order to ship… it then auto fills in the shipping details and shipping method.
3. once you hit submit it either uses a backend service to create the Fedex shipping label OR it automates the login and data entry via the USPS click and ship website.
4. After the label is printed it then automates the process of logging back into your magento store, navigating to the proper order, inputting the tracking number and closing the order.
I uninstalled the program as suggested but when I installed it again but the loading screen still showed v3.0 and still had the settings saved from the last install.
It also produced the following error when using the program:
************** Exception Text **************
System.DllNotFoundException: Unable to load DLL ‘sqlceme35.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
at System.Data.SqlServerCe.NativeMethods.DllAddRef()
at System.Data.SqlServerCe.SqlCeConnection..ctor()
at System.Data.SqlServerCe.SqlCeConnection..ctor(String connectionString)
at SimpleShip.Main.AddToAddressBook()
at SimpleShip.Main.btnSubmit_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
We got the following error when clicking on submit:
************** Exception Text **************
System.DllNotFoundException: Unable to load DLL ‘sqlceme35.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
at System.Data.SqlServerCe.NativeMethods.DllAddRef()
at System.Data.SqlServerCe.SqlCeConnection..ctor()
at System.Data.SqlServerCe.SqlCeConnection..ctor(String connectionString)
at SimpleShip.Main.AddToAddressBook()
at SimpleShip.Main.btnSubmit_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
It worked well until it logged into magento. It stopped before it could get to the order.
It stopped on the magento dashboard with “New page is same as old page, stopping : Application is processing request” as the status message.
When i tried going into the order manually it kept forcing the browser to go back to the dashboard and displayed the same status message. It also didnt appear to have written anything to the magento database.
I am using a Windows XP machine and Magento ver. 1.3.2.4.
Let us know if you need anymore information or if there is anyway we can help.
Hey cool idea. I have had a bit of trouble getting it to work however. I can connect to my DB with MySQL workbench by specifying the correct values..
IE:
IP: 127.0.0.1
Port: 12345
DB: blah
and it will work.. However when I enter the correct values into your program all I see is “unable to connect to any of the specified MySQL Hosts”. Not sure whats going on? Any ideas?
Is this app still beings supported by you? I tried to use an old version today (still using one of the 1.x versions) and I get a message about the trial key not being active. I guess you’ve decided to charge for the app now? How do we go about purchasing?
I also noticed that the download link for version 3.x is not working.
FYI, I’ve been a beta tester for Ordercup.com and their new Magento integration which handles shipping and label creation for Magento and EBay. It’s working great for me.
