Loss ends on a cable tester

[08anja]

Hi everyone,

I got a system to test the impedans of a connection in a USB cable handed over to me by a fellow student and I need to implement some new features. I'll hope you can give me some ideas how to implement these things. The system is attached so you can see what i'm working with. Some of the things I need to implement is:

- A totale time for which the system is running should be shown in the the "New case" . (Should I use a timestamp or an elapsed time or a third thing?)
- There is a HW part to this, which runs in cycles and I'll like to count for every time. It's a motor that goes from left to right while holding the USB cable. When goes from left to right it's one cycle. This number should also been shown in the "New case". 

- When the impedans is out of my thredshold, it should be shown in the to boxes to the left. 

- I'll also like to save some of the data to at txt. file or similar. For example from the moment the connection fails, i'll like to save the last 100 cycles. 

I hope you'll just be able to give me som ideas and please let me know if you need further details. 

The whole system also contain a dummy PCB which further contain diffrent connectors for the cable i'll like to test. 

Thanks in advance.

[NapDynamite]

You can use Write to Spreadsheet function to save your data to an excel file. To monitor the total time, YES you can elapsed time function. 

Now for counting cycles for motors, is there any mechanism which triggers a signal as it reaches right from left. (I'm talking about some sort of "switch")? Please elaborate on these lines.

Regards.

[Bob_Schor]

Aha, the first LabVIEW 2015 VI I've seen on the Forum!  A suggestion -- many of us might not (yet) have LabVIEW 2015 installed.  If your VI isn't too big (meaning screen size), consider saving it as a Snippet.  Those of us running LabVIEW 2014 still won't be able to open it in LabVIEW, but we'll at least be able to see it.  Before James Morris jumps all over me, do not simply post a picture (a JPEG or an "ordinary" PNG), as those with 2015 won't be able to drag the picture to an empty LabVIEW 2015 Block Diagram and have it magically become code (they'll swear at you, instead).

My other Pet Peeve is people who say that Write to Spreadsheet File produces an Excel file.  It does not.  It produces a 

[Bob_Schor]

Oops, that got away from me.  I was ranting about Write to Spreadsheet File.  It produces a <character-delimited> file, where the default delimiter is a tab.  If you happen to name it with the .csv extension, most installations of Excel will "trap" this extension and open the file, by default, with Excel.  CSV means "Comma Separated Variables", and Excel, when it sees .csv, assumes that the file has commas to separate numbers.  But if, for example, you run the following test routine and specify a .csv extension, Excel will show you a view with "012" in the first cell and everything else empty.

Just be careful.

 

Bob Schor

[JÞB]

And, While we all are ranting,

Why are you not asking your fellow student to document the (Swearing words) code that you were given?

[08anja]

With the elapsed time function, how do i connected to my code and what should I be aware of when using it? 

There is a relay build into it, which makes it stop at and angle of 70 deg +/- on both sides. It looks like this: 

And i tried with the Snippet tool

[08anja]

An according to you Write to Spreadsheet .. could I use Write to Measurement File istead if i like to have more data collected fx in colums. It could look something like this: 

----------------------------------------------------------------------
      Cycles #         |          Resistance           |      Status

----------------------------------------------------------------------

                              |                                          |

Sorry for all these post. Im new to this forum and are suprised that a can't delete and only edit for at short period.. 

[mikeporter]

Uh Bob, I don't know how to break this to you but " Write to Spreadsheet File " doesn't exist in 2015... 😱

Mike...

[JÞB]

---

@mikeporter wrote:
Uh Bob, I don't know how to break this to you but " Write to Spreadsheet File " doesn't exist in 2015... 😱

Mike...

---

????

I guess I do need some mail delivered!  Or, at least, a few days to down-load 56 products

[Bob_Schor]

In LabVIEW 2015, NI changed the name (and the Icon) of Write to Spreadsheet File to "Write Delimited Spreadsheet", possibly in an attempt to get people to no longer think they were "writing an Excel File".  I know that my set of LabVIEW 2015 disks haven't yet arrived (it's only been "out" less than three weeks), and I'm willing to guess that 95% of the readers of this Forum are not using it.  All of the remarks I made for "Write to Spreadsheet File" are also applicable to "Write Delimited Spreadsheet".

Bob Schor