Importing xlsx is not supported.
I am currently trying to make a workaround for Windows Server.
What I am doing so far is using a process like:
- New form where I upload the xlsx file.
- Export the file to the server.
- run a powershell script with EXECUTE PROGRAM that converts it to csv (sorry about the somewhat illogical variable names, this is not finished):
#Install-module PSExcel
Import-module PSExcel
$xlsxFile="HardwareImport.xlsx"
$csvname='C:\acme\'+$xlsxFile.replace('xlsx','csv')
$xlsFilePath='C:\acme\'+$xlsxFile
$rawFile = Import-XLSX -Path $xlsFilePath
$rawFile | Export-Csv $csvname -Encoding UTF8 -NoTypeInformation
- import the csv file from the server using a predefined template.
- profit, hopefully
My progress so far? All of the above steps are actually working for me, as long as the file doesn't have too many rows.
I can give more concrete information with proper AwareIM rules later if you want, but I can't access the BSV right now.
I also recommend having a look inside the database table, because chances are your failed xlsx import messed up the BO, making it impossible to display. Delete the row with messed up data if it exists.
