SaveFileBytesToUserTempFolder returning an error message

We ended up saving the data to the user's folder instead of the temp folder:

'Export the data
Dim fileName As String = "IC_Detail.csv"
Dim filePath As String = "Documents/Users/" & StringHelper.RemoveSystemCharacters(si.UserName,False,False)
 					
'Export csvContent to User Folder
Dim fileBytes() As Byte = system.Text.Encoding.Unicode.GetBytes(csvContent.ToString)
	
Dim fileDataInfo As New XFFileInfo(FileSystemLocation.ApplicationDatabase, fileName, filePath)
Dim fileData As New XFFile(fileDataInfo, String.Empty, fileBytes)
brapi.FileSystem.InsertOrUpdateFile(si, fileData)	

Unfortunately, no resolution yet.

Hi Sergey!
Have you tried browsing to http://localhost:50002/OneStreamApp/SVC/XFFileSystem.svc you might find more info.

Also did you check that the extension is on the filename? My understanding is that the fileBytes is already good on your side? Have you tested it? for example using https://base64.guru/converter/decode/file

Or Have you tried with the exact same base64 (byte) than with the other file or see if there is a difference? Have you hard coded the fileName instead to "test.csv" or "test.xls" depending on the filetype?

'Export Register
Dim fileName As String = "Register.csv"

'Export CSV to User Temp Folder
Dim csv As String = Me.CreateRegisterTableCSVText(si, profileName, scenarioName, timeName).ToString
Dim fileBytes As Byte() = Encoding.UTF8.GetBytes(csv)
BRApi.Utilities.SaveFileBytesToUserTempFolder(si, si.UserName, fileName, fileBytes)

We're getting a similar error:

Here's the section of the code that gets the CSV string that is converted to Byte:

                Dim ds As New DataSet
				Dim csvContent As New Text.StringBuilder
				Dim qualifier As String = StageConstants.ParserDefaults.DefaultQuoteCharacter
				Dim delimiter As String = StageConstants.ParserDefaults.DefaultDelimiter
				
				csvContent.AppendLine("Intercompany Detail")
				csvContent.AppendLine("Workflow Profile: " & WFProfile)
				csvContent.AppendLine("Workflow Scenario: " & WFScenario)
				csvContent.AppendLine("Workflow Time: " & WFTime)			

                Dim methodQuery As String = "{" & WFProfile & "}{" & WFScenario & "}{" & WFTime & "}{}{}{V#[YTD]}{True}{}{}{}{}{}" 

                If Not String.IsNullOrEmpty(WFTime) Then
                    Using dbConnApp As DbConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)					
                        ds = BRApi.Database.ExecuteMethodCommand(dbConnApp, XFCommandMethodTypeId.ICMatchingForWorkflowUnitMultiPlug, methodQuery, "PlugAccounts", Nothing)
"Get the IC Detail"
						'Export the data
						Dim fileName As String = "IC_Detail.csv"

						'********* debug info *********	
						brapi.ErrorLog.LogMessage(si, "ADU_SoluitonHelper.Extract_WFU_IC_Matching_Plug_Accounts" & vbCrLf & 
														"csvContent: " & csvContent.Length)
						'****************************** 					
						'Export csvContent to User Temp Folder
						Dim fileBytes As Byte() = Encoding.UTF8.GetBytes(csvContent.ToString)
	'					Threading.Thread.Sleep(5000) ' 5000 milliseconds = 5 seconds
						BRApi.Utilities.SaveFileBytesToUserTempFolder(si, si.UserName, fileName, fileBytes)
						
					End Using
				End If

The application is on the cloud so we can't use http://localhost:50002/OneStreamApp/SVC/XFFileSystem.svc

Hi All,

Did anybody get any resolution to their .csv export problem? We're facing similar issues, but it affects some users and not others....and we can't see what the common theme is between them.

Thanks

What if you try to save it as an application file instead of a temp user file? Does that work?

Hi,

In our case, we are posting CSV file to Batch Harvest folder, not user temp folder. Do we have any samples to create application CSV file through BR?

Hi All,

I ran into the same issue earlier today and managed to get it working, so I wanted to share the solution in case it helps others.

In my case, the error was caused by an invalid path name. The SaveFileBytesToUserTempFolder function saves the file to the temp folder, and then my dashboard button tries to open that path. I was using a |UserName| substitution variable in the Navigation Arguments. However, since the username contained spaces, the system couldn't locate the path correctly.

To resolve this, I created an XFBR rule to trim the spaces from the username, and now everything works as expected.