web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Exporting PVs
Microsoft Dynamics SL (Archived)

Exporting PVs

(0) ShareShare
ReportReport
Posted on by Bruce.T 459

Hi,

We are upgrading from SL7 to SL2015 and want to review the existing modified PV's to determine if these still required. We know the PVRec table contains all the PV names but doesn't appear to contain the PV statements.

Does anyone know a way to export PVs or obtain the content of the PVs?

Bruce

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mark E Profile Picture
    Mark E 6,451 on at

    Here's what I do.  Find the pvrec.csv file in your installation in the DB/csvs folder (hopefully, it has not been modified).  Run a "select * from pvrec" SQL statement from the SL7 Production System DB, then copy contents (maybe up to 500 rows at a time) to the following URL (ttdsinc.com/.../index.jsp), which will convert to .csv format.  Copy results to Notepad and save as .csv file.  Repeat until you have all the rows converted.  Then, use a tool like ExamDiff (www.prestosoft.com/edp_download.asp) to compare the two .csv files to see where the differences are.

    If the standard PVRec file has been modified (check the file date), then get the original from your SL7 CD.

    As a best practice, never modify the original pvrec.csv file.  Always keep any custom pvrec modifications in a separate .csv file to use for future reference, upgrades, re-installations, etc.

  • Bruce.T Profile Picture
    Bruce.T 459 on at

    Thanks this is exactly what we needed.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans