Does anyone know how to import daily timecard comments from an external source into Timecard Entry?
You need a specific control macro which I have copied below. Give this a try and let me know how it goes.
'PANOT Control Macro
Sub ProcessImportLine( LevelNumber%, Retval% )
select Case LevelNumber
call AliasConstant( "Level0", "notes" )
case 0 ' 0 of 0
'Level 0 if of Type N
' cnote_type_cd is a key field for level 0
' Field mask is UUUU
' NOTE -- This field is a required field
serr = SetObjectValue( "cnote_type_cd", ImportField(1) )
' ckey_value is a key field for level 0
' Field mask is UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU
serr = SetObjectValue( "ckey_value", ImportField(2) )
' ckey_index is a key field for level 0
' Field mask is 99
serr = SetObjectValue( "ckey_index", ImportField(3) )
'Currently Disabled clu_logon_id
'Currently Disabled cnote_desc
'Currently Disabled clu_date
' The following shows the correct syntax to
' PRESS a button
' These object names are specific to this screen.
' Button object name cmdButnBar, Caption
' serr = SetObjectValue( "cmdButnBar", "PRESS" )
Technical Support Engineer
**This posting is provided "AS IS" with no warranties and confers no rights.
Thanks a lot!
Does this macro apply to a timecard that already exists? If so, is there a different macro for importing daily comments as part of a new timecard?
I believe it will work for both since the comments have to be imported separately from the timecard import. Let me know how it goes.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13