dongash 0 Posted May 19, 2020 Report Share Posted May 19, 2020 Hi Martin, I am not sure what I am doing wrong. I am having a challenge uploading my last two (2) measured climate data files into PVSol. I have converted the files into .DAT format, as per the instructions but I keep getting "Conversion failed, Formatting error" message whenever I try to upload same into PVSol. I have attached the two (2) files for your kind review and support. Could you please convert them into .DAT file for me. I am using PVSOl Premium 2019 (R10) Thanks Dongash MLow Values.xlsx MHigh Values.xlsx Quote Link to post Share on other sites
developer_mh 79 Posted May 19, 2020 Report Share Posted May 19, 2020 Hi Dongash, I guess it is line 3, as mentioned in our previous conversation, and the whitespace (space) right after the column name "Ta". Copy the values from your Excel sheet to a text file, remove the (invisible) tabs in line 3 and at the end of lines 1 and 2, remoe also the whitespace after Ta in line 4 (only the space, not the tab), then save as *.dat. That should work. This doesn't import. This works. Hope that helps, kind regards, Martin Quote Link to post Share on other sites
dongash 0 Posted May 21, 2020 Author Report Share Posted May 21, 2020 Thank you. Problem solved. Dongash Quote Link to post Share on other sites
Nasr 0 Posted Tuesday at 02:19 PM Report Share Posted Tuesday at 02:19 PM weather.dat I am getting this error can you please fix this error "Conversion failed, Formatting error" Diamond_Tyres-hour_modified.dat Quote Link to post Share on other sites
developer_mh 79 Posted Tuesday at 02:54 PM Report Share Posted Tuesday at 02:54 PM Hello Nasr, there are values missing at the end of the file. You should provide 8760 rows with values, one row for each hour of the year. So, including the header, the last line number of the file should be 8764. Kind regards, Martin Quote Link to post Share on other sites
Nasr 0 Posted Tuesday at 03:12 PM Report Share Posted Tuesday at 03:12 PM Diamond_Tyres-hour.datsame issue with this file Quote Link to post Share on other sites
developer_mh 79 Posted Tuesday at 03:16 PM Report Share Posted Tuesday at 03:16 PM Hallo again, here the header seems to be the problem: Remove the " from the second line Replace the space between Ta and Gh and Gh and FF with a tab (\t) Kind regards, Martin Quote Link to post Share on other sites
Nasr 0 Posted Tuesday at 04:21 PM Report Share Posted Tuesday at 04:21 PM 1.which text editor you are using 2.can you please explain what do you mean by a tab between Ta and Gh and Gh and FF 3. i tried this it doesn't worked for me i have also attached the screenshot and file. 4.can you please update the file and send it to me. Diamond_Tyres-hour.dat Quote Link to post Share on other sites
developer_fw 4 Posted Wednesday at 06:45 AM Report Share Posted Wednesday at 06:45 AM Hi Nasr, 1. In this case it is https://notepad-plus-plus.org/, a free editor which can show you "hidden characters" like SPACE, TAB, NEWLINE and so on. View > Show Symbol > ... 2. TAB is a special character https://en.wikipedia.org/wiki/Tab_key#Tab_characters So in this case the \t is represented as string: and here as character: Best regards, Frederik Diamond_Tyres-hour_fixed.dat 1 Quote Link to post Share on other sites
Nasr 0 Posted Wednesday at 07:14 AM Report Share Posted Wednesday at 07:14 AM Thank you @developer_fw for the help. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.