[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Export Specific Columns and Rows
Mike Heins wrote:
> Quoting Jon (prtyof5@attglobal.net):
> > Can someone provide a sample code snippet to export specific
> > rows and specific columns from a table. I've read about the export tag
> > which appears to assume you want to export the entire table; all rows
> > and columns.
> > And I've searched the archives for which there is a lot of discussion
> > but I didn't find what I'm looking for there either. An example would
> > be real helpful. Thanks !
> >
>
> If it doesn't have embedded tabs, something like this would work:
>
> [log type=text file=">output.txt" interpolate=1][loop search="
> sf=prod_group
> se=Hand Tools
> rf=sku,price,description
> "
> ][loop-line]
> [/loop][/log]
>
Well, what I'm looking to do is take the transaction table to create
a specific probably CSV type file to use for importing. I like what the
export
function in the admin UI does except it dumps all rows and columns.
Would the above example place commas between fields ? Thanks Mike.
Jon