I am working on building a clean ready to import dataset in a configuration package while development is going on.
When the developers or Microsoft-update create a new field it does not get added to the fields in the configuration package. (I have no idea why)
For this Particular table i have 223 fields, 96 of which need to be checked , the rest unchecked
What I currently Do.
- create a new config pack where i can add the table temporarily so that I can draw a fresh list of the fields (this includes the fields missing in my package)
- copy the missing fields data or keep it open in another tab for reference
- Go to the config package table's fields and enter Edit Mode
- Scroll to bottom (make sure all fields are loaded)
- CTRL+a -> CTRL+c -> CTRL+v them to an XL file
- In XL insert the missing row data based on the data from step 1
- Delete the table from the Config Package who's fields I want to update
- Readd the table (now the missing fields are included but all fields are set to included for import.
- Enter Edit List mode for the fields Scroll to bottom (make sure all fields are loaded)
- CTRL+a -> CTRL+v
- After following the prompts i now have the missing fields included in my table and I have not lost the order of included and excluded fields.
Is there no way to just tell BC to look for any fields missing from the table in the config package?
Doing this kind of stuff several times a week gives me conniptions.
