Last active
June 21, 2020 18:20
-
-
Save eewee/685d09a263a5cb13210ef0097d9fcec8 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
VERSION BUILD=10.4.28.1074 | |
'-------------------------------------------------------------- | |
' Ajouter des prospects sur Sellsy | |
' Comment cela fonctionne ? | |
' - Lire CSV | |
' - Ajouter prospect | |
'-------------------------------------------------------------- | |
' Uses a Windows script to submit several datasets to a website, e. g. for filling an online database | |
TAB T=1 | |
TAB CLOSEALLOTHERS | |
URL GOTO=https://www.sellsy.fr/?_f=prospection_prospect | |
' Specify input file (if !COL variables are used, IIM automatically assume a CSV format of the input file | |
' CSV = Comma Separated Values in each line of the file | |
SET !FOLDER_DATASOURCE C:\Users\Michael\Documents\iMacros\Datasources\ | |
SET !DATASOURCE sellsy_prospects.csv | |
' Commence ligne 2 | |
SET !LOOP 2 | |
SET !DATASOURCE_LINE {{!LOOP}} | |
'PROMPT "Aaa: {{!COL1}}" | |
TAG POS=2 TYPE=LI ATTR=TXT:Ajouter<SP>un<SP>prospect | |
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:thirdFormCreate ATTR=ID:corp_name CONTENT={{!COL1}} | |
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:thirdFormCreate ATTR=ID:corp_ident CONTENT={{!COL2}} | |
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:thirdFormCreate ATTR=ID:corp_web CONTENT={{!COL3}} | |
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:thirdFormCreate ATTR=ID:corp_tel CONTENT={{!COL4}} | |
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:thirdFormCreate ATTR=ID:corp_mobile CONTENT={{!COL5}} | |
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:thirdFormCreate ATTR=ID:corp_email CONTENT={{!COL6}} | |
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:thirdFormCreate ATTR=ID:thirdcontact_forename CONTENT={{!COL7}} | |
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:thirdFormCreate ATTR=ID:thirdcontact_name CONTENT={{!COL8}} | |
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:thirdFormCreate ATTR=ID:thirdcontact_position CONTENT={{!COL9}} | |
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:thirdFormCreate ATTR=ID:thirdcontact_email CONTENT={{!COL10}} | |
TAG POS=1 TYPE=BUTTON ATTR=TXT:Enregistrer | |
WAIT SECONDS=1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
corp_name | corp_ident | corp_web | corp_tel | corp_mobile | corp_email | thirdcontact_forename | thirdcontact_name | thirdcontact_position | thirdcontact_email | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Societe_001 | Ref_55001 | www.site_001.com | 0122334455 | 0622334455 | societe_001@eewee.fr | Prenom_001 | NOM_001 | Fonction_001 | Prenom_001.nom_001@eewee.fr | _001 | www.site | .com | societe | @eewee.fr | Prenom | .nom | |||||
Societe_002 | Ref_55002 | www.site_002.com | 0122334456 | 0622334456 | societe_002@eewee.fr | Prenom_002 | NOM_002 | Fonction_002 | Prenom_002.nom_002@eewee.fr | _002 | www.site | .com | societe | @eewee.fr | Prenom | .nom | |||||
Societe_003 | Ref_55003 | www.site_003.com | 0122334457 | 0622334457 | societe_003@eewee.fr | Prenom_003 | NOM_003 | Fonction_003 | Prenom_003.nom_003@eewee.fr | _003 | www.site | .com | societe | @eewee.fr | Prenom | .nom | |||||
Societe_004 | Ref_55004 | www.site_004.com | 0122334458 | 0622334458 | societe_004@eewee.fr | Prenom_004 | NOM_004 | Fonction_004 | Prenom_004.nom_004@eewee.fr | _004 | www.site | .com | societe | @eewee.fr | Prenom | .nom | |||||
Societe_005 | Ref_55005 | www.site_005.com | 0122334459 | 0622334459 | societe_005@eewee.fr | Prenom_005 | NOM_005 | Fonction_005 | Prenom_005.nom_005@eewee.fr | _005 | www.site | .com | societe | @eewee.fr | Prenom | .nom | |||||
Societe_006 | Ref_55006 | www.site_006.com | 0122334460 | 0622334460 | societe_006@eewee.fr | Prenom_006 | NOM_006 | Fonction_006 | Prenom_006.nom_006@eewee.fr | _006 | www.site | .com | societe | @eewee.fr | Prenom | .nom | |||||
Societe_007 | Ref_55007 | www.site_007.com | 0122334461 | 0622334461 | societe_007@eewee.fr | Prenom_007 | NOM_007 | Fonction_007 | Prenom_007.nom_007@eewee.fr | _007 | www.site | .com | societe | @eewee.fr | Prenom | .nom | |||||
Societe_008 | Ref_55008 | www.site_008.com | 0122334462 | 0622334462 | societe_008@eewee.fr | Prenom_008 | NOM_008 | Fonction_008 | Prenom_008.nom_008@eewee.fr | _008 | www.site | .com | societe | @eewee.fr | Prenom | .nom | |||||
Societe_009 | Ref_55009 | www.site_009.com | 0122334463 | 0622334463 | societe_009@eewee.fr | Prenom_009 | NOM_009 | Fonction_009 | Prenom_009.nom_009@eewee.fr | _009 | www.site | .com | societe | @eewee.fr | Prenom | .nom | |||||
Societe_010 | Ref_55010 | www.site_010.com | 0122334464 | 0622334464 | societe_010@eewee.fr | Prenom_010 | NOM_010 | Fonction_010 | Prenom_010.nom_010@eewee.fr | _010 | www.site | .com | societe | @eewee.fr | Prenom | .nom |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment