List:Eventum General Discussion« Previous MessageNext Message »
From:Jorge Jarrin Date:September 22 2011 9:53pm
Subject:Re: Eventum Mass Loading of Excel Spreadsheet Information.
View as plain text  
Excuse me.. interesting use for eventum... :) .. are you planning to
register each server as an issue?, and change register as notes?.. and
server data (IP, name, licence, etc) as a custom field; am I wrong?...if
so.. may be is better if you register each server by hand.. because prepare
the files and load it to each table may take a long time...

Regards,
JJ

2011/9/22 Knox, Ernest <Ernest.Knox@stripped>

> Nothing major, just several excel rows of server inventory listing:****
>
> ** **
>
> *Priority*
>
> *Issue ID*
>
> *Reporter*
>
> *Group*
>
> *Assigned*
>
> *Time Spent*
>
> *Status*
>
> 7****
>
> Knox****
>
> Knox****
>
> 0h 0m****
>
> Dev-QA****
>
> ** **
>
> *Status Change Date*
>
> *Last Action Date*
>
> *Est. Dev. TIme*
>
> *Summary*
>
> Updated: 68d 19h ago****
>
> 0****
>
> Server name****
>
> ** **
>
> *Expected Resolution Date*
>
> *MySQL Root Password*
>
> *Application*
>
> xxxxxxxxx****
>
> DR Project ****
>
> ** **
>
> *MySQL Version*
>
> *License*
>
> *I/P Address*
>
> *Sensitive Data*
>
> * *
>
> 5.1.39****
>
> Enterprise - W/ Support****
>
> nn.nn.nn.nn ****
>
> ** **
>
> We want to load all server information to maintain an inventory listing for
> all DBMSs.****
>
> ** **
>
> Thanks,****
>
> ***********************************************************************
>
> Ernie Knox****
>
> IT Database Administrator Specialist****
>
> Sears Holdings - BU: I & T Group****
>
> 3333 Beverly Rd.****
>
> Hoffman Estates, IL. 60179****
>
> Office: (847) 286-5735****
>
> Email: Ernest.Knox@stripped****
>
> Blackberry: 2244650553@stripped****
>
> Informix Email: ifmxdba@stripped and Team: InformixDBA@stripped****
>
> Informix Primary: INFORMIXDBAPrimaryPager@stripped****
>
> Informix Secondary: INFORMIXDBASecondaryPager@stripped****
>
> MySQL Email: MYSQLDBAe@stripped and Team: MySQLDBA2@stripped****
>
> MySQL Primary: MYSQLDBAPrimaryPager@stripped****
>
> MySQL Secondary: MYSQLDBASecondaryPager@stripped****
>
> ** **
>
> " Yes we can make a Change! "****
>
> " It's always a great day to watch Sports: "****
>
> "   Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "****
>
> "   Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "****
>
> GSU****
>
> ***********************************************************************
>
> ** **
>
> *From:* Jorge Jarrin [mailto:jjarrinf@stripped]
> *Sent:* Thursday, September 22, 2011 1:54 PM
> *To:* Knox, Ernest
> *Subject:* Re: Eventum Mass Loading of Excel Spreadsheet Information.****
>
> ** **
>
> may be PHPMyAdmin..or MySQL Workbench..  but ¿what kind of data?.. I mean..
> tickets?.. if so, may be difficult due autonumeric fields on ticket Id....
>  I think it is possible but not easy...personally I use MS Access w/ MySQL
> ODBC for manipulate data in Eventum but only with some "difficult"
> requirements.. (my 5 cents)...****
>
> ** **
>
> JJ****
>
> 2011/9/22 Knox, Ernest <Ernest.Knox@stripped>****
>
> Is it possible to insert and/or mass load delimited data into Eventum?
> Is there a tools or SQL available to perform this task?  We do not wish
> to manually cut and paste each row and/or piece of data at a time.
>
>
>
> Thanks,
>
> *******************************************************************
>
> Ernie Knox
>
> IT Database Administrator Specialist
>
> Sears Holdings - BU: I & T Group
>
> 3333 Beverly Rd.
>
> Hoffman Estates, IL. 60179
>
> Office: (847) 286-5735
>
> Email: Ernest.Knox@stripped <mailto:Ernest.Knox@stripped>
>
> Blackberry: 2244650553@stripped
> <mailto:2244650553@stripped>
>
> Informix Email: ifmxdba@stripped <mailto:ifmxdba@stripped>  and
> Team: InformixDBA@stripped <mailto:InformixDBA@stripped>
>
> Informix Primary: INFORMIXDBAPrimaryPager@stripped
> <mailto:INFORMIXDBAPrimaryPager@stripped>
>
> Informix Secondary: INFORMIXDBASecondaryPager@stripped
> <mailto:INFORMIXDBASecondaryPager@stripped>
>
> MySQL Email: MYSQLDBAe@stripped <mailto:MYSQLDBAe@stripped>  and
> Team: MySQLDBA2@stripped <mailto:MySQLDBA2@stripped>
>
> MySQL Primary: MYSQLDBAPrimaryPager@stripped
> <mailto:MYSQLDBAPrimaryPager@stripped>
>
> MySQL Secondary: MYSQLDBASecondaryPager@stripped
> <mailto:MYSQLDBASecondaryPager@stripped>
>
>
>
> " Yes we can make a Change! "
>
> " It's always a great day to watch Sports: "
>
> "   Lets GO Detroit: Lions, Tigers, Pistons, and Red Wings! "
>
> "   Lets GO Chicago: Bears, Cubs, White Sox, Bulls, and Black Hawks! "
>
> GSU
>
> *******************************************************************
>
>
>
> This message, including any attachments, is the property of Sears Holdings
> Corporation and/or one of its subsidiaries. It is confidential and may
> contain proprietary or legally privileged information. If you are not the
> intended recipient, please delete it without reading the contents. Thank
> you.****
>
>
>
> ****
>
> ** **
>
> --
>
> ================================================================================
> 190grCO2/Km = Generación de CO2 por Km de recorrido de mi auto
> ¿No sería mejor si primero intentamos resolverlo todo por e-mail,
> teléfono
> o video conferencia?
>
> ****
>  This message, including any attachments, is the property of Sears Holdings
> Corporation and/or one of its subsidiaries. It is confidential and may
> contain proprietary or legally privileged information. If you are not the
> intended recipient, please delete it without reading the contents. Thank
> you.
>



-- 
================================================================================
190grCO2/Km = Generación de CO2 por Km de recorrido de mi auto
¿No sería mejor si primero intentamos resolverlo todo por e-mail,
teléfono o
video conferencia?

Thread
Eventum Mass Loading of Excel Spreadsheet Information.Ernest Knox22 Sep
RE: Eventum Mass Loading of Excel Spreadsheet Information.Ernest Knox22 Sep
  • Re: Eventum Mass Loading of Excel Spreadsheet Information.Jorge Jarrin22 Sep