For instances where you have to convert data that you have downloaded from Wisenet as an Excel file to a Flat file, follow the steps below.
1
- Navigate to HEIMSHELP > Provider Information Request
- Click on the Reporting your data Tab and Click to expand How to create a HEPCAT data file from an Excel spreadsheet
- Click to download and save the PIR Microsoft Excel to Flat File Template XLSX
2
- Open Microsoft Excel
- Under Menu, Select File > Open
- Navigate to the System Folder where your Wisenet Data has been exported to
- Select the spreadsheet which contains the data being converted
- Click Open
3
- Once the spreadsheet has successfully opened, highlight all data records
- Right-Click the highlighted data records and Click Copy
4
- Once again from Microsoft Excel, under Menu, select File > Open
- Navigate to the system folder where the PIR Microsoft Excel to Flat File Template has been saved, Select and Open
3. Locate and Click the relevant Tab
4. Select Cell B2 and paste, using Crtl V (for Windows keyboard) or Cmd V (for Mac Keyboard)
Click image to enlarge
5
- Once all data records have been successfully pasted, highlight all records in Column A
- Then Right-Click the highlighted data records and Click Copy
3. Open Notepad and paste the previosuly copied data records (using Crtl V or Cmd V)
4. From the Menu, Select File > Save As
5. Navigate to the system folder where the Sample HEPCAT Flat Files have been saved and select the appropriate sample
6. Update the File Name by replacing 9998 with your organiation number and removing the .txt extension
7. Click Save
Click image to enlarge