2. ASPRunnerPro General questions
  3. Export Results
This topic is locked

Export Results

 		11/6/2006 05:29:15
ASPRunnerPro General questions
I
 intour author

Hi,
I'm using asprunner version 4 to create a datafeed. The feed requires the product url. The problem I have is that the URL is made up of the domain name,folder and record number and the database only holds the record number.

http://www.mystore.co.uk/foldername/viewPrd.asp?idproduct=21


I can display the correct url by adding txt in front of the display field but this txt is ignored when I export the file to CSV.
Anyone know how I can make the rest of the URL display please?
Many thanks
Nigel
Sergey Kornilov admin 11/7/2006

In ASPRunnerPro 4.1 you can use View type Custom which will be exported the same it appears on List/View pages.
You can use this View type to build a correct product URL.
I
 		intour author 11/7/2006

Hi Sergey,
Thanks for the reply.
Where do I find the View type Custom please?
Nigel
I
 		intour author 11/7/2006

Hi Sergey,
I found the custom view option in the datasource table - at least I think so - where I can create a new view for the same table.
My problem though is that I want to export some txt along with the product id to create the url. it displays fine but won't export. Here is the code:

<TD align=middle><A

href="products_list.asp?{$row.1products_masterkeys}">products</A> </TD>

<TD>http://www.gegolf.co.uk/productcart/pc/viewPrd.asp?idproduct={$row.1idProduct_value} </TD>

<TD>{$row.1description_value} </TD>

<TD>{$row.1price_value} </TD>

<TD>{$row.1smallImageUrl_value} </TD>

<TD>{$row.1sku_value} </TD>

<TD>{$row.1stock_value} </TD>

<TD>{$row.1manufacturer_value} </TD>

<TD>{$row.1category_value} </TD><!--{/foreach}--></TR>{/if}</TBODY></TABLE></FORM>


many thanks
Nigel
Alexey admin 11/9/2006

Nigel,
here is what you can do.
Undo the changes you made in on the List page.
Double-click idProduct field and choose Custom in the list.

Enter the following in the box:

strValue = "http://www.gegolf.co.uk/productcart/pc/viewPrd.asp?idproduct="; & strValue