Skip to content
/ EDM Public

Configurable data collection program for archaeological survey and excavation

License

Notifications You must be signed in to change notification settings

surf3s/EDM

Repository files navigation

EDMpy (Beta)

The Python version of EDM-Mobile and EDMWin.

This is now a Beta version which means that I am ready for other people to try to use it in field situations. Beta means that I have eliminated the bugs that I know of but a) there are still bugs and b) users should proceed with some caution. I would also recommend that if you do not have time to test extensively before going into the field, you should also have a backup option (e.g. EDM-Mobile or EDMWin). By summer 2023 I will know better how the program is working.

If you want to work with the source code rather than the Windows distributable provided here (see Windows folder), you can clone this repository, setup a virtual environment, and install the required packages (pip -r requirements.txt). I don't advise doing this for now unless you are keen in part because I will be making modifications a lot leading up to the summer of 2023. If you are Mac user (or Linux), then the fastest way to start using the program is by installing it from PyPi (see below).

Installation

Windows

A Windows exe file can be found in the Windows folder listed above or click here to download directly. Download this file, place it in a folder where you want to start your data entry, and launch the program.

I have tested EDMpy thus far on several Windows 10 and 11 computers. I also have it running on an ARM ChromeBook (non-ARM ChromeBooks should work as well). One user has reported that it runs on a Microsoft tablet running Windows 11. Another user is running it on Topcon tablets without issues. I doubt it works on Windows 7 and it almost certainly does not work on Windows XP, but you really, really should not be using computers with either of those operating systems.

If you get a Windows error telling you that the program is incompatible with Windows 10 or 11, be sure that you have downloaded the complete program. I have found that you can run a partially downloaded exe, in which case Windows will give an incompatability error. Also, when you first run the program, Windows may tell you the program is dangerous. Just work your way around these blocks and run it anyway.

Mac OS

These instructions are similar to what is required for Linux. Let me know if these instructions do not work. I am not sure about python3-pip versus pip. You may need to install pip instead of python3-pip with sudo apt install pip. If python3 does not work, then try typing just python. This will put you into python and tell you the version number. Exit python with quit(). If the version is 3.0 or above, then you can replace python3 below with python.

pip install edm-arch --user
python3 -m edmpy

If you already have edm-arch installed, you can upgrade it as follows.

pip install --upgrade edm-arch
Android

I am not sure I will do an Android version or not. I have look into how to connect a phone to a total station, and it doesn't look straightforward even with BlueTooth. I will keep looking at this option. Better will be to use a ChromeBook I think.

Linux and ChromeBooks

I have run the program on Linux, on the Linux subsystem for Windows, and on the Linux subsystem for ChromeBooks. On ChromeBooks, I have tested a cabled connection to a Leica total station. I used a serial to USB cable, and when connected to the ChromeBook I was given the option to make it a serial port in Linux. Once this was done, I was able to configure EDM to see that port and to record points. On Windows Linux, I didn't have to do anything special and it worked like it was Windows. On pure Linux, I am not sure, but if you know Linux then you must know how to install this type of connection (USB and serial).

pip install edm-arch
python -m edmpy

If you already have edm-arch installed, you can upgrade it as follows.

pip install --upgrade edm-arch

When it crashes.

For me, this version works without crashing. But I know that other people using the program in different ways on different computers with different total stations will find bugs that crash the program. To help me fix these problems, I recommend the following.

First, send me the output from the program. If you are running directly from Python, you will get an error messsage that you can capture and send to me. If you are on Windows and using the EDM.EXE provided here, the error message appears on a screen that instantly closes and is lost. In those cases there are two methods to get me the error. One, you can run the program from the command prompt instead of double-clicking it. To do this, open a command prompt (cmd on Windows computers), navigate to the folder with the program, and run it by typing edm.exe. Replicate your error and you should see the output there in your command prompt window. Send this to me. Two, there may be log files in a folder that looks something like this - C:\Users\username.kivy\logs\ where username is the name you use to log into Windows. Note that the . before kivy may make the folder invisible. You can get by that by telling Windows Explorer to show hidden files or by typing the path directly into the navigation box. Have a look at the txt files in the log folder and the latest one should contain information on the program crash.

Second, when you write me, it is usually best to have the CFG and JSON file as well so I can fully replicate the problem.

Third, recently I have found that using your phone to record a video of what you are doing to crash the program saves a lot of time for you trying to explain to me what happened. This step is optional though.

I am sorry when the program crashes as I want this to be as stable and useful as possible. And I am very appreciative when you contact me for help. While you may be worried about bothering me, at the same time, you will be saving others a lot of wasted time trying to solve a problem.

What total station should I use?

Currently EDM is tested on Topcon and Leica. For Topcon, I tested (in January of 2023) a model GM-55/EBL. Topcon has kept their communication protocols very consistent over the last forty years. The first version of this program was written for a Topcon GTS-3B, and I didn't change the code at all to work on the brand new GM-55. My guess is that EDM will work on virtually any basic model of Topcon total station. For Leica, I have tested an older Builder R200M, an older TCR403, a newer TS13 and a newer TS07. Over the years, Leica introduced a new communications protocol called GeoCOM. For a while I think some stations supported both the old protocol and the new GeoCOM. Now I think they only support GeoCOM. EDM supports both. EDM now also works with GeoMax stations.

In the past EDM also worked with Sokkia stations. I think I could make it work again with Sokkia stations, but I need someone to help me test them. The same is true for Nokkia stations, though here I think I never had a successful test. If someone wants to work with me on it, I am willing to try again. If you are a programmer, make the code work with these types, place a pull request, and I will put the code into the main program here.

This version of EDM also works with Microscribes. These are instruments built for taking 3D coordinates from objects. However, we adapted them to excavate sediment blocks in the laboratory. EDM will allow you to georeference these blocks so that as you record points, the XYZ coordinates are excavation grid coordinates rather than coordinates local to the Microscribe only.

What computer should I use?

Currently EDM is only fully tested on Windows 10 and 11. However, the libraries used here are specifically designed to work on Windows, Linux, MacOS and even Android. The only issue I see is serial port drivers (but see also below BlueTooth). In the coming months, I will be testing EDM on a variety of platforms including ChromeOS. If you have experience running it on other platforms, please let me know. For Android, I will have to produce a separate installation that I hope to work on soon.

The main issues with a field computer are battery life and durability. Now that the new program is written, I am looking for good field computers. I have run both EDMWin and this version of EDM on a Topcon FC-6000 Geo Cell CE 128GB tablet with Windows 10. This tablet is ruggized and comes with an exchangeable battery. I will know better how they work in a few months, but it seems like a good solution. I have also tested it on a reconditioned Panasonic ToughBook. A fuller test of this unit will happen in the summer of 2024. And I know a team using the Juniper Systems Mesa 2. This looks a lot like the Topcon FC-6000. I haven't used one myself, but a team will be using it in summer 2024.

How should I connect a computer to a total station?

There are two ways to connect to a total station: serial and BlueTooth. Up to now, I only have experience with serial. However, serial is not easy these days, and one of the main reasons I rewrote the program was to provide better support for BlueTooth. Serial on a modern computer really means USB. By far the easiest solution is to purchase a USB cable designed to work with your total station (by two - cables can fail - and don't buy cheap cables). In the past, these cables sometimes also required a driver. Alternatively, if you already have a serial cable for your total station, you can buy a serial to USB converter cable. These are inexpensive and relatively easy to find. You can have them in both USB Type A and C formats. It may be less of an issue today, but in the past some serial to USB cables used chipsets that were not compatible with some computers. Solving this problem will just take a bit of Internet research. When the total station and computer are cabled, you will need to set the communications parameters in the station and in the EDM program. I suggest using something slow and simple like 2400 (or 1200), E, 7, 1 (I have used 1200 baud, 7 databits, 1 stopbit and even parity since 1987). If it works and you want to experiment with higher speeds, you can. But start slow. You will need to put the same settings into EDM and you will need to specify the COM port. This latter can be a bit tricky, but EDM will scan your system to find available COM ports and from there you can test them. If you are good with Windows device manager, you can typically find the COM port assigned to the USB cable there. You can also use the Setup Test COM screen to see what is being sent to and received from the total station.

BlueTooth is also an option, and it works better and better these days. First, of course, you need a BlueTooth equipped total station. Enable BlueTooth in your station. On the Leica TS07 there is no option to enter communications parameteres. On the TS13 you could (but I am not sure it matters). If you can set parameters, set them to something simple like 2400 baud, 7 databits, 1 stopbit, and even parity. Second, enable BlueTooth on your computer and pair with the station. For Leica, you might see more than one option for pairing. When I tested it, the total station appeared as TS followed by a string of 7 digits (rather than an option like TPS radio LR BT). Connecting to it might mean entering a code (it is 0000 for Leica and 1111 for Topcon). Third, you will need to specify the COM port and the same protocol information (2400, E, 7, 1) in EDM (note: you don't need to set this in the Windows device manager - EDM will override these). Trying to work out which COM port is the correct one can be challenging. EDM will scan the available ports and report back. Then you can try each. To test the connection, use the Measure button on the main screen. You can also use the Setup Test COM screen to see what is being sent to and received from the total station. Note that until you have communications working, the program will be extremely slow while it tries to access to the communication ports.

I don't have a lot of experience yet with BlueTooth but I know others that do use it with older version of this program. For both BlueTooth and serial, making it work the first time can be a bit of a challenge, but once it works, it tends to work thereafter. Note that BlueTooth will draw more power than serial. If battery life is an issue, you might want to consider serial. It is also good to have a serial option as a backup.

Important - On Windows 11, when you scan for the total station to connect via BlueTooth, there is a new setting called "Bluetooth devices discovery". This needs to be set to Advanced for the Bluetooth scan to find the total station.

What data format does EDM use?

This new EDM program uses a plain text JSON database. The advantage to this is that the program easily runs on multiple platforms (i.e. Windows, MacOS, Linux) and the data are not locked in a proprietary format. The main downside I see to this format is that it is not as easy to view and repair the database as it was with Microsoft Access which gave a nice grid view of the data (like in spreadsheet program). However, as of version 1.0.31, I made an important change that makes the JSON files easy to read in a text editor (i.e. they are formatted nicely). It should now be easy to search for cases and view the data associated with each point. Changes made in the JSON file are reflected in the program. Still, while I understand that sometimes you need to edit your data this way, I still encourage doing it from within the program. Note that EDM will also export the data in CSV format. From there the data are easily imported into a number of different programs. However, changes made to the CSV file are not reflected in the program (you could re-import the CSV but I have not tested this and would not recommend it for now). CSV export is intended for when you want to move the data into another database.

How many points can I store in the database?

Short answer, I don't know. I have simulated having 1000 points in the database and it is still reasonably fast and responsive on my laptop. As you add more points, you can expect certain parts of the program to slow (e.g. opening the data grid to view all points). I never intended my programs to be the main database a person uses. I always envisioned doing some data entry with these programs (E5 and EDM) before moving the data into a real database. However, I know lots of people who keep their entire dataset in these programs. I think that is okay, but remember to always keep backups.

Why can't I plot the points with this program?

I am working on this. Once this program is working smoothly, I will add plot functionality.

Virus Warning

Recently (May, 2024) I was helping someone put the program on a Windows 10 tablet. However, the virus protection software (Microsoft) said the Windows exe version was a virus and immediately removed it. It took a lot of time to find a work around. Eventually we made exe programs a virus exception. This is not a great solution. I can assure you that edm.exe does not contain a virus. I also personally downloaded the same version and scanned it with my virus detection software. Nothing. I will try to find a computer where I can replicate this and see what part of my program is giving this problem. If you experience this as well, let me know.

Changes to Version 1.0.48

  1. Better error trapping of CSV export when there are bad characters.
  2. Better handling of CFG files moved between MacOS and Windows

Changes for Version 1.0.47 (August 6, 2024)

  1. Fixed problem with continuation shots that cross unit boundaries.

Changes for Version 1.0.45 (July 10, 2024)

  1. Added code to allow uploading data to cloud OSA type system

Changes for Version 1.0.45 (July 5, 2024)

  1. Some newer Leica models can return a valid hangle and vangle but a slope distance of 0 when the distance can't be measured. This is now error trapped. If the coordinates are the same as the station coordinates or if slope distance is zero, a message is displayed.
Changes for Version 1.0.44 (May 31, 2024)
  1. Fixed major bug with auto finding Unit based on XY
  2. Fixed other related issues stemming from this
Changes for Version 1.0.43 (May 20, 2024)
  1. Fixed bug that broke communication with older Leica instruments
Changes for Version 1.0.42 (May, 2024)
  1. Fixed bug where default values on speed buttons did not trigger linked fields
  2. Fixed bug where changing value of a field in edit screen did not trigger linked fields
Changes for Version 1.0.41 (May, 2024)
  1. Fixed crash when spamming Add button in menu in datagrid
Changes for Version 1.0.40 (Decemeber, 2023)
  1. GeoMax added by Tim Schueler
  2. Multiple bugs traps in datagrid
  3. Brought changes in E5 over and debugged more
  4. Added message to communication settings to let user know program is trying
  5. Fixed datum menu in setups (to not have add new)
  6. Added message when trying to do setups without having added datums
  7. Fixed a logic bug with units when also unit is set to carry
Changes for Version 1.0.39
  1. Fixed issue with Alpha default buttons not working
  2. Changed way checking if last two points are the same works
Changes for Version 1.0.38 (August, 2023)
  1. On startup program resumes with last setup coordinates for XYZ
Changes for Version 1.0.38 (August, 2023)
  1. On startup program resumes with last setup coordinates for XYZ
Changes for Version 1.0.37 (June, 2023)
  1. Fixed a bug in simulation mode
  2. Fixed very bad bug with popup window sizing that meant that sometimes prism didn't advance to edit screen
Changes for Vesion 1.0.36
  1. Redid font sizing for buttons and text
  2. Trapped a bug with units when switching CFGs
  3. Various bugs having to do with entering/editing data
  4. Add support for datumx, datumy, datumz (which is now called stationx, stationy, stationz)
Changes for Version 1.0.35 (May 24, 2023)
  1. Bug in file import fixed
  2. Bug in CFG when no field type is specified fixed as well
  3. Bug in Filter records that crashed program is fixed
  4. Importing CSV now takes seconds rather than many many minutes (tested on import of 3996 records)
  5. Saving a point is now faster when record count is high
  6. Reworked a number of features because JSON files are not in doc_id order
  7. Add a "SIMULATION mode on" warning to maing screen when simulating points
  8. Suffix values on import csv are retained as integers
  9. Tried to improve open CFG so that if a non-EDM CFG is opened, it is not also trashed
  10. Fixed important bugs in station setup when using Manual XYZ or Manual VHD options
  11. Error trap continuation shot on an empty data file
Changes for Version 1.0.34
  1. Yet more fixes for Windows/PyPi installations
Changes for Version 1.0.33
  1. Fixed installation issues
Changes for Version 1.0.32
  1. Fixing issues with GeoCom and station setup
Changes for Version 1.0.31
  1. Fixed issue with numeric values saved as text in JSON after initial save
  2. Added Help JSON to view raw data in JSON file
Changes for Version 1.0.31
  1. BlueTooth tested with Leica GeoCom stations
  2. UI fixes
  3. Tested with 1000 records in DB
  4. Made JSON files better formatted so that they are more human readable
  5. Made geoJSON files work with QGIS (points and lines are separate layers)
  6. Substantial refactoring of Python classes and file structure
Update (March 2, 2023)
  1. Added and debugged Topcon stations
  2. Added and debugged Leica and Leica GeoCom stations
  3. Stopped program from exiting when escape is pressed
  4. Fixed default locations for ini, log, and data
  5. Program remembers last size and location of the screen
  6. Repeat button added to measure screen
  7. Flag to not prompt for prism each point added to options screen
  8. Misc. prism height issues addressed
  9. X box added to text boxes to help clearing values on touchscreen computers
  10. Prism menu added to edit record with update of Z on prism height change
  11. Improved text sizing in buttons to include word wrapping and dynamic sizing
  12. Improved the default CFG and carry and increment issues
  13. Fixed button font size on open dialog
  14. Length checking implemented (length in CFG is enforced during data entry)
  15. Prompt values (from CFG when provided) are used in Edit last record and New Record instead of the field name
  16. Empty entries in MENUs are removed
  17. Better error trapping of mistakes in the CFG
  18. First shot on empty data table put 1 in increment fields
  19. Fields shown in CFG order on delete record in gridview
  20. Can do offsets in the datagrid using +-
  21. Added save and revert buttons to case saving in datagrid (i.e. no longer saves immediately)
  22. Basic editing shortcuts (like cntl-c etc.) work in text boxes
  23. BlueTooth working on Leica GeoCOM stations
  24. Multiple UI fixes
Update (July 21, 2022)
  1. Bugs in datagrid
  2. Bugs in data filter in edit last record
  3. Bug in starting path that meant a first CFG could not be opened
Update (July 18, 2022)
  1. Bugs in editing that converted numeric values to string values
Update (July 16, 2022)
  1. Microscribe setup asked for prism
  2. Manual XYZ or VDH didn't work for setups
  3. Welcome screen kept reappearing
Update (July 6, 2022)
  1. Improvements in CSV file import
  2. Some misc. bug fixing
  3. Added CSV export to EDMWin (see oldstoneage.com website)
Update (July 1, 2022)
  1. Tweaked the default CFG to carry unit and increment ID
  2. Changed how increment works a bit (should work properly now)
  3. Disabled multitouch to disable red dot on right mouse click
  4. Check to see if mdf or sdf file is specified (from EDMWin and EDM-Mobile).
  5. Change to json format and give warning#$
  6. Check to see if json file can be found
  7. If not, new empty file is created and warning given
  8. Prism height - whether menu or manual - carries between shots
  9. Prism height menu - works better with keyboard (enter key and arrow keys)
  10. A number of issues with using the program before opening a CFG fixed
Update (June 21, 2022)
  1. Fix a number of bugs (some of them important)
  2. Added a screen called Test COM to help test serial connections to the total station
  3. Started adding support for Sokkia. I need someone who can help me debug this.
  4. Made the logging actual log something useful.
  5. Create a PyPi project called edm-py so that Linux and MacOS users can easily install the program

About

Configurable data collection program for archaeological survey and excavation

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published