red1.org Forum Index red1.org
Nihili est - in vita priore ego imperator romanus fui
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Table used for POS

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    red1.org Forum Index -> Ask RED1 personally
View previous topic :: View next topic  
Author Message
syah



Joined: 10 Aug 2005
Posts: 8
PostPosted: Wed Aug 24, 2005 11:40 am    Post subject: Table used for POS Reply with quote
Hi all,

I'm currently trying to use a VB POS and link it to Oracle compiere database and the management side still can use compiere to view all the transaction.

I've thought of using red1 approach but the client needs to be mobile so they will be using laptop for the pos and store it in a local database (access or mysql) and at the end of the day upload it to the central database (oracle)

I've gone through redPOS and that's helps in a way but I still can't figure out which table that POS actually used.

Have anyone tried this approach before? Is there going to be any problem with the AD if another application putting data str8 into oracle?

Thanks for your help.

SYAH
Back to top
View user's profile Send private message
red1
Site Admin


Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
PostPosted: Wed Aug 24, 2005 1:37 pm    Post subject: Reply with quote
POS is based on the C_Order and C_OrderLine tables.

To import your mobile POS data into the system, u massage the data to excel CSV format. Then u use the Import Order to bring them into the system.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
syah



Joined: 10 Aug 2005
Posts: 8
PostPosted: Wed Aug 24, 2005 11:42 pm    Post subject: Reply with quote
red1 wrote:
POS is based on the C_Order and C_OrderLine tables.

To import your mobile POS data into the system, u massage the data to excel CSV format. Then u use the Import Order to bring them into the system.




Thanks red1 for the prompt reply. Really appreciate that because I need to demo this to a client next week Very Happy

Dont mean to trouble you but when you said massage the data to CSV format do I need to include all the fields in both C_Order and C_Orderline in the CSV file? Is there a sample for the file?

Secondly, I've looked at the Import Order but I don't understand what all those fields are for (eg. Order, Business Partner, Product and Reference). Do I need to fill all those fields before I can proceed with the import?

Does it work the same way as importing Chart of Account?

Thanks again.

SYAH
Back to top
View user's profile Send private message
trifon
Senior


Joined: 23 Dec 2004
Posts: 324
Location: Bulgaria, Sofia
PostPosted: Thu Aug 25, 2005 5:38 am    Post subject: Reply with quote
Hi SYAH,

Yes, there is an example Order import, see: "Example Order" in "Import Loader Format" window.

Yes, you need most of fields, at least this which are mandatory for Sales Order.

Regards,
Trifon
_________________
Trifon Trifonov
Back to top
View user's profile Send private message Yahoo Messenger
red1
Site Admin


Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
PostPosted: Thu Aug 25, 2005 7:35 am    Post subject: Reply with quote
syah wrote:
Does it work the same way as importing Chart of Account?


The framework of all imports are the same:
1) Have source data in CSV format. Fields map to Import Loader.
2) Import Loader bring them to I_* files. Which for Orders its I_Order.
3) Process I_Order so that the values are updated into C_Order/Line tables.

The processing work is done by ImportOrder.java

You can refer to our http://compiere.red1.org/XML2AD.zip that handles Imports in a major way, which may be overkill for u, but contains some explanations that can be useful if u want to delve into it technically.

Last edited by red1 on Fri Dec 23, 2005 8:53 am; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail Visit poster's website
syah



Joined: 10 Aug 2005
Posts: 8
PostPosted: Thu Aug 25, 2005 1:29 pm    Post subject: Reply with quote
Hi all,

If I create another Import Loader Format and named it Import POS and create another I_POS table will it serve the same function as Import Order?
Back to top
View user's profile Send private message
trifon
Senior


Joined: 23 Dec 2004
Posts: 324
Location: Bulgaria, Sofia
PostPosted: Thu Aug 25, 2005 5:18 pm    Post subject: Reply with quote
Hi Syah,

you do not need to create new table in order to import POS Orders.
Compiere already contains table "I_Order" which is used to store external data.

You only need to create proper Import Loader Format.

Regards,
Trifon
_________________
Trifon Trifonov
Back to top
View user's profile Send private message Yahoo Messenger
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    red1.org Forum Index -> Ask RED1 personally All times are GMT + 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group