Home	Products	Downloads	Order	Support	Links	Contact Us
myPM SCG	myPM Replicate	myPM Update	myPM Merge
Overview	Features	Requirements	Operation	Pricing	History	FAQ

myPM Update: Operation

Inputs...

• User: Update MS Excel Source File ( *.xls ) data.
  
  

Load Data File ( *.upd ) / Configure...

• Define: Source File properties ( Filename, Worksheet, etc. )
• Define: Destination File properties ( Filename, Worksheet, etc. )
• Define: Update Map ( Source Field, Destination Field, Action )
• Define: Update Filter ( Optional: Source Field, Comparison, Value )
• Save: Save configuration to Data File ( *.upd )
  
  

Process Data...

• Extract: Source File data
• Filter: Source File data ( Optional )
• Validate: Source File data
• Open: Open Destination File
  
  

Outputs...

• Update: Update destination file records ( Average source record values )
• Update: Update destination file records ( Count source record values )
• Update: Update destination file records ( List source record values )
• Update: Update destination file records ( Sum source record values )
• Close: Save changes to Destination File

Copyright © 2003 - 2004 Midori Media - All Rights Reserved

Privacy Policy

Feedback

Version 2.5.0.0

17 May 2004