Mike:
Along with Bill, I have also done quite a bit of these. The
only tricky part is understanding the very confusing header
line that must be the first row. Razzak's suggestion of a
plain .csv file won't work without the proper header row.
I was able to figure it out by reading the help files also.
Here's an example of what an imported RBase file for sales
would look like:
!INVITEM,ACCNT,INVITEMTYPE,ASSETACCNT,COGSACCNT,NAME,DESC,COST,PURCHASEDESC
,PRICE
INVITEM,Sales,INVENTORY,Inventory,Cost of Goods Sold,21-15670,Natural Fox
men's Coat,1000,Natural Fox Coat,1000
INVITEM,Sales,INVENTORY,Inventory,Cost of Goods Sold,22-23718,Dyed Red Fox
women's coat,1000,Dyed Red Fox,1000
At least in the case I'm dealing with, there had to be no quote
marks surrounding the text. I downloaded the data to a temp table
first and replaced all commas with semicolons. Here's what I did.
There is a chance that you'd exceed the expression size limit when
constructing the SELECT command.
SET WIDTH 160
SET VAR MICRORIM_SELMARGIN=1
SET HEADINGS OFF
OUTPUT &vfilename
WRI
'!INVITEM,ACCNT,INVITEMTYPE,ASSETACCNT,COGSACCNT,NAME,DESC,COST,PURCHASEDES
C,PRICE'
SELECT ('INVITEM,Sales,INVENTORY,Inventory,Cost of Goods Sold,'+
+TextID+','+(SGET(pdescript,40,1))+','+
+ctxt(nint(cost*1.15))+','+(SGET(pdescript,40,1))+','+
+ctxt(nint(minprice)) )=160 +
FROM quickbk
OUTPUT SCREEN
Karen
