Need a comma delimited feed

[lesliekirk]

I need to create a Comma Delimited CSV file that includes the product description which has commas in it. I'm using the EmporiumPlus Template Data module for this venture.

Leslie

[Brennan]

Re: Need a comma delimited feed

Leslie - Check out our standard product exports. Those support excel csv format. Basically you need to encapsulate the field that has commas in it in quotes.

[lesliekirk]

Re: Need a comma delimited feed

That would require a number of additional steps. There are fields this feed needs that can be added to the Template Data Feed that are not needed as part of the product (such an an ID specific to the feed). Then the file would have to be loaded back to the server to be available. It might wind up being the way I will have to go, but having to manually do this every week is going to become tedious.

[Bruce - PhosphorMedia]

Re: Need a comma delimited feed

If the site is running Empressa 5.18 or higher, you should be able to use

<mvt:assign name="g.fixedDesc" value="{ glosub( product-array:descrip,  ',' , '",")" />

where product-array:descrip is whatever branch you are picking the product data off of.

[lesliekirk]

Re: Need a comma delimited feed

If the site is running Empressa 5.18 or higher, you should be able to use

<mvt:assign name="g.fixedDesc" value="{ glosub( product-array:descrip,  ',' , '",")" />

where product-array:descrip is whatever branch you are picking the product data off of.

Will this work within the Emporium Plus Template Data Feed Product field?

[lesliekirk]

Re: Need a comma delimited feed

Leslie - Check out our standard product exports. Those support excel csv format. Basically you need to encapsulate the field that has commas in it in quotes.

Brennan - also can the product description be limited to 255 characters using this method?

[Brennan]

Re: Need a comma delimited feed

You can still use the template data feed, I was just saying look at the product export for the format of the data. Here is a line from a csv file that will open correctly in excel.

TESTITEM,,TEST ITEM,,,,0.01,0,0,"This is a description that has, commas, contained, within it.",1,1,graphics/00000009/sm/ics_sm.jpg,graphics/00000009/ics.jpg,No

You just need to wrap any field that contains commas in quotes. So to translate this over to template data feed you would just need to do something like this:

%^%"%product:descrip%"%^%

Where the delimiter, %^% is a comma

Im not seeing any way in template data feed to limit the length of the description. If you need that you may need to pull in a custom product field with the shortened data or use a page template/batch report to do a custom export.

[wcw]

Re: Need a comma delimited feed

You can limit length in each feed's setup.

[Brennan]

Re: Need a comma delimited feed

Thanks Bill. Leslie, looks like there is a setting at the top of the feed to limit the description length.

[lesliekirk]

Re: Need a comma delimited feed

Thanks Bill. Leslie, looks like there is a setting at the top of the feed to limit the description length.

Yes, I already knew this and already have it set.

I will try adding the other suggestions.

[Bruce - PhosphorMedia]

Re: Need a comma delimited feed

If a control exists in the feed, use that, but for the sake of education:

<mvt:assign name="g.fixedDesc" value="{ substring(glosub( product-array:descrip,  ',' , '","), 1, 244)" />

So, substring() is returning the first through 244th character of the result of the glosub() function.