I can do all that with SSIS, VB.net and/or c# classes too without having
to install another server, buy extra software and learn a new language.
On 09/06/2013 01:09, Bill Brutzman wrote:
Mecki:
While the old-fashioned approach is decent, it appears that there would be
the fallout of having to manually mop-up the dead rows.
To me... a more robust way is to... have the CF middleware read the Seiki
data... CF clean the old SQL rows... CF would call the new Rocket REST tool
to call a UniBasic sub to write the data to the UD Avante table.
The CF handler might be less than a dozen lines of HTML-like tags... or CF
script.
Upon doing this... there would likely be other data translation apps that
would come to mind... like integrating Avante with other ODBC... United
Parcel Service, employee time clock, shop floor equipment etc.
Likewise, I expect that ASP.net could do most all of the CF part. Of
course, the main idea here is that a server would be running agents
(services). The latest CF 10 has TomCat built-in.
I got turned on to "The Zen of REST" by the author Scott Davis at a
Philadelphia Emerging Technologies conference.
Slick Willy
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Saturday, June 8, 2013 3:52 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] How do I get the U2 Metadata Manager to work
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
_______________________________________________
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
