Home tool set left
Floating menu
...
Text
Ajouter un champ du fichier converti
CSV in : Nom du fichier dans votre espace FTP
Prévoir DropZone
CSV out : Nom du fichier sortant dans votre espace FTP
Nom du champ : Mail
Position : 2
Formule
=checkAndCorrect( 'email', ..email)
{"meta":{"name":"List1","zone":"List1editZone","type":"list","captionPosition":"top","caption":"List des champs"},"data":{"1":{"tag":"ul","name":"List1","class":"listStyle1","value":{"1":{"tag":"li","class":"itemModel","placeholder":"Model...","value":[{"tag":"span","class":"emphasized","value":"email"},{"value":" utilisé 0 fois"}]},"2":{"tag":"li","placeholder":"Enter item","value":[{"tag":"span","class":"emphasized","value":"nom"},{"value":" utilisé 1 fois"}]},"3":{"tag":"li","placeholder":"...","value":[{"tag":"span","class":"styled","value":"civilité"},{"value":" utilisé 0 fois"}]}}}},"changes":{}}
- email utilisé 0 fois
- nom utilisé 1 fois
- civilité utilisé 0 fois
{"meta":{"type":"connector","name":"Conn1","zone":"Conn1editZone","caption":"Conn1","captionPosition":"top"},"data":{"1":{"tag":"span","class":"rightButton","value":[{"tag":"a","href":"javascript:","onclick":"API.showNextInList( ['Conn1_dataeditZone', 'Conn1_parameters_editZone']);","value":"configurer"}]},"2":{"tag":"span","class":"rightButton","value":[{"tag":"a","href":"javascript:","onclick":"API.connectorRefresh( 'Conn1');","value":"refresh"}]},"3":{"tag":"span","class":"rightButton","value":[{"tag":"a","href":"javascript:","onclick":"API.connectorUpdateServer( 'Conn1');","value":"update server"}]},"4":{"tag":"div","name":"Conn1_parameters_editZone","class":"hidden","type":"text","bind":"Conn1_object","value":{"tag":"textedit","class":"","value":{"ready":"yes","service":"csvfile","actions":{"refresh":"read","update":"append"},"file":"testdata.csv","separator":",","batch":100,"target":"Conn1","filterField":"mail","filterLookup":"","lookup":"","lookupField":"","lookupKey":"mail"},"mime":"text/json"}},"5":{"tag":"div","name":"Conn1_dataeditZone","type":"table","bind":"Conn1_object","offset":"0","value":{"tag":"jsontable","name":"Conn1","class":"dataset","value":{"model":{"date":"","mail":"","civilite":"","jour-naissance":"","mois-naissance":"","annee-naissance":"","option 1":"","option 2":"","option 3":""},"row 1":{"date":"01/01/1602","mail":"mail208.test.com","civilite":"Madame","jour-naissance":"23","mois-naissance":"6","annee-naissance":"1961","option 1":"0","option 2":"1","option 3":"0"},"row 2":{"date":"01/01/1602","mail":"mail453.test.com","civilite":"Madame","jour-naissance":"8","mois-naissance":"7","annee-naissance":"1966","option 1":"0","option 2":"1","option 3":"0"},"row 3":{"date":"01/01/1602","mail":"mail398.test.com","civilite":"Madame","jour-naissance":"10","mois-naissance":"1","annee-naissance":"1996","option 1":"0","option 2":"1","option 3":"0"},"row 4":{"date":"01/01/1602","mail":"mail499.test.com","civilite":"Madame","jour-naissance":"4","mois-naissance":"1","annee-naissance":"1977","option 1":"0","option 2":"1","option 3":"1"},"row 5":{"date":"01/01/1602","mail":"mail320.test.com","civilite":"Madame","jour-naissance":"11","mois-naissance":"7","annee-naissance":"1991","option 1":"0","option 2":"0","option 3":"0"},"row 6":{"date":"01/01/1602","mail":"mail190.test.com","civilite":"Madame","jour-naissance":"9","mois-naissance":"8","annee-naissance":"1974","option 1":"0","option 2":"0","option 3":"0"},"row 7":{"date":"01/01/1602","mail":"mail34.test.com","civilite":"Madame","jour-naissance":"11","mois-naissance":"2","annee-naissance":"1970","option 1":"0","option 2":"0","option 3":"1"},"row 8":{"date":"01/01/1602","mail":"mail437.test.com","civilite":"Madame","jour-naissance":"10","mois-naissance":"9","annee-naissance":"1978","option 1":"1","option 2":"1","option 3":"0"},"row 9":{"date":"01/01/1602","mail":"mail338.test.com","civilite":"Madame","jour-naissance":"5","mois-naissance":"9","annee-naissance":"1979","option 1":"0","option 2":"1","option 3":"1"},"row 10":{"date":"01/01/1602","mail":"mail359.test.com","civilite":"Madame","jour-naissance":"18","mois-naissance":"4","annee-naissance":"1982","option 1":"0","option 2":"1","option 3":"0"},"row 11":{"date":"01/01/1602","mail":"mail423.test.com","civilite":"Madame","jour-naissance":"3","mois-naissance":"10","annee-naissance":"1987","option 1":"1","option 2":"1","option 3":"1"},"row 12":{"date":"01/01/1602","mail":"mail115.test.com","civilite":"Madame","jour-naissance":"6","mois-naissance":"12","annee-naissance":"1969","option 1":"0","option 2":"0","option 3":"0"},"row 13":{"date":"01/01/1602","mail":"mail259.test.com","civilite":"Madame","jour-naissance":"18","mois-naissance":"9","annee-naissance":"1971","option 1":"0","option 2":"1","option 3":"0"},"row 14":{"date":"01/01/1602","mail":"mail314.test.com","civilite":"Madame","jour-naissance":"18","mois-naissance":"2","annee-naissance":"1964","option 1":"1","option 2":"0","option 3":"1"},"row 15":{"date":"01/01/1602","mail":"mail391.test.com","civilite":"Madame","jour-naissance":"21","mois-naissance":"10","annee-naissance":"1990","option 1":"0","option 2":"0","option 3":"0"},"row 16":{"date":"01/01/1602","mail":"mail252.test.com","civilite":"Madame","jour-naissance":"10","mois-naissance":"12","annee-naissance":"1973","option 1":"0","option 2":"0","option 3":"1"},"row 17":{"date":"01/01/1602","mail":"mail413.test.com","civilite":"Madame","jour-naissance":"5","mois-naissance":"5","annee-naissance":"1960","option 1":"0","option 2":"1","option 3":"1"},"row 18":{"date":"01/01/1602","mail":"mail77.test.com","civilite":"Madame","jour-naissance":"3","mois-naissance":"4","annee-naissance":"1999","option 1":"0","option 2":"1","option 3":"1"},"row 19":{"date":"01/01/1602","mail":"mail386.test.com","civilite":"Madame","jour-naissance":"28","mois-naissance":"7","annee-naissance":"2003","option 1":"1","option 2":"1","option 3":"0"},"row 20":{"date":"01/01/1602","mail":"mail197.test.com","civilite":"Madame","jour-naissance":"20","mois-naissance":"6","annee-naissance":"1985","option 1":"0","option 2":"0","option 3":"0"},"row 21":{"date":"01/01/1602","mail":"mail308.test.com","civilite":"Madame","jour-naissance":"12","mois-naissance":"11","annee-naissance":"1987","option 1":"0","option 2":"0","option 3":"0"},"row 22":{"date":"01/01/1602","mail":"mail414.test.com","civilite":"Madame","jour-naissance":"8","mois-naissance":"6","annee-naissance":"1998","option 1":"1","option 2":"1","option 3":"0"},"row 23":{"date":"01/01/1602","mail":"mail70.test.com","civilite":"Madame","jour-naissance":"5","mois-naissance":"8","annee-naissance":"1988","option 1":"1","option 2":"1","option 3":"1"},"row 24":{"date":"01/01/1602","mail":"mail337.test.com","civilite":"Madame","jour-naissance":"12","mois-naissance":"11","annee-naissance":"1990","option 1":"0","option 2":"0","option 3":"0"},"row 25":{"date":"01/01/1602","mail":"mail8.test.com","civilite":"Madame","jour-naissance":"7","mois-naissance":"10","annee-naissance":"1971","option 1":"1","option 2":"0","option 3":"1"},"row 26":{"date":"01/01/1602","mail":"mail309.test.com","civilite":"Madame","jour-naissance":"18","mois-naissance":"5","annee-naissance":"1974","option 1":"0","option 2":"1","option 3":"1"},"row 27":{"date":"01/01/1602","mail":"mail189.test.com","civilite":"Madame","jour-naissance":"24","mois-naissance":"8","annee-naissance":"1986","option 1":"0","option 2":"1","option 3":"0"},"row 28":{"date":"01/01/1602","mail":"mail208.test.com","civilite":"Madame","jour-naissance":"3","mois-naissance":"4","annee-naissance":"1967","option 1":"0","option 2":"0","option 3":"0"},"row 29":{"date":"01/01/1602","mail":"mail298.test.com","civilite":"Madame","jour-naissance":"3","mois-naissance":"9","annee-naissance":"1997","option 1":"0","option 2":"0","option 3":"1"},"row 30":{"date":"01/01/1602","mail":"mail435.test.com","civilite":"Madame","jour-naissance":"6","mois-naissance":"5","annee-naissance":"1981","option 1":"0","option 2":"1","option 3":"0"},"row 31":{"date":"01/01/1602","mail":"mail162.test.com","civilite":"Madame","jour-naissance":"10","mois-naissance":"6","annee-naissance":"1984","option 1":"1","option 2":"1","option 3":"1"},"row 32":{"date":"01/01/1602","mail":"mail388.test.com","civilite":"Madame","jour-naissance":"4","mois-naissance":"10","annee-naissance":"1987","option 1":"1","option 2":"1","option 3":"1"},"row 33":{"date":"01/01/1602","mail":"mail441.test.com","civilite":"Madame","jour-naissance":"7","mois-naissance":"11","annee-naissance":"1966","option 1":"1","option 2":"1","option 3":"1"},"row 34":{"date":"01/01/1602","mail":"mail242.test.com","civilite":"Madame","jour-naissance":"25","mois-naissance":"6","annee-naissance":"1982","option 1":"0","option 2":"0","option 3":"0"},"row 35":{"date":"01/01/1602","mail":"mail369.test.com","civilite":"Madame","jour-naissance":"18","mois-naissance":"4","annee-naissance":"2005","option 1":"0","option 2":"1","option 3":"1"},"row 36":{"date":"01/01/1602","mail":"mail31.test.com","civilite":"Madame","jour-naissance":"1","mois-naissance":"7","annee-naissance":"1996","option 1":"1","option 2":"1","option 3":"0"},"row 37":{"date":"01/01/1602","mail":"mail486.test.com","civilite":"Madame","jour-naissance":"6","mois-naissance":"12","annee-naissance":"1967","option 1":"1","option 2":"0","option 3":"1"},"row 38":{"date":"01/01/1602","mail":"mail17.test.com","civilite":"Madame","jour-naissance":"7","mois-naissance":"8","annee-naissance":"1982","option 1":"0","option 2":"0","option 3":"1"}}}}}}
{"meta":{"type":"connector","name":"Connector2","zone":"Connector2editZone","caption":"Connector 2","captionPosition":"top"},"data":{"button1":{"tag":"span","class":"rightButton","value":{"tag":"a","href":"javascript:","onclick":"API.showNextInList( ['Connector2_dataeditZone', 'Connector2_parameters_editZone']);","value":"configurer"}},"button2":{"tag":"span","class":"rightButton","value":{"tag":"a","href":"javascript:","onclick":"API.connectorRefresh( 'Connector2');","value":"refresh"}},"button3":{"tag":"span","class":"rightButton","value":{"tag":"a","href":"javascript:","onclick":"API.connectorUpdateServer( 'Connector2');","value":"update server"}},"config":{"tag":"div","type":"text","name":"Connector2_parameters_editZone","value":{"tag":"textedit","class":" ","value":{"ready":"yes","service":"csvfile","actions":{"refresh":"read","update":"append"},"file":"F144out.csv","separator":",","batch":100,"target":"Connector2","dataSource":"Conn1","cols":["action","email","dinscription","dnaissance","civ","nom","prenom","famille","salaire","epargne","niveau_impots","csp","ville","cp","tel","source","optin"],"modelRow":{"action":"=if( statut == 'absent', 'ignore', 'append');","email":"=mail","dinscription":"=datestr( Date, 'DD-MM-YYYY @ HH:mm', 'YYYY-MM-DD HH:mm');","dnaissance":"=datestr( annee_naissance+'-'+mois_naissance+'-'+jour_naissance, 'YYYY-M-D', 'YYYY-MM-DD');","civ":"=if( oneOf( ..civilite, 'Monsieur', 'un homme'), 'mr', 'mme');","nom":"=uppercase(nom);","prenom":"=titlecase(prenom);","famille":"=situation_familiale;","salaire":"=salaire_brut","epargne":"","niveau_impots":"=niveau_imposition;","csp":"=profession;","ville":"=uppercase(ville);","cp":"=code_postal;","tel":"=telephone;","source":"retraite.com","optin":"1"},"formName":"CSVwrite"},"mime":"text/json"}},"cache":{"meta":{"type":"table","name":"Connector2","zone":"Connector2_dataeditZone","offset":0},"data":{"tag":"jsontable","class":"dataset","sourceURL":"UniversalDocElement--21-4-21-4934-21-4944-21-4946--UD|1","updateMinutes":1440,"_lastUpdated":"2021-08-31T17:34:55+0200","datasrc":"Conn1","value":{"model":{"action":"=if( statut == 'absent', 'ignore', 'append');","email":"=mail","dinscription":"=datestr( Date, 'DD-MM-YYYY @ HH:mm', 'YYYY-MM-DD HH:mm');","dnaissance":"=datestr( annee_naissance+'-'+mois_naissance+'-'+jour_naissance, 'YYYY-M-D', 'YYYY-MM-DD');","civ":"=if( oneOf( ..civilite, 'Monsieur', 'un homme'), 'mr', 'mme');","nom":"=uppercase(nom);","prenom":"=titlecase(prenom);","famille":"=situation_familiale;","salaire":"=salaire_brut","epargne":"","niveau_impots":"=niveau_imposition;","csp":"=profession;","ville":"=uppercase(ville);","cp":"=code_postal;","tel":"=telephone;","source":"retraite.com","optin":"1"},"row 1":{"action":"...","email":"...","dinscription":"31/08/2021","dnaissance":"31/08/2021","civ":"...","nom":"...","prenom":"...","famille":"...","salaire":"...","epargne":"...","niveau_impots":"...","csp":"...","ville":"...","cp":"...","tel":"...","source":"...","optin":"..."}}}}},"changes":[]}
Contrôles : Sample Map .
...
Catalog converter
This application provides a simple way to build how fields from an incoming e-catalog are mapped to an outgoing e-catalog.
Formats for e-catalogs can be CSV, JSON,Google sheet, XLS, XLSX or ODS.
Outgoing fields can take constant values, formulas on 1 or more incoming fields and looked up values. Formulas can use a host of formatting, mathematical or financial functions.
Home tool set right