EXPORT – IMPORT FOR BATCH UPDATE (PF7)

Short outline and example to update customer division.

See other articles for details on how to export and import.

1. Export primary key, description, and field to update. Save as text file (.txt, not .prn)

Example to update Customer Division:

Export CUSTOMERS : CCODE, CNAME, C_DIV_CODE
Save as Cust_DIV.txt

2. Open in Excel. Use Fill Down commands to populate the C_DIV_CODE (third) column with the correct division code. Save as TXT file.

3. Import for UPDATE into PF.
Import > Map fields as above.
Be sure to select UPDATE button, not INSERT button.

Also see this:
Import for Update

Back to Top
Verified by MonsterInsights