der-vet

Open full view…

Errors reading PV production data

sophie_t
Tue, 05 Oct 2021 18:12:06 GMT

I have tried to upload a solar generation profile but keep getting this error message: "Invalid Data: This file has 35136 entries. It must have 35040." My file does have 35040 entries and there is no blank cell in between. It's a csv file. Please help! [Capture for DERVET](//muut.com/u/der-vet/s1/:der-vet:rrGE:capturefordervet.png.jpg)

Andrew Etringer, EPRI
Tue, 05 Oct 2021 18:32:27 GMT

The file must have exactly 35040 lines with a single numeric value on each line. Beneath the 'Invalid Data' error message in DER-VET, is there another error message describing the 'Invalid Rows'?

sophie_t
Tue, 05 Oct 2021 19:24:39 GMT

"Invalid Data: This file has 35136 entries. It must have 35040 35136 Invalid Rows: each row must have 1 value : Line Numbers: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,...]" I have 1 value in each row.

Andrew Etringer, EPRI
Tue, 05 Oct 2021 20:36:45 GMT

Thank you--this is helpful. It seems that DER-VET is finding more than one value on each row. In what format was the Excel spreadsheet saved?

sophie_t
Tue, 05 Oct 2021 20:44:02 GMT

Thank you Andrew for looking into this. It was saved as .csv. I believe that's the right format? I also tried .txt but the same error occurred.

Andrew Etringer, EPRI
Tue, 05 Oct 2021 20:49:00 GMT

Can you confirm that you are using v1.1.2 of the DER-VET app? This is the latest version. I'd be happy to take a look at the file to further troubleshoot this issue. Can you please send me the file to : aetringer -at- epri.com

sophie_t
Tue, 05 Oct 2021 20:50:09 GMT

Yes, it is the latest version. I'll send you the PV production file. Thank you very much!