I am not an expert, by any means...on this particular topic. First...if you need a .CSV (comma separated values) formatted file...saving your data files (per the sales rep for program#1) as 'tab delimited text files' (.TSV...tab separated values) will not work. Program#2 is expecting to see the data separated by a comma...not a tab.
Not having Program#1 and Program#2 names, not knowing anything about how Program#1 saves it's data files... or how Program#2 expects the position of data in the .csv file to be...the suggestion below is a "blind" suggestion so to speak.
I would suggest you (experiment) take one of your (program#1) data files and save it as a .csv file.
If you can do a "Save As" function in program#1..then save the file (for example) as data.csv
. If program#1 usually saves the file as (for example) data.p1f
(Program 1 file) and ends up saving your data.csv
file as data.csv.p1f
(automatically adding it's own file extension as part of the name...then when you save the .csv file... do the Save As function and enclose the file name in quotes
...this should prevent program#1 appending it's own extension onto the file name.
Then once you have your file data.csv ... try to open it. If you get the window , asking what program you want to use to open the file...select Notepad or Wordpad...any vanilla text file editor and look at the file contents...
Are the values separated by commas? Does the data itself look correct? Meaning did any of the original data have commas in it that may have been interpreted as a separator?
There are plenty of places you can look online for .CSV file format and the various ways to handle special data... Google search... " .csv files"
Again...not knowing the particulars about the 2 programs... you would have to see if (when you create a .csv file) the position of the data is what Program#2 is expecting.
Program#1 data = Patient First name, Patient Middle Initial, Patient Last Name
Program#2 expects = Patient Last Name, Patient First Name, Patient Middle Initial
Will you be able to send a "test" file to Program#2...to see if it has been interpreted correctly?
Just throwing out some thoughts...I hope this helps.
Edited by Wing Man, 18 September 2008 - 08:55 AM.