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

Josh

Software Developer
Staff member
Joined
Jun 3, 2005
Messages
96
Location
Florida
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.
 

idbdoug

Member
Joined
Jun 26, 2005
Messages
24
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:

Josh

Software Developer
Staff member
Joined
Jun 3, 2005
Messages
96
Location
Florida
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.
 

idbdoug

Member
Joined
Jun 26, 2005
Messages
24
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
 

gizbug

Well-known member
APDL Beta Team
Joined
Dec 9, 2003
Messages
129
Location
Chicago, IL
Is there a guide on how to export the info from DECS so it can be imported to the schedule importer?
 
Top