|
|
 |
 |
Joined: 6/3/2010
Posts: 59
|
|
|
I am trying to set up the Batch Export program that I have purchased from you. I have followed the instructions but get the following error when the program is run. The program is on the same server as the cart and has full rights to run.
Unhandled Exception: System.TypeInitializationException: The type initializer fo
r 'ExportOrders.Program' threw an exception. ---> System.IO.FileNotFoundExceptio
n: Could not load file or assembly 'log4net, Version=1.2.10.0, Culture=neutral,
PublicKeyToken=1b44e1d426115821' or one of its dependencies. The system cannot f
ind the file specified.
File name: 'log4net, Version=1.2.10.0, Culture=neutral, PublicKeyToken=1b44e1d42
6115821'
at ExportOrders.Program..cctor()
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\M
icrosoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure lo
gging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fus
ion!EnableLog].
--- End of inner exception stack trace ---
at ExportOrders.Program.Main(String[] args)
|
|
|
|
 | |
|
|
 |
 |
Joined: 3/11/2010
Posts: 1979
|
|
|
Programming is looking at this today and I will post back when I have more info.
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 6/3/2010
Posts: 59
|
|
|
I have come up with a work around myself. Simply copy the following files from the bin folder of the DNN website: log4net.dll and Microsoft.ApplicationBlocks.Data.dll as they are both required. The application is now running and I have set the configuration as per the manual but I dont get any CSV file generated and simply get the following in the cpsparser.log file:
2010-07-11 14:43:03,265 187 [7252] DEBUG ExportOrders.Program - Before dataset creation
2010-07-11 14:43:03,374 296 [7252] ERROR ExportOrders.Program - Error in creating order file
2010-07-11 14:43:03,374 296 [7252] ERROR ExportOrders.Program - Error in creating order file
|
|
|
|
| |
|
|
|
Joined: 7/28/2009
Posts: 1452
|
|
|
Can you confirm that you have the following 2 settings configured properly on your server:
<add key="OutputDirectory" value="C:\SftpRoot\" />
<add key="dbprefix" value="dnn_" />
At your service,
Dave Smith
|
|
|
|
| |
|
|
|
|
Joined: 6/3/2010
Posts: 59
|
|
|
yes, see below:
<add key="ToEmail" value="support@AAAAAAA.com" />
<add key="FromEmail" value="support@BBBBB.com" />
<add key="CCEmail" value="" />
<add key="EmailSubject" value="Order File" />
<add key="SmtpServer" value="127.0.0.1" />
<add key="SmtpPort" value="25" />
<add key="SmtpUserID" value="SSSS@FFFFF.co.uk" />
<add key="SmtpPassword" value="QQ" />
<add key="dbprefix" value="dnn_" />
<add key="OutputDirectory" value="C:\AAAA\orderexport\" />
Error:
2010-07-12 18:52:08,186 171 [7260] DEBUG ExportOrders.Program - Before dataset creation
2010-07-12 18:52:08,311 296 [7260] ERROR ExportOrders.Program - Error in creating order file
2010-07-12 18:52:08,311 296 [7260] ERROR ExportOrders.Program - Error in creating order file
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
Are you running the program on the same server as your dnn site? If you are running it on another server does that server have proper access to the sql database?
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 6/3/2010
Posts: 59
|
|
|
It is running on the same server. I am running it from the command line to test it. Can you increase the logging via log4net so we can see some more detail to try and track down the issue.
|
|
|
|
| |
|
|
|
Joined: 7/28/2009
Posts: 1452
|
|
|
Yes open up the app.config and add the line "<level value="Debug" />" in the log4net section. The change is highlighted below in yellow:
<log4net>
<appender name="RollingFile" type="log4net.Appender.RollingFileAppender">
<file value="cpsparser.log" />
<appendToFile value="true" />
<maximumFileSize value="1MB" />
<maxSizeRollBackups value="10" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%newline%date %-4timestamp [%thread] %-5level %logger - %message%newline" />
</layout>
</appender>
<root>
<!--<level value="All" />-->
<!--<level value="Error" />-->
<level value="Debug" />
<appender-ref ref="RollingFile" />
</root>
</log4net>
At your service,
Dave Smith
|
|
|
|
| |
|
|
|
|
Joined: 6/3/2010
Posts: 59
|
|
|
Hmm, below is a copy of the root section of my config:
<root>
<!--<level value="All" />-->
<!--<level value="Error" />-->
<level value="Debug" />
<appender-ref ref="RollingFile" />
</root>
And below is the output with the above:
2010-07-13 12:33:56,518 171 [3240] DEBUG ExportOrders.Program - Before dataset creation
2010-07-13 12:33:56,674 328 [3240] ERROR ExportOrders.Program - Error in creating order file
2010-07-13 12:33:56,674 328 [3240] ERROR ExportOrders.Program - Error in creating order file
I cant see any difference, have I done something wrong?
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
Can you check the permissions on the account that you setup to run the orders export exe program and make sure that it has the proper file permission for the folder that you configured to write the output file to.
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 6/3/2010
Posts: 59
|
|
|
I am currently running the exe from the command line as an Administrator that has full control on all folders and sub folders so it is not a permission problem.
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
I will have our programmer recompile the batch export program with additional logging and email you a new one.
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
Do you have orders with status = 'Open' in your smith_orders table? The query that populates the output file has that where condition.
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 6/3/2010
Posts: 59
|
|
|
Yes i have two orders with an Open state.
|
|
|
|