1 / 37

Tutorial upload data

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. content. Save excel file as .csv file Export access table as .csv file Upload data file to database

gates
Download Presentation

Tutorial upload data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related