[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4505: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4507: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4508: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4509: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
From Flames To Fork, Comes Freedom • View topic - Case Study II - Integrating to 3rd party POS (Main Topic)

Case Study II - Integrating to 3rd party POS (Main Topic)

All Case Experiences in Topic format. Easy reading mode for contextual understanding. Quickie snapshot and howtos Files are linked into http://compiere.red1.org/

Case Study II - Integrating to 3rd party POS (Main Topic)

Postby red1 » Fri Jul 09, 2004 11:54 am

This next case in progress is a multi-million dollar, multi-location; multi-currency, multi-webstore spelling a BIG challenge. They have queer price lists (ending in 8cts, or 0.80 or $88.) so we have to create an Import Price. They use commercial 3rd party POS terminals (with barcode scanners, credit-card, multi-screen, special keypad, loyalty scheme, coupons, packaging pricing). We shall batch import (replicate) their daily sales, be they cash or credit-cards or split by coupons. Inventory replenishments are exported back to the DBF files in the terminals.
We will go through this tutorial in topic stages.
As a departure from our previous style, we will now have the descriptive portion of the tutorial rendered in this forum under Topics. Lessons and interaction will then fall according to their Topic heading. (I hope to try this out to organise better). Hyperlinks to screenshots and exact steps to follow (ongoing, keep watching here for the links) will be made into the dump at http://compiere.red1.org/.
Now we describe the topics in general. Topic I covers the use of TOAD to make SQL routines. Topic 2 learns about the Import Price creation. Topic 3 shall cover the Import Order – loader format setup. We spruce up a batch process for high volume POS Orders. Topic 4 explores the challenge of migrating the opening balances – Inventories and Accounts. We also do the export of inventories of various locations in Compiere back to the POSes. Then we tackle POS business issues such as coupons.
We leave this topic thread here to discuss contextual and broader issues. The other topics will deviate into more narrower tracks.
Last edited by red1 on Tue Nov 09, 2004 2:22 pm, edited 5 times in total.
red1
Site Admin
 
Posts: 2759
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby Jiang Nan » Mon Jul 12, 2004 2:24 pm

How do your POS terminals comunicate with your data server?
Jiang Nan
 
Posts: 4
Joined: Thu Jul 08, 2004 2:45 pm

Timed-based Integration

Postby red1 » Tue Jul 13, 2004 12:38 pm

They communicate via normal PSTN lines, thus its a timed nightly affair, where the main server will dial in to pick up the day sales data.
Later we can consider a more hour to hour basis.
The reason the POS vendor is wanting this is because they have an established clientile on their POS systems, but no back-end. This is a forerunner for them. Then the vendor will move higher up the integration scale. Their strength is market rapport, track-record and customisability of their POS to fit varied customer needs.
red1
Site Admin
 
Posts: 2759
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Version 2: Integrating with Split Settlement

Postby red1 » Sat Jul 24, 2004 3:28 pm

THIS version 1 will be a throwaway, as during discussions with the 3rd party POS vendor, who is now interested to fully put Compiere as the backend, their concern is about Split Payments - which is when a customer is ready to pay, she may just tender part in cash, and part in Credit Card.
Of course Compiere takes care of that by issuing an invoice and then accepting multiple payments. However during ImportOrder.java only Order generating process occurs. We need to carry the process further to include Invoice actions and payments too.
Also the I_Order format will be inadequate as it only takes in lines on a orderline basis and doesnt include Order Header details and invoice payment details.
This version 2 will be interesting also due to the agreement to implement this with XML as a standard to pass datafiles. We will also use a near real-time process - store and forward from the client end to the host server. The host server spawns a scheduler process to check latest new sales and process it.
WE are chasing a deadline of September to showcase the package and oh! i forgot, IT also has to be on Suse Linux! hmm..yummy!
Meanwhile the version 1 still goes on, and i will finish the documenting and case experience, as an option for those who find it more suitable to their situation.
red1
Site Admin
 
Posts: 2759
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Progress on the Version II POS on Suse

Postby red1 » Tue Aug 03, 2004 11:24 am

Hi,

The Suse Linux on our POS-Novel Prototype is up. The stumbling block which gave SuSe the hangover for more than few hours is solved by a probo.com comment:

There is apparently some kind of conflict between this driver and the BIOS found on some ProSavage-DDR motherboard that causes anything but the default refresh rate to be set wrong. There are two workaround for this. One is to turn off the use of the BIOS by adding
Option "UseBios" "no"
in the "Device" section of your XF86Config file.

We did exactly that on /etc/X11/XF86Config.

Then Andrew tweak back the vomited screen to normal.

Then the Oracle story. The www.suse.com/oracle/ looks nice but aint much help or assume that we aren't dummies, which we are. So after fumbling thru the ORacle install went to just before the finishing line. Problem is the MAKE program is missing in /usr/bin/.
So next round we will retry again but this time enxure that gcc or all linker compilers such as MAKE are in.

red1
red1
Site Admin
 
Posts: 2759
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia


Return to Compiere Case Workshop

Who is online

Users browsing this forum: No registered users and 1 guest