Here’s the record. As you can see there are a large number of fields (it’s not my data - I know it’s not normalized, I have to live with it). I’ve also included a record which loaded successfully.
I really can’t do it manually. There are just too many fields and too many errored records to make that feasible.
Good record:
HCGS830228LB,5189,Site 36 ABN AMRO/AASC,No,National Frame Relay Service,ICB,A,RC: Access Charge (high speed),175,RC: Port Charge (high speed),267.4,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),3,8K,RC: Standard PVC (high speed),9,128K,RC: Standard PVC (high speed),11,256K, , , , , ,Y
Bad Record:
HFGS794598LB,N25220,DOC-DR1-STATEVILLE R&C,PON 62450,Yes,Managed Router Service (Frame Relay),RC: AADS Local Loop (DS3),980,RC: SOI Port Charge - DS3 (high speed),3675,RC: Additional PVC/DLCI - DS3 256K CIR,45,310 HFGS789464LB 310,Additional PVC/DLCI - DS3 256K CIR,RC: Additional PVC/DLCI - DS3 256K CIR,45,744 HFGS789515LB 744,Additional PVC/DLCI - DS3 256K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,099 HCGS800980LB 266,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,410 HFGS789514LB 410,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,800 HCGS798826LB 800,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,801 HCGS802983LB 801,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,802 HCGS810009LB 802,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,803 HCGS801142LB 803,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,804 HCGS801144LB 804,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,820 HCGS791232LB 820,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,823 HCGS803127LB 823,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,824 HCGS802454LB 824,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,842 HCGS802451LB 842,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,843 HCGS831973LB 843,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,844 HCGS828693LB 844,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,845 HCGS791032LB 845,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,805 04QGDA760456GTIL 805,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,822 12QGDA760376GTIL 822,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,825 12QGDA760373GTIL 825,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,826 10QGDA760423GTIL 826,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,841 12QGDA760371GTIL 841,Additional PVC/DLCI - DS3 8K CIR,RC: Additional PVC/DLCI - DS3 8K CIR (high speed),0,846 12QGDA760378GTIL 846,Additional PVC/DLCI - DS3 8K CIR, , , , , ,Y
Quite a mess right?
If there was a way to attach a file I would but I don’t think it’s possible.
Any other ideas?