Thursday, September 9, 2010

Upload Status of each Record

UDIMagic v3.0 Release 2.4 now provides facility to view the upload status of each record (Log Status). This is useful in finding the duplicate records or records with error, particularly while uploading of Master-records into the Tally Software.

By default, the Upload Status is shown in the last two Column(s) of the Excel sheet as given  below :-

Column IU (i.e. Column No 255 of Excel sheet)
Upload status us shown as CREATED, ALTERED, IGNORED, COMBINED, ERROR.

Column IV  (i.e. Column No 256 of Excel sheet) 
Contains the Error description, if any.

PS:
1) You can change the Column in which the Upload Status appears by setting the following option in the "c:\udi-magic\udimagic.ini" file

[UDI-Magic]
;;This will show the upload status in Col. Y (and error description in Col. Z)
;;The option "UploadStatusInColumnNumber" must appear under [UDI-Magic] section
;;The lines starting with ;; are comments and will be ignored
UpdateStatusInColumnNumber=25

2) In case, if macros are used, the Columns AA to BZ are used for internal calculations. Hence, you must specify Columns other than those.

No comments: