2. ASPRunnerPro General questions
  3. Import Before Insert Record
This topic is locked

Import Before Insert Record

 		3/25/2010 1:43:47 PM
ASPRunnerPro General questions
T
 Tim author

Hello,
I am attempting to to modify a record as it's being imported. I am using Before Insert Record event on the Import page and I have the following code:
values("UPC Code") = "'00' + replace(replace(left(" & rawvalues("UPC Code") & ",13),'-',''),' ','')"
The error I get is: Type mismatch: 'rawvalues'
Am I going about this the right way?
Sergey Kornilov admin 3/26/2010

I recommend to post your application to demo account and to contact support team directly.
C
 		clig 3/26/2010



Hello,
I am attempting to to modify a record as it's being imported. I am using Before Insert Record event on the Import page and I have the following code:
values("UPC Code") = "'00' + replace(replace(left(" & rawvalues("UPC Code") & ",13),'-',''),' ','')"
The error I get is: Type mismatch: 'rawvalues'
Am I going about this the right way?


string to int mismatch
T
 		Tim author 3/29/2010

Thanks clig. I assume it's something like that, but I don't know why that's happening. The import file is a csv (should be all strings... correct?), and the db field "UPC Code" is a varchar(15). Where and why is it attempting to convert to int? If I don't have this code, the import works fine. Any thoughts?
J
 		Jane 4/2/2010

Hi,
it was a bug in the ASPRunnerPro.

We'll fix it in the next update.