Button Text

[Jenny]

Version 7.0.2 had "Button Text" held on the data base in Product sButtonTxt
Upgrading looses this information. v8 stores button text ,if you define it to product level, within UserDefinedProperties sValue
any idea how to use the old button text, as there are 13000 products. the customer wrote bespoke button textfor most of them.
this info is still held in the old table.
Thanks
Jenny

[Duncan Rounding]

In v8 define your own CV scoped to product instead of CartButtonText and modify the layout to use this CV instead.

Now if you export v8 with a sample entry on a product for the new CV then at the end of the Header:Product row you will see your CV and the data in the column under it.

Using that info and a v7 export you will be able to create a new v8 import file to update the CV contents in v8.

[leehack]

Are you serious? he has 13,000 different phrases, one for almost every product? OMG! WTF was he thinking!

[Jenny]

Thanks
was hoping to avoid exporting/importing.
seems strange that a field can vanish between versions though. or has it?

yep Lee serious!
Jenny

[Duncan Rounding]

The field is still in the database but it doesn't appear to be used in the layout.
It's rare that anyone uses their own button text at all, never mind 13000 of them.

[Jenny]

yep!
an interesting one.

[NormanRouxel]

Try adding

<actinic:variable name="CartButtonText" />

into a Layout and see what appears.

If the info is still there, it may be possible to do an Access Update query to copy it into a Product level Variable.

[Jenny]

<INPUT TYPE=SUBMIT VALUE="<actinic:variable name="CartButtonText"/>" class='forminput' NAME="<actinic:variable name="ProductReference"/>">

CartButtonText is now taken from the new place in the database: UserDefinedProperties sValue

The data is still there under the Product sButtonTxt


hands up! access is not my thing. however the new query button is greyed out in Access.

[Duncan Rounding]

As you say the link from the variable to the database field has changed.

If you don't want to mess with access then export/import is the only way to go.

[NormanRouxel]

If you go to Design / Library / Variables / Product and open CartButtonText, you can add Product to Place of Setting. The variable should now appear on the General tab of each product.

[Jenny]

Norman i have it all set up in v8 and can add cart text to it at product level. the old cart button text has been left in limbo land. it has not been upgraded to anywhere as far as i can see.
Jenny

[fergusw]

Jenny,
I'm not sure there is a simply SQL Query you can perform to copy the contents from sButtonText in Product table to UserDefinedProperties table.

it would be something like

INSERT INTO UserDefinedProperties ("65740","0",sButtonText,ProductReference,"2","N")
SELECT sButtonText,[product reference] as ProductReference 
FROM Product

but that wont work because fields don't match. You get the idea though.

A little bit of custom Macro VBS scripting would do it for you though There are a few examples from myself and Gabriel on the forum - although not for the faint-hearted.

[Jenny]

well i've found a coding buddy so may have to do that!
but guess it is a bug as the upgrade forgot it? is it?
Jenny

[Duncan Rounding]

The choice is yours but you don't really need to 'code' to do this if you do what I suggested above in post #2.

[fergusw]

well i've found a coding buddy so may have to do that!
but guess it is a bug as the upgrade forgot it? is it?
Jenny

I would say so. Worth reporting to Actinic

Oh - to save your coding buddy a little time.....

'my shop database is located at:
mydb = "C:\Program Files\Actinic v8\Sites\Site1\ActinicCatalog.mdb"

    
    'This script will scan throught the database and reset the Section HTML page name values
    Set OBJdbConnection = CreateObject("ADODB.Connection")
    Set rsproducts = CreateObJect("ADODB.Recordset")
    set rsUserDefinedCount = CreateObject("ADODB.Recordset")
    OBJdbConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & mydb


    'Get the current nID for inserting
    rsUserDefinedCount.open "SELECT nID FROM UserDefinedProperties ORDER BY nID DESC",OBJdbConnection,2,3
        If NOT rsUserDefinedCount.EOF then
            nID = rsUserDefinedCount("nID") + 1
        End IF
    rsUserDefinedCount.Close
    set rsUserDefinedCount = nothing
    
    strSQL = "SELECT [product reference],sButtonText FROM [product]"

    rsproducts.Open strSQL,OBJdbConnection,3,2
    iCount= 0

    'Now loop through each one updating the page name
    While NOT rsproducts.EOF


        'Check to see if the section already has a name
        If rsproducts("sButtonText") <> ""  then

                '#####################################################################################
                'Insert the button text into the User Defined table
                strSQL = "Insert INTO UserDefinedProperties (nID,nVariableID,nUseParentSetting,sValue,sContentID,nContentLevel,sStatus) VALUES (" & nID & ",65740,0,'" & rsProducts("sButtonText") & "','" & rsProducts("product reference") & "',2,'N')"
                OBJdbConnection.Execute strSQL 
                'Increment nID for next pass
                nID = nID + 1

                iCount= iCount + 1        

        End If


    rsproducts.Movenext
    Wend

    rsproducts.Close
    OBJdbConnection.Close
    
    
    
msgbox( iCount & " button texts moved over")

copy that into notepad file, save as [any file name].vbs (note the .vbs extension) then double click and run.

NOTE: Backup beforehand though