[ic] Problem Importing Shipping Rates

Jason Osborne jason@sohonetworks.cc
Sun, 8 Apr 2001 05:01:47 -0500


This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C0BFE9.0366D550
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Ok, I've been playing with the UPS shipping rates and have run into a small
problem while important a new csv file containing the new rates. I went to
ups.com and got the new NextDayAir rate chart. I then went into the admin
side of the site and selected tables. From here I viewed the current
NextDayAir table in excel. I pasted the new dollar amount values over the
current values that were displayed in excel and then saved the file as
NextDayAir.csv on my system. I then went and tried to import the csv file
into Interchange and received an error. The error was:

FATAL error

gdbm store returned -1, errno 0, key
"k1,14.5,16.5,19.5,21,22.5,23.25,23.75,25.25,25.25,36.25
" at /usr/local/interchange/lib/Vend/Table/Common.pm line 327,  line 2.

Progress to date:

Using fields from file: 'Exceed,102,103,104,105,106,107,108,124,125,126
'
Adding record '1,14.5,16.5,19.5,21,22.5,23.25,23.75,25.25,25.25,36.25
'.

Any ideas? csv file is attached.

Thanks,

Jason Osborne
Data and Telecom Network Solutions
3847 Timberglen Rd., STE 4013
Dallas, Texas 75287
phone: 972-307-0676
fax:   972-662-7956
e-mail: sales@sohonetworks.cc
web: http://www.sohonetworks.cc

------=_NextPart_000_0005_01C0BFE9.0366D550
Content-Type: application/octet-stream;
	name="NextDayAir.csv"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="NextDayAir.csv"

Exceed,102,103,104,105,106,107,108,124,125,126
1,14.5,16.5,19.5,21,22.5,23.25,23.75,25.25,25.25,36.25
2,15.5,17.5,21.75,23.5,25,26,26.5,28,28,39
3,16.75,18.5,24.25,26,27.5,28.75,29.5,31,31,42
4,17.75,19.75,26.5,28.25,30.25,31.25,32,33.5,33.5,44.5
5,18.75,20.75,28.75,30.75,32.75,33.75,34.75,36.25,36.25,47.25
6,19.5,22,31,33.25,35.5,36.5,37.25,38.5,38.5,49.5
7,20.25,23.25,33,35.5,38,39,39.75,40.75,40.75,51.75
8,21,24.25,35,38,40.75,41.75,42.5,43.25,43.25,54.25
9,21.75,25.25,37.25,40.25,43.25,44.25,45,45.75,45.75,56.75
10,22.5,26.25,39.5,42.5,45.5,47,47.5,48.25,48.25,59.25
11,23.25,27.5,41.75,44.75,48,49.5,50,50.5,50.5,61.5
12,24,28.5,43.75,47,50.25,52,52.75,53.25,53.25,64.25
13,24.75,29.75,45.75,49.25,52.5,54.25,55.25,55.75,55.75,66.75
14,25.75,30.75,47.75,51.5,54.75,56.5,57.75,58.25,58.25,69.25
15,26.5,32,49.5,53.5,56.75,58.5,60,60.25,60.25,71.25
16,27.25,33,51,55,58.5,60.25,62,62.25,62.25,73.25
17,28,33.75,52.5,56.5,60,61.75,63.75,64,64,75
18,28.75,34.5,54,58.25,61.5,63.25,65.5,65.75,65.75,76.75
19,29.5,35.25,55.5,59.75,63,65,67.25,67.5,67.5,78.5
20,30.25,36,57,61.25,64.75,66.5,69,69.25,69.25,80.25
21,31,36.75,58.5,62.75,66.25,68.25,70.75,71,71,82
22,31.75,37.75,60,64.25,67.75,69.75,72.5,72.75,72.75,83.75
23,32.5,38.5,61.75,66,69.25,71.5,74,74.25,74.25,85.25
24,33.25,39.5,63.25,67.5,71,73,75.5,75.75,75.75,86.75
25,34,40.5,64.75,69.25,72.75,74.5,77,77.25,77.25,88.25
26,35,41.25,66.25,71,74.5,76,78.5,78.75,78.75,89.75
27,35.75,42,68,72.75,76.25,77.5,80,80.25,80.25,91.25
28,36.5,42.75,69.75,74.5,78,79,81.75,82,82,93
29,37.25,43.5,71.5,76.25,79.5,80.75,83.75,84,84,95
30,38.25,44.25,73,78,81,82.5,85.5,85.75,85.75,96.75
31,39.25,45.25,74.75,80,82.75,84.25,87.25,87.5,87.5,98.5
32,40,46.25,76.5,81.75,84.5,86.25,89.25,89.5,89.5,100.5
33,41,47.25,78.25,83.5,86.25,88.25,91.25,91.5,91.5,102.5
34,41.75,48.5,79.75,85.25,88.25,90,93.25,93.5,93.5,104.5
35,42.5,49.5,81.5,87.25,90.25,92,95.25,95.5,95.5,106.5
36,43.25,50.25,83,89.25,92,94,97.25,97.5,97.5,108.5
37,44,51,84.75,91,93.75,96,99.25,99.5,99.5,110.5
38,44.75,51.75,86.25,92.75,95.75,98,101.25,101.5,101.5,112.5
39,45.5,52.75,87.75,94.5,97.5,100,103.5,103.75,103.75,114.75
40,46.25,53.75,89.5,96.5,99.25,102,105.5,105.75,105.75,116.75
41,47,54.5,91.25,98.25,101.25,104,107.75,108,108,119
42,47.75,55.5,93,100,103.25,106,109.75,110,110,121
43,48.5,56.5,94.75,101.75,105.25,108,111.75,112,112,123
44,49.5,57.5,96.5,103.5,107.25,110,113.75,114,114,125
45,50.5,58.5,98.25,105.25,109,112,115.75,116,116,127
46,51.5,59.75,99.75,106.75,111,113.75,117.75,118,118,129
47,52.5,60.75,101.5,108.25,113,115.5,119.75,120,120,131
48,53.25,61.75,103.25,109.75,114.75,117.25,121.5,121.75,121.75,132.75
49,54,63,105,111.5,116.75,119.25,123.25,123.5,123.5,134.5
50,55,64.25,106.5,113.25,118.75,121.25,125.25,125.5,125.5,136.5
51,56,65.5,108,114.75,120.75,123.25,127.5,127.75,127.75,138.75
52,57,67,109.75,116.25,122.75,125.25,129.75,130,130,141
53,58,68.25,111.25,118,124.75,127.5,132,132.25,132.25,143.25
54,59,69.75,113,119.75,126.75,129.75,134.25,134.5,134.5,145.5
55,60,71.25,114.75,121.5,128.75,132,136.5,136.75,136.75,147.75
56,61,72.5,116.25,123.25,130.75,134.25,138.75,139,139,150
57,62,74,118,125,132.75,136.5,141.25,141.5,141.5,152.5
58,63.25,75.25,119.75,127,134.75,138.75,143.75,144,144,155
59,64.25,76.75,121.75,129,137,141,146.25,146.5,146.5,157.5
60,65.5,78.25,123.75,131,139,143.25,149,149.25,149.25,160.25
61,66.75,79.75,125.75,133.25,141.25,145.75,151.75,152,152,163
62,68.25,81.5,127.5,135.5,143.5,148.25,154.5,154.75,154.75,165.75
63,69.5,83,129.25,137.75,145.75,150.75,157.25,157.5,157.5,168.5
64,70.75,84.75,131.25,140,148.25,153.5,160,160.25,160.25,171.25
65,72,86.5,133.25,142.5,150.75,156,162.75,163,163,174
66,73.25,88,135.25,144.75,153.25,158.5,165.25,165.5,165.5,176.5
67,74.5,89.75,137.25,147,155.75,161,168,168.25,168.25,179.25
68,75.75,91.5,139.25,149.5,158,163.75,170.75,171,171,182
69,77.25,93.25,141.25,151.75,160.25,166.5,173.5,173.75,173.75,184.75
70,78.75,94.75,143.5,154,162.75,169.25,176.25,176.5,176.5,187.5
71,80,96.25,145.75,156.25,165,172,179,179.25,179.25,190.25
72,81.25,97.75,147.75,158.75,167.5,174.75,181.75,182,182,193
73,82.75,99.25,150,161.25,170,177.5,184.5,184.75,184.75,195.75
74,84.25,101,152.25,163.5,172.5,180.5,187.25,187.5,187.5,198.5
75,85.5,103,154.75,165.75,175,183.25,190.25,190.5,190.5,201.5
76,87,104.75,157.25,168,177.5,186,193,193.25,193.25,204.25
77,88.5,106.5,159.5,170.25,180,188.5,195.5,195.75,195.75,206.75
78,90,108.5,162,172.75,182.5,191,198.25,198.5,198.5,209.5
79,91.5,110.25,164.5,175,185.25,193.5,201,201.25,201.25,212.25
80,92.75,112.25,167,177.25,187.75,196,203.75,204,204,215
81,94.25,114,169.5,179.75,190.25,198.75,206.5,206.75,206.75,217.75
82,95.75,115.75,172,182,192.75,201.25,209,209.25,209.25,220.25
83,97.25,117.5,174.25,184.25,195.25,203.75,211.5,211.75,211.75,222.75
84,98.75,119.25,176.75,186.75,197.75,206.25,214,214.25,214.25,225.25
85,100,121.25,179,189,200.25,208.75,216.75,217,217,228
86,101.25,123.25,181.5,191.25,202.5,211.25,219.25,219.5,219.5,230.5
87,102.5,125.25,183.75,193.5,205,213.75,222,222.25,222.25,233.25
88,103.75,127.25,186,196,207.5,216.5,224.5,224.75,224.75,235.75
89,105,129,188.25,198.25,210,219,227.25,227.5,227.5,238.5
90,106.25,131,190.5,200.5,212.5,221.75,230,230.25,230.25,241.25
91,107.5,132.75,192.5,203,215,224.25,232.5,232.75,232.75,243.75
92,109,134.5,194.75,205.25,217.5,226.75,235.25,235.5,235.5,246.5
93,110.25,136.25,196.75,207.5,220,229.25,238,238.25,238.25,249.25
94,111.5,137.75,199,209.75,222.5,231.75,240.75,241,241,252
95,113,139.25,201.25,211.75,225,234.25,243.5,243.75,243.75,254.75
96,114.25,141,203.25,213.75,227.25,236.75,246,246.25,246.25,257.25
97,115.5,142.75,205.25,215.75,229.5,239.25,248.5,248.75,248.75,259.75
98,116.75,144.25,207.25,218,231.5,241.5,251,251.25,251.25,262.25
99,118,145.75,209.25,220.25,233.75,243.75,253.5,253.75,253.75,264.75
100,119.25,147.25,211,222.25,236,246,255.75,256,256,267
101,120.5,148.75,212.75,224.5,238.25,248.25,258.25,258.5,258.5,269.5
102,121.75,150.25,214.75,226.5,240.75,250.5,260.75,261,261,272
103,123,151.75,216.75,228.75,243,253,263.25,263.5,263.5,274.5
104,124.25,153.25,218.75,231,245.25,255.5,265.75,266,266,277
105,125.5,155,220.75,233.25,247.5,258,268.25,268.5,268.5,279.5
106,126.75,156.5,223,235.25,249.75,260.25,271,271.25,271.25,282.25
107,128.25,158,225.25,237.25,252.25,262.75,273.5,273.75,273.75,284.75
108,129.5,159.5,227.25,239.5,254.75,265.25,276,276.25,276.25,287.25
109,130.75,161,229.5,241.75,257,267.75,278.5,278.75,278.75,289.75
110,132,162.5,231.75,244,259.5,270.25,280.75,281,281,292
111,133.25,164,233.75,246.25,261.75,272.75,283.25,283.5,283.5,294.5
112,134.5,165.75,235.75,248.5,264.25,275.25,285.75,286,286,297
113,135.75,167.25,237.75,250.75,266.5,277.75,288.25,288.5,288.5,299.5
114,137,168.75,239.75,252.75,269,280.25,290.75,291,291,302
115,138.25,170.25,242,255,271.5,282.75,293.25,293.5,293.5,304.5
116,139.5,171.75,244,257,273.75,285.25,295.75,296,296,307
117,140.75,173.25,246.25,259.25,276.25,287.5,298.25,298.5,298.5,309.5
118,142.25,174.75,248.25,261.5,278.5,290,300.75,301,301,312
119,143.5,176.5,250.25,263.75,280.75,292.25,303.25,303.5,303.5,314.5
120,144.75,178,252.5,266,283.25,294.75,305.75,306,306,317
121,145.75,179.5,254.5,268,285.75,297.25,308.5,308.75,308.75,319.75
122,146.75,181,256.75,270.25,288.25,299.75,311,311.25,311.25,322.25
123,148,182.5,258.75,272.5,290.5,302.25,313.75,314,314,325
124,149.25,184,260.75,274.5,292.75,304.75,316.25,316.5,316.5,327.5
125,150.5,185.5,263,276.5,295,307.25,318.75,319,319,330
126,151.75,187.25,265,278.75,297.25,309.5,321.25,321.5,321.5,332.5
127,152.75,188.75,267,281,299.5,312,323.75,324,324,335
128,153.75,190.25,269.25,283.25,302,314.5,326.5,326.75,326.75,337.75
129,155,191.75,271.25,285.75,304.25,317,329,329.25,329.25,340.25
130,156.25,193.25,273.5,288,306.75,319.5,331.75,332,332,343
131,157.5,194.75,275.5,290.25,309,321.75,334.5,334.75,334.75,345.75
132,158.75,196.25,277.5,292.5,311.25,324,337.25,337.5,337.5,348.5
133,159.75,198,279.75,294.75,313.75,326.5,339.75,340,340,351
134,160.75,199.5,281.75,296.75,316.25,329,342.25,342.5,342.5,353.5
135,161.75,201,284,298.75,318.5,331.5,344.75,345,345,356
136,162.75,202.25,286,301,320.75,334,347.25,347.5,347.5,358.5
137,163.75,203.5,288,303.25,323,336.5,349.75,350,350,361
138,164.5,204.75,290,305.25,325.5,339,352.5,352.75,352.75,363.75
139,165.25,206,292,307.5,328,341.5,355,355.25,355.25,366.25
140,166,207.25,294.25,309.75,330.25,344,357.5,357.75,357.75,368.75
141,166.75,208.5,296.25,312,332.75,346.5,360,360.25,360.25,371.25
142,167.25,209.75,298.25,314.25,335,349,362.5,362.75,362.75,373.75
143,168,211,300.25,316.75,337.5,351.25,365,365.25,365.25,376.25
144,168.75,212,302,319,340,353.75,367.75,368,368,379
145,169.5,213,303.5,321.25,342.5,356.25,370.25,370.5,370.5,381.5
146,170.25,213.75,305.25,323.5,345,358.75,372.75,373,373,384
147,171,214.5,306.75,325.75,347.25,361.25,375.25,375.5,375.5,386.5
148,171.5,215.25,308,327.75,349.75,363.5,377.75,378,378,389
149,172.25,216,309.25,329.75,352,365.75,380.25,380.5,380.5,391.5
150,173,216.75,310.5,332,354.25,368.25,382.75,383,383,394

------=_NextPart_000_0005_01C0BFE9.0366D550--