rfg_drawer or OTDR Editor

Introduction

Not so long ago, I was transferred to the office, to the design and engineering department. I worked as a communications installer in one small organization in the city. Then there was a promotion to a more prestigious position in the organization - a fiber fiber splinder. This whole action took place within 3 years.



During this time we have built many objects in the city and by regions, including entire cities entangled with the FTTH / FTTB network, so experience in building and maintaining some documentation already existed.



They transferred me to the PTO at the very peak of the documentation, by the end of the year they closed two large objects in different cities. They put them at the computer, explained what was missing, gave the data and determined the deadlines.

')

This is where the fun began.

Go

They gave me the most unpleasant task, it was necessary to make OTDR reports on all measurements that were carried out throughout the construction. Since there were two objects, and the reflectometer was rushed here and there, we did not have all the measurements. There was also no input control carried out when the optical cable arrived at the warehouse before it was laid. How do they usually act in cases when the train left and did not return anything? Begin to rummage in old reflectograms and look for data similar in length. They were not as many as we would like. I decided to search the Internet for programs of reflectograms, there were such, but they were paid. Many of the things that I tried were the usual Viewers, there were online simulators for “making” ref.



I have been searching the Internet for a long time in search of the SOR file structure, it hasn’t been crowned with anything good. Here, purely by chance, in the OTDR View program from SVPRIBOR I found the data export to a CSV file. And when I opened this file with Notepad, I was extremely happy to see there:

0,000000; -17,723000

0.003267; -0.863000

0.006535; -0.863000

0.009802; -0.863000

0,013070; -0,863000

0.016337; -0.863000

0.019604; -0.863000

0.022872; -2.445000

0.026139; -4.276000

...

4,982791; -21,518999

4.986059; -19.915001

4,989326; -22,038000

4.992593; -25.032000

4.995861; -39,894001

4,999128; -39,894001

These were the X, Y values ​​for the graph.



Here it remains the case for small, take Delphi, component TChart and draw a graph using the modified data. The data had to be corrected manually in Excel, but the result was not long in coming.

Main program window

Skills

• Range selection;

• Download data in CSV, TXT format (both exported CSV and processed by CSV, TXT);

• Saving data in CSV, TXT formats (for future change);

• Saving in BMP format (for future use in the OTDR report).

The result of the program

Total

In a short time, a program was written that could draw a trace of any complexity. It depended, of course, on fantasy and certain standards and conditions.



I will not upload the full program listing, there is nothing special and complicated in it.



Thanks for attention!