The nightly export scans the files each night and detects any changes or additions.
We are working on removals - as these are harder to detect What I did was create a set of files on the UV side that mimick the flat files. Essentially, we take each set of data - figure out how it would look as a flat line and if it's different from The last image we had - we flag that file/id When done, I grab all the flagged file/ids and then check a third file for how the last image looked (if it's a Change), and then only send the changed data It takes about an hour to run - but it's on an off-hours time frame I'm sure it could be done differently - but that's the best way we came up with. George -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 07, 2013 5:25 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I am looking for a CRM package on multi-value What do you do about data change conflicts between these two disconnected systems? -----Original Message----- From: George Gallen <ggal...@wyanokegroup.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Wed, Aug 7, 2013 2:21 pm Subject: Re: [U2] I am looking for a CRM package on multi-value We export to flat files (tearing apart the multivalue bonds) and import into Microsoft Dynamics (via a C# routine) on a nightly basis. So far it works fairly well - especially for collating all the different sources we have customers in (multiple files - multiple product types). Whereas, our MV system is quite disorganized from 30 years of Pick - once we moved everything over to the CRM - it really helps see just Where your customers are. I use SQL to pull queries from the CRM if I need to import anything back into the MV system. I'm sure there is quite a bit of tweeking on the CRM side (which is not me) but it works fairly well. We continue to use our MV system To enter and work as it's been programmed to over the decades, and use the CRM to analyze the data. It's like MITS on steroids. George -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel Ruckel Sent: Wednesday, August 07, 2013 5:00 PM To: 'U2 Users List' Subject: Re: [U2] I am looking for a CRM package on multi-value Always appreciate your insights Tony, thank you. Danny Ruckel -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, August 07, 2013 12:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I am looking for a CRM package on multi-value You're quite clear that you don't want a pitch for non-MV so that's not where I'm going here. I think this inquiry is fascinating for how it's presented rather than what it's about. In short, in this case I think you're doing MV a dis-service by being so supportive. Because my response isn't specifically about U2, and not a direct answer to your question, I've posted it as a blog: http://nebula-rnd.com/blog/tech/mv/2013/08/compete1.html Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog http://LinkedIn.com/in/TonyGravagno http://Twitter.com/TonyGravagno http://PickWiki.com http://groups.google.com/group/MVDBMS http://BitBucket.org/FOSS4MV/ > From: Wjhonson > I am looking for a Customer Relationship Management application. > > I have a client who is familiar with Universe and would prefer that, but > willing to look at other MV database applications. > > However they also will want to demo this to their own clients from > time-to-time and so want a pretty looking face on it. > The backend has to be multi-value of some sort, so don't pitch me non > multi-value solutions please > > What are my choices if any? > > Only looking for *already installed* choices, not custom work. > Some customization is always necessary, but they want to see a working > application from the get-go. _______________________________________________ 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 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
