Hi,
I get (Result: 161 Wrong xml file) , when i try to import employees from an excel using file vb.net.
Importing within Sage works ok.
Any help to resolve this would be much appreciated.
below is my code?
With IE
.Open(mDBLinkCmpRW)
.ImportAction = tagImportActionType.IMPORT_INSERT_AND_UPDATE
.SetViewEx("PM0021", "", tagViewType.VIEW_BATCH, vbNull, tagViewActionType.ACTION_ASK)
.SetViewEx("PM0022", "", tagViewType.VIEW_FLAT, vbNull, tagViewActionType.ACTION_ASK)
.SetViewEx("PM0039", "", tagViewType.VIEW_BATCH, vbNull, tagViewActionType.ACTION_ASK)
.VerifyOnPut = True
'
.GetExecuteResult(str)
If IE.ImpExpStatus = tagImportExportStatus.IE_SUCCESS Then
Else
sResultText += "Result: " & IE.ImpExpStatus
For i As Integer = 0 To mDBLinkCmpRW.Session.Errors.Count - 1
sResultText += vbTab & vbTab & mDBLinkCmpRW.Session.Errors.Item(i) & vbCrLf
Next
End If
.Close()
End With
Regards
I get (Result: 161 Wrong xml file) , when i try to import employees from an excel using file vb.net.
Importing within Sage works ok.
Any help to resolve this would be much appreciated.
below is my code?
With IE
.Open(mDBLinkCmpRW)
.ImportAction = tagImportActionType.IMPORT_INSERT_AND_UPDATE
.SetViewEx("PM0021", "", tagViewType.VIEW_BATCH, vbNull, tagViewActionType.ACTION_ASK)
.SetViewEx("PM0022", "", tagViewType.VIEW_FLAT, vbNull, tagViewActionType.ACTION_ASK)
.SetViewEx("PM0039", "", tagViewType.VIEW_BATCH, vbNull, tagViewActionType.ACTION_ASK)
.VerifyOnPut = True
'
.GetExecuteResult(str)
If IE.ImpExpStatus = tagImportExportStatus.IE_SUCCESS Then
Else
sResultText += "Result: " & IE.ImpExpStatus
For i As Integer = 0 To mDBLinkCmpRW.Session.Errors.Count - 1
sResultText += vbTab & vbTab & mDBLinkCmpRW.Session.Errors.Item(i) & vbCrLf
Next
End If
.Close()
End With
Regards