Sid

[rolo2912]

Hi all.

We have a front-page section (php/mysql) outside the cataloge that is displaying special offers and a bargain section. Each time actinc is updated all products need to be updated with the new SID & prices using a webinterface. To get the SID a manual search for the product has to be done and the sourcecode of the html page is checked to find the new SID.
Is there a way of finding the "new SID" using the excel file that is used to generate the html files ? Is the creating of SID following any logical order ?

Hope question make sense.

Any hints are welcomed.

[rolo2912]

How SID is created

Hi All.

I messed around with the excel file a bit and found the following interesting "feature" in Actinic.

Excel file line :

... 1071599 3Com|3Com Baseline Switch & Hub Family|Adapter or Media Converter ....

The | seperated values building the categories in the shop. Suppose that is not new to all your actinic cracks out there. Interesting is, that as soon as there are more than 50 charaters in any of the fields, actinic is leaving the product out.

Can anybody confirm this ?

Thanks.

[Bruce]

Hi Roland,

I am not able to replicate this. Please try with the attached test import file. Here I have

1071599 3Com|3Com Baseline Switch & Hub Family|Adapter or Media Converter|This is A Test

in the Section Text Field, a Product name in the 'Short Description Field etc, and it brings it all in just fine. The sample attached will bring in 4 sections and 1 product (within the last section).

Kind regards,

[Bruce]

As for the SID values. If you take a look in ActinicCatalog.mdb in your Site1 folder (Open with Access) and open the 'Catalog section' table. Here you will find the SID value in a column called 'nSectionID'. You can copy the details from here after upload, to your excell file.

Kind regards,

[rolo2912]

excel file

Hi,

sorry, the sample line from the excel file wasnt one that made trouble.

The first line that is causing problems is the following :

Buffalo|Buffalo 125Mbps* Accessories (Mainstream with AOSS) Range|Wireless Adapter

Some other examples :

Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Network Management
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Support
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Support
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Support
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Support
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Upgrade
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Upgrade
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Upgrade
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Upgrade
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Warranty
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Warranty
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Warranty
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Warranty
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Warranty
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Warranty
Cisco Smartnet|SMARTnet Software Application Support Plus Upgrades|Warranty


Here we have the 2nd col. with a lenght of >50. These linesare left out when building the catalog.

Thank you very much for the hint with the access file. Will check this out.

[Bruce]

Are you sure each of these products (the 4 for support for example) has a unique product ID, or do you have 'Auto generate Product refrences' turned on. I will check this tomorrow, but try removing the '*' from the other section name, these are special characters that are not allowed in section names. (Take a look in Help | Help Topics for more information.)

Kind regards,

[rolo2912]

Hi,

the unique Product ID is coming from the supplier of my client (client using Actinic www.microaid.ie, supplier sending the actinic ready file including the Product ID is www.computer2000.co.uk ).

I can not confirm your statement about the * in the section name. If you go on www.microaid.ie, navigate in the shoping section to acer. There you will find

Power F* Desktop
Power M* Desktop

Regards

Roland

[wjcampbe]

The trouble is that in an import file * means find a section above with the same name as from here to the next pipe symbol, and add the earlier part of that section path to this path.

e.g. MyStore | MyFunthings | CardTrick
* | CardTrick | FindTheLady

the second line would expand to MyStore | MyFunthings | CardTrick | FindTheLady.