Enterprise - help!

[Barry Kahn]

My earlier email doesn't seem to have reached the list so here's  
another try. The Error Detail window shows that the last line is  
where the error occurred, when it reached the openfile statement.

Is there an alternate way to get this data into the database?

thanks,
bk


Debug
/*The first section below imports the listed fields from the  
bin_locs_etc.txt file, which is updated nightly from Connected. It  
includes available quantities of each item.*/
/* Note that the fields of the source text file are counted 0,1,2,  
etc.--so the first field is numbered 0, etc.*/
importusing
importcell(1)+ ¬ +   /*Available  This takes the 2nd column of the  
source file and imports it into the first field of the destination  
database.*/
importcell(2)+ ¬ +   /*ItemNum    This takes the 3rd column of the  
source file and imports it into the 2nd field of the destination  
database.*/
importcell(4)+ ¬ +   /*Description  */
importcell(15)+ ¬ +   /*SalesHistory   This takes the 15th column of  
the source file and imports it into the 4th field of the destination  
database.*/
importcell(13)+ ¬ +   /*MinQty  */
importcell(14)+ ¬ +   /*ReorderQty  */
importcell(5)+ ¬ +   /*PriceLevel3_stores  */
importcell(6)+ ¬ +   /*PriceLevel4_WS  */
importcell(7)+ ¬ +   /*VendorCode  */
importcell(8)+ ¬ +   /*BinLocation  */
importcell(9)+ ¬ +   /*TubeBinLocation  */
importcell(10)+ ¬ +   /*TubePrice  */
importcell(11)+ ¬ +   /*AnalysisCode  */
importcell(12)+ ¬ +      /*VendorItemNumber  */
¬ +   /*There must be as many lines in the import cell list, as there  
are fields in the destination database. So if fields are not  
receiving any data, use the ¬ + to show that they are being skipped.*/
¬ +
¬ +
¬ +
¬ +
importcell(17)+ ¬ +      /*UnitCost  */
importcell(18)       /*QtyOnOrder  */


openfile "&Dell_shared:bin_locs_etc.txt"



Barry Kahn
Caravan Beads, Inc.
915 Forest Ave
Portland ME 04103
800-230-8941
fax: 207-874-2664
www.caravanbeads.net
barryk at caravanbeads.net





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080731/56a7f64f/attachment.html