Aportes

Note: The Colored Block below is a “Button” to restart the program.


[pic]
Instructions for Converting Excel Files Instructions for Converting C2PC Files



PLEASE!!! Check for updates at http://www.mission-planning.com
PPT Training Presentation Available Too!
Caution: Word Macro Security must be set to “Medium” to run Excel2FV successfully. Ifyou weren’t asked to “Enable Macros” then your security setting is wrong. Go to Tools – Macro –Security in the Menu and switch to Medium. Close and reopen Word before running the program.



CheckList for Importing Excel/Text Data

1. Use an Excel or Tab Delimited File. Tab delimited files import quicker so if you have a large number of points (over 1000) to import it may be faster tocreate a tab delimited file first.
2. Click on the “Source” button in the program and browse to your source (*.txt or *.xls) file. By default the files will be filtered to only show .xls file. You can change the “Files of Type” option to switch to text files.
3. Confirm destination filename. Full filename is available if you move the mouse over the short filename. If you don’t have fullaccess to all your storage devices save the file somewhere you can open it again.
4. Ensure the Label row is correctly identified. Import of data will start on the line after the labels
5. Select to import to a local point file or drawing file. Select desired options for general import, i.e. icon and point group for a local point import and shape, color and size for a drawing object. You canuse the existing sizes and point group or type in a new group or point size.
6. Assign columns from the import file to items in the PFPS export file. At a minimum you need to assign Latitude, Longitude and (for a local point file) Name. Columns that aren’t assigned are transferred “comments” unless you choose “Don’t Import” for the column. These comments will appear in the comment section ofthe local point or drawing item record. Local Point Comments are limited to 255 characters and Drawing File Comments have no limit.
7. Assign Filters if desired. Check to Enable Filters then push the “Set Filters” button. First select a filter column. Each record in this column will be searched for records containing the text you specify in Filters 1 through 20. If a match is found, thecolor/shape or icon/point group you specify will be assigned to that point. Filter 1 is the highest priority filter and Filter 20 is the lowest, i.e. if a records text matches the criteria for Filter 1 and Filter 5, the Filter 1 specifications will apply to that point’s record. You can search for several different strings by separating them with columns, i.e. “Church, Mosque, Synagogue” will groupany record containing any of the three strings. You can do searches that are limited to the start of a string using the ~ character, for example a search for “74~” will find “74556” but not “56474”. Similarly, searching for “~74” will search for records that end with 74 only.
8. Save your import settings! Press the “Save Import Settings” button on the main tab to save all the filters, columnassignments etc. that you’ve entered. Next time you receive a file in the same format, just click on the “Load Import Settings” to restore all the assignments you’ve made.
9. Click on the “Create!” button and sit back. If a record is found with a zero in the Latitude or Longitude record you will be asked if you want to Accept/Fix (you can make manual corrections), skip the single record, skipall records with a zero Latitude or Longitude or accept all records with a zero.
Troubleshooting
• Make sure your MS Word Security is not set to “High”. Go to Tools – Macros – Security and make sure you’re set to Medium. When you open the file you must enable Macros.
• Make sure PFPS and PFPS Update (4.1.1 and earlier) or In2FV (4.2 and beyond) are installed. This program uses Visual...