Re: OT our shipping software is finally finished

2018-10-07 Thread Mike Kerner via use-livecode 
Since we're talking about shipping software, I prefer to have our forklift
operators having mobiles on their trucks instead of lappies, but we do have
a bunch of desktop (and server, and mainframe) apps, it's just that most of
them are written in tools other than LC.  I will say that integrating our
mobile apps into our ecosystem with the mainframes and the desktops has
been pretty easy with LC.

On Thu, Oct 4, 2018 at 4:10 PM Ralph DiMola via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Congrats! Nice to see LC out in the field.
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
> rdim...@evergreeninfo.net
>
> -Original Message-
> From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On
> Behalf Of Matthias Rebbe via use-livecode
> Sent: Wednesday, October 03, 2018 6:34 PM
> To: How to use LiveCode
> Cc: Matthias Rebbe
> Subject: OT our shipping software is finally finished
>
> Hi,
>
> with a little proud i am happy to say that after many weeks of "blood,
> sweat and tears" i´ve finally finished our Windows software for DHL and
> Trans-o-flex shipments. This software is used by our own and replaces a 3rd
> party software. There are several reasons, why we decided to replace the
> software.
>
> These are the main features:
> By entering the invoice number the software fetches the corresponding
> shipping address and some other additional information like cash on
> delivery amount (if applicable) from the database of our ERP software and
> creates a shipping label, which then is printed onto a thermal printer.
>
> For Trans-o-Flex the shipping labels (including a 1D barcode 2of5
> interleaved and  a qrCode) are completely built with the app.
> The qrCode is created with a slightly modified version of the Livecode
> qrCode library. The modified library allows to specify the version number
> the created qrCode should have. This is important, as the carrier
> Trans-o-Flex only allows version 14 qrCodes for their shipping labels. The
> original LC library selects the version according to the data the qrCode
> contains. If you are interested in the modified library, you´ll find it
> here <https://quality.livecode.com/show_bug.cgi?id=21428>  I´ve attached
> it to “bug” report 21428.
>
> The 1D barcode is created with a 3rd party Windows SDK from Tec-It <
> https://www.tec-it.com/en/software/barcode-software/tbarcode/overview/Default.aspx
> >.
> Currently the SDK is called from a .vbs script.The .vbs file is created
> dynamically. The future plan is to create a widget which calls the SDK. But
> due to my lack of knowledge about widget i had to choose the .vbs way for
> now.
>
> After successful printing, the shipping data is stored into a database. At
> the end of the day, the shipping data of all parcels and pallets is
> exported from database to an XML file, which is then uploaded to the sftp
> server of the shipment carrier. The tracking number of each shipment, the
> according invoice and customer number are exported also to our web server.
> This allows our customers to query the tracking numbers by entering their
> invoice and customer number. The software allows also the export a PDF of
> all shipments of a day.
>
> I´ve uploaded 3 screenshots of the app if you´re interested. Please don´t
> laugh about the user interface. The design does not match the current
> Windows design nor is it state of the art. Our users wanted it simple and
> “readable” and no small buttons or text.
>
> https://mr.on-rev.com/menu.png <https://mr.on-rev.com/menu.png>
> https://mr.on-rev.com/shipping.png <https://mr.on-rev.com/shipping.png>
> https://mr.on-rev.com/label.png <https://mr.on-rev.com/label.png>
>
> This is by far the most extensive app i´ve created with Livecode so far
> and i am really happy that it was finally approved by Trans-o-Flex.
>
>
> Matthias
>
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: OT our shipping software is finally finished

2018-10-04 Thread Ralph DiMola via use-livecode 
Congrats! Nice to see LC out in the field.

Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net

-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of 
Matthias Rebbe via use-livecode
Sent: Wednesday, October 03, 2018 6:34 PM
To: How to use LiveCode
Cc: Matthias Rebbe
Subject: OT our shipping software is finally finished

Hi,

with a little proud i am happy to say that after many weeks of "blood, sweat 
and tears" i´ve finally finished our Windows software for DHL and Trans-o-flex 
shipments. This software is used by our own and replaces a 3rd party software. 
There are several reasons, why we decided to replace the software.

These are the main features:
By entering the invoice number the software fetches the corresponding shipping 
address and some other additional information like cash on delivery amount (if 
applicable) from the database of our ERP software and creates a shipping label, 
which then is printed onto a thermal printer. 

For Trans-o-Flex the shipping labels (including a 1D barcode 2of5 interleaved 
and  a qrCode) are completely built with the app. 
The qrCode is created with a slightly modified version of the Livecode qrCode 
library. The modified library allows to specify the version number the created 
qrCode should have. This is important, as the carrier Trans-o-Flex only allows 
version 14 qrCodes for their shipping labels. The original LC library selects 
the version according to the data the qrCode contains. If you are interested in 
the modified library, you´ll find it here 
<https://quality.livecode.com/show_bug.cgi?id=21428>  I´ve attached it to “bug” 
report 21428.

The 1D barcode is created with a 3rd party Windows SDK from Tec-It 
<https://www.tec-it.com/en/software/barcode-software/tbarcode/overview/Default.aspx>.
Currently the SDK is called from a .vbs script.The .vbs file is created 
dynamically. The future plan is to create a widget which calls the SDK. But due 
to my lack of knowledge about widget i had to choose the .vbs way for now.

After successful printing, the shipping data is stored into a database. At the 
end of the day, the shipping data of all parcels and pallets is exported from 
database to an XML file, which is then uploaded to the sftp server of the 
shipment carrier. The tracking number of each shipment, the according invoice 
and customer number are exported also to our web server. This allows our 
customers to query the tracking numbers by entering their invoice and customer 
number. The software allows also the export a PDF of all shipments of a day.

I´ve uploaded 3 screenshots of the app if you´re interested. Please don´t laugh 
about the user interface. The design does not match the current Windows design 
nor is it state of the art. Our users wanted it simple and “readable” and no 
small buttons or text. 

https://mr.on-rev.com/menu.png <https://mr.on-rev.com/menu.png> 
https://mr.on-rev.com/shipping.png <https://mr.on-rev.com/shipping.png>
https://mr.on-rev.com/label.png <https://mr.on-rev.com/label.png>

This is by far the most extensive app i´ve created with Livecode so far and i 
am really happy that it was finally approved by Trans-o-Flex.


Matthias



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-04 Thread Mark Wieder via use-livecode 

On 10/04/2018 04:45 AM, Andre Garzia via use-livecode wrote:


I think that LiveCode is
the best thing under the sun to build Desktop apps. I wish people were not
so enthralled with mobile these days because Desktop stuff rocks.


Amen to that.

--
 Mark Wieder
 ahsoftw...@gmail.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-04 Thread Matthias Rebbe via use-livecode 

> Am 04.10.2018 um 13:45 schrieb Andre Garzia  >:
> 
> I think that LiveCode is the best thing under the sun to build Desktop apps. 
> I wish people were not so enthralled with mobile these days because Desktop 
> stuff rocks.


Andre, 
i second that. The possibility to create mobile apps with LC is nice and the 
progress from the beginning of revMobile to the current state is remarkable. 
But creating Desktop apps with LC and the Livecode Server stuff is  awesome and 
by far the best and amazing thing i met in programming except mTropoplis, 
although that was buggy. But that´s an other story.


Btw.: Your fon.nu site has a dead link to your fon.nu project at Bitbucket. 
Where is the new home of the project?

Regards,

Matthias
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-04 Thread Andre Garzia via use-livecode 
Matthias,

Congratulations on shipping a shipping software! I think that LiveCode is
the best thing under the sun to build Desktop apps. I wish people were not
so enthralled with mobile these days because Desktop stuff rocks.

Best
andre

On Thu, Oct 4, 2018 at 10:30 AM Matthias Rebbe via use-livecode <
use-livecode@lists.runrev.com> wrote:

> The complete project started in February this year.
> I´ve started with our DHL module in February and finished that at the end
> of March. The DHL part was easier, as the app does not have to create the
> label. The app fetches the shipping data the same way as the Trans-o-Flex
> module does, but then writes the shipping information as XML file into a
> folder which is monitored by a DHL polling software. This polling software
> is provided by DHL. The DHL polling software then transmits the data to DHL
> and if the shipment data is correct, then the software receives the
> shipping label from DHL as PDF and prints that out. At the end of the day
> the DHL polling software fetches the shipping data for all parcels and
> pallets from DHL and stores that information in our database. (We need that
> data for tracking and to export it to our webserver.
>
> I started with the Trans-o-Flex module early April. It began with studying
> the tech papers of Trans-o-Flex, fetching needed information and evaluating
> the needs of my colleagues. For Trans-o-Flex we used a separate program
> and  I wanted to make the change from the old to the new app as easy as
> possible for them . Programming started late  April. I worked on that app
> about 5 hours a day, sometimes more somtimes less. First shipments were
> done with the new app from the 18th of September. The complete switch from
> the old Trans-o-Flex app to the new app was around the 25th of September.
> Since the 18th we shipped about 739 Trans-o-Flex parcels/pallets with our
> new app.
>
> So all in all the complete app took about 8 month in research and
> development.
> Currently i am reviewing my comments in the scripts to make them more
> “understandable” for others in case this is needed in the future.
>
>
> > Am 04.10.2018 um 02:11 schrieb Tom Glod via use-livecode <
> use-livecode@lists.runrev.com>:
> >
> > All the best and tons of sales.
> >
> Unfortunately it´s an in-house tool and there are no plans to sell it.
>
> Regards,
>
> Matthias
>
>
> > Cheers
> >
> >
> >
> > On Wed, Oct 3, 2018 at 8:07 PM Mark Wieder via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> On 10/03/2018 03:33 PM, Matthias Rebbe via use-livecode wrote:
> >>
> >>> This is by far the most extensive app i´ve created with Livecode so far
> >> and i am really happy that it was finally approved by Trans-o-Flex.
> >>
> >> Congratulations. I know this has been a long rocky road.
> >>
> >> --
> >>  Mark Wieder
> >>  ahsoftw...@gmail.com
> >>
> >> ___
> >> use-livecode mailing list
> >> use-livecode@lists.runrev.com
> >> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



-- 
http://www.andregarzia.com -- All We Do Is Code.
http://fon.nu -- minimalist url shortening service.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-04 Thread Matthias Rebbe via use-livecode 
The complete project started in February this year.
I´ve started with our DHL module in February and finished that at the end of 
March. The DHL part was easier, as the app does not have to create the label. 
The app fetches the shipping data the same way as the Trans-o-Flex module does, 
but then writes the shipping information as XML file into a folder which is 
monitored by a DHL polling software. This polling software is provided by DHL. 
The DHL polling software then transmits the data to DHL and if the shipment 
data is correct, then the software receives the shipping label from DHL as PDF 
and prints that out. At the end of the day the DHL polling software fetches the 
shipping data for all parcels and pallets from DHL and stores that information 
in our database. (We need that data for tracking and to export it to our 
webserver.

I started with the Trans-o-Flex module early April. It began with studying the 
tech papers of Trans-o-Flex, fetching needed information and evaluating the 
needs of my colleagues. For Trans-o-Flex we used a separate program and  I 
wanted to make the change from the old to the new app as easy as possible for 
them . Programming started late  April. I worked on that app about 5 hours a 
day, sometimes more somtimes less. First shipments were done with the new app 
from the 18th of September. The complete switch from the old Trans-o-Flex app 
to the new app was around the 25th of September. Since the 18th we shipped 
about 739 Trans-o-Flex parcels/pallets with our new app.

So all in all the complete app took about 8 month in research and development. 
Currently i am reviewing my comments in the scripts to make them more 
“understandable” for others in case this is needed in the future. 


> Am 04.10.2018 um 02:11 schrieb Tom Glod via use-livecode 
> :
> 
> All the best and tons of sales.
> 
Unfortunately it´s an in-house tool and there are no plans to sell it.

Regards,

Matthias


> Cheers
> 
> 
> 
> On Wed, Oct 3, 2018 at 8:07 PM Mark Wieder via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> 
>> On 10/03/2018 03:33 PM, Matthias Rebbe via use-livecode wrote:
>> 
>>> This is by far the most extensive app i´ve created with Livecode so far
>> and i am really happy that it was finally approved by Trans-o-Flex.
>> 
>> Congratulations. I know this has been a long rocky road.
>> 
>> --
>>  Mark Wieder
>>  ahsoftw...@gmail.com
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-03 Thread J. Landman Gay via use-livecode 
Congratulations! That's an impressive project and speaks well for both you 
and LiveCode.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com
On October 3, 2018 5:35:48 PM Matthias Rebbe via use-livecode 
 wrote:



Hi,

with a little proud i am happy to say that after many weeks of "blood, 
sweat and tears" i´ve finally finished our Windows software for DHL and 
Trans-o-flex shipments. This software is used by our own and replaces a 3rd 
party software. There are several reasons, why we decided to replace the 
software.


These are the main features:
By entering the invoice number the software fetches the corresponding 
shipping address and some other additional information like cash on 
delivery amount (if applicable) from the database of our ERP software and 
creates a shipping label, which then is printed onto a thermal printer.


For Trans-o-Flex the shipping labels (including a 1D barcode 2of5 
interleaved and  a qrCode) are completely built with the app.
The qrCode is created with a slightly modified version of the Livecode 
qrCode library. The modified library allows to specify the version number 
the created qrCode should have. This is important, as the carrier 
Trans-o-Flex only allows version 14 qrCodes for their shipping labels. The 
original LC library selects the version according to the data the qrCode 
contains. If you are interested in the modified library, you´ll find it 
here   I´ve attached it 
to “bug” report 21428.


The 1D barcode is created with a 3rd party Windows SDK from Tec-It 
.
Currently the SDK is called from a .vbs script.The .vbs file is created 
dynamically. The future plan is to create a widget which calls the SDK. But 
due to my lack of knowledge about widget i had to choose the .vbs way for now.


After successful printing, the shipping data is stored into a database. At 
the end of the day, the shipping data of all parcels and pallets is 
exported from database to an XML file, which is then uploaded to the sftp 
server of the shipment carrier. The tracking number of each shipment, the 
according invoice and customer number are exported also to our web server. 
This allows our customers to query the tracking numbers by entering their 
invoice and customer number. The software allows also the export a PDF of 
all shipments of a day.


I´ve uploaded 3 screenshots of the app if you´re interested. Please don´t 
laugh about the user interface. The design does not match the current 
Windows design nor is it state of the art. Our users wanted it simple and 
“readable” and no small buttons or text.


https://mr.on-rev.com/menu.png 
https://mr.on-rev.com/shipping.png 
https://mr.on-rev.com/label.png 

This is by far the most extensive app i´ve created with Livecode so far and 
i am really happy that it was finally approved by Trans-o-Flex.



Matthias



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode





___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-03 Thread Tom Glod via use-livecode 
Congratulations.

Just wondering what the time frame was to start and complete this project?

All the best and tons of sales.

Cheers



On Wed, Oct 3, 2018 at 8:07 PM Mark Wieder via use-livecode <
use-livecode@lists.runrev.com> wrote:

> On 10/03/2018 03:33 PM, Matthias Rebbe via use-livecode wrote:
>
> > This is by far the most extensive app i´ve created with Livecode so far
> and i am really happy that it was finally approved by Trans-o-Flex.
>
> Congratulations. I know this has been a long rocky road.
>
> --
>   Mark Wieder
>   ahsoftw...@gmail.com
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-03 Thread Mark Wieder via use-livecode 

On 10/03/2018 03:33 PM, Matthias Rebbe via use-livecode wrote:


This is by far the most extensive app i´ve created with Livecode so far and i 
am really happy that it was finally approved by Trans-o-Flex.


Congratulations. I know this has been a long rocky road.

--
 Mark Wieder
 ahsoftw...@gmail.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-03 Thread Matthias Rebbe via use-livecode 
As this runs only on Windows and we are fetching the data from a MSSQL database 
we are using the  odbc driver “SQL Server” which is included in Windows.

Btw.: For connections from Mac to MSSQL server i have here Actualtech´s ODBC 
driver and also the Openlink SQL Server Lite driver. But i prefer the 
Actualtech one. Why? Because it´s cheaper and it´s easier to configure and 
Jonathan Monroe of Actualtech was always helpful when i requested support.

Matthias




> Am 04.10.2018 um 01:01 schrieb Bob Sneidar via use-livecode 
> :
> 
> Ah. So do you use an ODBC connector? If so, which did you use? We have an ARP 
> I would like to at least create read connectors for into my Forms Generator, 
> but I would have to have some kind of ODBC connector, unless direct 
> connections are permitted now. 
> 
> Bob S
> 
> 
>> On Oct 3, 2018, at 15:57 , Matthias Rebbe via use-livecode 
>>  wrote:
>> 
>> No, there is no api. We are fetching the data directly from the MSSQL 
>> database. But fortunately the developer of our ERP provided very detailed 
>> informations about the database and the structure of its tables.
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-03 Thread Bob Sneidar via use-livecode 
And congratulations by the way. :-)

Bob S


> On Oct 3, 2018, at 16:01 , Bob Sneidar via use-livecode 
>  wrote:
> 
> Ah. So do you use an ODBC connector? If so, which did you use? We have an ARP 
> I would like to at least create read connectors for into my Forms Generator, 
> but I would have to have some kind of ODBC connector, unless direct 
> connections are permitted now. 
> 
> Bob S
> 
> 
>> On Oct 3, 2018, at 15:57 , Matthias Rebbe via use-livecode 
>>  wrote:
>> 
>> No, there is no api. We are fetching the data directly from the MSSQL 
>> database. But fortunately the developer of our ERP provided very detailed 
>> informations about the database and the structure of its tables.
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-03 Thread Bob Sneidar via use-livecode 
Ah. So do you use an ODBC connector? If so, which did you use? We have an ARP I 
would like to at least create read connectors for into my Forms Generator, but 
I would have to have some kind of ODBC connector, unless direct connections are 
permitted now. 

Bob S


> On Oct 3, 2018, at 15:57 , Matthias Rebbe via use-livecode 
>  wrote:
> 
> No, there is no api. We are fetching the data directly from the MSSQL 
> database. But fortunately the developer of our ERP provided very detailed 
> informations about the database and the structure of its tables.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-03 Thread Matthias Rebbe via use-livecode 
No, there is no api. We are fetching the data directly from the MSSQL database. 
But fortunately the developer of our ERP provided very detailed informations 
about the database and the structure of its tables.
So at least i knew what table stored what information. I then “just” had to 
find out how to fetch  the needed information from which tables and to create 
the sql commands for it.

To make it more complicated, the app does not just fetch shipping addresses for 
invoices, but also for orders,return shipments and return shipments with credit 
memo. They are all stored somewhere else. That´s one reason why i wrote 
“blood,sweat and tears”.



> Am 04.10.2018 um 00:45 schrieb Bob Sneidar via use-livecode 
> :
> 
> I'd be curious how you did the back end integration with your ERP sysetm. Do 
> they provide an API? 
> 
> Bob S
> 
> 
>> On Oct 3, 2018, at 15:33 , Matthias Rebbe via use-livecode 
>>  wrote:
>> 
>> These are the main features:
>> By entering the invoice number the software fetches the corresponding 
>> shipping address and some other additional information like cash on delivery 
>> amount (if applicable) from the database of our ERP software and creates a 
>> shipping label, which then is printed onto a thermal printer. 
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT our shipping software is finally finished

2018-10-03 Thread Bob Sneidar via use-livecode 
I'd be curious how you did the back end integration with your ERP sysetm. Do 
they provide an API? 

Bob S


> On Oct 3, 2018, at 15:33 , Matthias Rebbe via use-livecode 
>  wrote:
> 
> These are the main features:
> By entering the invoice number the software fetches the corresponding 
> shipping address and some other additional information like cash on delivery 
> amount (if applicable) from the database of our ERP software and creates a 
> shipping label, which then is printed onto a thermal printer. 


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

OT our shipping software is finally finished

2018-10-03 Thread Matthias Rebbe via use-livecode 
Hi,

with a little proud i am happy to say that after many weeks of "blood, sweat 
and tears" i´ve finally finished our Windows software for DHL and Trans-o-flex 
shipments. This software is used by our own and replaces a 3rd party software. 
There are several reasons, why we decided to replace the software.

These are the main features:
By entering the invoice number the software fetches the corresponding shipping 
address and some other additional information like cash on delivery amount (if 
applicable) from the database of our ERP software and creates a shipping label, 
which then is printed onto a thermal printer. 

For Trans-o-Flex the shipping labels (including a 1D barcode 2of5 interleaved 
and  a qrCode) are completely built with the app. 
The qrCode is created with a slightly modified version of the Livecode qrCode 
library. The modified library allows to specify the version number the created 
qrCode should have. This is important, as the carrier Trans-o-Flex only allows 
version 14 qrCodes for their shipping labels. The original LC library selects 
the version according to the data the qrCode contains. If you are interested in 
the modified library, you´ll find it here 
  I´ve attached it to “bug” 
report 21428.

The 1D barcode is created with a 3rd party Windows SDK from Tec-It 
.
Currently the SDK is called from a .vbs script.The .vbs file is created 
dynamically. The future plan is to create a widget which calls the SDK. But due 
to my lack of knowledge about widget i had to choose the .vbs way for now.

After successful printing, the shipping data is stored into a database. At the 
end of the day, the shipping data of all parcels and pallets is exported from 
database to an XML file, which is then uploaded to the sftp server of the 
shipment carrier. The tracking number of each shipment, the according invoice 
and customer number are exported also to our web server. This allows our 
customers to query the tracking numbers by entering their invoice and customer 
number. The software allows also the export a PDF of all shipments of a day.

I´ve uploaded 3 screenshots of the app if you´re interested. Please don´t laugh 
about the user interface. The design does not match the current Windows design 
nor is it state of the art. Our users wanted it simple and “readable” and no 
small buttons or text. 

https://mr.on-rev.com/menu.png 
https://mr.on-rev.com/shipping.png 
https://mr.on-rev.com/label.png 

This is by far the most extensive app i´ve created with Livecode so far and i 
am really happy that it was finally approved by Trans-o-Flex.


Matthias



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode