Mecki I already told you how to pick up changes to an SQl Table without using BCI
We do it every night. And we don't need SAMBA either. We use bcp (not the P at the end not I) bcp has been around since the VW bug Try it, it works. It can pick up changes and write them to a tab delimited file -----Original Message----- From: Mecki Foerthmann <[email protected]> To: u2-users <[email protected]> Sent: Sat, Jun 8, 2013 12:52 am 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 > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
