Helios210 Posted July 2, 2018 Posted July 2, 2018 Hi all,I would like to check the parameters for a large number of modules across several manufacturers against parameters I have stored in a database (from manufacturer's datasheets). I'm comparing over 100 modules so doing this manually is not really an option.I am able to perform an automated comparison using Python to parse .PAN files which I myself have added, however I have been unable to locate the .PAN files for the modules which are already included in PVsyst. I did find a "PVModuleDB_V6" CSV which looked promising for a direct Excel-based comparison but the file doesn't appear to be human-readable, or the file uses a very strange encoding scheme.I have thought that PVsyst shipped with .PAN files for all the modules used in the program but perhaps this was for an earlier version.Can anyone shed some light on how I might achieve the above?
Helios210 Posted July 2, 2018 Author Posted July 2, 2018 Okay so for anyone else who comes across this I figured out how to do it, its not ideal but its better than a manual check.1) Open PVsyst, go to "Databases" then PV Moduiles2) Select the modules you wish to export, hold CTRL to select more than one, I'd recommend doing this in batches of ten as one wrong click will send you back to square 1.3) Click 'export' - this will copy the data to the clipboard4) Paste the data into the PVsyst database file located at C:\Program Files (x86)\PVsyst6.7.3\DataRO\PVsyst660_Data\Userdata\Components.xls5) Use the data import tool to correct any formatting errors6) Perform your comparisons!Why the module data isn't stored as ASCII like the pumps etc I don't know. This is a needlessly arduous process that I could have circumvented in an hour with Python, but instead I'm forced to use a rather inefficient copy-and-paste method with the GUI - frustrating!In any case I solved the immediate problem, I hope this is of use to someone.
dtarin Posted July 12, 2018 Posted July 12, 2018 Thanks for this tip, it is something we will be doing ourselves soon.
Helios210 Posted July 18, 2018 Author Posted July 18, 2018 Thanks for this tip, it is something we will be doing ourselves soon. No problem, glad to help, if you come up with a better solution let me know, I'd love to be able to run these comparisons programmatically.Best,H
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now