Welcome to the Calyx Software Message Boards where you can share ideas and solutions with other Calyx users! Calyx personnel including Tech Support, Development, QA, and Business Planning often visit these message boards unofficially to better understand our customers' needs. To submit your suggestions Click Here.
This discussion forum is a service provided by Calyx Software. Calyx Software does not endorse any particular point of view expressed in this forum or any information provided in it. The use of the information provided by other users in this message board is at your own risk.
Calyx Software Message Board
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      


12»»

Can I copy the Import.exe to a separate...Expand / Collapse
Author
Message
Posted 8/15/2005 1:56:04 PM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 6/21/2007 3:27:09 PM
Posts: 95, Visits: 748
I want to copy the import.exe and import.exe.config files to a server and execute the process from there.  Do I need a copy of Point installed?

I'm trying to run the import right now and I'm getting "The Application has generated an exception that can not be handled."

Post #176
Posted 8/15/2005 2:05:59 PM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 6:19:09 AM
Posts: 1,183, Visits: 9,259
Import.exe is a .net application and the default security context will not let it run from a remote location.  Point 5.1's version of import.exe has a strong name so you can set up a code access policy.

go to the control panel open administrative tools click .net configuration 1.1
expand runtime security policy
expand machine
expand code groups
expand all code
right click localintranet_zone
choose new.
name it what you would like click next

select Strong Name from the drop down
click the import button and brows to import.exe and select it.
click next.
allow full trust just click next.
click finished.

it should now work on this system.

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.

Post #177
Posted 8/15/2005 2:17:57 PM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 6/21/2007 3:27:09 PM
Posts: 95, Visits: 748
I added it both to LocalIntranet_Zone and My_Computer_Zone.  Neither worked.  I am trying to run it from the D: drive on a 2000 server.
Post #178
Posted 8/15/2005 2:31:12 PM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 6:19:09 AM
Posts: 1,183, Visits: 9,259
Sorry although that was the first thing to come to my mind, and is probably part of the issue you will need to make sure you have  all of its dependancies in the same directory with import.exe
pdd.dll, AesLib.dll, Sqlite.dll, sbautils.dll, sbaparam.dll, mfc71.dll, msvcp71.dll, msvcr71.dll and Implode.dll

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
Post #179
Posted 8/15/2005 2:53:37 PM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 6/21/2007 3:27:09 PM
Posts: 95, Visits: 748
Adding the dependent DLLs worked.  Thank you very much for your help.
Post #180
Posted 8/16/2005 9:11:44 AM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 6/21/2007 3:27:09 PM
Posts: 95, Visits: 748
OK.  When I double click my VB Script to execute the import statement with parameters, it works correctly.

When I call the statement from the commandline (cscript ImportFiles.vbs or wscript ImportFiles.vbs), the import process does not work.

Why?

Here is the important parts of the VBS code I'm using.

======== importfiles.vbs ===========

Option Explicit

Const ImportDefinition  = "Final.imp"
Const ImportLocation = "J:\PROSPECT"
Const ImportFile = "D:\ScheduledTasks\WebAppImport\ImportCode\Import.exe"
Dim WshShell, ImportCommand

Set WshShell = CreateObject("WScript.Shell")

ImportCommand = ImportFile & " " & FileName & " " &_
      ImportDefinition & " " & ImportLocation

Wscript.echo ImportCommand ' Debugging purposes
WshShell.Run (ImportCommand, 1, true)

Set WshShell = nothing

==========

Post #183
Posted 8/16/2005 9:26:33 AM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 6/21/2007 3:27:09 PM
Posts: 95, Visits: 748
Adding a path to my ImportDefinition

ImportDefinition = "G:\Final.imp"

executing this from the commandline now give me the first error I posted.

"Application has generated an exception that can not be handled."

I have added the import.exe program all over the .Net 1.1 config.

Post #184
Posted 8/16/2005 9:33:48 AM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 6:19:09 AM
Posts: 1,183, Visits: 9,259
sorry just want to make sure if you double click the vb script it still works right?  Also where is FileName comming from?

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
Post #185
Posted 8/16/2005 9:39:46 AM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 6/21/2007 3:27:09 PM
Posts: 95, Visits: 748
Copy and paste error.  File namne is coming from part of the main pgm that parses the directory looking for files.  it is a path to a CSV.

Yes doubleclicking still works.

Now I'm to the point of just trying to call the import.exe directly from the command line with arguments and it isn't working. 

Post #186
Posted 8/16/2005 10:02:32 AM