.csv file uploaded by usb pl2303 into a cash register

hi,
i’m new with linux, recently we had a visit from BSA to our company and they forced us to move OS’s on linux.I have installed opensuse 11 on DELL Vostro 1000 laptop’s. We are using them to upload a .csv file into a cash register.The file contains products, prices, and other parameters. If i install Wine and run the normal windows app, it doesn’t recognize my com ports. We connect to these devices by an usb to serial rs232 adapter (PL 2303) or by direct usb cable for some models (FTDI driver).
What i need to know is how can i upload/download that .csv file to the cash register. Is there a posibility to send it directly without using that windows app?
Need help, and i’m not even sure i’m posting in the right place.

On windows app we connect through com1 4800 baud.

Thank you.

> i’m new with linux,

-=WELCOME=- new poster!!

> recently we had a visit from BSA to our company

only BSA i know is Boy Scouts of America…

> and they forced us

the Boy Scouts seldom force anyone to do anything…did these Scouts
have guns?

> to move OS’s on linux.I have installed opensuse 11

there actually is no such thing as opensuse 11, there are openSUSE 11.0,
11.1, 11.2, 11.3 and 11.4, but of those only the last two are currently
supported…did you install one of those?

and, there is a SUSE Linux Enterprise Desktop (SLED) version 11, is it
that which you installed? if so, you have x days of free support with
the makers of that software, and i would expect them to be much more
capable of answering your business type questions (these are the
openSUSE forum which is mostly personal desktop users helping the
same–not to say we don’t also have professional and business users, we
sure do)

if your is 11.3 or 11.4 say so, and if it is SLED i’ll say you are
welcome to hang out here and see if you get the help you need, but BE
ADVISED that here many of the answers might be from folks who have never
run SLED (like me, or maybe never even heard of it before) and
you are likely much better off if you seek assistance from the
Attachmate/SUSE forums (where the SUSE Linux Enterprise gurus hang out),
at: http://tinyurl.com/422mrnu

> on
> DELL Vostro 1000 laptop’s. We are using them to upload a .csv file into
> a cash register.The file contains products, prices, and other
> parameters. If i install Wine and run the normal windows app, it doesn’t
> recognize my com ports. We connect to these devices by an usb to serial
> rs232 adapter (PL 2303)

hmmm…does that laptop have a serial port? because i think it most
likely you will have success sooner if you avoid the USB and just hook
up a serial cable and use the program ‘minicom’ (available and
installable by YaST from the standard repo)

> or by direct usb cable for some models (FTDI driver).

i have no idea what an FTDI driver is, but if you just hook up USB port
to USB port do you get a pop up saying a new device has become
available, and offer to (something like) “Open it in a file
manager”…if that happens it should be possible to set up a dual pane
file manager and navigate to where the file is on your Linux machine in
one pane, and to where it is stored on the cash register in the other
pane, and then just drag and drop to copy newer over older…

> What i need to know is how can i upload/download that .csv file to
> the cash register. Is there a posibility to send it directly without
> using that windows app?

without knowing anything about the cash register, or how it presents
itself either to the serial port or the USB i can only guess it is
possible…(and i told you in which ways above)…however i think it
would wise to dig out the tech data on the cash registers and see if
they made provisions for any back and forth without a windows machine
around…

> Need help, and i’m not even sure i’m posting in the right place.

you posted to a good enough place…i wish i had fast answer which were
as good as your place pick…

> On windows app we connect through com1 4800 baud.

that information would be very useful for the case where it is possible
to connect from the laptops serial port to the cash registers serial
port (i would expect minicom to want to know those parameters–but, i’ve
not used that critter in this century)

hmmmmm…i have no idea if minicom or any other such ‘terminal program’
knows how to connect via USB

OH! you didn’t mention what kind of error message (if any) you are
getting out of WINE, and maybe your smile will grow greatly if you were
to nose around the forums (and/or) contact the nice folks at WINE Hqs
<http://www.winehq.org/> where the answer you need might be waiting on
you to find it (in a posting about as old as those laptops and cash
registers)

finally, can’t you get those Scouts with guns to also force you
management to no longer purchase equipment which sports “Windows Ready”
logo which actually often means “Windows REQUIRED” (despite the cost or
insecurity)

if you have more questions or run into roadblocks (i’m sure you will)
please provide error messages and other useful hints…


DD http://tinyurl.com/DD-Caveat
openSUSE®, the “German Engineered Automobiles” of operating systems!

Hello bolchisb,

Do not be shued away bby the above explosion of text. While DD might have written a lot of text, he basicaly has some correct questions to you.

Which version of openSUSE do you use.

When it is SLED/SLES 11 you better go to the link DD posted above.

Your thread is read all over the world, thus do not assume that all those people undrstand what you mean by BSA (I don’t btw). While that introducing line might besuperfluous, make it perfect or leave it out.

On 11/27/2011 06:46 PM, hcvv wrote:
> Do not be shued away bby the above explosion of text.

you are welcome to demonstrate how to make all the same points, as
clearly with less explosive length… :slight_smile:


DD

On Sun, 27 Nov 2011 16:50:16 +0000, DenverD wrote:

>> recently we had a visit from BSA to our company
>
> only BSA i know is Boy Scouts of America…

BSA is a software industry anti-piracy group. IIRC, it’s the “Business
Software Alliance”.

Jim

Jim Henderson
openSUSE Forums Administrator
Forum Use Terms & Conditions at http://tinyurl.com/openSUSE-T-C

> BSA is a software industry anti-piracy group. IIRC, it’s the “Business
> Software Alliance”.

thanks for the info!

heh! so, they OP’s place of business must have been caught speeding…

i’m really torn between to poles:

i am dead set against stealing other folks stuff!!
vs
is taking from Microsoft actually stealing??

its a quandary i solved by just not using software which is not worth
stealing.


DD
openSUSE®, the “German Engineered Automobiles” of operating systems!

Am 27.11.2011 17:06, schrieb bolchisb:
>
> We connect to these devices by an usb to serial
> rs232 adapter (PL 2303) or by direct usb cable for some models (FTDI
> driver).
>
You can easily use minicom (FTDI also works) for that but I guess that
the communication uses some protocol for communication which you do not
mention (I guess you are not using hyperterminal on windows but some
program which has the communication logic built in). Without a bit more
details it is difficult to be more specific.
If the program you use is written by yourself or your company it should
(depending on the programming language and what windows specifics it
uses) more or less easy to port it to linux.
You should see devices like /dev/ttyUSB0 (1, 2 …) as the mapped
devices for the usb to rs232 device in linux.

There was also a simple trick to map them to COM1 … in wine but I do
not remember what to do for that.


PC: oS 11.4 (dual boot 12.1) 64 bit | Intel Core i7-2600@3.40GHz | KDE
4.6.0 | GeForce GT 420 | 16GB Ram
Eee PC 1201n: oS 11.4 64 bit | Intel Atom 330@1.60GHz | KDE 4.7.3 |
nVidia ION | 3GB Ram

USB serial adapters based on the PL2303 chip are supported. As martin_helm says, you should be able communicate with the device using minicom, but it depends on where there is some kind of protocol expected, or you can just dump the data downstream. If the protocol is documented and the device uses an open format like CSV, it’s probably not hard to write a program to download the data. Any of many languages can be used for this, C, Perl, Python, etc.

Am 28.11.2011 01:06, schrieb ken yap:
>
> USB serial adapters based on the PL2303 chip are supported. As
> martin_helm says, you should be able communicate with the device using
> minicom, but it depends on where there is some kind of protocol
> expected, or you can just dump the data downstream. If the protocol is
> documented and the device uses an open format like CSV, it’s probably
> not hard to write a program to download the data. Any of many languages
> can be used for this, C, Perl, Python, etc.
>
Yep, that would be what I would do (write a python script pyserial will
handle the connection), every other language you listed will for sure be
ok as well.

But I suspect when I read

i’m new with linux, recently we had a visit from BSA to our company
and they forced us to move OS’s on linux

simply paying the license fees would have been the easiest solution (as
much as I dislike windows).


PC: oS 11.4 (dual boot 12.1) 64 bit | Intel Core i7-2600@3.40GHz | KDE
4.6.0 | GeForce GT 420 | 16GB Ram
Eee PC 1201n: oS 11.4 64 bit | Intel Atom 330@1.60GHz | KDE 4.7.3 |
nVidia ION | 3GB Ram

On the other hand, once you have the source of a program, you are free of not just the licensing fees for Windows, but also from adverse changes in the binary only API the Windows program imposes on you.

It might be worth checking if somebody has open sourced a program to talk to the model of cash register in question. That would be a good starting point.

Am 28.11.2011 01:36, schrieb ken yap:
>
> On the other hand, once you have the source of a program, you are free
> of not just the licensing fees for Windows, but also from adverse
> changes in the binary only API the Windows program imposes on you.
>
I do not disagree. In the long term it is the better solution to leave
the locked down windows world here.


PC: oS 11.4 (dual boot 12.1) 64 bit | Intel Core i7-2600@3.40GHz | KDE
4.6.0 | GeForce GT 420 | 16GB Ram
Eee PC 1201n: oS 11.4 64 bit | Intel Atom 330@1.60GHz | KDE 4.7.3 |
nVidia ION | 3GB Ram

On 2011-11-28 01:36, ken yap wrote:
>
> On the other hand, once you have the source of a program, you are free
> of not just the licensing fees for Windows, but also from adverse
> changes in the binary only API the Windows program imposes on you.

Hah! But then we are subject to the changes of mind of the developers. Like
thinking we need systemd. >:-)


Cheers / Saludos,

Carlos E. R.
(from 11.4 x86_64 “Celadon” at Telcontar)

Am 28.11.2011 03:03, schrieb Carlos E. R.:
> Hah! But then we are subject to the changes of mind of the developers. Like
> thinking we need systemd. >:-)
>
I was sure come with that - I was absolutely sure :slight_smile:
I saw your thread on the mailing list


PC: oS 11.4 (dual boot 12.1) 64 bit | Intel Core i7-2600@3.40GHz | KDE
4.6.0 | GeForce GT 420 | 16GB Ram
Eee PC 1201n: oS 11.4 64 bit | Intel Atom 330@1.60GHz | KDE 4.7.3 |
nVidia ION | 3GB Ram

Actually it’s not a comparable situation and so a strawman. If you pay the developer, you control what you want her to write. Also systemd did not make SysVinit disappear off the face of the earth. So I’m sure there will be versions and distros to cater for diehards (slackware perhaps? But I think they are still using BSD rc scripts :)) in the future.

The company i work for, have 200 engineers with laptops and desktops all over the country, they won’t pay.The windows software we were using it it’s made by the cash register company called Danubius, they had a programmer but he left. I don’t know the com protocol it’s using it but i’ll try to talk to someone from that company.

My suse version is openSUSE 11.4 “Celadon”.

I’ll be back in a few hours with more info.

thank you

If you have 200 engineers already using the software and all their machines are already licensed for Windows, then logically you should solve the problem by getting one license for your desktop. What’s 1 compared to the 200 you are already paying? Unless they all need a license, in which I think you might in big trouble with BSA, unless you do a migration off Windows fast.

We have no windows licenses, we need 200 licenses for Windows xp for notebooks, and another 200 for desktops(almost 200, not all of them have a desktop to).That’s why we were forced to use linux.

I guess it would be best to go to that Danubius and tell them that when they can no longer support that interface software (because their one and only guy knowing somnething about it is gone), you want to have the source. You then hire a good programmer to port that software to Linux.

Can you point me to a good decompiler for windows apps. This software has only one file (.exe), can i extract the source from it?

It might be easier to snoop on what is exchanged between the program and the device. What you want is a data sniffer. There might be a free one for Windows. If you are lucky, perhaps the protocol is very simple: the program just sends a command followed by the data. Maybe there are only a few commands. Maybe only one. Then write a Linux program to do the same.