Bill,
What I try to achieve is converting production data collected by Seiki
software into labour bookings on our Avante ERP system.
Currently operators use Seiki on the machine and also book the jobs on a
separate screen to update ERP.
So I have one application writing to a SQL Server table and I want to
run a phantom on UD that picks up changes on that table and updates
several UD files using existing business logic when it finds any.
That way the operator doesn't have to enter labour bookings and make
mistakes any more.
I also want to remove the rows from the SQL Server table once they are
marked as completed operations and update SQL Server with changes of the
production schedule to produce loading lists on the machines.
How can a browser or Coldfusion help me with that?
If I really wanted a browser based front end I would most likely use
Designbais or SBXA since I don't see the point and don't have the time
trying to learn yet another new language (or a whole bunch of them) just
for that.
I think I'll just go the old fashioned way and run a SSIS package on SQL
server that checks for changes on the table and writes these to a Samba
share on the UD server as a Tab delimited text file and also updates the
tables Seiki uses for loading lists.
Then my phantom can pick up those changed rows every minute or so and
update my files.
I just wanted a more elegant solution and and see if and how the UD
tools work.
Mecki
On 07/06/2013 23:02, Bill Brutzman wrote:
Mecki:
While it may be counter-intuitive that ColdFusion is very hot...
The compelling gravity in the entire web UniVerse is the idea is the idea
browser front end.
As CF was originally tag-based... if a programmer knows any HTML... that
same programmer already knows much CF.
Where CF shines is middleware to connect to databases... and rapid
application development.
It is worth it to go to adobe.com and check out CF.
A related impossibility is that the CF community is even more gung-ho that
the U2 community. Who knew?
--Bill
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
