Web interface - request for help

[Former Member]

Hello All,

I consider to create for our customers a web interface that will allow them to place orders on their own. Currently this work is being done manually, i.e. a person picks up phone calls, enters data into SAP, etc. There are many orders everyday so such a facility would simplify the process very much.

Since I am new in developing SAP then have many questions how to accomplish this task. Is it for example possible to create a web page in PHP or Java? Are there any additional resources necessary, or that what we have on CD is enough? Should I read and put data into database using SQL queries or other special mechanism?

I started to dig into SDN pages, but there is an overwhelming amount of information so I feel a little lost. If you could navigate me in this jungle I would be happy. Are there any ready-made examples?

I will be grateful for all your replies.

Grzegorz

[Former Member]

well, if we use PHP we can directly access to SBO database through SQL Server. For Example to Create Order, we have to manipulate ( like function doquery in DI/API) ORDR dan Its Line Item tables to manipulate Order. But you have to declare your connection to dabatabase from config.php or some king like that. But SAP reminds Us that it is absolutely forbidden to use and action queries (UPDATE, INSERT, DELETE) directly to SAP Business One system Tables without using DI/Api through its business object.

Regarding to your question i suggest you to use vb script to create the wb site since vb support SBO Object.or you can use jsp ( java)as long as you install java connector. But truly i've never tried this. But theoritically it can be done.

Cheers,

Hamdi

Message was edited by: Hamdi Syukriwan

[Former Member]

I have done some work with ASP and used an ODBC connection to the SAP B1 server. It also does some inserting, but I advice against this, since SAP advices people to use their datainterface for that.

6.5 Does not support the DI API with ASP, don't know about PHP or Java, but I would not count on it.

6.7 Will aparently support the DI API in ASP through something called "DI SERVER". I do not know how or if this will work, but I will check it out when 6.7 comes.

Otherwise... you can always implement an activeX dll with the functions in VB or C# and use them in your ASP/PHP/JAVA code somehow... there are ways, if you're a wizard 🐵

If you wait for 6.7 and use the DI API,.. you can use that for inserting your orders from an ASP page. There are VB samples of how to do this on the CD. And you need of course to install the DI (DataInterface) to do this stuff ...