User Tools

Site Tools


falcon4:tools:csv2tdf

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
falcon4:tools:csv2tdf [2016/11/12 10:51] – switched tactical.nekromantix.com to www.pmctactical.org domain. snakemanfalcon4:tools:csv2tdf [2024/07/31 10:04] (current) – links added. snakeman
Line 1: Line 1:
-====== CSV2TDF ======+====== Falcon 4 CSV2TDF ======
  
-**CSV2TDF** by Sherlock+[[https://www.pmctactical.org/forum/viewforum.php?f=47|Falcon 4.0 Forum]], [[:falcon4|Falcon 4 Home]], [[falcon4:campaign|Falcon 4 Campaign]], [[falcon4:cockpits|Falcon 4 Cockpits]], [[falcon4:database|Falcon 4 Database]], [[falcon4:file_formats|Falcon 4 File Formats]], [[falcon4:srtm|Falcon 4 SRTM Terrain]], [[falcon4:terrain|Falcon 4 Terrain]], [[falcon4:textures|Falcon 4 Textures]], [[falcon4:tools|Falcon 4 Tools]] 
 + 
 +**Falcon 4 CSV2TDF** by Sherlock
  
 The purpose of this MS Excel macro converter is to convert your airbases.csv file to the .tdf file format that [[falcon4:tools:terrainview|Terrainview]] can read and which [[falcon4:tools:dem2terrain|DEM2Terrain]] makes when first creating terrain. The purpose of this MS Excel macro converter is to convert your airbases.csv file to the .tdf file format that [[falcon4:tools:terrainview|Terrainview]] can read and which [[falcon4:tools:dem2terrain|DEM2Terrain]] makes when first creating terrain.
Line 14: Line 16:
   - Open the accompanying airbases.xls file in the same instance of MS Excel.   - Open the accompanying airbases.xls file in the same instance of MS Excel.
   - Select and copy the first 7 columns from your airbase xls file (out to the 7th column - "Y"); then paste those copied columns into the accompanying airbases.xls file on worksheet "Sheet1" This is important that you paste onto "Sheet1". If you don't, the macro won't work.  Also, on the airbases.xls file, start your paste operation in cell A1; this is important also.   - Select and copy the first 7 columns from your airbase xls file (out to the 7th column - "Y"); then paste those copied columns into the accompanying airbases.xls file on worksheet "Sheet1" This is important that you paste onto "Sheet1". If you don't, the macro won't work.  Also, on the airbases.xls file, start your paste operation in cell A1; this is important also.
-  - In the upper left corner, in the MS Excel menus: +  - In the upper left corner, in the MS Excel menus:
     - a. click on "Tools",     - a. click on "Tools",
-    - b. then click on "Macro", +    - b. then click on "Macro",
     - c. then click on "Marcros" (the MACRO dialog box should pop up),     - c. then click on "Marcros" (the MACRO dialog box should pop up),
     - d. then click on/highlight Macro name: "AirbaseConvert",     - d. then click on/highlight Macro name: "AirbaseConvert",
     - e. then click on the "Run" button.     - e. then click on the "Run" button.
   - The macro should then run, reporting success with a popup dialog box that says "Done ------------------>". Your csv file data has now been converted to a tdf file with the name "airbases-outputMMDD.TDF" The MM is the current month and DD is the current day of the month . The file will mostly likely be saved/written in your "My Documents" folder because that is where MS Office applications typically are pointed as the default path when installed. If not, just do a search on "My Computer" for the following string:  "airbases-output*" (without the quotation marks) and you should find it no problem.   - The macro should then run, reporting success with a popup dialog box that says "Done ------------------>". Your csv file data has now been converted to a tdf file with the name "airbases-outputMMDD.TDF" The MM is the current month and DD is the current day of the month . The file will mostly likely be saved/written in your "My Documents" folder because that is where MS Office applications typically are pointed as the default path when installed. If not, just do a search on "My Computer" for the following string:  "airbases-output*" (without the quotation marks) and you should find it no problem.
-  - Please report any bugs experienced at PMC Tactical in the forums, under the [[http://www.pmctactical.org/forum/viewforum.php?f=26|Theater Tools]] forum.  If one thread for csv2tdf has already been started, then please use that same thread for your bug report.+  - Please report any bugs experienced at PMC Tactical in the forums, under the [[https://www.pmctactical.org/forum/viewforum.php?f=26|Theater Tools]] forum.  If one thread for csv2tdf has already been started, then please use that same thread for your bug report.
  
 ====== Tips ====== ====== Tips ======
Line 27: Line 29:
 Open the TDF file in text editor, then start to go through the airbases in terrainview. Each airbase you confirm its okay, remove its line on the TDF file. After you've removed enough of them, save the TDF, then reload the TDF in Terrainview to update the list. Now the airbase dots arent showing the already checked airbases, saving even more time when you go through the dots. Open the TDF file in text editor, then start to go through the airbases in terrainview. Each airbase you confirm its okay, remove its line on the TDF file. After you've removed enough of them, save the TDF, then reload the TDF in Terrainview to update the list. Now the airbase dots arent showing the already checked airbases, saving even more time when you go through the dots.
  
-Download [[http://www.pmctactical.org/f4/downloads/CSV2TDF.rar|CSV2TDF.rar]] - 8kb.+Download CSV2TDF.rar - 8kb. PMCTODO download is missing!? 
falcon4/tools/csv2tdf.1478947885.txt.gz · Last modified: 2016/11/12 10:51 by snakeman

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

All PMC web site download services are temporarily suspended until web site yearly fees have been recovered, want to download addons/mods? Then Support PMC.

If you are grateful for all the work PMC has done in the past 25 years, use Support PMC page.