Data transfer from a scale to Excel
adeline
-
Alex_2030 Posted messages 1 Status Membre -
Alex_2030 Posted messages 1 Status Membre -
Hello,
I acquired a laboratory scale on which I perform weighings and I want to transfer this data into Excel cells. The seller of the scale does not sell this programming. I called on a computer scientist, but this programming is beyond his skills. If someone has such programming, is it possible to transfer it? If not, how can I find a solution?
Thank you.
I acquired a laboratory scale on which I perform weighings and I want to transfer this data into Excel cells. The seller of the scale does not sell this programming. I called on a computer scientist, but this programming is beyond his skills. If someone has such programming, is it possible to transfer it? If not, how can I find a solution?
Thank you.
4 réponses
Hello,
I work in a laboratory and all our scales are controlled by the Bill Redirect software from BillProduction. This small application sends the weight from our scales to Excel! This software supports all types of USB and RS232 scales; we have several brands of scales such as Mettler Toledo, Avery Berkel, Sartorius...) and they all work with this software.
The data can be sent to Excel via:
- Real-time to Excel via a DDE link (a free plugin does this)
- .XLS file
- Keyboard weight simulation (as if it was entered) we use this method!
For more information visit the following page:
http://www.billproduction.com/billscalebalance/INDEX_FR.HTML
By the way, the technical support is very quick!
Good luck
Éric D.
I work in a laboratory and all our scales are controlled by the Bill Redirect software from BillProduction. This small application sends the weight from our scales to Excel! This software supports all types of USB and RS232 scales; we have several brands of scales such as Mettler Toledo, Avery Berkel, Sartorius...) and they all work with this software.
The data can be sent to Excel via:
- Real-time to Excel via a DDE link (a free plugin does this)
- .XLS file
- Keyboard weight simulation (as if it was entered) we use this method!
For more information visit the following page:
http://www.billproduction.com/billscalebalance/INDEX_FR.HTML
By the way, the technical support is very quick!
Good luck
Éric D.
Hello
The first issue is to determine whether your scale is designed to transmit data to a PC, for example via a USB or RS232 connector or other... Indeed, quite a few do so...
This should be specified in the manual...
In that case, you should normally have an installation CD containing the software for the connection.
If this software exists, there should be a way to retrieve the data, for example in the form of a file, probably text. After that, retrieving data in Excel is just a matter of tinkering, probably quite simple.
Can you provide the exact brand and model of your scale, which would allow us to search first on the manufacturer's website...
Talk soon
Nyctaclope
The first issue is to determine whether your scale is designed to transmit data to a PC, for example via a USB or RS232 connector or other... Indeed, quite a few do so...
This should be specified in the manual...
In that case, you should normally have an installation CD containing the software for the connection.
If this software exists, there should be a way to retrieve the data, for example in the form of a file, probably text. After that, retrieving data in Excel is just a matter of tinkering, probably quite simple.
Can you provide the exact brand and model of your scale, which would allow us to search first on the manufacturer's website...
Talk soon
Nyctaclope
Hello,
Thank you for such a quick response. Yes, my scale has an RS232 output and a button labeled "print," but no CD was provided. When I connect it to my PC, the scale (THB 600 from AIP SYSTEMES) is recognized as a device. Of course, I called the manufacturer to request the log, but I was told that they don't provide it due to the large number of receiving software: Excel, Access, other specific lab logs... So I searched their website and found nothing. That's why I called in an IT specialist who also found nothing. Therefore, I need to find someone who uses a scale and transfers data to Excel, so I can obtain that log to see if the transfer program is compatible. Any advice...?
Thank you for such a quick response. Yes, my scale has an RS232 output and a button labeled "print," but no CD was provided. When I connect it to my PC, the scale (THB 600 from AIP SYSTEMES) is recognized as a device. Of course, I called the manufacturer to request the log, but I was told that they don't provide it due to the large number of receiving software: Excel, Access, other specific lab logs... So I searched their website and found nothing. That's why I called in an IT specialist who also found nothing. Therefore, I need to find someone who uses a scale and transfers data to Excel, so I can obtain that log to see if the transfer program is compatible. Any advice...?
Re
Sorry for the delayed response, I accidentally deleted your post from my list due to a mishap. I managed to recover it after worrying about not being able to find any trace of it.
It seems that your scale has an RS232 output, allowing you to connect a printer to it, and the Print button enables you to get a printed output.
You said you can connect it to your PC: it must therefore have a serial connector (which is currently rare), and you connect it via a serial cable unless you have an RS232/USB adapter.
After taking the measurement, pressing the Print button should "send" the data to the PC, so the PC must be "listening" just beforehand.
=>> I found this for you, a VBA program that works under Excel and allows you to "listen" to a serial port and display the results on the screen.
Give it to your IT person; they should be able to make use of it. A simple modification should allow you to send the data to a file instead of the screen. Otherwise, in a DOS console, it's very easy to "redirect" the screen output to a text file.
Afterwards, retrieving the file in Excel is very simple: just open the text file from Excel (you may need to force it a bit) and follow the prompts to get the data in columns and rows. The successive operations should be able to be "automated" later on. First, they need to be tested in principle.
If you have any problems, there are excellent VBA specialists here on CCM. Due to a lack of practice in recent years, this topic currently exceeds my skills.
=>> Here is the page where you can copy the program code; there are also user comments:
https://codes-sources.commentcamarche.net/
Good luck ..
A+
Nyctaclope
PS: how is your scale recognized by your PC (type of device?)
And what happens on the screen when you view it and press "print"?
Sorry for the delayed response, I accidentally deleted your post from my list due to a mishap. I managed to recover it after worrying about not being able to find any trace of it.
It seems that your scale has an RS232 output, allowing you to connect a printer to it, and the Print button enables you to get a printed output.
You said you can connect it to your PC: it must therefore have a serial connector (which is currently rare), and you connect it via a serial cable unless you have an RS232/USB adapter.
After taking the measurement, pressing the Print button should "send" the data to the PC, so the PC must be "listening" just beforehand.
=>> I found this for you, a VBA program that works under Excel and allows you to "listen" to a serial port and display the results on the screen.
Give it to your IT person; they should be able to make use of it. A simple modification should allow you to send the data to a file instead of the screen. Otherwise, in a DOS console, it's very easy to "redirect" the screen output to a text file.
Afterwards, retrieving the file in Excel is very simple: just open the text file from Excel (you may need to force it a bit) and follow the prompts to get the data in columns and rows. The successive operations should be able to be "automated" later on. First, they need to be tested in principle.
If you have any problems, there are excellent VBA specialists here on CCM. Due to a lack of practice in recent years, this topic currently exceeds my skills.
=>> Here is the page where you can copy the program code; there are also user comments:
https://codes-sources.commentcamarche.net/
Good luck ..
A+
Nyctaclope
PS: how is your scale recognized by your PC (type of device?)
And what happens on the screen when you view it and press "print"?
Hello and thank you for your response, I will call my IT technician again and I hope he will succeed because I'm spending a lot of time entering my weights. I think the scale is recognized since my IT technician installed it for me. When I press print, it says ACC 1 on the scale but nothing happens on the screen, then ACC 2 for the second weight,...
I remain hopeful... thank you again and I'll keep you updated on the results.
I remain hopeful... thank you again and I'll keep you updated on the results.
Re
Last minute, I found this for you, a program that writes data received from a serial port to Excel or others:
https://www.aggsoft.com/serial-data-logger.htm
It's paid, but you can download the trial version and see if it suits you...
It's probably a much simpler and quicker solution to implement than the previous VBA...
=>> also check "serial receptor" on the original link's page:
http://www.logitheque.com/logiciels/windows/utilitaires/gestion_ports_series/tous/toutes/?Tri=6
It is probably less advanced than the first one...
I don't have a serial type device on hand, otherwise I would have gladly tried both...
A+
Nyctaclope
Last minute, I found this for you, a program that writes data received from a serial port to Excel or others:
https://www.aggsoft.com/serial-data-logger.htm
It's paid, but you can download the trial version and see if it suits you...
It's probably a much simpler and quicker solution to implement than the previous VBA...
=>> also check "serial receptor" on the original link's page:
http://www.logitheque.com/logiciels/windows/utilitaires/gestion_ports_series/tous/toutes/?Tri=6
It is probably less advanced than the first one...
I don't have a serial type device on hand, otherwise I would have gladly tried both...
A+
Nyctaclope
Hello, and welcome to CCM ..
We haven't heard from Adeline since 2010.
But I just saw that she is still active on the forum, and since you can't (not registered) see her recent posts, I'm sending her a little message reminding her of this post.
https://forums.commentcamarche.net/forum/affich-27496180-changement-de-forfait-sans-accord#1
I hope she can reply to you here ..
A+
Nyctaclope
We haven't heard from Adeline since 2010.
But I just saw that she is still active on the forum, and since you can't (not registered) see her recent posts, I'm sending her a little message reminding her of this post.
https://forums.commentcamarche.net/forum/affich-27496180-changement-de-forfait-sans-accord#1
I hope she can reply to you here ..
A+
Nyctaclope