How to use Chili with Switch

manupapet · Post by **manupapet** » Thu Jul 31, 2014 7:49 am

Hello,

I'm trying to use Chili Publish with Switch but it don't work.

I can't find any examples of it anywhere or documentation.

Does anyone have any examples ?

Thank you

Manu

dkelly · Post by **dkelly** » Thu Jul 31, 2014 3:33 pm

I have lots of experience with CHILI Publisher & Switch. What type of operations were you attempting?

manupapet · Post by **manupapet** » Thu Jul 31, 2014 7:45 pm

Hello,

I have a card visit template on chili server and an excel file.

When a drag an drop an excel file, i want switch generate pdf a file by line.

I don't find exemple on goole, website enfocus or chili publish.

Could you give me an example.

Thank you

dkelly wrote: I have lots of experience with CHILI Publisher & Switch. What type of operations were you attempting?

dkelly · Post by **dkelly** » Thu Jul 31, 2014 8:00 pm

I assume you want to pass each row of the Excel spreadsheet to CHILI as a variable?

Switch can't process an Excel spreadsheet or even a CSV file directly. So it will not be able to read rows in spreadsheet and use information to call CHILI server to generate a PDF file.

It would be possible with a custom Switch script.

manupapet · Post by **manupapet** » Thu Jul 31, 2014 8:21 pm

Yes, I pass each rows of the excel preadsheet to chili variable.

I don't know that switch don't support excel file.

So, I try another idea.

thank you

dkelly wrote: I assume you want to pass each row of the Excel spreadsheet to CHILI as a variable?

Switch can't process an Excel spreadsheet or even a CSV file directly. So it will not be able to read rows in spreadsheet and use information to call CHILI server to generate a PDF file.

It would be possible with a custom Switch script.

dkelly · Post by **dkelly** » Thu Jul 31, 2014 9:59 pm

With a script I wrote for convert CSV files to XML you could do something like:

manupapet · Post by **manupapet** » Fri Aug 01, 2014 7:16 am

Hello dkelly,

Could you send me an example xml file please

Thank you

dkelly wrote: With a script I wrote for convert CSV files to XML you could do something like:

dkelly · Post by **dkelly** » Fri Aug 01, 2014 3:19 pm

I'd be happy to. Please send me a copy of your spreadsheet and I'll convert it for you.

Dwight Kelly

dkelly@apago.com

manupapet · Post by **manupapet** » Fri Aug 01, 2014 5:23 pm

Here a link : spreadsheet

http://we.tl/2oPcu5WfGG

Thank you

dkelly wrote: I'd be happy to. Please send me a copy of your spreadsheet and I'll convert it for you.

Dwight Kelly

dkelly@apago.com

dkelly · Post by **dkelly** » Fri Aug 01, 2014 6:00 pm

OK, the CSV2XML script created 467 XML files each containing a single record.

<?xml version="1.0" encoding="UTF-8"?>

<order>

<PRENOM>SAS</PRENOM>

<NOM>NATURHOUSE</NOM>

<ADR>82 avenue Camille Pujol</ADR>

<CP>31500</CP>

<VILLE>TOULOUSE</VILLE>

<TEL>05 61 26 42 36 </TEL>

</order>

The CHILI configurator can then access the data to set variables using a Switch variable statement

[Metadata.Text:Path="/order/PRENOM",Dataset="Xml",Model=XML]

manupapet · Post by **manupapet** » Fri Aug 01, 2014 7:33 pm

Thank you to your help.

dkelly wrote: OK, the CSV2XML script created 467 XML files each containing a single record.

<?xml version="1.0" encoding="UTF-8"?>

<order>

<PRENOM>SAS</PRENOM>

<NOM>NATURHOUSE</NOM>

<ADR>82 avenue Camille Pujol</ADR>

<CP>31500</CP>

<VILLE>TOULOUSE</VILLE>

<TEL>05 61 26 42 36 </TEL>

</order>

The CHILI configurator can then access the data to set variables using a Switch variable statement

[Metadata.Text:Path="/order/PRENOM",Dataset="Xml",Model=XML]

pietvanc1 · Post by **pietvanc1** » Fri Apr 03, 2015 6:47 pm

I have quite the same XML setup and after I define those variables I don't see any changes in the editor. Is there something wrong with my variables or is it just normal that the editor doesn't show changes in the editor and just apply them on the XML?

Enfocus Community