https://owl.unipharm.com/mediawiki/index.php?action=history&feed=atom&title=Information_Systems%3ASales_Reporting_to_IMS 2026-09-01T11:31:28Z Revision history for this page on the wiki MediaWiki 1.35.4 https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Sales_Reporting_to_IMS&diff=447&oldid=prev 2015-10-15T21:13:06Z

<p>Created page with &quot;According to their website (www.imshealth.com), “IMS Health is the world’s leading information, services and technology company dedicated to making healthcare perform bett...&quot;</p> <p><b>New page</b></p><div>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.<br /> <br /> “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.<br /> <br /> “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.<br /> <br /> “Customers include pharmaceutical, medical device and consumer health manufacturers and distributors, providers, payers, government agencies, policymakers, researchers and the financial community.”<br /> <br /> 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.<br /> <br /> ‘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. <br /> <br /> Go to Unity / Start uniPHARM Extensions / VA Company (PRODUCTION) / Work with UWD IT Tools / FTP Connections / IMS (TSAdump) FTP Config.<br /> <br /> WORK WITH DATA IN A FILE Mode . . . . : CHANGE <br /> Format . . . . : TSACONFR File . . . . : TSACONFP <br /> <br /> *RECNBR: 1 <br /> FTP Server: 'ftp.ims-canada.com' <br /> FTP User ID: unipharm <br /> FTP Password: winter+s1 <br /> FTP Directory: __________________ <br /> Prt FTP Logs: Y <br /> Errors MSGQ: __________ <br /> Errors MSGQ Lib: __________ <br /> <br /> <br /> F3=Exit F5=Refresh F6=Select format <br /> F9=Insert F10=Entry F11=Change <br /> <br /> Note the quotation marks around the FTP Server’s name - they are necessary because of the dash. <br /> <br /> 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.<br /> <br /> Work with All Spooled Files <br /> <br /> Type options, press Enter. <br /> 1=Send 2=Change 3=Hold 4=Delete 5=Display 6=Release 7=Messages <br /> 8=Attributes 9=Work with printing status <br /> <br /> Creation Creation <br /> Opt File User Form Type Pty Date Time <br /> _ QPQUPRFIL IMSTSA *STD 5 09/04/14 14:07:53 <br /> _ QPQUPRFIL IMSTSA *STD 5 10/01/14 09:54:38 <br /> _ QPQUPRFIL IMSTSA *STD 5 10/08/14 11:48:25 <br /> _ QPQUPRFIL IMSTSA *STD 5 11/01/14 04:47:28 <br /> 5 QPQUPRFIL IMSTSA *STD 5 12/01/14 07:10:01 <br /> <br /> Parameters for options 1, 2, 3 or command <br /> ===&gt; _________________________________________ <br /> F3=Exit F10=View 1 F11=View 3 F12=Cancel F22=Printers F24=More keys <br /> <br /> Use Option 5-Display to see the log.<br /> <br /> Display Spooled File <br /> File . . . . . : QPQUPRFIL Page/Line 1/6 <br /> Control . . . . . Columns 1 - 80 <br /> Find . . . . . . <br /> *...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8 <br /> 12/01/14 07:10:02 FTP Output Log PAGE 1 <br /> Output redirected to a file. <br /> Input read from specified override file. <br /> Connecting to host ftp.ims-canada.com at address 162.44.221.67 using port 21. <br /> 220 Microsoft FTP Service <br /> Enter login ID (imstsa): <br /> A single ' not permitted within a parameter enclosed by the same delimiter. <br /> Enter an FTP subcommand. <br /> &gt; user unipharm ********* <br /> 331 Password required for unipharm. <br /> 230-***************************** * Welcome To The EDT Server * <br /> ***************************** <br /> 230 User logged in. <br /> Windows_NT <br /> Enter an FTP subcommand. <br /> &gt; put qtemp/tsadump UnipharmNov14 <br /> 200 PORT command successful. <br /> 150 Opening ASCII mode data connection. <br /> 226 Transfer complete. <br /> 32712363 bytes transferred in 58.624 seconds. Transfer rate 558.003 KB/sec. <br /> Enter an FTP subcommand. <br /> &gt; quit <br /> 221 Bye ! <br /> * * * E N D O F R E P O R T * * * <br /> <br /> 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.<br /> <br /> ==Contacts==<br /> <br /> Leslie Martinez<br /> Production Analyst, GTSO<br /> IMS Health<br /> Av. Del Valle 869 – Of. 102<br /> Santiago, Postal Code 8580000, Chile.<br /> <br /> Phone: +56 2 368 0781<br /> Email: martinezl@cl.imshealth.com<br /> <br /> Linda Curwell<br /> Manager, Supplier Quality Management<br /> IMS Brogan, a Unit of IMS Health<br /> 1670 Trans-Canada Highway<br /> Kirkland, QC H9H 5M5<br /> <br /> Phone: 514 428 6081<br /> Cell: 514 824 9586<br /> Fax: 514 428 6259<br /> Email: lcurwell@ca.imsbrogan.com</div>

Sheilav