ࡱ> ;( ~/ 0|DTimes New Romantts 0DTahomaew Romantts 0" DWingdingsRomantts 00DArialngsRomantts 0@DGaramondRomantts 0 C).n<@  @@``  @n?" dd@  @@``   ($     !"#$ xaxa     A@  A1 8c8c     ?1 d0u0@Ty2 NP'p<'pA)BCD|E||s " 0e@        @ABC DEEFGHIJK5%LMNOPQRSTUWYZ[ \]^_ `abN E5%  N E5%  N F   5%    !"?N@ABC DEFFGHIJK5%LMNOPQRSTUWYZ[ \]^_ `ab`f@8 g4(d(dP 0%ppp@ E`ʚ;ʚ;<4dddd@ x 0@<4BdBd@ x 0@r0___PPT10 2___PPT9/ 0?  %,MANMAN DATA MIGRATION MANMAN DATA MIGRATION Overview $Benefits of Automated Data Conversion General Approach & Considerations Data Manipulation Go-Live Data Conversion Alternative Approaches Conclusions f"AUTOMATED DATA CONVERSION Benefits #( $Data consistency Referential integrity between tables Fewer errors Faster than manual methods for large numbers of records Accurate field translations Effective for multiple sites f GENERAL APPROACH GENERAL APPROACHIdentify files and fields to be converted Perform data mapping Define conversion from old to new values Extract data from Manman Add new application defaults Convert data to new format Testing and validation Upload data into new ERP application f GENERAL APPROACH?Static data should be converted through the automated data conversion process Files with a smaller number of records should be entered manually Transactional data should be entered manually Determine timing as it will affect month-end and any other signification reporting dates, for example, inventory and G/L overlays@ f@GENERAL APPROACH Static Data&  BIdentify files and fields to be converted Static data should be transferred using automatic data conversion Item Master % Vendors Product Master % Customers Inventory by Location % Ship-to addresses Bills of material % Pricing table Routings % General Ledger Employees % G/L Historyh* fB `A*B  %  'GENERAL APPROACH Transactional Records 0( $Transactional records entered manually Open Accounts Payable Open Accounts Receivable Open Purchase Orders Open Sales Orders Open Work Orders8' g`7'g  GENERAL APPROACH Historical Data! The following historical data can be extracted from Manman and preserved for inquiry and reporting using SSGBusIntell: Accounts Payable Distribution Accounts Receivable History Closed Production Orders Purchase Order History Purchase Receipt History Historical stock balances lw  !i " GENERAL APPROACH Historical Data! Removing the historical data from Manman can meet the following organizational needs: The end-user will have Manman data available for reporting and inquiry I/T can take the Manman system off-line to eliminate maintenance requirements6V  V!GENERAL APPROACH Optional Data The following data can be converted manually or automatically, or some of it may not apply to your environment: Bills of Material Routings Operations Lot Master and Variable Features Approved Supplier List Rp c !fpeGENERAL APPROACH Data Mapping&  Data mapping & related considerations Define matching files Define matching fields Define field translations & cross-references Identify table dependencies J& fx &x #GENERAL APPROACH Data Mapping to MK&$ Manman Files MK Tables Item Master tiitm001 Item Data Product Master tiitm001 Item Data Inventory by Location tdinv001 Item Data by Whse Bills of Material tibom010 Bill of Material Routings tirou020 Routing Vendors tccom020 Suppliers Bill-to Customers tccom010 Customers Ship-to Customers tccom013 Delivery Address Pricing file tdsls032 Prices by Price List G/L History tfgld011 G/L Balances tfgld012 G/L HistoryP     ) GENERAL APPROACHlAutomated Data Conversion Output format ASCII file Variable field lengths Delimited with  | No trailing delimiter No quotes around strings Numeric values for enum fieldsT f A7GENERAL APPROACHAutomated Data Conversion Special handling may be required for: Date fields Field alignment Decimal point Right justification Combined fields Special characters Output example (pricing by price list) SPL|100015|999999|01011994|00000000|45.21|0|1  f& +A7_ .A7&+_.  DATA MANIPULATIONExport data from Manman Load data into Access Perform translations and conversions from Manman values to value in new ERP application Add new defaults and required fields Extract data from Access Upload data into new ERP application N/ f} ? f/}?"Automated Data Conversion Solution# $SSGBusIntell provides an  off-the-shelf solution that meets approximately 80% of the data conversion requirements SSGBusIntell consists of a series of data extracts that take data from Manman to an Access or SQL database B f g `"Automated Data Conversion Solution# $mSSGBusIntell static data extracts from Manman: Customer Master Vendor Master Item Master Employees InventoryD/ f?  #?"Automated Data Conversion Solution# $SSGBusIntell data extracts from Manman: Accounts Payable Distribution Accounts Receivable History Closed Work Orders Purchase Order History Purchase Receipt History General Ledger Detail and Summary Open Sales Orders Open Accounts Receivable Open Purchase Orders Open Production OrdersJ( f   GO-LIVE DATA CONVERSIONSample Conversion Sequence General Ledger accounts Item master Vendor master Customer master Employee master Delivery addresses Bills of material Routings Prices by price list Item data by warehouse Manual data entry of A/R, A/P, S/O, P/O, W/O Go live G/L history8 f ALTERNATIVE APPROACHES*Modify standard SSGBusIntell extracts to: Build translation and cross-references into the data extracts Create new default values using Manman values Use Quiz extracts to enhance SSGBusIntell data extracts * fm8 f    m   Advantages  iSSGBusIntell contains 80% of the data needed for most data conversions SSGBusIntell extracts can easily be modified to add Cross references New values based on Manman values Software development time is limited or not required, depending on conversion requirements Results can be achieved more quickly SSG has good knowledge of Manman data structures and tools| f3  f : )3 CONCLUSIONS  Compare benefits of SSGBusIntell data conversion tool to cost of software development to create conversion scripts from  scratch Suggestions for success Go slow and plan conversion carefully Focus on the static data Assemble a team with varied application and technical skills Save some energy for post-conversion difficultiesX f  z/PL  0` 33PP` 13` 3333` Q_{` 333fpKNāvI` j@v۩ῑ΂H>?" dd@,?n<d@ `7 `2@`7``2 n?" dZ(@   @@``PR    @ ` ` p>> n f ` X (  X X <tڒ" B   X Tݒd" B   X <@"U_ B   X Td">& B   X Nt"P B   X <"p B   X C xh?d?"bUv B    X < #" `   T Click to edit Master title style! !$  X 0 "   RClick to edit Master text styles Second level Third level Fourth level Fifth level!     S  X 6( "]}  ^*   X 6  "] }    `*   X 6  "]T}   `* B X s *޽h ? 333380___PPT10.(г%  Blends   0 5 - p\ (  \T + \ "+bb P@ \# "Dwoh \ s *"PP \ Bd" P@bb P 0  \# "Nyh \ s *"P   \ Bd"P 0 z  \ <" a*h  \ s *"  \  f?d?"+)  \ BT  ?#" ` p   T Click to edit Master title style! !  \ 0  " `     W#Click to edit Master subtitle style$ $ \ 6xU*  "`p  *  b*  \ 6Y*  "`p  *  d*   \ 6D^*  "` *  d*  B \ s *޽h ? 333380___PPT10.(г% 0 SK (    Z UU1?k]  ~ Page *Z  ###55FFp  01 ?    )  ZP xaxa1 ? @   ;Body Text Second Level Third Level Fourth Level Fifth Level     <B  s *޽h ? a(80___PPT10.@>* 0 P(     Z$* UU1?k]   Page *Z ###55FFB  s *޽h ? a(80___PPT10.@d  0L0 @(    3 r` xaxa1 ? X`   4  Zĕ xaxa1?  6Strategic Systems Group www.ssgnet.com info@ssgnet.com(7 0&I  Z xaxa 1?"6@ NNN?N`^ +MK BaaN Oracle Many other ERP applications ,,( n<2,$H  0޽h ? a(y___PPT10Y+D='  = @B +3  0L0 B:`(    C xD xaxa1 ? X      3 r xaxa1 ? X    H  0޽h ? a(y___PPT10Y+D='  = @B +3  0L0 B:p(    C x8 xaxa1 ? X      3 r xaxa1 ? X   H  0޽h ? a(y___PPT10Y+D='  = @B +  0L0   <m (  <l < 61?"`4 |l < 61?"`l l < 61?"`4l  < 3 r\ xaxa1 ? Xp    < Z9 xaxa1?P\ EClassic Manman  < Z` xaxa1?p0  e!SSGBusIntell ASCII file extracts("  < Zf xaxa1?  l  IASCII extract files  < Zk xaxa1?px  HASCII file format  < Zl8 xaxa1?t  SASCII formatted import files  < Zq xaxa1?$, JNew ERP application < Txu xaxa1?~ `j Z$File Transfer to new ERP application%% < Zx xaxa1?  GData Manipulation < T$} xaxa1?0 Yo V File Transfer from Manman system!!^B < 61?d``l^B < 61?` 0 ^B < 61?P ^B < 61? h^B < 61?,t < B 1?"` `  BAccess 0^B < 6D1?p H < 0޽h ? a(y___PPT10Y+D='  = @B +9  0L0 H@ ( [F[    C x$) xaxa1 ? X      C x) xaxa1 ? X   H  0޽h ? a(y___PPT10Y+D='  = @B +9  0L0 H@$(  $ $ C x7 xaxa1 ? X`     $ C x8 xaxa1 ? X`   H $ 0޽h ? a(y___PPT10Y+D='  = @B +}  0 h$(  hr h S F  X    r h S XG  X    H h 0޽h ? 3333___PPT10i.PHU+D='  = @B +9  0L0 H@((  ( ( C xM xaxa1 ? X     ( C xtN xaxa1 ? X    H ( 0޽h ? a(y___PPT10Y+D='  = @B +}  0  $(  r  S a  X    r  S b  Xp     H  0޽h ? 3333___PPT10i. +D='  = @B +}  0 @$(  r  S p  X    r  S   X    H  0޽h ? 3333___PPT10i.ڿ@͡+D='  = @B +}  0 $(  r  S   X    r  S   X P   H  0޽h ? 3333___PPT10i.+D='  = @B +}  0 d$(  dr d S   X0   r d S   X    H d 0޽h ? 3333___PPT10i.p _+D='  = @B +-  0L0 <4,(  , , 3 r$ xaxa1 ? X@    , 3 r xaxa1 ? X    H , 0޽h ? a(y___PPT10Y+D='  = @B +3  0L0 B:4(  4 4 C xt xaxa1 ? X     4 3 r xaxa1 ? X0   H 4 0޽h ? a(y___PPT10Y+D='  = @B +}  0 p$(  pr p S   XS   r p S P  X     H p 0޽h ? 3333___PPT10i. 1+D='  = @B +}  0 t$(  tr t S p  XS`   r t S   Xp    H t 0޽h ? 3333___PPT10i.d+D='  = @B +}  0 l$(  lr l S 0  X    r l S @  X    H l 0޽h ? 3333___PPT10i.P)+D='  = @B +}  0 x$(  xr x S   X    r x S   X 0   H x 0޽h ? 3333___PPT10i.A+D='  = @B +}  0 |$(  |r | S X*  X   *  r | S H*  XP` *  H | 0޽h ? 3333___PPT10i.V+D='  = @B +-  0L0 <4D(  D D 3 rl* xaxa1 ? X0p`  *   D 3 r* xaxa1 ? X0  *  H D 0޽h ? a(y___PPT10Y+D='  = @B +-  0L0 <40L(  L L 3 rL%* xaxa1 ? X0  *   L 3 r<&* xaxa1 ? X *  H L 0޽h ? a(y___PPT10Y+D='  = @B +}  0 `$(  `r ` S 0*  X S`  *  r ` S 1*  X0p *  H ` 0޽h ? 3333___PPT10i.+D='  = @B +9  0L0 H@@P(  P P C xD0* xaxa1 ? Xp   *   P C x xaxa1 ? Xp   *  H P 0޽h ? a(y___PPT10Y+D='  = @B +J 0  P(    # l xaxa1 ? @       H1 ?    H  0޽h ? a(r0UYp[`cu?yZ (gcR;JͥՉ|ʒԗOYޜFP˄"1;( ~/ 0|DTimes New RomanTTsܖ 0ܖDTahomaew RomanTTsܖ 0ܖ" DWingdingsRomanTTsܖ 0ܖ0DArialngsRomaOh+'0|3 px  8 D P\dMANMAN Data Migration(David Cervelli (dcervelli@ssgnet.com)Manman Data MigrationBlends PJohnson62Microsoft PowerPoint@*-6;@0Ҫ@5G2;  9  y--$xx--'--$--'---$   --O--$--݊--$----$----$----$---'33--$  "" --'-55--$##--XX--$##----$##----$##----$##----$##----$##---'9A  (yybbMM88kkVV@@uu__~~*+,-./01"#$%&'() !  '--$  # #  --'---$----$  --"""--$     --$$$--$     --&&&--$     --)))--$     --+++--$   -------$--///--$--111--$--333--$--555--$--777--$--999--$--<<<--$-->>>--$--@@@--$--BBB--$--DDD--$--FFF--$--HHH--$--JJJ--$--LLL--$--OOO--$--QQQ--$  --SSS--$  !! --UUU--$!!""!--XXX--$""##"--ZZZ--$##$$#--\\\--$$$%%$--^^^--$%%&&%--```--$&&''&--ccc--$''(('--eee--$(())(--ggg--$))**)--iii--$**++*--lll--$++,,+--nnn--$,,--,--ppp--$--..---sss--$..//.--uuu--$//00/--xxx--$00110--zzz--$11221--|||--$22332--~~~--$33443----$44554----$55665----$66776----$77887----$88998----$99::9----$::;;:----$;;<<;----$<<==<----$==>>=----$>>??>----$??@@?----$@@AA@----$AABBA----$BBCCB----$CCDDC----$DDEED----$EEFFE----$FFGGF----$GGHHG----$HHIIH----$IIJJI----$JJKKJ----$KKLLK----$LLMML----$MMNNM----$NNOON----$OOPPO----$PPQQP----$QQRRQ----$RRSSR----$SSUUS----$UUVVU----$VVWWV----$WWYYW----$YYZZY----$ZZ[[Z----$[[\\[----$\\^^\----$^^__^----$__aa_----$aabba----$bbddb----$ddeed----$eegge----$gghhg----$hhjjh----$jjllj----$llnnl----$nnppn----$ppssp----$ssuus----$uuwwu----$ww{{w----${{}}{----$}}}----$----$----$----$---'@"Tahoma-. 33'2 MANMAN DATA MIGRATION. "System:-@Arial-. *2 e^Strategic Systems Group.-@Arial-. 2 ijwww.ssgnet.com.-@Arial-. 2 niinfo@ssgnet.com.-@"Tahoma-. 33 2 *LMK.-@"Tahoma-. 33 2 8IBaaN.-@"Tahoma-. 332 GFOracle.-@"Tahoma-. 3302 U Many other ERP applications.-՜.+,0  $ ,4 <DLT \ eData ConversionLetter Paper (8.5x11 in)(Strategic Systems Group, Inc. (SSG)a Times New RomanTahoma WingdingsArial GaramondBlendsMANMAN DATA MIGRATIONMANMAN DATA MIGRATION Overview#AUTOMATED DATA CONVERSION BenefitsGENERAL APPROACHGENERAL APPROACHGENERAL APPROACHGENERAL APPROACH Static Data(GENERAL APPROACH Transactional Records !GENERAL APPROACH Historical Data!GENERAL APPROACH Historical DataGENERAL APPROACH Optional DataGENERAL APPROACH Data Mapping$GENERAL APPROACH Data Mapping to MKGENERAL APPROACHGENERAL APPROACHDATA MANIPULATION#Automated Data Conversion Solution#Automated Data Conversion Solution#Automated Data Conversion SolutionGO-LIVE DATA CONVERSIONALTERNATIVE APPROACHES Advantages CONCLUSIONS  Fonts UsedDesign Template Slide Titles _y0PJohnsonPJohnson  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWYZ[\]^_`abcdefghijklmnopqRoot EntrydO)_@Current User8SummaryInformation(X3PowerPoint Document(aDocumentSummaryInformation8nTTsܖ 0ܖ@DGaramondRomanTTsܖ 0ܖ C).n<@  @@``  @n?" dd@  @@``   ($     !"#$ xaxa     A@  A1 8c8c     ?1 d0u0@Ty2 NP'p<'pA)BCD|E||s " 0e@        @ABC DEEFGHIJK5%LMNOPQRSTUWYZ[ \]^_ `abN E5%  N E5%  N F   5%    !"?N@ABC DEFFGHIJK5%LMNOPQRSTUWYZ[ \]^_ `ab`f@8 g4(d(dP 0%ppp@ E`ʚ;ʚ;<4dddd  x 0 <4BdBd  x 0 r0___PPT10 2___PPT9/ 0?  %,MANMAN DATA MIGRATION MANMAN DATA MIGRATION Overview $Benefits of Automated Data Conversion General Approach & Considerations Data Manipulation Go-Live Data Conversion Alternative Approaches Conclusions f"AUTOMATED DATA CONVERSION Benefits #( $Data consistency Referential integrity between tables Fewer errors Faster than manual methods for large numbers of records Accurate field translations Effective for multiple sites f GENERAL APPROACH GENERAL APPROACHIdentify files and fields to be converted Perform data mapping Define conversion from old to new values Extract data from Manman Add new application defaults Convert data to new format Testing and validation Upload data into new ERP application f GENERAL APPROACH?Static data should be converted through the automated data conversion process Files with a smaller number of records should be entered manually Transactional data should be entered manually Determine timing as it will affect month-end and any other signification reporting dates, for example, inventory and G/L overlays@ f@GENERAL APPROACH Static Data&  BIdentify files and fields to be converted Static data should be transferred using automatic data conversion Item Master % Vendors Product Master % Customers Inventory by Location % Ship-to addresses Bills of material % Pricing table Routings % General Ledger Employees % G/L Historyh* fB `A*B  %  'GENERAL APPROACH Transactional Records 0( $Transactional records entered manually Open Accounts Payable Open Accounts Receivable Open Purchase Orders Open Sales Orders Open Work Orders8' g`7'g  GENERAL APPROACH Historical Data! The following historical data can be extracted from Manman and preserved for inquiry and reporting using SSGBusIntell: Accounts Payable Distribution Accounts Receivable History Closed Production Orders Purchase Order History Purchase Receipt History Historical stock balances lw  !i " GENERAL APPROACH Historical Data! Removing the historical data from Manman can meet the following organizational needs: The end-user will have Manman data available for reporting and inquiry I/T can take the Manman system off-line to eliminate maintenance requirements6V  V!GENERAL APPROACH Optional Data The following data can be converted manually or automatically, or some of it may not apply to your environment: Bills of Material Routings Operations Lot Master and Variable Features Approved Supplier List Rp c !fpeGENERAL APPROACH Data Mapping&  Data mapping & related considerations Define matching files Define matching fields Define field translations & cross-references Identify table dependencies J& fx &x #GENERAL APPROACH Data Mapping to MK&$ Manman Files MK Tables Item Master tiitm001 Item Data Product Master tiitm001 Item Data Inventory by Location tdinv001 Item Data by Whse Bills of Material tibom010 Bill of Material Routings tirou020 Routing Vendors tccom020 Suppliers Bill-to Customers tccom010 Customers Ship-to Customers tccom013 Delivery Address Pricing file tdsls032 Prices by Price List G/L History tfgld011 G/L Balances tfgld012 G/L HistoryP     ) GENERAL APPROACHlAutomated Data Conversion Output format ASCII file Variable field lengths Delimited with  | No trailing delimiter No quotes around strings Numeric values for enum fieldsT f A7GENERAL APPROACHAutomated Data Conversion Special handling may be required for: Date fields Field alignment Decimal point Right justification Combined fields Special characters Output example (pricing by price list) SPL|100015|999999|01011994|00000000|45.21|0|1  f& +A7_ .A7&+_.  DATA MANIPULATIONExport data from Manman Load data into Access Perform translations and conversions from Manman values to value in new ERP application Add new defaults and required fields Extract data from Access Upload data into new ERP application N/ f} ? f/}?"Automated Data Conversion Solution# $SSGBusIntell provides an  off-the-shelf solution that meets approximately 80% of the data conversion requirements SSGBusIntell consists of a series of data extracts that take data from Manman to an Access or SQL database B f g `"Automated Data Conversion Solution# $mSSGBusIntell static data extracts from Manman: Customer Master Vendor Master Item Master Employees InventoryD/ f?  #?"Automated Data Conversion Solution# $SSGBusIntell data extracts from Manman: Accounts Payable Distribution Accounts Receivable History Closed Work Orders Purchase Order History Purchase Receipt History General Ledger Detail and Summary Open Sales Orders Open Accounts Receivable Open Purchase Orders Open Production OrdersJ( f   GO-LIVE DATA CONVERSIONSample Conversion Sequence General Ledger accounts Item master Vendor master Customer master Employee master Delivery addresses Bills of material Routings Prices by price list Item data by warehouse Manual data entry of A/R, A/P, S/O, P/O, W/O Go live G/L history8 f ALTERNATIVE APPROACHES*Modify standard SSGBusIntell extracts to: Build translation and cross-references into the data extracts Create new default values using Manman values Use Quiz extracts to enhance SSGBusIntell data extracts * fm8 f    m   Advantages  iSSGBusIntell contains 80% of the data needed for most data conversions SSGBusIntell extracts can easily be modified to add Cross references New values based on Manman values Software development time is limited or not required, depending on conversion requirements Results can be achieved more quickly SSG has good knowledge of Manman data structures and tools| f3  f : )3 CONCLUSIONS  Compare benefits of SSGBusIntell data conversion tool to cost of software development to create conversion scripts from  scratch Suggestions for success Go slow and plan conversion carefully Focus on the static data Assemble a team with varied application and technical skills Save some energy for post-conversion difficultiesX f  z/Pry-"1 ՜.+,0  $ ,4 <DLT \ eData ConversionLetter Paper (8.5x11 in)(Strategic Systems Group, Inc. (SSG)a Times New RomanTahoma WingdingsArial GaramondBlendsMANMAN DATA MIGRATIONMANMAN DATA MIGRATION Overview#AUTOMATED DATA CONVERSION BenefitsGENERAL APPROACHGENERAL APPROACHGENERAL APPROACHGENERAL APPROACH Static Data(GENERAL APPROACH Transactional Records !GENERAL APPROACH Historical Data!GENERAL APPROACH Historical DataGENERAL APPROACH Optional DataGENERAL APPROACH Data Mapping$GENERAL APPROACH Data Mapping to MKGENERAL APPROACHGENERAL APPROACHDATA MANIPULATION#Automated Data Conversion Solution#Automated Data Conversion Solution#Automated Data Conversion SolutionGO-LIVE DATA CONVERSIONALTERNATIVE APPROACHES Advantages CONCLUSIONS  Fonts UsedDesign Template Slide Titles _=0PJohnsonPJohnson