Re: Importing excel info, and making add to cart links

On Wed, 5 Mar 2008 17:34:21 +1000, Paul Scott wrote:

> I have used this method to generate my hidden fields, but, when I import
the 
> spread sheet (cut and paste at present), the info is simple inserted into 
> the field as text.

Paul,

After you click into your cell (and are in the "text" mode - where
you
could type), press CTRL+T to open up an embed point.

Then paste your code in there.

Does that help?


Charles


-- 
--------------------------------------------------------------------------------
-----------------------
Charles Edmonds
cje_ByteMeSpammers_@lansrad.com  (remove the _ByteMeSpammers_ to email me)
www.pagesnip.com - "Print and Save the Web, just the way you want
it!"
www.clarionproseries.com - "Serious imaging tools for Clarion
Developers"
www.ezround.com - "Round Corner HTML tables with matching Banners, Buttons
and Forms!"
www.lansrad.com - "Intelligent Solutions for Universal Problems"
www.fotokiss.com - "World's Best Auction Photo Editor"

Hi guys,

It's good to see I'm not the only one still using v9

I am upgrading my website, and would like to bring in a variety of items 
which I have in a excel spreadsheet.

I intend to use add to cart buttons, in conjunction with mals ecommerce.

I have looked at simply using the NOF "Ecommerce Catalogue" but
discounted 
this idea, for two reasons:
1) Because I need to include my established quantity breaks (i.e. 1-9, 10-49 
and 50+)
and
2) The layout. Due to the nature of my items, I would prefer a simple table 
format with a qty box, and add to cart on each line.

I found that this can be achieved fairly easily using mals "productpr"
field

OK now we come to the crux of it all.

What is the best way to bring in all the info from excel, and have the 
necessary hidden fields for mals already included in the table? (And the 
buttons if possible)

I found this link http://www.4guysfromrolla.com/webtech/081001-1.shtml Which 
is excellent.

It shows how to produce the required info automatically using excel.

I have used this method to generate my hidden fields, but, when I import the 
spread sheet (cut and paste at present), the info is simple inserted into 
the field as text.

Any ideas?

Thanks.


-- 
Best Regards


Paul Scott
www.PremiumProductions.com
www.CurlyCords.com.au
www.SurvivalZone.com.au
www.ShortNCurlies.com.au

On Thu, 6 Mar 2008 14:43:08 +1000, Paul Scott wrote:

> Using that method, and cutting and pasting each cells contect individually,

> i can achieve a working system.
> However it would be quite a lot of work for all the required items.
> Do you (or anyone :) Know of a way to automate this?

Hi Paul.

One method we have used is to generate a <TABLE> outside of NOF and embed
our repetitive code in it (using Notepad or a standard HTML editor), then
in NOF add a layout region where we want it.

Then embed the entire table in one spot in NOF (with the region's HTML
button).

You could also do this with a text box and the CTRL+T method.

IMHO, it is always easier to copy/paste/modify repetitive code outside of
NOF.

;-)

Charles



-- 
--------------------------------------------------------------------------------
-----------------------
Charles Edmonds
cje_ByteMeSpammers_@lansrad.com  (remove the _ByteMeSpammers_ to email me)
www.pagesnip.com - "Print and Save the Web, just the way you want
it!"
www.clarionproseries.com - "Serious imaging tools for Clarion
Developers"
www.ezround.com - "Round Corner HTML tables with matching Banners, Buttons
and Forms!"
www.lansrad.com - "Intelligent Solutions for Universal Problems"
www.fotokiss.com - "World's Best Auction Photo Editor"

Hi Charles.
Thanks for that.
Yes, that sort of helps.
Using that method, and cutting and pasting each cells contect individually, 
i can achieve a working system.
However it would be quite a lot of work for all the required items.
Do you (or anyone :) Know of a way to automate this?

Thanks again for you help.

Paul. 

On Mon, 10 Mar 2008 14:00:43 +1000, Paul Scott wrote:

> In doing that I assume you are not able to edit the table properties (ie 
> visual style, layout etc) with Fusion?
> (if you can edit it...I don't know how :)

Hi Paul,

No the visual aspect of the table design is done outside of NOF.  I use a
CSS editor called TopStyle, but anyone that gives you a preview vs real
source code mode will do.  One other one I have used is the free SoThink
editor ( http://www.sothink.com/product/htmleditor )


However you really don't need much at all because your just editing a table
- not a full page (just keep it simple for better results).

Concentrate on the content first.  Simply get it so that the cells you want
hold the content that they should.

Then use CSS styling.

Add a CLASS statement to the <TD> elements and usually to the
<TABLE>
itself.

You can Google and there are plenty of sites out there showing how to use
CSS styling with tables.

When you have your CSS styling adjusted the way you want it, you can either
add the styles manually in NOF, but what I do there is add a <STYLE>
block
into the <HEAD> of the page and copy my custom CSS from my external
editor
into that block.

This lets the CSS travel with the page where the HTML table was inserted.

Think of it this way:

Your designing a "chunk" of HTML (the table) and styling it with CSS
to get
the precise control you want.

Once you have that, you are inserting it (almost like a window) into your
regular NOF page.

Since the HTML is already written and the CSS styling is done, all you need
to do is insert them into enough space on your NOF page.

Does that help?

;-)

Charles



-- 
--------------------------------------------------------------------------------
-----------------------
Charles Edmonds
cje_ByteMeSpammers_@lansrad.com  (remove the _ByteMeSpammers_ to email me)
www.pagesnip.com - "Print and Save the Web, just the way you want
it!"
www.clarionproseries.com - "Serious imaging tools for Clarion
Developers"
www.ezround.com - "Round Corner HTML tables with matching Banners, Buttons
and Forms!"
www.lansrad.com - "Intelligent Solutions for Universal Problems"
www.fotokiss.com - "World's Best Auction Photo Editor"