Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Automated USPS Click & Ship Application
 
esolutions
Jr. Member
 
Avatar
Total Posts:  24
Joined:  2009-02-12
California
 

I was wondering if the SQLCE.DLL file missing message has been fixed yet. I would love to try out this program.

 
Magento Community Magento Community
Magento Community
Magento Community
 
kardson
Member
 
Total Posts:  59
Joined:  2009-02-17
 

While fixing the missing DLL another problem arose.

Should only be a day or 2 before I can get it out to everyone. 

Sorry for the delay :(

 
Magento Community Magento Community
Magento Community
Magento Community
 
kardson
Member
 
Total Posts:  59
Joined:  2009-02-17
 

Alright.

Files updated and program recompiled.  You will most likely have to uninstall the old version first.  Before installing this version.

Please let me know if you have trouble

 
Magento Community Magento Community
Magento Community
Magento Community
 
bj0rn
Member
 
Avatar
Total Posts:  37
Joined:  2008-06-16
 

So this is a standalone application that automates data input into the browser? It’s not actually working in the backend? Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
kardson
Member
 
Total Posts:  59
Joined:  2009-02-17
 

Yes,

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
esolutions
Jr. Member
 
Avatar
Total Posts:  24
Joined:  2009-02-12
California
 

Hi,

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)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3603 (GDR.050727-3600)
CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
SimpleShip
Assembly Version: 3.0.0.0
Win32 Version: 3.0.0.0
CodeBase: file:///C:/Program%20Files/Creative%20Beam/SimpleShip/SimpleShip.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data.DataSetExtensions
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.1 built by: SP
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Data.DataSetExtensions/3.5.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
----------------------------------------
System.Core
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.1 built by: SP
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
MySql.Data
Assembly Version: 6.1.2.0
Win32 Version: 6.1.2.0
CodeBase: file:///C:/Program%20Files/Creative%20Beam/SimpleShip/MySql.Data.DLL
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.Data.SqlServerCe
Assembly Version: 3.5.1.0
Win32 Version: 3.5.5692.0
CodeBase: file:///C:/Program%20Files/Creative%20Beam/SimpleShip/System.Data.SqlServerCe.DLL
----------------------------------------

 
Magento Community Magento Community
Magento Community
Magento Community
 
kardson
Member
 
Total Posts:  59
Joined:  2009-02-17
 

Hrmm.. that shouldn’t have happened… Maybe I uploaded the wrong files…

I recompiled to be safe and updated the ver number to 3.03

please try again and thanks for the patience.

 
Magento Community Magento Community
Magento Community
Magento Community
 
esolutions
Jr. Member
 
Avatar
Total Posts:  24
Joined:  2009-02-12
California
 

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)

 
Magento Community Magento Community
Magento Community
Magento Community
 
kardson
Member
 
Total Posts:  59
Joined:  2009-02-17
 

Not sure why it’s not auto installing SQL Compact Library..

But you can get it here

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID;=e497988a-c93a-404c-b161-3a0b323dce24

that should fix your problem.

What version of windows are you using?

 
Magento Community Magento Community
Magento Community
Magento Community
 
esolutions
Jr. Member
 
Avatar
Total Posts:  24
Joined:  2009-02-12
California
 

Hi,

Got the sql problem fixed.

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
kardson
Member
 
Total Posts:  59
Joined:  2009-02-17
 

Do you know if you have any admin modules added to your magento installation that would change the link layout of a default magento install?

I’ll toy around with some things tonight and see what I can come up with.

Also,
What was the final fix on the sqlce.dll file issue?  Did you install the library with the link I provided?

 
Magento Community Magento Community
Magento Community
Magento Community
 
esolutions
Jr. Member
 
Avatar
Total Posts:  24
Joined:  2009-02-12
California
 

I installed library from the link you provided.

We have not installed any modules for this magento installation.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ril3y
Jr. Member
 
Total Posts:  1
Joined:  2010-08-31
 

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?

Ril3y

 
Magento Community Magento Community
Magento Community
Magento Community
 
flytrapcare.com
Member
 
Total Posts:  46
Joined:  2009-08-09
 

Hi Travis,

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
wsj3
Guru
 
Avatar
Total Posts:  521
Joined:  2008-07-13
Portland, OR
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top