With Meta-Update there is NO temporary for and NO workflow except normal OOTB workflow (when desired).
I regularly load data of all sorts and sizes into live systems with no performance effects. Meta-Update will allow you to validate, load other data into memory, etc. You can automatically create a duplicate CSV containing only those records that failed validations. This can then be attached to the original record holding the source CSV. A Meta-Update script is trivial to create and there are many Meta-Update scripts available. For example, this data import from a spreadsheet <http://www.softwaretoolhouse.com/product/SthMupd/2012-RUG-de.html> into the CMDB, creating relationships, creating series of associations, to different classes, adjusting attributes, took under 2 hours to write. A script similar to that one would be all you need. You would still have to have a form to hold the attached CSVs. A separate Meta-Update script running as a shell script or command file could query unprocessed CSV file records on as throttled a pace as you like and then launch import processes as desired. Total Remedy work: One simple form with only ALs for the User experience. Two Meta-Update scripts (similar to ones already available), One shell script or command file. In short about a days work. No performance issues no matter how many uses. No staging form with workflow to build, maintain, document, manage. Trial licenses are free and unrestricted in functionality or capacities. Please contact us if you have any questions, want more information, a demo, or a trial. Cheers Ben Chernys Senior Software Architect Description: logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:Ben.Chernys_AT_softwaretoolhouse.com> Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and out Freebies Section for a ITSM 7.6.04 and 8.0.0 Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of laurent matheo Sent: January-11-13 11:07 To: [email protected] Subject: Re: Upload data from excel sheet to computer system ** I have a suggestion, don't do it :) We did it for a customer where end users had a console where they could upload csv files to import cis and relations into CMDB and also modify existing assets (status, put it into inventory, stuff like that). It had a very big impact on performances since we had to code extensive checks (that company was ok, people was ok, name was ok and stuff like that). We computed that 1 people running a 200 lines import + check + our own "reconciliation" was as heavy as 600 people working on this ARS server for 1 minute. In the beginning it was just to help asset admins to upload very small quantity of assets and to relieve the are administrators for this kind of tasks. The problem is that the customer went ballistic and opened this to just everyone and they tried to import files with like 2000 records... If you really want to do that, here what we did: 1°) a console where a people can upload a csv file, 2°) the csv file is saved and exported to the ars server where data import is launched to import this csv file into a temporary form, 3°) code some checks (name ok, company ok ), 4°) inject into the right form (computer system), If we had known, we would have code a queue on one of the ARS admin servers from the server group and run only one import at a time, only one check and so on to make it bearable performance speaking. Hope this helps. Laurent. Le 11 janv. 2013 à 10:43, "Ramy S. Ayoub" <[email protected]> a écrit : ** All We have requirements to allow the users upload data into computer system by excel sheet Any suggestion !!! Version 7.6x -- Ramy Ayoub Products and Service Delivery Business Process Automation Vodafone Egypt Phone: +20100441441 Email: [email protected] Smart Village, Vodafone-Egypt C2 Building Cairo/Alex Desert Road KM28, Smart Village _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<image003.jpg>>
smime.p7s
Description: S/MIME cryptographic signature
