Skip to content
,
Skip to search
Wiki Sumber Informasi iSIKHNAS
Dari Wiki Sumber Informasi iSIKHNAS
Menu
Home
Apa itu ISIKHNAS? : What is iSIKHNAS?
FAQ:Pertanyaan Umum : FAQ
ISIKHNAS Kode-Kode : Codes
Pengguna : Users
Pelsa : Village reporters
Dinas : Field Staff
Laboratorium : Laboratory
Koordinator : Coordinators
Pengguna Data : Data Users
Teknis : Technical
Data Dikelola : Data managed
Referensi Teknis : Technical references
Kode-kode : Codes
Tabel Database : Database Tables
Struktur Database : Database ERDs
Fungsi Database : Database Functions
Panduan dan Standar : Guides and Standards
Menggunakan wiki : Using the Wiki
Pelatihan : Training
ISIKHNAS pelatihan pengguna : iSIKHNAS Training
Epidemiologi di lapangan : Field Epidemiology
Surveilans : Surveillance
Advokasi untuk Anggaran : Budget Advocacy
Analisis Epidemiologi data : Epi Data Analysis
GIS untuk kesehatan hewan : GIS for animal health
Excel
Investigasi penyakit untuk paravet : Disease Investigation
Mengenali tanda-tanda penyakit : Recognising Signs of Disease
Panduan fasilitasi : Facilitators Manual
Glosarium : Glossary
Komunikasi : Communication
Sosialisasi ISIKHNAS : Communicating about iSIKHNAS
ISIKHNAS Videos
ISIKHNAS Logos
Pertanyaan : FAQ
Informasi tentang ISIKHNAS : About iSIKHNAS
Menyerahkan data : Submitting data
Menggunakan kode : Using system queries
Terjemahkan
|
Statistik bahasa
|
Statistik kelompok pesan
|
Ekspor
|
Terjemahkan
Pengaturan
Kelompok
Terjemahan terkini
Penambahan terkini
Sandbox messages
Animal and Farmer Identification
Animal ID and health reporting
Basic Field Epi: Facilitator Guide
Basic Field Epi: Manual
Budget Advocacy
Budget Advocacy:Outline
Changing location data
Communication
Coordinator Checklist
Course objectives
Disease Investigation
District coordinators
District coordinators - in more detail
Epidemiological Data Analysis
FAQ: Frequently Asked Questions
Field Epidemiology
Field Epidemiology Advanced: Manual
GIS AH Answers
GIS for Animal Health
How can I get involved?
How does it work?
How is it managed?
Human health
Instant Messaging
Introduction
ISIKHNAS Training Resources
ISIKHNAS Training Toolkit
ISIKHNAS User References
Livestock insurance
Main Page
Manage
Manage : Manage Users
Manage Programs
Mangement of the System
Manual for Coordinators
Manually sending individual or bulk SMS messages
Manuals for Data Users
Manuals for Field Data Reporters
Manuals for Laboratory Users
Manuals:Abattoir Reporters
Manuals:Active Surveillance
Manuals:Animal Idenification
Manuals:Farmer Registration
Manuals:Field Staff
Manuals:General Introduction
Manuals:Insemination
Manuals:InstantMessaging
Manuals:Movement
Manuals:Population
Manuals:Priority disease investigation
Manuals:Registration
Manuals:SMS Reports
Manuals:SMS System Trainer's Manual
Manuals:System Coordinator
Manuals:Vaccination
Manuals:Village Reporters
New system features
Operational instructions:BB
Operational instructions:BH
Operational instructions:CKI
Operational instructions:CKJS
Operational instructions:CKL
Operational instructions:CKO
Operational instructions:CKP
Operational instructions:CKT
Operational instructions:CUL
Operational instructions:DH
Operational instructions:DHP
Operational instructions:DKB
Operational instructions:DKL
Operational instructions:DP
Operational instructions:DX
Operational instructions:IB
Operational instructions:IH
Operational instructions:KGG
Operational instructions:KODE
Operational instructions:KOM
Operational instructions:LAB
Operational instructions:LAPD
Operational instructions:LAPK
Operational instructions:LAPSK
Operational instructions:LH
Operational instructions:LTL
Operational instructions:OB
Operational instructions:P
Operational instructions:PK
Operational instructions:PKB
Operational instructions:POP
Operational instructions:R
Operational instructions:RP
Operational instructions:RVAK
Operational instructions:SK
Operational instructions:SLAB
Operational instructions:SLAP
Operational instructions:SP
Operational instructions:SUR
Operational instructions:TK
Operational instructions:TL
Operational instructions:U
Operational instructions:UC
Operational instructions:VAK
Operational instructions:VSK
Operational instructions:Z
Pelsa
Pelsa Facilitator Manual
Queries
Query message formats
Reports
Role of the Coordinators
Role of training facilitator
Roles and responsibilities:District coordinators
Roles and responsibilities:Regional and Provincial coordinators
SMS handler setup
SMS Handler: Step by step example
Spatial data management manual
Spreadsheet data submission manual
Staff Technical Development
Surveillance
Surveillance course facilitator
Surveillance course participant
Technical assistance modules
Training
Training and Facilitation Guide
Training and Facilitation Guide:Code Lists
Training and Facilitation Guide:Scenario Cards
Training and Facilitation Guide:SMS Message Training points
Training your staff
User References
User registration
User registration by email spreadsheet upload
User types
User:Ben
Using Book Creator
Using the data
Website
What are the benefits?
What is iSIKHNAS?
What is it for?
Who is involved?
Wiki Work
Bahasa
aa - Afar
ab - Abkhaz
ace - Aceh
ady - Adygei
ady-cyrl - адыгабзэ
aeb - Arab Tunisia
aeb-arab - تونسي
aeb-latn - Tûnsî
af - Afrikaans
ak - Akan
aln - Gheg Albanian
am - Amharik
an - Aragon
ang - Inggris Kuno
anp - Angika
ar - Arab
arc - Aram
arn - Araukan
arq - Arab Algeria
ary - Arab Maroko
arz - Arab Mesir
as - Assam
ase - Bahasa Isyarat Amerika
ast - Astur
atj - Atikamekw
av - Avar
avk - Kotava
awa - Awadhi
ay - Aymara
az - Azerbaijan
azb - تۆرکجه
ba - Bashkir
ban - Bali
bar - Bavaria
bbc - Batak Toba
bbc-latn - Batak Toba
bcc - Southern Balochi
bcl - Bikol Central
be - Belarusia
be-tarask - Belarusian (Taraškievica orthography)
bg - Bulgaria
bgn - Balochi Barat
bho - Bhojpuri
bi - Bislama
bjn - Banjar
bm - Bambara
bn - Bengali
bo - Tibet
bpy - Bishnupriya
bqi - Bakhtiari
br - Breton
brh - Brahui
bs - Bosnia
bto - Iriga Bicolano
bug - Bugis
bxr - буряад
ca - Katalan
cbk-zam - Chavacano de Zamboanga
cdo - Min Dong Chinese
ce - Chechen
ceb - Sebuano
ch - Chamorro
cho - Koktaw
chr - Cherokee
chy - Cheyenne
ckb - Kurdi Sorani
co - Korsika
cps - Capiznon
cr - Kree
crh - Tatar Krimea
crh-cyrl - Crimean Turkish (Cyrillic script)
crh-latn - Crimean Turkish (Latin script)
cs - Cheska
csb - Kashubia
cu - Bahasa Gereja Slavonia
cv - Chuvash
cy - Welsh
da - Dansk
de - Jerman
de-at - Austrian German
de-ch - Jerman Tinggi (Swiss)
de-formal - German (formal address)
din - Dinka
diq - Zazaki
dsb - Sorbia Rendah
dtp - Central Dusun
dty - डोटेली
dv - Divehi
dz - Dzongkha
ee - Ewe
egl - Emilian
el - Yunani
eml - Emiliano-Romagnolo
en - Inggris
en-ca - Canadian English
en-gb - British English
eo - Esperanto
es - Spanyol
es-formal - español (formal)
et - Esti
eu - Bask
ext - Extremaduran
fa - Persia
ff - Fula
fi - Suomi
fit - Tornedalen Finnish
fj - Fiji
fo - Faro
fr - Prancis
frc - Cajun French
frp - Arpitan
frr - Frisia Utara
fur - Friuli
fy - Frisia Barat
ga - Irlandia
gag - Gagauz
gan - Gan Chinese
gan-hans - Simplified Gan script
gan-hant - Traditional Gan script
gcr - kréyòl gwiyanè
gd - Gaelik Skotlandia
gl - Galisia
glk - Gilaki
gn - Guarani
gom - Goan Konkani
gom-deva - Goan Konkani (Devanagari script)
gom-latn - Goan Konkani (Latin script)
gor - Gorontalo
got - Gothik
grc - Yunani Kuno
gsw - Jerman (Swiss)
gu - Gujarati
gv - Manx
ha - Hausa
hak - Hakka Chinese
haw - Hawaii
he - Ibrani
hi - Hindi
hif - Hindi Fiji
hif-latn - Fiji Hindi (Latin script)
hil - Hiligaynon
ho - Hiri Motu
hr - Kroasia
hrx - Hunsrik
hsb - Sorbia Atas
ht - Haiti
hu - Hungaria
hu-formal - magyar (formal)
hy - Armenia
hz - Herero
ia - Interlingua
id - Bahasa Indonesia
ie - Interlingue
ig - Igbo
ii - Sichuan Yi
ik - Inupiak
ike-cans - Eastern Canadian (Aboriginal syllabics)
ike-latn - Eastern Canadian (Latin script)
ilo - Iloko
inh - Ingushetia
io - Ido
is - Islandia
it - Italia
iu - Inuktitut
ja - Jepang
jam - Jamaican Creole English
jbo - Lojban
jut - Jutish
jv - Jawa
ka - Georgia
kaa - Kara-Kalpak
kab - Kabyle
kbd - Kabardi
kbd-cyrl - Адыгэбзэ
kbp - Kabɩyɛ
kg - Kongo
khw - Khowar
ki - Kikuyu
kiu - Kirmanjki
kj - Kuanyama
kk - Kazakh
kk-arab - Kazakh (Arabic script)
kk-cn - Kazakh (China)
kk-cyrl - Kazakh (Cyrillic script)
kk-kz - Kazakh (Kazakhstan)
kk-latn - Kazakh (Latin script)
kk-tr - Kazakh (Turkey)
kl - Kalaallisut
km - Khmer
kn - Kannada
ko - Korea
ko-kp - 한국어 (조선)
koi - Komi-Permyak
kr - Kanuri
krc - Karachai Balkar
kri - Krio
krj - Kinaray-a
krl - Karelia
ks - Kashmir
ks-arab - Kashmiri (Arabic script)
ks-deva - Kashmiri (Devanagari script)
ksh - Dialek Kolsch
ku - Kurdi
ku-arab - كوردي (عەرەبی)
ku-latn - Kurdish (Latin script)
kum - Kumyk
kv - Komi
kw - Kornish
ky - Kirgiz
la - Latin
lad - Ladino
lb - Luksemburg
lbe - лакку
lez - Lezghia
lfn - Lingua Franca Nova
lg - Ganda
li - Limburgia
lij - Liguria
liv - Livonian
lki - Laki
lmo - Lombard
ln - Lingala
lo - Lao
loz - Lozi
lrc - Luri Utara
lt - Lituavi
ltg - Latgalian
lus - Mizo
luz - Southern Luri
lv - Latvi
lzh - Literary Chinese
lzz - Laz
mai - Maithili
map-bms - Basa Banyumasan
mdf - Moksha
mg - Malagasi
mh - Marshall
mhr - Eastern Mari
mi - Maori
min - Minangkabau
mk - Makedonia
ml - Malayalam
mn - Mongolia
mo - молдовеняскэ
mr - Marathi
mrj - Western Mari
ms - Melayu
mt - Malta
mus - Bahasa Muskogee
mwl - Miranda
my - Myanmar
myv - Eryza
mzn - Mazanderani
na - Nauru
nah - Nāhuatl
nan - Min Nan Chinese
nap - Neapolitan
nb - Bokmål Norwegia
nds - Jerman Rendah
nds-nl - Low Saxon
ne - Nepali
new - Newari
ng - Ndonga
niu - Niuea
nl - Belanda
nl-informal - Nederlands (informeel)
nn - Nynorsk Norwegia
nov - Novial
nrm - Nouormand
nso - Sotho Utara
nv - Navajo
ny - Nyanja
nys - Nyunga
oc - Ositania
olo - Livvi-Karelian
om - Oromo
or - Oriya
os - Ossetia
pa - Punjabi
pag - Pangasina
pam - Pampanga
pap - Papiamento
pcd - Picard
pdc - Jerman Pennsylvania
pdt - Plautdietsch
pfl - Palatine German
pi - Pali
pih - Norfuk / Pitkern
pl - Polski
pms - Piedmontese
pnb - Western Punjabi
pnt - Pontic
prg - Prussian
ps - Pashto
pt - Portugis
pt-br - Brazilian Portuguese
qqq - Dokumentasi pesan
qu - Quechua
qug - Chimborazo Highland Quichua
rgn - Romagnol
rif - Riffian
rm - Reto-Roman
rmy - Romani
rn - Rundi
ro - Rumania
roa-tara - tarandíne
ru - Rusia
rue - Rusyn
rup - Makedo-Rumania
ruq - Megleno-Romanian
ruq-cyrl - Megleno-Romanian (Cyrillic script)
ruq-latn - Megleno-Romanian (Latin script)
rw - Kinyarwanda
sa - Sanskerta
sah - Sakha
sat - Santali
sc - Sardinia
scn - Sisilia
sco - Skotlandia
sd - Sindhi
sdc - Sassarese Sardinian
sdh - Kurdi Selatan
se - Sami Utara
sei - Seri
ses - Koyraboro Senni
sg - Sango
sgs - Samogitian
sh - Serbo-Kroasia
shi - Tachelhit
shi-latn - Tašlḥiyt
shi-tfng - ⵜⴰⵛⵍⵃⵉⵜ
shn - Shan
si - Sinhala
sk - Slovak
skr - سرائیکی
skr-arab - سرائیکی
sl - Sloven
sli - Silesia Bawah
sm - Samoa
sma - Sami Selatan
sn - Shona
so - Somali
sq - Albania
sr - Serb
sr-ec - Serbian (Cyrillic script)
sr-el - Serbian (Latin script)
srn - Sranan Tongo
ss - Swati
st - Sotho Selatan
stq - Saterland Frisian
sty - cебертатар
su - Sunda
sv - Swedia
sw - Swahili
szl - Silesia
ta - Tamil
tay - Tayal
tcy - Tulu
te - Telugu
tet - Tetun
tg - Tajik
tg-cyrl - Tajik (Cyrillic script)
tg-latn - Tajik (Latin script)
th - Thai
ti - Tigrinya
tk - Turkmen
tl - Tagalog
tly - Talysh
tn - Tswana
to - Tonga
tpi - Tok Pisin
tr - Turki
tru - Turoyo
ts - Tsonga
tt - Tatar
tt-cyrl - Tatar (Cyrillic script)
tt-latn - Tatar (Latin script)
tum - Tumbuka
tw - Twi
ty - Tahiti
tyv - Tuvinia
tzm - Tamazight Maroko Tengah
udm - Udmurt
ug - Uyghur
ug-arab - Uyghur (Arabic script)
ug-latn - Uyghur (Latin script)
uk - Ukraina
ur - Urdu
uz - Uzbek
uz-cyrl - ўзбекча
uz-latn - oʻzbekcha
ve - Venda
vec - Venesia
vep - Veps
vi - Vietnam
vls - West Flemish
vmf - Main-Franconian
vo - Volapuk
vot - Votia
vro - Võro
wa - Walloon
war - Warai
wo - Wolof
wuu - Wu Chinese
xal - Kalmuk
xh - Xhosa
xmf - Mingrelian
yi - Yiddish
yo - Yoruba
yue - Kanton
za - Zhuang
zea - Zeelandic
zh - China
zh-cn - Chinese (China)
zh-hans - China (Aksara Sederhana)
zh-hant - China (Aksara Tradisional)
zh-hk - Chinese (Hong Kong)
zh-mo - 中文(澳門)
zh-my - 中文(马来西亚)
zh-sg - Chinese (Singapore)
zh-tw - Chinese (Taiwan)
zu - Zulu
Ekspor untuk terjemahan luring
Ekspor dalam format asli
<languages/> =User registration by email spreadsheet upload= ==Introduction== There are several ways to register new users on the iSIKHNAS system, including via SMS, Instant Messaging (IM) and the Web interface. All these methods create one user at a time and are suitable for individual or small numbers of users. However, many users are registered for the first time during their first training course. At a training course, there are usually many users to register at the start of the course, and doing them one by one takes a great deal of time. This page describes how to register many users at once, by entering their data into a spreadsheet, and then sending the spreadsheet by email to the iSIKHNAS web site. ==Overview== There are several steps required to prepare for the bulk spreadsheet registration: # Register the training course on the iSIKHNAS web site (Manage | Training Courses) specifying the topic, duration, location and area from which participants will be drawn. # You will need 2 spreadsheets: the Reference spreadsheet (with codes) and the Template spreadsheet for data entry. # Download the Reference spreadsheet containing the codes used to simplify data entry (location and user-type codes) # Download a copy of the User Registration Template spreadshet (a .XLSX file) # Save both the spreadsheets (reference and template) in the same directory. # Open both the spreadsheets # Enter the registration data for all the users, copying and pasting where it makes things faster and easier # Save the Registration data # Email it to iSIKHNAS ==Registering the training course on the iSIKHNAS web site== This feature has not yet been completed. More detail will be provdided soon. ==The Reference spreadsheet== This spreadsheet provides lookup values to make data entry faster and easier using the Template spreadsheet. The Reference spreadsheet is customised for each training course, so that the locations and areas of responsibility of the participants can picked from drop-down lists. To generate your custom Reference spreadsheet, log on to the iSIKHNAS web site, then go to Manage | Download Standards. {{hlbox|Note: This is currently called 'Download Laboratory Standards' }} On the screen: * Choose 'Training Course Registration' from the drop-down list * Choose your training course from the list {{hlbox|Note: The training course list is not yet developed. For the moment, choose some infrastructure (a laboratory) that has the same area of responsibility as the training course area.}} * Click OK, and the standards spreadsheet will be emailed to you in a few moments. * Save the Standards spreadsheet without changing its name into a directory and remember where you saved it. It must be in the same directory as the Template spreadsheet. ==The Template spreadsheet== * [[Media:pendaftaran pengguna v1.xlsx|Download the Template spreadsheet]] * Save it in the same directory as the Standards spreadsheet * You can rename the Template spreadsheet to any name you want, for example the name of the training course. ==Entering data== You enter data into the Template spreadsheet, but you must have the Reference spreadsheet open in Excel at the same time. # Open MS Excel # Open the Reference spreadsheet # Open the Template spreadsheet You are now ready to start entering data on the users at the course Each user is entered on one row, with the different details in different columns. Some columns are controlled so you can only enter values from the drop down pick lists. Others are formulae and are calculated automatically. The data for each of the columns is: * ID Pelatihan: the course ID as shown when you created the course on the iSIKHNAS web site. {{hlbox|Note. This is not yet implemented so leave this column empty}} * Nama depan: first name. Please use proper capitalisation * Nama belakang: second name. Please use proper capitalisation. If the person only has one name, leave this blank * Telepon: The mobile phone number. Enter this starting with 08, with no spaces or other punctuation. {{hlbox|Be very careful to get the phone number correct as it is used as the persons user name when accessing the system}} * Email: If the user has a email address, they can use this as their user name to log on to the iSIKHNAS web site, and also use it to receive automated daily, weekly and monthly reports. Please enter this very carefully and double check that it is correct. If the user has no email address, either create a new email address for them, or leave it blank. {{hlbox|'''Important''': NEVER use the same email address for more than a single user. This is a security risk and means that some users will not receive their reports.}} * Kata sandi: The user's password. [[FAQ:_Frequently_Asked_Questions#I_want_to_change_my_password._What_is_a_good_password_to_use.3F | Please choose a good password.]] * User's location: You should always enter the full details of the user's location, down to the village level for every user. For staff, this is the location of their office. For farmers or others, this is the location of their home or farm. To choose the location, first click on Provinsi and pick from the list. Then click on Kabupaten and pick from the list, and so on. The code for the location will be automatically displayed. * User's area of responsibility: All users that submit data should have an area of responsibility, indicating the area from which they are authorised to submit data. This may be the province, the district, the subdistrict or the village. If the user has more than one areas of responsibility, choose the first in the spreadsheet and then edit the detail on-line. The code will be automatically displayed. * Infrastruktur: All government users and many others will have associated infrastructure. This is the lab, Dinas office, checkpoint, abattoir etc that the person works at. Pick the type of infrastructure first, then the specific name from the next column. The code will be automatically displayed. * Kelompok pengguna: The user group or user type. This determines what permissions the new user will have on the system. Please make sure this is correct. If a user has more than one group, enter the main group for the training, and then update the details on line afterwards. ==Submitting the spreadsheet== Once all new users have been entered, save the Template spreadsheet again on your hard disk. You can then email it to iSIKHNAS. # If you have an email client installed (like MS Outlook, Thunderbird or Eudora), you can send the spreadsheet from within MS Excel ## Click on the File tab ## Click '''Save and Send''' ## Click '''Send as Attachment''' # A new email compose window will open with the spreadsheet already attached # If you use a web-mail interface (e.g. Gmail) ## Open the mail interface in a web browser ## Create a new message (the link may be called 'Compose') ## Find the option to add an attachment (it may be a paperclip symbol and click '''Add''' ## Browse for the directory where you saved the Template spreadsheet ## Select the Template spreadsheet only (DO NOT send the Reference spreadsheet) # Enter the address for the email: data@isikhnas.com # The subject line can be blank # The body of the email can be blank # Send the message You should then get a reply in a few moments indicating if the data was correctly submitted. ==Errors== If there were errors in your spreadsheet, this will be noted in the reply. None of the data will be submitted until all the errors are fixed. # Check the email that has been returned and read the message # Open the attached spreadsheet. Any errors will be highlighted in yellow. # Point to the yellow cell with your mouse, and a message explaining the error will pop up. # Correct the problem, and send the spreadsheet again. ==Conclusion== Once the data has been successfully submitted, all users will be immediately registered, on both the live and training systems, and will be able to start using the system for the training course or for real data submission.