OT our shipping software is finally finished

classic Classic list List threaded Threaded
15 messages Options
Reply | Threaded
Open this post in threaded view
|

OT our shipping software is finally finished

Bob Sneidar 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 <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
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

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 <[hidden email]> 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
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar 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 <[hidden email]>:
>
> 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 <[hidden email]> 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
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

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 <[hidden email]> 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
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar via use-livecode
And congratulations by the way. :-)

Bob S


> On Oct 3, 2018, at 16:01 , Bob Sneidar via use-livecode <[hidden email]> 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 <[hidden email]> 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
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar via use-livecode
In reply to this post by Bob Sneidar 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 <[hidden email]>:
>
> 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 <[hidden email]> 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
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar via use-livecode
In reply to this post by Bob Sneidar 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
  [hidden email]

_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar 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 <
[hidden email]> 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
>   [hidden email]
>
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar via use-livecode
In reply to this post by Bob Sneidar via use-livecode
Congratulations! That's an impressive project and speaks well for both you
and LiveCode.

--
Jacqueline Landman Gay | [hidden email]
HyperActive Software | http://www.hyperactivesw.com
On October 3, 2018 5:35:48 PM Matthias Rebbe via use-livecode
<[hidden email]> 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 <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
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode




_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar via use-livecode
In reply to this post by Bob Sneidar 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 <[hidden email]>:
>
> 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 <
> [hidden email]> 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
>>  [hidden email]
>>
>> _______________________________________________
>> use-livecode mailing list
>> [hidden email]
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar 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 <
[hidden email]> 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 <
> [hidden email]>:
> >
> > 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 <
> > [hidden email]> 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
> >>  [hidden email]
> >>
> >> _______________________________________________
> >> use-livecode mailing list
> >> [hidden email]
> >> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> > _______________________________________________
> > use-livecode mailing list
> > [hidden email]
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> 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
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar via use-livecode

> Am 04.10.2018 um 13:45 schrieb Andre Garzia <[hidden email] <mailto:[hidden email]>>:
>
> 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
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar via use-livecode
In reply to this post by Bob Sneidar 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
  [hidden email]

_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

RE: OT our shipping software is finally finished

Bob Sneidar via use-livecode
In reply to this post by Bob Sneidar via use-livecode
Congrats! Nice to see LC out in the field.

Ralph DiMola
IT Director
Evergreen Information Services
[hidden email]

-----Original Message-----
From: use-livecode [mailto:[hidden email]] 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
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


_______________________________________________
use-livecode mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Reply | Threaded
Open this post in threaded view
|

Re: OT our shipping software is finally finished

Bob Sneidar 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 <
[hidden email]> wrote:

> Congrats! Nice to see LC out in the field.
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
> [hidden email]
>
> -----Original Message-----
> From: use-livecode [mailto:[hidden email]] 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
> [hidden email]
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> _______________________________________________
> use-livecode mailing list
> [hidden email]
> 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
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode