Log ten pro and NJA.csv file

[billybob]

Working on the old logbook, has anyone imported the .csv file from Nja to log ten pro? I can't get it to pull things in (800xpc and a few other things) then I import without some empty fields or just a bunch of crap like \\\{}}#>?%~ where is should have a tail number. Thought I would ask

 

[fly4funcrj]

Yes. It works fantastic but you have to edit the .csv file from NJA. Do the following to import into logbook pro or Logten Pro.
1. “Download” the file from the Crewops website.

2. “Open” the downloaded file.

3. “Insert” a blank column between the DATE and TYPENAME
columns (usually columns B & C).

4. Place your cursor over the DATE column header and
“left click” on the column header which highlights the
DATE column.

5. With the DATE column highlighted, select “DATA” at
the top of the page, then scroll down and select
“text to columns.”

6. When the pop-up box appears ensure that “delimited”
is selected then click on “next.”

7. On the next screen “de-select” tabs and “select” space.
There should now be a line between the dates and times in
the data preview pane. “Select” next.

8. The DATES should be highlighted and the TIMES should not.

9. “Select” finish and all the times should be moved to
the blank column that you created earlier.

10. Place the cursor over the header for the column with
the times in it. Select it to highlight the TIMES column.

11. Right click on the highlighted columns and “select”
DELETE. All the times are now gone and the file can be
imported into Logbook Pro.

 

[billybob]

Thanks so much. I'll give it a go.