Page 1 of 1
upload lagacy assets
Posted: Mon May 18, 2009 11:58 am
by scorpion09
Hi
this month we'll start manage our assets using Oracle FA
but first we need to upload all existing assets from the old system
the number of assets is above 200 000 assets, so if we'll use ADI,or WEB ADI we need at least 3 months to upload these assets .we'll use SQL loader .can any one help or tell me how to use SQL LOADER to load these assets and wich table should i use.
best regards[:)]
Posted: Tue May 19, 2009 1:41 am
by pinnashanmukh
Hi,
Who told it will take months using web adi.
If the data is correct it hardly takes one day
Even using SQL loader initial data should be correct right?
Thanks,
Shanmukh
Posted: Tue May 19, 2009 6:36 am
by scorpion09
hi
thanks for reply
right all data are right
Posted: Tue May 19, 2009 7:24 am
by scorpion09
so can you help me to use sql loader
Posted: Tue May 19, 2009 8:26 am
by oteixeira
Hello.
As Shanmukh said, if you initial data is correct you can use WEB ADI to load it.
Octavio
Posted: Wed May 20, 2009 6:12 am
by scorpion09
HI
but i've probleme with web adi that i can't have attributes in my file how can i do this
regards
Posted: Wed May 20, 2009 6:36 am
by oteixeira
Hello.
I see you problem. So what you need is some help on writing the sqlloader ctl file, right? If you give me the column names and types of the FA_MASS_ADDITIONS interface table you want to update perhaps i can help you on writing the sqlloader script.
My e-mail is
oteixeira@tuiportugal.com
Octavio
Posted: Wed May 20, 2009 7:10 am
by scorpion09
HI
THANKS OCTAVIO FOR REPLY I'VE UPLOAD THE LEGACY DATA FILE STRUCTURE.
REGARDS
[img]/images/icon_zip.gif[/img] <b>Attachment:</b>
EXCEL ASSET FILE STRUCTURE.zip <i>( 2627bytes )</i>
Posted: Mon Jun 01, 2009 1:35 am
by pinnashanmukh
Hi,
I can see that All the columns used can be uploaded throught Web ADI.
You have to change the lay out and try again.
If columns are not available then u have to go for sql loader
thanks,
shanmukh