Information Systems:Sales Reporting to IMS
According to their website (www.imshealth.com), “IMS Health is the world’s leading information, services and technology company dedicated to making healthcare perform better.
“By applying cutting-edge analytics and proprietary application suites hosted on the IMS One intelligent cloud, the company connects more than 10 petabytes of complex healthcare data on diseases, treatments, costs and outcomes to enable our clients to run their operations more efficiently.
“Drawing on information from 100,000 suppliers, and on insights from more than 45+ billion healthcare transactions processed annually, IMS Health’s approximately 10,000 professionals drive results for over 5,000 healthcare clients globally.
“Customers include pharmaceutical, medical device and consumer health manufacturers and distributors, providers, payers, government agencies, policymakers, researchers and the financial community.”
On the first of every month, we send them a file of our sales for the previous month, and information on our customers, vendors, and items. About 2 million of the ‘45+ billion per year healthcare transactions processed annually’ are from us.
‘TSADUMPA’ (TSA is an acronym IMS uses for their transactions) is called by the end of month processing. It uses query to pull out the data, then consolidates everything into one file, which is FTP’ed to IMS.
Go to Unity / Start uniPHARM Extensions / VA Company (PRODUCTION) / Work with UWD IT Tools / FTP Connections / IMS (TSAdump) FTP Config.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : TSACONFR File . . . . : TSACONFP
*RECNBR: 1
FTP Server: 'ftp.ims-canada.com'
FTP User ID: unipharm
FTP Password: winter+s1
FTP Directory: __________________
Prt FTP Logs: Y
Errors MSGQ: __________
Errors MSGQ Lib: __________
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Note the quotation marks around the FTP Server’s name - they are necessary because of the dash.
Because ‘Prt FTP Logs’ is ‘Y’, we can go back to the uniPHARM It Tools menu, and then select FTP Logs / IMS (TSAdump) FTP Logs. Press F11 to see the creation date and time.
Work with All Spooled Files
Type options, press Enter.
1=Send 2=Change 3=Hold 4=Delete 5=Display 6=Release 7=Messages
8=Attributes 9=Work with printing status
Creation Creation
Opt File User Form Type Pty Date Time
_ QPQUPRFIL IMSTSA *STD 5 09/04/14 14:07:53
_ QPQUPRFIL IMSTSA *STD 5 10/01/14 09:54:38
_ QPQUPRFIL IMSTSA *STD 5 10/08/14 11:48:25
_ QPQUPRFIL IMSTSA *STD 5 11/01/14 04:47:28
5 QPQUPRFIL IMSTSA *STD 5 12/01/14 07:10:01
Parameters for options 1, 2, 3 or command
===> _________________________________________
F3=Exit F10=View 1 F11=View 3 F12=Cancel F22=Printers F24=More keys
Use Option 5-Display to see the log.
Display Spooled File
File . . . . . : QPQUPRFIL Page/Line 1/6
Control . . . . . Columns 1 - 80
Find . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
12/01/14 07:10:02 FTP Output Log PAGE 1
Output redirected to a file.
Input read from specified override file.
Connecting to host ftp.ims-canada.com at address 162.44.221.67 using port 21.
220 Microsoft FTP Service
Enter login ID (imstsa):
A single ' not permitted within a parameter enclosed by the same delimiter.
Enter an FTP subcommand.
> user unipharm *********
331 Password required for unipharm.
230-***************************** * Welcome To The EDT Server *
*****************************
230 User logged in.
Windows_NT
Enter an FTP subcommand.
> put qtemp/tsadump UnipharmNov14
200 PORT command successful.
150 Opening ASCII mode data connection.
226 Transfer complete.
32712363 bytes transferred in 58.624 seconds. Transfer rate 558.003 KB/sec.
Enter an FTP subcommand.
> quit
221 Bye !
* * * E N D O F R E P O R T * * *
We get the message “A single ' not permitted within a parameter enclosed by the same delimiter” because we have ‘ in the parameter, and the program puts a second set around it when it uses the server name. However, if it is not done this way, FTP doesn’t work.
Contacts
Leslie Martinez Production Analyst, GTSO IMS Health Av. Del Valle 869 – Of. 102 Santiago, Postal Code 8580000, Chile. Phone: +56 2 368 0781 Email: martinezl@cl.imshealth.com
Linda Curwell Manager, Supplier Quality Management IMS Brogan, a Unit of IMS Health 1670 Trans-Canada Highway Kirkland, QC H9H 5M5 Phone: 514 428 6081 Cell: 514 824 9586 Fax: 514 428 6259 Email: lcurwell@ca.imsbrogan.com