Hi all, i have a bit of a problem when importing an excel file of products that use popups (extended info) for further product info.
The issue is that on the spreadsheet we have two columns that map directly into fields in Actinic with a flat file import, one for 'Generate Popup Page' which either has a value of 1 or 0 and that field works fine, put a 1 in there, and when imported the product has 'generate pop up page ticked', obviously a 0 means there is no popup for that product.
the other column we have is for 'Display by Link' which also seems to only accept a 1 or a 0 and again, is fine but.....
We dont have a place to specify what the actual text of the link should be...if you try to put a word such as "More Info" into the 'Display by link' field, on import into actinic it gives an error saying it expects a value between -1 and 1, clearly a yes/no switch for the link, but not a place you can put a word for the link.
To complicate matters, if you export a product list out of Actinic, and check the field that the contents of the Extended info link end up in, its our old pal 'Display by link text' so naturally you think that to go into actinic, the word you want as text link goes into the 'Display by link' field, which as ive said only accepts 1's or 0's in it.
The only difference i can see, is that when exporting out of actinic, you get a heirarchical file, and im trying to import a flat file...
it seems if you import a hierarchical file, it somehow accepts words in the 'Display by link' field, but not if it comes in via a flat file....confused, i am too and i dont know if i can re-word this any different so im just gonna post it and see if anyone can help...
also i should mention these guys have over 7,500 products and manually going into actinic to find and type 'more info' into the link text field is not really an option as they need to work seamlessley from their spreadsheet without any intervention into actinic....
suppose is someone knows where the html for 'extended info' text link is generated, in actiniccatalog.mdb, design text, scripts or otherwise let me know and maybe i can override it..
Steve Quinn
Harlequin Domains
www.harlequindomains.com
0800 0832077
Actinic Design, Hosting and Website Marketing
The issue is that on the spreadsheet we have two columns that map directly into fields in Actinic with a flat file import, one for 'Generate Popup Page' which either has a value of 1 or 0 and that field works fine, put a 1 in there, and when imported the product has 'generate pop up page ticked', obviously a 0 means there is no popup for that product.
the other column we have is for 'Display by Link' which also seems to only accept a 1 or a 0 and again, is fine but.....
We dont have a place to specify what the actual text of the link should be...if you try to put a word such as "More Info" into the 'Display by link' field, on import into actinic it gives an error saying it expects a value between -1 and 1, clearly a yes/no switch for the link, but not a place you can put a word for the link.
To complicate matters, if you export a product list out of Actinic, and check the field that the contents of the Extended info link end up in, its our old pal 'Display by link text' so naturally you think that to go into actinic, the word you want as text link goes into the 'Display by link' field, which as ive said only accepts 1's or 0's in it.
The only difference i can see, is that when exporting out of actinic, you get a heirarchical file, and im trying to import a flat file...
it seems if you import a hierarchical file, it somehow accepts words in the 'Display by link' field, but not if it comes in via a flat file....confused, i am too and i dont know if i can re-word this any different so im just gonna post it and see if anyone can help...
also i should mention these guys have over 7,500 products and manually going into actinic to find and type 'more info' into the link text field is not really an option as they need to work seamlessley from their spreadsheet without any intervention into actinic....
suppose is someone knows where the html for 'extended info' text link is generated, in actiniccatalog.mdb, design text, scripts or otherwise let me know and maybe i can override it..
Steve Quinn
Harlequin Domains
www.harlequindomains.com
0800 0832077
Actinic Design, Hosting and Website Marketing
Comment