I assume you mean you tried to load the PI Excel Add-in on a DeltaV node? Why did this not work? (What errors did you get?)
In 2006, I wrote a batch file to perform this task (we didn't have the PI tools).
The principle is to
1. Create a piconfig commandfile.
2. Run piconfig with the commandfile as input.
3. Return a .csv as output.
The command file should look like this:
@prom n
@table piarc
@mode list
@istru tag, starttime, endtime, count, mode
@output %Out%
@echo data
@ostru value, status, time, tag
@ostru ...
%Tag%, "%Startdate% %Starttime%", "%Enddate% %Endtime%", %Count%, %Mode%
@exit
where
%Out% = Output file path/name (remove quotes)
%Tag% = tagname
%Startdate% = starting date formatted correctly
%Starttime% = starting time formatted correctly
%Enddate% = Ending date formatted correctly
%Endtime% = Ending time formatted correctly
%Count% = maximum number of expected records
%Mode%= retrieval mode, I suggest Comp
Then run piconfig through batch script on your historian, using the command file as input.:
piconfig -remote -node %NodeName% -port 5450 -username %Username%<%InputFile%
%NodeName% = PI historian name
%Username% = PI User
%InputFile% = Command File Name
I would refer to the PIConfig documentation for specifics. The output file should list the record fields as comma-separated values per the ostru.
In reply to Youssef.El-Bahtimy: