Skip to content

Instantly share code, notes, and snippets.

@eewee
Last active June 21, 2020 18:20
Show Gist options
  • Save eewee/685d09a263a5cb13210ef0097d9fcec8 to your computer and use it in GitHub Desktop.
Save eewee/685d09a263a5cb13210ef0097d9fcec8 to your computer and use it in GitHub Desktop.
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
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