ASIARS-Net Tutorial

Procedure for Creating Antimicrobial
Resistance Reports by ASIARS-Net
Antimicrobial Resistance Research Center
National Institute of Infectious Diseases, Japan

This tutorial includes the following sections.
Part 1. Create an ASIARS-Net data file
Part 2. Login a website and download a compression toolPart 3. Create a zip file to be submitted to ASIARS-Net
Part 4. Bulk upload of ASIARS-Net data zip file
Part 5. Check submitted data
Part 6. Download a report of each facility
Part 7. Create a national & feedback report
Part 8. Create data for WHO GLASSPart 9. Change definition settings
Part 10. Delete data
Part 11. Download Surveillance materials
Part 12. Change password
Part 13. Enter the number of patients directly
Part 14. Tool for bulk downloading feedback CSVPart 15. Account settingThis tutorial shows how to convert the original file to an ASIARS-Net data file, upload theASIARS-Net data file, and get the results of data analysis.

Mandatory items of data

Basic Patient Data

Data
Requirements

All required fields must be filled out.
(Mandatory items*）．
If there are empty fields, ASIARS-Net cannot
create the file.

Attribute

Length*Starting
Locationnumeric

1

1

6: international surveillance

Assigned institutional code
Encrypted unique ID using 30 singlebyte characters

Specification

M

1M

2

numeric

52

M

3Patient ID

alphanumeric/symbol

30

7

S

4
5BlankSex

spacealphabet

8
1

37
45

S

6

Date of Birthnumeric

846

YYYY: year, MM: month, DD: dayM

7

Hospital Status

numeric

154

1: Outpatient, 2: Inpatient, 3: Unknown

S

8

Department

numeric

355

Refer to "Department Code"

S

9Ward

alphanumeric

1558

Free-text format (alphanumeric only)

10Blank

space

409

73

11

Specimen Source

numeric

3482

Refer to "Specimen Source Code"12

Specimen
Reception Datenumeric

8485

YYYY: year, MM: month, DD: day

13

SpecimenCollection Datenumeric

8493

YYYY: year, MM: month, DD: day

S
M

14
S

15(M)

16

Blank
Bacterial Culture
ResultIsolated
Bacterium "A"

(S)

17

Quantification ofBacterial Amount(S)18Amount of
Bacterium "A"19

Bacterial Test Data

Item
Surveillance
Category
Facility CodeM

Specimen Data

No.

(M)

20(M)

24(M)

28(M)

32Blank
Isolated
Bacterium "B"
IsolatedBacterium "C"
Isolated
Bacterium "D"
Isolated
Bacterium "E"

M: Male, F: Female

Mandatory items*Patient_ID*WARD TYPE
(outpatient or inpatient)*SPEC_DATE(Specimen collection date)*SPEC_TYPE(Specimen Source)*SPEC_NUM(Specimen ID)

space

13501

1 or space1514

1: negative, space: positive

numeric

4515

Refer to "Isolated Bacterial Code"numeric1519

1: semi-quantitative analysis, 2:quantitative analysis, 9: others

numeric1520

1: ≤10^2/ml, 2: 10^3/ml, 3: 10^4/ml, 4:10^5/ml, 5: 10^6/ml,6: ≥10^7/ml, 7: 10^3 - 10^4/ml, 8:10^5 - 10^6/ml

space

1521

numeric

7522

numeric

7529

numeric

7536

numeric

7543

numeric

4550

Refer to "Antimicrobial Code"

2554

Refer to "Susceptibility Test Method
Code"

(M)

36

A-1 AntimicrobialAgent

(M)

37

A-1 Susceptibility
Test Method

numeric(M)

38

A-1 Sign

numeric or space1556

1: <, 2: >, 3: ≤, 4: ≥, space: =(M)39

A-1 MIC Value

numeric/period

5557

XXXXX (right-adjusted integer) or X.XXX(fixed decimal point format)(S)

40A-1 Zone
Diameter

numeric

2562

XX (millimeters in integer)

(M)

41

A-1 Interpretation(RIS)

alphabet1564

R: resistant, I: intermediate, S:susceptible, N: non-susceptible

(M)

42

A-1 Interpretation(+)

numeric

1565

1: -, 2: +, 3: ++, 4: +++

(M)
(M)
(M)
(M)
(M)

43
386
736
1086
1436

A-2 to A-50
B
C
D
E

Data format

784
800
800
800
800

566
1350
2150
2950
3750

Part 1. Create an ASIARS-Net data file

1. Create an ASIARS-Net file from WHONET data file
2. Create an ASIARS-Net file from an Excel data filePart 1-1. Create an ASIARS-Net data file from WHONET data file
You have to create a WHONET data file from your original data file using
BacLink beforehand. If you want to know further, please access this link.
1. Select the laboratory name and press.

2. Click“Open laboratory”.

3. At the top of the screen, you will see the main “Data entry” menu.
To create a ASIARS-Net file, select “Combine or export data files”.

1. Put your WHONET data in data files.
(You can put multiple files.)

2. Save as type : Select “JANIS”
4. Click “Browse” andname a new file andchoose where to save it.

3. Uncheck all checkboxes.
(If you need the options (e.g. encryption),
please check the boxes.)
If you check “use a date filter”,
please select Month and Year.

5. Click “Combine”.
You can get ASIARS-Net converted file.

You will now have a new ASIARS-Net data file.

Part 1-2. Create an ASIARS-Net data file from an Excel data file

5 simple steps
1. Import an Excel file containing surveillance data
2. Make "mapping template"
3. Expand "mapping template" to the other sheets
4. Output the result of mapping
5. Convert input data into an ASIARS-Net format text file

1. Import an Excel file containing surveillance data.

Click [Browse] and select an Excel file

2. Make "mapping template"
1. Click this button to create dropdown lists in “Format sheet”
5. Convert input data into ASIARS-Net format file

2. Click “Format” tab

3. Select an item of “Mapping” column corresponding to
the item in your Excel file

4. Click this button to keep yourmapping on “Mapping_data”
folder.

3. Expand "mapping template“ to the other sheet
1. Click this button to do mapping in all theother sheets (Hospital, Bacterium,Antimicrobial, Department, Specimen)
Select an item of “Mapping” column
corresponding to the item in your Excel file.
2. Open these tabs

e.g. In “Bacterium” tabBacteria name in yourinput file
3. Please repeat mapping in the remaining sheets.

Select a name (code)
defined in JANIS

4. Output the result of mapping
1. Click this button

2. [Mapping Date] folder is written again to store mapping you did5. Convert input data into an ASIARS-Net format text file
5. Convert input data into ASIARS-Net format file

1. Click this button

2. [CSV] and [txt] files are created next to the “Mapping Data” folder.

Part 2. Login a website and download a compression tool
Access the following URL：
https://www.asiars-net.jp/eng/admin/
1. Login by entering Country code, Administrator ID,and Password.
2. Click“Submit data(Bulk upload)”.
3. Firstly, please download a “Compress WithValidation” zip folder by clicking ”tool “Records of submitted data are displayed.

Unzip a downloaded “Compress With Validation” zip folder
Downloaded “Compress With Validation” zip folder.
Please unzip “Compress With Validation”
folder using decompression software

Part 3. Create a zip file to be submitted to ASIARS-Net
1. Drug and drop your ASIARS-Net converted file (test181228.txt) on “compress ”.

2. A file name of the target file is displayed.

5. You can create a zip file tobe submitted to ASIARS-Net.
3. Input “（country code）”
and press “Enter”.

4. Please press any key

Part 4. Bulk upload of ASIARS-Net data zip file

1. Click“Submit data(Bulk upload)”.

2. If you have not downloaded “Compress WithValidation” zip folder before, please download it here.

If a PDF report is needed,
please uncheck the first box.
4. Click “ Send”.

3. Drug and drop the zip file into
the “file name” box.
Then monthly feedback reports to each hospital will be created within 24 hours.

If the submitted data have any problems, error messages willbe displayed.

After clicking “Send” icon, you will see
this message.
If there are any problems, error
messages will be displayed as below.
<Examples of displayed error messages>
・Please select the file to be uploaded.
・We accept only zip file on this page.
・There is a possibility that the zip file is broken.
・There is a possibility that the file is broken.
・It does not include a text file in the file.
・There are different in length record.
・There is a record that the country code has not been .
・Format of country code there is a record that has been set a code of fraud or another country.
・There is a record that specimen collection date has not been input.
・There is a bad record format of specimen collection date (YYYYMM).
・There is a record where the facility code has not been input.
・There is a bad record format of the facility code.

Part 5. Check submitted data

1. Click“List of submission”.

2. To find a facility, enter facility codes of the target facilities.

3. Select a year.

4. Click “Search”.

Selected facilities are displayed.

5. Click “Code” of the target facility.

About “Feedback information”, move to a next slide.
6. Click the number of errors, warnings and alerts.

7. The details of errors, warnings and alerts are displayed.
Review the data, correct these problems, and resubmit the data.

Part 6. Download a report of each facility
1. After clicking “Feedback information”, “Download feedback information” appears.

2. Monthly report is automaticallycreated within 24 hours after datasubmission.
If you click “Monthly Data”,
a csv file is downloaded.

3. If all months data are uploaded,please click “Annual report”
to get an annual report.

Part 7. Create a national ＆ feedback report
2. Select a report type.

1. Click “Create a national &feedback reports”.
3. Click “Tabulation”.

National & feedback reports will be created within 24 hours.

If a national report is created, please check it.

2. There are 3 types of annual reports (quarter-annual, semi-annual, annual).
Click the period you want to check.
1. Click “National report”.

3. Inpatient / outpatient / all sample reports are downloadable.

Part 8. Create data for WHO GLASS

1. Click“Create data for WHO GLASS”.

2. Select a Year.

3. Click “Create”.
4. Click “OK”.

5. Download data for GLASS byclicking "Download“.

Part 9. Change definition settings

1. Click “Definition”.

2. You can change thedefinition of de-duplication
to count patients andisolates.

3. Click “Change definition”.

Part 10. Delete data
3. Click “Delete” of the month including
data you want to delete.
1. Click“Delete data”.

2. Click the facility
code including data
you want to delete.

5. Wait for a while during deletion.

6. After deletion is completed, you can resubmit data.

4. Click “OK”.

Part 11 . Download Surveillance materials
Click“Download
Surveillance materials”.

Part 12. Change password

2. Please enter the old password.

3. Please enter the new password.
4. Please click “Submit”.

1.Click“Change Password”.

Part 13 . Enter the number of patients directly
1. Click “List of submission”

3. Click “Update No. of patients”

2. If you can get the number of patients
including both those with and withoutbacteria, please enter it directly to thecolumn.

Part 14. Tool for bulk downloading feedback CSV
If you want to check CSV file data, please make use of this tool.
2. Login by entering
Country code,
Administrator ID,Password.

1. Click “Tool for
downloading feedback CSV”.

3. Press “login”.

4. Choose “Period”,“Inpatient or outpatient”,
and “Record to beextracted” based on yourpreferences.

5. Press “Execute”.
Extracted data are displayed.

Part 15. Account setting

Click “Account setting”.

Click “Save” after setting up an account.