DV7 Data Import & Export March 24 2021

[Music] [Applause] [Music] [Applause] [Music] [Applause] okay thank you again um this is module four in our drain view advanced training and this is going to be on data importing and exporting so drain view pro and enterprise this is this has the uh this is compatible with both versions of them have the ability to import various data formats and export into a couple data formats so we're going to cover them individually let's briefly talk about the uh the import capability and that's really a file open so if i go file and i go open you can see on path to the sag directivity subfolder that i have but if you look here just like any windows program i have the ability to pull down the file type here so you can see a heck of a lot of information here so you can see all of our various instruments listed here from current instruments to a lot of our legacy products as well but you can also see a pq diff format you can see a comtrade format so really those are the there's kind of three different things that you're going to be importing in general the first one is just open up a file from an instrument likely today that's coming from our hdbq family possibly from our px5 family which is here in the list somewhere i'm missing it um but also you know those come directly from instruments but also you can open up a pq diff file so if you have uh some product that recorded or software that recorded in a pq diff file as well as comtrade files so contrate is going to have some sort of oscillography maybe from a dfr or some other information so bqdf is an industry format ieee 1159.3 and comtrade is c37.1 or something like that don't don't hold me to that but it is also a an industry standard so to open up a file you would just simply do file and open and you would select it in that format that's exactly what i did before when i opened up our sag directivity example in our last section i just opened the pq diff format for here you can see it's recorded sag directivity pq diff open now i've added another tab or it's adding another tab right now with that file format so it's that simple so um when you import data it's more like opening files now exporting data that's extremely powerful maybe you want to export it to go do your own work in um in excel or something more advanced than mathcad or other uh math packages so drainview has the ability to export most of the time it's in a comment eliminated the lipid delineated format if i can speak or tab delineated or other type of format so it's the process of either doing one of two things you can take the data from drainview and what i mean by data you can take a timeline everything that's in a timeline or at a particular zoom level or you can take the wave shapes here depends upon which pane is the active pane so you have the ability to export that simply sometimes copy it from the clipboard and paste it into excel or another application or save it off as a text file that file can then be imported into excel or any other package that's extremely uh standard way it's it's very old way but it's an extremely standard way of taking sample data and again whether it be sampled on the journal level from the instruments in the timeline or digitized on 512 samples per cycle in the instrument so how do we do that so you can easily you could select any of the active pane then i go to the uh view tab and in fact let me select this and you can see the data table that's what we're talking about so anything that you see plotted or graphed in drain view is just simply drain views um plotting what came from the instrument or it's been recomputed on an xy plot so if i just click data table and you'll see it's processing it this is a pretty large file all right now you can see it's weak it's it's not recomputed it's displayed all the things that we have plotted here all right so what i'm going to do is actually simplify this i'm going to close this out and just make it a little easier on us as we import and export in our examples so i'm going to right click properties and i am going to only turn on the value recorded by the instruments i shut off max i've shut off min and this this is the just of journal value that's been recorded by the instrument and these are just the high low limits so i'm going to turn those off as well now when i go data table you will very simply just see the time and you will see the value at that time so here's the x-axis the time and you can see here's the y-axis the actual value that you see again what i'm doing i have the data points for this graph over here and this is the the voltage response to the step load changes that we have in this particular example file so now what can i do with this you just simply right click if you want to copy this information to the clipboard and then go paste it into another application so i right click i can say copy now it's going to ask you well what format do you want to cop well for this this example i'm going to copy and paste it to an excel spreadsheet so i'm going to make this a tab delineated file just because it's easier to copy and paste so this is going to ask me what i want to do as for as far as the time the time stamps just want to show the true the full time stamp which you see here or do i want just time difference relative to the time stamp of the first row so offset or do i want the time difference from row to row this is the the difference in the journal intervals so you can do different formats and and how do i treat decimals and different things so i'm going to just click ok or click ok and we'll just let it work now i'm going to switch over to excel i'm going to open a blank spreadsheet i'm going to simply go right click i'm going to say paste and you can see the values recorded here this is exactly if i just alt tab back over to drain view you look at that first value 480.3 look i got 480.3 and just to show you let's just do a very quick plot where i go uh insert i'm going to just create a graph here a line chart in excel doesn't that look familiar so if i just expand upon this you can see this is the the trend of the voltage that i have in trend use so get a visual image of that i go switch back to tranview and you can see they are the same i'll make i'll maximize this okay so now i've put this in excel i can do anything that excel can do with this information and and this is just what you see here for the time this is just the number format here so you would have to change the number format right over here in excel to make this the time date down to the millisecond so don't be worried about what you see over here all right so hopefully hopefully that's clear now how do i save and export the data so i go to my data table again so uh you saw before how i did it and it's very similar to before except i do file save as and i create a file name so i'm going to just add ross to this because i already have a file of that that format click save and it's going to bring me that same selection option that i had before so again i can i can do how it's going to save the time the timelines what it's going to do with the decimal points and more importantly what is the delineation of this so i'm going to make this a comma delineated file much more uh common way of doing things so i'm going to click ok see drainview just did its thing now i'm going to switch back to excel i'm going to open up a new tab in excel i'm going to go to i think it's data from text that allows me to do this within an individual tab and let me just path over and if i change this to all files oops [Music] i'm sorry i'm in the wrong folder i apologize for that this is in the generator tests so this is the file that i just created right here i'm going to import that file now i'm going to go through the standard excel prompts when you import a csv or or a tab deleted file so this is going to be delineated it has headers and i'm going to click next this is just a wizard in excel and this is comma delineated now you can see over here excel has detected the file so i could have done a tab delineated if i wanted to but i said comma and you can see here's the the x-axis here's the y-axis i click next it's going to ask me some other things as far as the type but we can just use the excel defaults i'm going to just say finish and it's going to ask me where i want to put this i'm going to just click ok now you can see it's the exact same data that we have before so if i go to our first tab this is what we exported or just widened this a little bit get them the same width versus similar this is what we copied and pasted from the first time and this is what i exported and imported and just to show you we're going to regenerate the plot i go to insert i go to a large chart select the chart and you can see this is the exact same thing if i had that i have in tab one here which is also the exact same plot that we have within drain view so very very simple again exporting you then you can go import to any other package and when you want to import data into drain view it's a file and open that accomplishes that you

Channel: DranetzTech

Views: 637

Keywords:

Id: ap54g6vK7fI

Length: 10min 49sec (649 seconds)

Published: Fri Mar 26 2021