American Airlines Schedule Importer

idbdoug

Member
Joined
Jun 26, 2005
Messages
24
Can you please build a schedule importer for AA! The others you have do not work for me. Below I will show my schedule and I will include it as an attachment. The file is a .CSV file.


FLT 644 DFW/JAX 7/5/2006 10:49 7/5/2006 14:13 " SEQ EQ M TOTL DUTY GND P&C 5210 35 L 2.24 3.24 0.42 0.00 "FLT 1185 JAX/DFW 7/5/2006 14:55 7/5/2006 16:31 " SEQ EQ M TOTL DUTY GND P&C 5210 35 2.36 6.42 0.45 0.00 "FLT 1185 DFW/MSP 7/5/2006 17:16 7/5/2006 19:41 " SEQ EQ M TOTL DUTY GND P&C 5210 35 D 2.25 10.07 0.00 0.00 11.27 Layover Hilton MSP A/P --2100 "FLT 675 MSP/DFW 7/6/2006 8:23 7/6/2006 10:47 " SEQ EQ M TOTL DUTY GND P&C 5210 35 B 2.24 3.24 0.55 0.00 "FLT 675 DFW/MEX 7/6/2006 11:42 7/6/2006 14:13 " SEQ EQ M TOTL DUTY GND P&C 5210 35 L 2.31 7.05 0.00 0.00 15.03 Layover Camino Real D/011- --8 "FLT 1066 MEX/DFW 7/7/2006 6:31 7/7/2006 9:09 " SEQ EQ M TOTL DUTY GND P&C 5210 22 B 2.38 3.53 0.00 0.22 "FLT 1225 DFW/SJD 7/10/2006 10:05 7/10/2006 11:45 " SEQ EQ M TOTL DUTY GND P&C 5209 22 L 2.40 3.40 0.50 0.00 "FLT 2438 SJD/DFW 7/10/2006 12:35 7/10/2006 16:23 " SEQ EQ M TOTL DUTY GND P&C 5209 22 2.48 7.18 1.08 0.00 "FLT 481 DFW/MEX 7/10/2006 17:31 7/10/2006 20:03 " SEQ EQ M TOTL DUTY GND P&C 5209 22 D 2.32 11.13 0.00 0.00 12.42 Layover Camino Real Ar011- --0 "FLT 2272 MEX/DFW 7/11/2006 10:00 7/11/2006 12:39 " SEQ EQ M TOTL DUTY GND P&C 5209 22 L 2.39 3.39 1.07 0.00 "FLT 551 DFW/MTY 7/11/2006 13:46 7/11/2006 15:22 " SEQ EQ M TOTL DUTY GND P&C 5209 22 1.36 6.22 0.57 0.00 "FLT 598 MTY/DFW 7/11/2006 16:19 7/11/2006 18:02 " SEQ EQ M TOTL DUTY GND P&C 5209 22 1.43 9.02 1.00 0.00 "FLT 598 DFW/SAT 7/11/2006 19:02 7/11/2006 20:05 " SEQ EQ M TOTL DUTY GND P&C 5209 22 D 1.03 11.20 0.00 0.00 10.00 Layover Hol Inn Select --5949 "FLT 1467 SAT/DFW 7/12/2006 7:20 7/12/2006 8:25 " SEQ EQ M TOTL DUTY GND P&C 5209 22 B 1.05 2.05 0.45 0.00 "FLT 1467 DFW/ELP 7/12/2006 9:10 7/12/2006 9:45 " SEQ EQ M TOTL DUTY GND P&C 5209 22 1.35 4.25 0.42 0.00 "FLT 562 ELP/DFW 7/12/2006 10:27 7/12/2006 13:11 " SEQ EQ M TOTL DUTY GND P&C 5209 22 L 1.44 7.06 0.00 0.00 "DEL 7/11/2006 00:01 7/11/2006 23:59 ""DEL 7/18/2006 00:01 7/18/2006 23:59 ""FLT 1823 DFW/SAT 7/19/2006 16:50 7/19/2006 17:53 " SEQ EQ M TOTL DUTY GND P&C 5246 EF 1.03 2.03 0.44 0.00 "FLT 511 SAT/DFW 7/19/2006 18:37 7/19/2006 19:44 " SEQ EQ M TOTL DUTY GND P&C 5246 EF D 1.07 3.54 0.45 0.00 "FLT 511 DFW/COS 7/19/2006 20:29 7/19/2006 21:17 " SEQ EQ M TOTL DUTY GND P&C 5246 EF 1.48 6.42 0.00 0.00 10.50 Layover "FLT 1020 COS/DFW 7/20/2006 9:22 7/20/2006 12:04 " SEQ EQ M TOTL DUTY GND P&C 5246 EF 1.42 2.42 0.46 0.00 "FLT 1020 DFW/MSY 7/20/2006 12:50 7/20/2006 14:15 " SEQ EQ M TOTL DUTY GND P&C 5246 EF L 1.25 4.53 0.43 0.00 "FLT 1947 MSY/DFW 7/20/2006 14:58 7/20/2006 16:32 " SEQ EQ M TOTL DUTY GND P&C 5246 EF 1.34 7.10 0.45 0.00 "FLT 1947 DFW/OKC 7/20/2006 17:17 7/20/2006 18:14 " SEQ EQ M TOTL DUTY GND P&C 5246 EF D 0.57 8.52 0.49 0.00 "FLT 1285 OKC/DFW 7/20/2006 19:03 7/20/2006 20:01 " SEQ EQ M TOTL DUTY GND P&C 5246 EF 0.58 10.54 0.00 0.00 "FLT 1109 DFW/AUS 7/24/2006 6:16 7/24/2006 7:05 " SEQ EQ M TOTL DUTY GND P&C 5185 22 0.49 1.49 0.35 0.00 "FLT 579 AUS/SJC 7/24/2006 7:40 7/24/2006 9:08 " SEQ EQ M TOTL DUTY GND P&C 5185 22 B 3.28 6.07 0.00 0.00 19.58 Layover EWR Frmt Hilto 510- --8390 "FLT 1204 SJC/DFW 7/25/2006 6:21 7/25/2006 11:53 " SEQ EQ M TOTL DUTY GND P&C 5185 22 B 3.32 4.32 0.45 0.00 "FLT 1204 DFW/DTW 7/25/2006 12:38 7/25/2006 16:19 " SEQ EQ M TOTL DUTY GND P&C 5185 22 L 2.41 8.13 0.00 0.00 12.51 Layover Hilton Garden --7105 "FLT 2015 DTW/DFW 7/26/2006 6:25 7/26/2006 8:01 " SEQ EQ M TOTL DUTY GND P&C 5185 22 B 2.36 3.36 0.53 0.00 "FLT 2015 DFW/MSY 7/26/2006 8:54 7/26/2006 10:20 " SEQ EQ M TOTL DUTY GND P&C 5185 22 L 1.26 5.55 0.42 0.00 "FLT 1429 MSY/DFW 7/26/2006 11:02 7/26/2006 12:33 " SEQ EQ M TOTL DUTY GND P&C 5185 22 1.31 8.23 0.00 0.00 "DEL 7/26/2006 00:01 7/26/2006 23:59 ""FLT 1166 DFW/RDU 7/31/2006 12:50 7/31/2006 16:30 " SEQ EQ M TOTL DUTY GND P&C 5217 22 2.40 3.40 0.42 0.00 "FLT 1317 RDU/DFW 7/31/2006 17:12 7/31/2006 19:06 " SEQ EQ M TOTL DUTY GND P&C 5217 22 D 2.54 7.16 0.46 0.00 "FLT 1058 DFW/BHM 7/31/2006 19:52 7/31/2006 21:35 " SEQ EQ M TOTL DUTY GND P&C 5217 22 1.43 10.00 0.00 0.00 17.44 Layover "FLT 875 BHM/DFW 8/1/2006 16:34 8/1/2006 18:30 " SEQ EQ M TOTL DUTY GND P&C 5217 22 1.56 2.56 0.55 0.00 "FLT 875 DFW/SJD 8/1/2006 19:25 8/1/2006 21:05 " SEQ EQ M TOTL DUTY GND P&C 5217 22 D 2.40 6.46 0.00 0.00 10.00 Layover "FLT 1630 SJD/DFW 8/2/2006 8:20 8/2/2006 12:07 " SEQ EQ M TOTL DUTY GND P&C 5217 22 B 2.47 4.02 0.00 0.20 "
 

Attachments

  • 333002-7.csv
    5.2 KB · Views: 70
What you submitted is very similar to the DECS filter. I have to figure out what is different and make the adjustment. I will put it into our next release. We just completed a release that will be online shortly so this next one might get out in a month. I will let you know if I find a temp solution.

You might even be able to see what makes this format slightly different then the example we have at: http://help.logbookpro.com/apdl/apdl-scheduleimporter.pdf

If you do, please let me know.
 
Hello
Two Things of note:
1. You have one American Import Filter using the .csv extension but for palm only. If you could adjust this filter for pocket pc, the importer should work.
2. The AA/American Eagle(Decs) import filter shows only one trip. I can get the trip information in the same format but also, I can only generate one trip at a time. I would have to run the import for each individual trip which would be a big hassle, versus importing entire month of flying at one time. The only way I can get an entire month of flying is the .csv extension that I sent you. I will sent you an HTML file and a .vcal file extension to see if they might work better. I tried to attach the two files, but .vcal is not supported as a valid extension. I will post with seperately for both file.
 
Last edited:
HI,
We have a support ticket system. You can send us a ticket with these files you are trying to attach. I think it will take that extension.

I see. If you have a pocket PC, then the current APDL software doesn't support monthly imports. However, we are working on some new software to get rid of this issue. AA just happens to have a great monthly trip output. Most airlines that do that have so little data, it almost doesn't mean much to import it.
 
Hello
Yes, I can get my monthly schedule in an Outlook 98/2000 in a downloadable .csv file, which can be read by Microsoft Excel. But for some reason your schedule importer specifies only works with output file to a Palm based device. Do you have any time frame on this new software?
Thanks
 
Is there a guide on how to export the info from DECS so it can be imported to the schedule importer?
 
Back
Top