DAIBOLA

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
en:sedamo:sedamo_email_mass_registration [2022/04/20 17:06] adminen:sedamo:sedamo_email_mass_registration [2022/04/20 20:53] (current) admin
Line 1: Line 1:
 +<WRAP tabs>
 +  * [[en:contact|English]]
 +</WRAP>
 +
 +====== sedamo and eMail2address.com mass registration ======
 +
 +You can link several e-mail addresses with a //sedamo// code --- and hence with a (physical or postal) address by simply uploading a CVS file or spreadsheet file in the format described below:
 +
 +File format:  
 +   * Comma Separated Values file (.csv)
 +         * UTF-8 encoding
 +         * text delimiters: ''"''
 +         * value separators: '',''
 +   * Open Document Spreadsheet (.ods)
 +   * Excel Spread Sheet (.xls)
 +         * Microsoft Excel 97/2000/XP
 +   * SQL
 +   * other formats on request 
 +   * maximum file size: 3 MiByte
 +
 +Fields: 
 +  - ''sedamo'' --- 8-letter code of the address (//mandatory//)
 +  - ''email'' --- e-mail address (//mandatory//)
 +  - ''nameline1'' --- e.g. hotel name
 +  - ''nameline2'' --- e.g. department 
 +  - ''phone'' --- phone number
 +  - ''mobile'' --- cell phone number
 +  - ''fax'' --- facsimile number 
 +  - ''homepage'' --- URL of your website
 +  - ''language'' --- ISO 2-code of the local language 
 +
 +Remarks:
 +  * Only //sedamo// and email fields are mandatory. All other fields are optional.
 +  * The first line of the spreadsheet file must contain the field names. (The field order is at your discretion.)
 +  * The //sedamo// field may contain a formatted or unformatted code (''ABCDEFGH'' or ''AB-CD-EF-GH'')
 +  * Phone/mobile/fax numbers have to be in the international format, e.g. ''+44-7700-900123'' or ''447700900123'' (here: +44- = UK IDD)
 +  * E-mail addresses must be unique (i.e., two //sedamo// address codes cannot be assigned to one e-mail address).
 +
 +Sample files:
 +  * CSV: {{ :img:email2address_example.csv |}} 
 +  * OpenDocument (also for MS Excel): {{ :img:email2address_example.ods |}} 
 +  * SQL: {{ :img:email2address_example.sql |}}
 +
 +Tips:
 +  * Use short e-mail addresses, e.g. ''fra@example.com'' instead ''point_of_delivery_frankfurt_am_main@mail.example.com'' 
 +  * Include the well-known e-mail addresses of contact persons (receptionists etc.), e.g. ''sabrina.davis@example.com''
 +  * Use ''A''~''Z'', dot ''.'' and ''@'' preferably; avoid underscore ''_'' and minus sign ''-'' and numbers, do not use special characters and IDNs(([[https://en.m.wikipedia.org/wiki/Internationalized_domain_name|Internationalised Domain Names]])) (negative example: ''xeno&phobia~2.0@example.中国'')
 +
 +<form>
 +Action mail gunnar.lindenblatt@daibola.biz
 +Thanks "Your file has been submitted. We will contact you as soon as your data are online"
 +
 +fieldset "Your contacts"
 +textbox  "Name"
 +email "E-mail address"
 +textbox "sedamo"
 +number  "Telephone number"
 +
 +
 +fieldset "Your sedamo data file"
 +file "sedamo file"
 +yesno "Allow access via eMail2address.com website and related services"
 +
 +fieldset ""
 +textbox "What's the day between yesterday and tomorrow?" /^today$/ "**The day between yesterday and tomorrow is: today"
 +submit "Submit"
 +</form>
 +
 +
 +Suggestions:
 +
 +Use ⊙ behind your e-mail address to signal that this electronic address can be used for navigation to your physical address. 
 +
 +⊙ is known as “CIRCLED DOT OPERATOR”, Unicode: U+2299, XML decimal entity: ''&#8857;''
 +
 +In printed publications, such as, name cards, stationary, leaflets: 
 +
 +> E-mail:  example@sedamo.info ⊙
 +
 +> ⊙ = You can use this e-mail address for navigation via http://www.email2address.com/
 + 
 +French:
 +> ⊙ = Cette adresse e-mail peut être utilisée pour navigation par http://www.email2address.com/.
 +
 +German: 
 +> ⊙ = Diese E-Mail-Adresse kann zur Navigation via http://www.email2address.com/ genutzt werden.
 + 
 +Spanish: 
 +> ⊙ = Esta dirección de correo electrónico se puede utilizar para la navegación a través de http://www.email2address.com/.
 +
 +
 +On web-pages: 
 +<code HTML> 
 +<a href="mailto:example@sedamo.info">example@sedamo.info</a>
 +<a href="http://www.email2address.com/example%40sedamo.info" target="_blank">&#8857;</a>
 +</code> 
 +
 +<HTML> 
 +<a href="mailto:example@sedamo.info">example@sedamo.info</a>
 +<a href="http://www.email2address.com/example%40sedamo.info" target="_blank">&#8857;</a>
 +</HTML> 
 +