File 2 is rather special in that there is a LOT of code and other constraints built into the DD. My recommendation would be to create an entirely new file for the purpose of uploading your data. Once the data is in Fileman, you can write your own code to set up the new patients (or update existing ones, as the case may be).
===
Gregory Woodhouse
[EMAIL PROTECTED]

"It is a capital mistake to theorize before one has data."
--Sir Arthur Conan Doyle



On Jun 14, 2005, at 11:59 PM, Usha wrote:

The file "/home/vista/VistA/patmast.txt" has the patient's data to import.

S CONTROL("FLAGS")="E"
S FIELDS=".01;.02;.09;.03;391;459022;.301;1901;.111;.115"
S SOURCE("FILE")="patmast.txt",SOURCE("PATH")="/home/vista/VistA"
D FILE^DDMP(2,.FIELDS,.CONTROL,.SOURCE,"EXCEL (TAB)")

This is the value of ^TMP global after running the import command is (when
$J=5721)

139) ^TMP("DIERR",5721,1) = 1810
140) ^TMP("DIERR",5721,1,"PARAM",0) = 1
141) ^TMP("DIERR",5721,1,"PARAM",1) = patmast.txt
142) ^TMP("DIERR",5721,1,"TEXT",1) = The data from host file 'patmast.txt' = could not be moved into a FileMan file.
143) ^TMP("DIERR",5721,"E",1810,1) =

The file's access rights are 644 and the owner is vista. Does anyone have an
idea of what the problem might be?

Regards
Usha


----- Original Message -----
From: "Gregory Woodhouse" <[EMAIL PROTECTED]>
To: <hardhats-members@lists.sourceforge.net>
Sent: Wednesday, June 15, 2005 9:18 AM
Subject: Re: [Hardhats-members] Does not ask DEVICE while exporting



Did you select Excel (tab) as your format? The import/export tools
should work with this format, but you need to specify that it is the
one you want.
===
Gregory Woodhouse
[EMAIL PROTECTED]

Better. Faster. Cheaper. Pick two.


On Jun 14, 2005, at 8:41 PM, Usha wrote:


You hit the nail on the thumb...

I have to import the data of the patients from an excel file. I
tried to
bring the data in excel to EXCEL (TAB) format, but it does not
accept that
file. So I tried to export data from patient file to get an idea of
the
format of file required by VistA. And by doing the steps in
previous mails,
I have succeeded in doing so.

Now I have to see how to import data into VistA using the exported
format.

Regards
Usha




-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members






-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members




-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members

Reply via email to