STATUS REPORT
ORDERTRUST / ERP INTEGRATION
Overall Task List 
<next week>   <prev week>  

Work Status KEYS
W - Work in Progress
C - Completed
X - Cancelled/On Hold
R - Research		 START DATE 7/16/2000
END DATE 7/22/2000

Maintained by: Scott E. Steingraber
Task #

Date input in System

 Work on This Week Current Work Status Priority or Whom LINKED
DOCS?

Description of Task & Threaded Discussions
(Click on "+" sign to see the threads)
1 07/19/00   This item has linked documents, click icon to see them
Click me to see the thread of this task We will not be testing image conveyance during this round of CERT testing. On the next presenter we will have to test all this functionality.
2 07/19/00   This item has no linked documents
Click me to see the thread of this task Laura is asking to resume conference calls on Wednesday's at 10:00 AM.
3 07/19/00   This item has no linked documents
Click me to see the thread of this task Magdaline will be on vacation 7/21 - 7/28 Steve Thorpe will take her place. Also Markus is going to be on vacation from  7/21 - 8/15 (or something close to that)
4 07/19/00   This item has no linked documents
Click me to see the thread of this task We might have to delete all old orders from TCN server, due to the way that the order conveyance program works.
5 07/19/00   This item has linked documents, click here to see them
Click me to see the thread of this task IP addresses for new host pro boxes are now certified 6/27/00 - 64.45.30.179 & 64.45.30.180
6 07/19/00   This item has no linked documents
Click me to see the thread of this task Someone needs to cleanup catalog for shop.trodat.net, I dont think this is completed yet.
 7   07/19/00   This item has linked documents, click here to see them
Click me to see the thread of this task Laura is asking Wolfgang which payment processor we are suppose to be using. Is Trodat going to switch from payment tech to FDC. I think, judging by current code that we may already be setup to use FDC. We are using the file FDCcodes.txt. If they change processor's we will have to change TCN code. Not sure how big of a deal this is. Could be small or medium task.
8 07/19/00 I worked on this task during this week This item has linked documents, click here to see them
Click me to see the thread of this task Laura at OrderTrust (OT) has asked that we change all customer id's in ctx files and in the presenters_lists.txt to: TXNTR001 from the previous values. Each presenter currently has a different id. I have to change customer id's in all CTX files as we move into other presenters..
9 07/19/00 I worked on this task during this week This item has linked documents, click here to see them
Click me to see the thread of this task I have to modify the WSH conveyance program some more. To write an audit file. Should we append or overwrite the audit file? Maybe create new one each time? (depends on file size).   I will probably have to modify all the other batch programs, if this one is any indication.
10 07/19/00 I worked on this task during this week This item has no linked documents
Click me to see the thread of this task Submit some more test orders and see how they go through after modifying WSH conveyance program. Work with Markus and Wolfgang on this.
11 07/19/00 I worked on this task during this week This item has no linked documents
Click me to see the thread of this task Run WSH file from Task Scheduler every 10 minutes? What is a safe time to run it? Not too close together in case a lot of orders are already being submitted. The WSH is not re-entrant safe code. Will need to test this once WSH script is OK.
12 07/19/00 I worked on this task during this week This item has no linked documents
Click me to see the thread of this task Have to discuss with Markus:
Examine the process how he gets the order data from TCN -> OT -> Markus
13 07/19/00 I worked on this task during this week This item has linked documents, click here to see them
Click me to see the thread of this task We need to find file format for these TCN->OT->Markus orders, and validate they are same format as Markus expects. I have the order format from Magdaline at OT. Markus gets TCN originated orders from trodgOOC - password: lw27AupX  (file format is in this file : 0406_ASCIIfileformatforendpointTrodatGMBH.doc)
14 07/19/00   This item has linked documents, click here to see them
Click me to see the thread of this task Has the file format changed for orders picked up at trodg00C? Markus sent a document called "TrodatOrderFormatFromOT.doc" Has this changed since March 2000? He was asking.
15 07/19/00 I worked on this task during this week This item has no linked documents
Click me to see the thread of this task We need to test sending order data from TCN to OT, and then have Markus pick up orders via FTP (user: trodg00C) and he checks file format. I don't yet know if Markus does anything else with this incoming order data. I think he only deals with it manually. It would be too time consuimg to automate it on their system.
16 07/19/00 I worked on this task during this week This item has linked documents, click here to see them
Click me to see the thread of this task Document the XML data that OT generates in CERT environment just so we have a record of it. This XML can be helpful in troubleshooting problems. There is also an LSF format that magdaline told me about. Its an internal format that they use at Ordertrust for storing order data.
17 07/19/00 I worked on this task during this week This item has linked documents, click here to see them
Click me to see the thread of this task Magdaline found a small problem in XML data for the 2 orders I sent in. However, I think the problem is in their conversion process, not in TCN sending data to OT. have to research.
18 07/19/00   This item has linked documents, click here to see them
Click me to see the thread of this task Order status used by batch programs is defined in the global asa file.
19 07/19/00   This item has linked documents, click here to see them
Click me to see the thread of this task We have to test how notification files are sent for partial orders, and how TCN code deals with them. TGMBHOOC is FTP user to read notification files - password: d89wgnWT. See linked documents for more information about Notification files.
20 07/19/00   This item has linked documents, click here to see them
Click me to see the thread of this task Laura sent a file called trodatsamplenotification.xls about notification data. Need to review it.
21 07/19/00   This item has linked documents, click here to see them
Click me to see the thread of this task Markus wants to change code in TCN so that the notification program updates the shipping date field. Currently it does not appear to do that.
22 07/19/00   This item has linked documents, click here to see them
Click me to see the thread of this task File format for ERP orders from Markus in found in ERPImportfilespecification0404.xls. The ERPImport.exe program or WSH should use this format.  We have to test this functionality.
23 07/19/00   This item has no linked documents
Click me to see the thread of this task TCN gets ERP originated orders from: TGMBSOCC - password: ZMNF8iq5. Will have to test this. Trodat (Markus) sends their ERP generated orders to: TGMBSOIC - password: ZMNE8iq5
24 07/19/00   This item has linked documents, click here to see them
Click me to see the thread of this task Custom field says "fax" when you log in as admin vs. user: mpcuser upon viewing in order history in TCN web site pages. Markus says this is a bug and needs to be fixed.  See attached screen print.
25 07/20/00 I worked on this task during this week This item has linked documents, click here to see them
Click me to see the thread of this task I am working on documenting the Profile/Tracing of the SQL server interaction with the ASP pages and DLL objects.  Having this knowledge is good for debugging, testing, and development.  I will be creating a document for each new critical path through the TCN system, on an as needed basis.  For starters, I have created a list of the SQL SPROC's enlisted from the time of login until an order is placed and order confirmation received. There are many good reasons to do this. We can find bottlenecks, establish performance criteria. Understand how the system works and how data flows throughout the system, and make it more efficient.  We do not have information such as this right now.
26 07/16/00 I worked on this task during this week This item has linked documents, click here to see them
Click me to see the thread of this task I am working with Magdaline at Ordertrust on the CERT testing process. She has given me a rather large testing matrix that I will be using to test the TCN production servers. She has told me which specific tables, and items in those tables to test.  Click green ball to see the linked docs. This is one of the largest time consuming tasks on this list. It means that all the programs on TCN have to working to complete the test successfully. So this one will take some time.
27 07/20/00 I worked on this task during this week This item has linked documents, click here to see them
Click me to see the thread of this task I have a separate list of issues dealing with the CERT process of Ordertrust and TCN servers. Click on the little green ball at left, to see the linked documents.
28 07/20/00   This item has linked documents, click here to see them
Click me to see the thread of this task Upload all the new documents I have received from OT and Markus, and custom ones I have created, to the Trodat extranet. Ask wolfgang for a new location for them.
29 xx/yy/zz   This item has no linked documents
Click me to see the thread of this task Enter a new task description here...
30 xx/yy/zz   This item has no linked documents
Click me to see the thread of this task Enter a new task description here...