General Discussions
Excel Addon VTScada - Data Retrieval

Good afternoon,
My name is Joseph Rhodes, I work as an electronic technician for the City of Tuscaloosa's wastewater treatment plant. The other day, our chemist sent me an email asking for data about the HCR Creek Flow. I was lucky that I have a co-worker who's about to retire point me in the right direction. I was able to find the data I needed for our chemist. I had to go through a few hoops to get that data. At first, I tried exporting the data into a CSV file. When I opened the file using Excel. There was only information I did not need the rest was hashtagged out. I had to manually write the average creek flow numbers for certain dates of the month then hand it off to our chemist. I was wondering about that excel add-on for VTScada called Data Retrieval. I remember being part of a class during the last VTScadaFest in Orlando, but I did not remember enough to utilize that add on to pull information I needed from VTScada.

I've uploaded some pictures to better illustrate everything above:

The first picture is a highlighted screenshot of the data I needed to give to our chemist. The rest of the information was not needed.

The second picture is a screenshot of VTScada - Data Retrieval Add-On. You have to create a connection, which I have done so using my VTScada credentials. It never seems to connect to VTScada, so maybe I have the wrong server address. However, I'm not entirely sure that I do considering I use that server address anytime I want to access VTScada through VTScada Internet Client or Google Chrome. As you might see, it has been trying to connect to the server. It's been trying to connect for the last 10 minutes.

''' I can be reached by email: Joseph.Rhodes@Tuscaloosa.com '''
''' Office - (205)248-5925 '''

UPDATE / 10-13-2021
I'm including a screenshot of the excel CSV file exported from VTScada that shows hashtagged dates

6167291b233d6
6167291b2d29c 6167312419857

Good afternoon, My name is Joseph Rhodes, I work as an electronic technician for the City of Tuscaloosa's wastewater treatment plant. The other day, our chemist sent me an email asking for data about the HCR Creek Flow. I was lucky that I have a co-worker who's about to retire point me in the right direction. I was able to find the data I needed for our chemist. I had to go through a few hoops to get that data. At first, I tried exporting the data into a CSV file. When I opened the file using Excel. There was only information I did not need the rest was hashtagged out. I had to manually write the average creek flow numbers for certain dates of the month then hand it off to our chemist. I was wondering about that excel add-on for VTScada called Data Retrieval. I remember being part of a class during the last VTScadaFest in Orlando, but I did not remember enough to utilize that add on to pull information I needed from VTScada. I've uploaded some pictures to better illustrate everything above: The first picture is a highlighted screenshot of the data I needed to give to our chemist. The rest of the information was not needed. The second picture is a screenshot of VTScada - Data Retrieval Add-On. You have to create a connection, which I have done so using my VTScada credentials. It never seems to connect to VTScada, so maybe I have the wrong server address. However, I'm not entirely sure that I do considering I use that server address anytime I want to access VTScada through VTScada Internet Client or Google Chrome. As you might see, it has been trying to connect to the server. It's been trying to connect for the last 10 minutes. ''' I can be reached by email: Joseph.Rhodes@Tuscaloosa.com ''' ''' Office - (205)248-5925 ''' *** UPDATE / 10-13-2021 *** I'm including a screenshot of the excel CSV file exported from VTScada that shows hashtagged dates ![6167291b233d6](serve/attachment&path=6167291b233d6) ![6167291b2d29c](serve/attachment&path=6167291b2d29c) ![6167312419857](serve/attachment&path=6167312419857)

Electronic Technician for the City of Tuscaloosa working in Wastewater. Shelton State - Industrial Electronics and Electrical Technology AAS, Military Veteran - Infantry, CBRN(e) Technician: Airborne, Tech Escort, etc...., NERD of all things SCIENCE

edited Oct 13 at 8:19 pm
15
0
1
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft