ContributionsMost RecentMost LikesSolutionsFTP File Load Best Practice When I pull a flat file from an SFTP server, I have been parsing that file in VB .net into a Data Table and loading it that way. Is this the best way to do this, or is there a way to make the Impo...how do I check if a period is locked or unlocked in vb.net I have a requirement to load to the most recent unlocked period. Using VB or C#, how do I check if a period is locked or unlocked? Thanks, Scott Re: Account Reconciliation Status Codes Thanks MarcusH, that was what I was looking for. Scott Account Reconciliation Status Codes I am trying to write some custom reports off of the RCM tables. Does anyone know the translation of the number in the status column from the table to the name that shows in the UI? Or does someone ...SolvedRe: Get the "Workflow Name" setting from a workflow profile in a business rule? Thank you!! Get the "Workflow Name" setting from a workflow profile in a business rule? Is it possible to get this setting in a business rule? Thanks, Scott SolvedRe: BR works when run manually, but not through Task Schedule I'm not going to bother. I moved it to a different dev application and It is working as expected. Unless someone can think of a reason task scheduler wouldn't run BR correctly in an application I t...Re: BR works when run manually, but not through Task Schedule All of the log.Appendline statements show all of what you are asking about. The first thing I checked before coming here is that all of the variables are populating correctly (Troubleshooting 101). ...Re: BR works when run manually, but not through Task Schedule Yes I have validated all of that. Here is the full code up to there: Dim jobLog As New Text.StringBuilder Dim returnValue As New List(Of Object) Dim jobStatus As Boolean = True Di...Re: BR works when run manually, but not through Task Schedule No, the BR is much longer, however the Execute Parse and Transform is the line that fails.
