![]()
|
|
|
| Home Products Support Order Contact Site Map |
Member Provanum Group |
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||
| Does your CDRL (Contract Data Requirements List)
specify delivery to JEDMICS standards? Using Trix RasterServer or
TracTrix you can convert your drawing files into the
JEDMICS C4 files required for many DoD contracts. And you can use an Excel
spreadsheet to record the file names, titles, sizes, etc. that JEDMICs requires.
But how do you convert the Excel spreadsheet into the Index.dlf file to submit
to the program office along with your C4 files? The instructions below should help you make the conversion from the Excel spreadsheet to the index.dlf file. |
What is a CDRL? It is a Contract Data Requirements List and defines the data that is to be delivered to the Government by the contractor. The data may be in hard copy, electronic, electronic mailable, or any other form specified. The specific form of delivery needs to be specified either in the SOW and/or in each individual CDRL item. |
Or let us do the work: We offer conversion services. We can create and assemble together your JEDMICS compliant document list with all the DLF files, C4 images and electronic documents required, ready for delivery to your program manager.
|
|
Instructions to convert an Excel Spreadsheet into a Pipe Delimited index.dlf file for JEDMICS: |
||||||||||||||
|
|
|
||||||||||||||
|
Open the spreadsheet in Excel
|
|||||||||||||||
|
2 |
Do “File
Save As…” and choose a tab-delimited txt file (see below).
You will get a
message, something like this
|
||||||||||||||
|
3 |
Close Microsoft Excel.
|
||||||||||||||
|
4 |
Open Microsoft Word.
|
||||||||||||||
|
5 |
Do “File
Open”
and select the tab-delimited txt file that you just saved. |
||||||||||||||
|
6 |
Click Show/Hide in the toolbar (see circled image below) to turn on hidden typesetting marks.
|
||||||||||||||
|
7 |
Locate and highlight the header information, which is shown in the document as the upper-most text, before the first record.
|
||||||||||||||
|
8 |
Do “Edit Replace…”. The following window will appear:
NOTE: In this window, you will need to do 3 sets of ‘find & replace’. You can copy and paste the text strings into the “Find and Replace” dialogue box from the table below.
Save your work.
|
||||||||||||||
|
9 |
Now, save the file by choosing “File Save As…”. The dialogue box appears.
Click Save. The following dialogue box appears. Make sure “Windows (Default)” is checked, then click OK.
|
Now you need to cross-check that the INDEX.DLF will import successfully and problem-free back into Excel.
Here’s how:
|
1 |
Launch MS Excel. |
|
2 |
Do “File Open…”. A dialogue box appears to choose your file. Make sure that the ‘File(s) of type’ field is set to “All Files (*.*)”. |
|
3 |
Point to the
INDEX.DLF file that you just saved. This prompts a series of three Text Import Wizard dialogue boxes. |
|
4 |
In the first window (Step 1), · change the data type from “Fixed width” to “Delimited”. · Click Next.
|
|
5 |
In the second window (Step 2), · click Tab to deselect, · click Other to select, and · enter | in the Other field. The data preview will change slightly. · Click Next.
|
|
6 |
Click Finish. The blank EXCEL spreadsheet will be populated with data as saved in the index.dlf.
|
Our Conversion Services can quote to create the DLF file for you. Call us on (978) 256-4445 for a quote.