Hello Lora and Scott, I did this on a Manage-2000 system. What it entailed was creating a list of every single data file on the system, and then searching every field on every record on every file on the system and at the field level comparing that field with every single G/L account in the G/L file and making a list of all the G/L account numbers found. There was also a pattern match that was executed before the G/L number search, one to save time if the pattern match failed, and two this client had trashed their G/L several years ago and there were G/L numbers in the files that did were not in the G/L masterfile, and they wanted to find all these and correct them as well.
This program was written in two different modes, one was the mode described above (Inspection mode) and the other was Update mode. It was a pain to write, because in addition to value mark and sub value mark delimited data, ROI had used about 5 other delimiters and they had to be respected when searching. >From that point, we gave the data to the Accounting dept. in the form of a spreadsheet, after downloading to a PC and importing into Excel. They filled in the "New account numbers" column, so what we had was essentially a 'map' of all the old G/L numbers and the new numbers they would be converted to. We used this map instead of just downloading the G/L masterfile because of the G/L trashing mentioned in the first paragraph. This was uploaded back into Manage-2000 and we ran the program (in the training account) in Update mode. If there were any accounts found that had "bad" new account numbers, or any other 'problem' with matching, then they were output to an error file. This cycle of was repeated several times until the accountants successfully had valid new numbers for all the old numbers. So when the error file came out empty we did a backup Friday night, and then let it run over the weekend. (The program was very time consuming, it took over 48 hours to run). Finally on Monday morning, a backup was made before anyone did any processing just in case of a catastrophic failure destroying our 48 hours of processing, and the new number scheme was off and running. It was a MAJOR undertaking, but it worked. I believe that the number of programming hours came out to about 150 hours. I just remember being *extremely* happy when I got my check from the nice people that paid me to do this..... :) Allen E. Elwood Senior Programmer Analyst Sysmark Information Systems, Inc. Direct (818) 361-5251 Fax (818) 361-5251 Cell (818) 359-8162 Home (818) 361-7217 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lora Pennington Sent: Tuesday, October 26, 2004 04:25 To: U2 Users Group; FR Talk; [EMAIL PROTECTED]; Scott Howder Subject: [U2] RE: Restructuring the GL Please post to the list. I would be interested in this also. Lora ======================================= Lora Pennington Application Database Administrator International Lutheran Laymen's League Phone: (314) 317-4133 Phone: 1-800-944-3450 ext. 4133 Fax: (314) 317-4299 [mailto:[EMAIL PROTECTED] Visit Us at: [www.lhm.org] ======================================== The Coming Of Jesus Christ Is Closer Than Ever. Will He Find You Faithful? www.jesushasrisen.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Scott Howder Sent: October 25, 2004 2:05 PM To: [EMAIL PROTECTED] Subject: [ID] Restructuring the GL Our controller has decided to completely restructure the GL. He wants to consolidate the number of funds from ten down to three and change the length of the GL number. I have several questions: 1. Are there any resources on Datatel's web site that would help with this project? I looked through the listserve archives and tried several searches on Answernet without any luck. I'd be happy with a simple list of all the fields in Colleague that store the GL number but I can't find anything like this. 2. Have you worked on such a project? If so, do you have any resources you could share? Any words of wisdom? I'm at the initial stages of trying to figure out what all needs to be done. Any information would be great. Thanks, Scott Scott Howder Assistant Director of Computer Services Cedarville University [EMAIL PROTECTED] 937-766-7905 ---- To subscribe-or-unsubscribe info-datatel send subscribe-or-unsubscribe info-datatel in an email (body) to [EMAIL PROTECTED] Send _problems_ only to [EMAIL PROTECTED] Please send all answers to questions to the list. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
