Tutorial upload data

1. Tutorial upload data November 2013 Rue Juliette Wytsmanstraat 14 | 1050 Brussels | Belgium T +32 2 642 51 11 | F +32 2 642 54 10 | email: info@iph.fgov.be | http://www.iph.fgov.be

2. content • Save excel file as .csv file • Export access table as .csv file • Upload data file to database • Trouble shooting – solving error messages.

3. Starting from .xls file

4. Open .xls file Right click on .xls file → select ‘Open’

5. View of Excel file

6. To save excel file as .csv file select ‘File’ → ‘Save As’

7. CSV (Comma delimited) (*.csv) In ‘Save As’ dialog box → select in ‘Save as type’ : ‘CSV (Comma delimited) (*.csv) → Save

8. To check the .csv file Right click on .csv file → select ‘Open With’ → ‘Choose Program’

9. To check the .csv file In ‘Open With’ dialog box → select ‘Notepad’ → OK

10. View of .csv file

11. To open .csv file in excel Right click on .csv file → select ‘Open With’ → ‘Microsoft Office Excel’

12. content • Save excel file as .csv file • Export access table as .csv file • Upload data file to database • Trouble shooting – solving error messages.

13. Starting from access database Right click on .xls file → select ‘Open’

14. View of access table

15. Create .csv file from access table Right click on .access table → select ‘Export’

16. Create .csv file from access table In ‘Export Table xxx As’ tabblad → select in ‘Save as type : ‘Text Files (*txt;*.csv;*.tab;*asc)’ →

17. Create .csv file from access table change in ‘File name’ .txt to .csv → Export

18. Create .csv file from access table In ‘Export Text Wizard’ tick ‘Delimited – Characters such as…’ → Next

19. Create .csv file from access table In ‘Export Text Wizard’ tick ‘Semicolon’ → tick ‘Include Field Names on First Row’ → Type “ in ‘Text Qualifier’ → Next

20. Create .csv file from access table In ‘Export Text Wizard’ → Finish

21. Create .csv file from access table In ‘Export Text Wizard’ → OK

22. content • Save excel file as .csv file • Export access table as .csv file • Upload data file to database • Trouble shooting – solving error messages.

23. To upload data to database Open Internet explorer → select website…. https://nrc.wiv-isp.be/

24. To upload data to database Open Internet explorer → select website…. https://nrc.acc.wiv-isp.be/ If security Alert → Yes

25. To upload data to database

26. Login with individual password enter your login and password → Continue In case of a problem try IPHWEB\login (for non IPH users) D_IPH\login (for IPH users)

27. Select file Select pathogen → Continue

28. To logout To upload new file To select new pathogen

29. In the upload interface In dictionary: discription of all fields, formats, range and possible coded values

30. In the upload interface In ‘Verification’ → Browse to your .csv file to upload

31. Select file In ‘Choose File to Upload’ → select the ‘.csv file’ → Open

32. In the upload interface → Validate

33. In the upload interface → Submit file if comment: Or….

34. In the upload interface if comment → modify excel file according to error messages to solve the errors

35. File correctly uploaded

36. content • Save excel file as .csv file • Export access table as .csv file • Upload data file to database • Trouble shooting – solving error messages.

37. Website in Google Chrome