topic Re: When will get "File has wrong format " as an Error in script? in App Development

When will get "File has wrong format " as an Error in script?

punitpopli — Wed, 16 Feb 2022 09:46:44 GMT

Hello,

I am working on handling error in Qlik Sense script and wanted to know if any one has encountered "File has wrong format" error and when exactly we receive this error?

Any help is much appreciated

thanks in advance

Re: When will get "File has wrong format " as an Error in script?

punitpopli — Thu, 17 Feb 2022 14:16:05 GMT

@sunny_talwar , @Gysbert_Wassenaar , @jagan , @tresB

Any input on this would be really helpful

Re: When will get "File has wrong format " as an Error in script?

Patricia_Silva — Thu, 17 Feb 2022 17:31:06 GMT

Hello @punitpoplil, would you have the script log? We could check if we can see further information on there. Thank you!

Re: When will get "File has wrong format " as an Error in script?

punitpopli — Fri, 18 Feb 2022 10:27:30 GMT

Hi @Patricia_Silva

I am not getting the mentioned error in my script.

I wanted to know when we usually get this error? as am working on handling all the errors in the script and want to handle this one as well upfront in my script.

Can you please let me now when we get this error? its when reading the data from file in some other format?

Re: When will get "File has wrong format " as an Error in script?

Gysbert_Wassenaar — Fri, 18 Feb 2022 12:39:26 GMT

You can get that error when the file format you specified doesn't match the real format. For example you specify loading from an xls file, but it's actually an xlsx file. Or you specify a csv format (txt with a comma as delimiter), but the file is zipped.

Re: When will get "File has wrong format " as an Error in script?

Patricia_Silva — Fri, 18 Feb 2022 14:25:44 GMT

Hello @punitpopli, sorry, I understood you had this error when you executed your script. I can confirm what @Gysbert_Wassenaar said. Thanks a lot!

Re: When will get "File has wrong format " as an Error in script?

ashish1504 — Mon, 07 Nov 2022 14:45:00 GMT

Hi @Gysbert_Wassenaar , @Patricia_Silva and @punitpopli Even i am getting this type of error i have tried to debug the script below is the error i am getting.

ScriptErrorCount 1
ScriptErrorDetails QVX_UNKNOWN_ERROR:
ScriptErrorList File Has Wrong Format
ScriptError File Has Wrong Format
LongDayNames "Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday"
DayNames "Mon;Tue;Wed;Thu;Fri;Sat;Sun"
LongMonthNames "January;February;March;April;May;June;July;August;September;October;November;December"
MonthNames "Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec"
CollationLocale "en-US"
FirstMonthOfYear 1
ReferenceDay 0
BrokenWeeks 1
FirstWeekDay 6
TimestampFormat "M/D/YYYY h:mm:ss[.fff] TT"
DateFormat "M/D/YYYY"
TimeFormat "h:mm:ss TT"
MoneyFormat "$#,##0.00;-$#,##0.00"
MoneyDecimalSep "."
MoneyThousandSep ","
DecimalSep "."
ThousandSep ","
OpenUrlTimeout 86400
StripComments 1
ErrorMode 1
WinRoot "C:"
WinPath "C:\Windows"
QvWorkRoot "D:"
QvWorkPath "D:\DEV\DATA\GenerationQVDQlikView\SALES\Stock"
QvRoot "C:"
QvPath "C:\Program Files\QlikView"
CD "C:"

Can you please help me with this ?? Thank you in advance.