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 2329GMT + 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:arslist@ARSLIST.ORG] On Behalf Of laurent matheo
Sent: January-11-13 11:07
To: arslist@ARSLIST.ORG
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" 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: ramy.ay...@vodafone.com
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"
<>
smime.p7s
Description: S/MIME cryptographic signature
