Does that work with the NEW versions of Datapage or is that for the OLD versions?
DP+ 3.33 with versions 3.2063, 3.7mr?, 4.1 (but we don't use that version). You do have to create a database for each part in said directories. I create separate ones so all our data isn't lumped into one.
We had a bunch of problems trying to save to the network. Hexagon said we had too many restrictions, our IT people said we had full admin rights. It was a lot of trial and error.
Everything Hexagon tried didn't work. The only way we got it to work was to use stats on, offline yes, xmlstats command on to a folder on the computer and use the data importer to move the xml files form the computer to the database on our network.
We had datapage 5.0 installed on the same computer as our offline seat. Just make sure datapage can access the database. Data importer is a free download form hexagon. You can set it to auto import data what a set frequency, 1 min, 2 hours, etc. The only draw back is that when they restart the computer on the cmm ( for whatever reason) the data importer is turned off and much be turned back on. I started checking it every morning as I come into work. Either way all the files are still be stored on the computer until the data importer send them.
I was fortunate enough that my IT dude is very smart. He actually spent many hours for many days speaking with Hexagon Support troubleshooting our network.
Code I use:
STATS/ON,DATAPAGE+,,OFFLINE=YES
RECORD=DIMENSION,TRACE,COMMENT,ALIGNMENT,FEATURE,HIT,
XMLSTATS/ON,C:\Users\Public\Documents\WAI\PC-DMIS\2015.0\ (this creates the xml file and stores in on the cmm computer) (have the data importer check this folder at a set frequency and send it to the database on the network)(make sure datapage is connected to this database)
We had a bunch of problems trying to save to the network. Hexagon said we had too many restrictions, our IT people said we had full admin rights. It was a lot of trial and error.
Everything Hexagon tried didn't work. The only way we got it to work was to use stats on, offline yes, xmlstats command on to a folder on the computer and use the data importer to move the xml files form the computer to the database on our network.
We had datapage 5.0 installed on the same computer as our offline seat. Just make sure datapage can access the database. Data importer is a free download form hexagon. You can set it to auto import data what a set frequency, 1 min, 2 hours, etc. The only draw back is that when they restart the computer on the cmm ( for whatever reason) the data importer is turned off and much be turned back on. I started checking it every morning as I come into work. Either way all the files are still be stored on the computer until the data importer send them.
I was fortunate enough that my IT dude is very smart. He actually spent many hours for many days speaking with Hexagon Support troubleshooting our network.
Code I use:
STATS/ON,DATAPAGE+,,OFFLINE=YES RECORD=DIMENSION,TRACE,COMMENT,ALIGNMENT,FEATURE,HIT, XMLSTATS/ON,C:\Users\Public\Documents\WAI\PC-DMIS\2015.0\ (this creates the xml file and stores in on the cmm computer) (have the data importer check this folder at a set frequency and send it to the database on the network)(make sure datapage is connected to this database)
Again this is the only way it worked. Good Luck.
If you're using XML files and data importer, try this instead:
At the end of the program, Insert>External Command>DataPageStats.exe (this is found in your DataPage installation folder). This doesn't require the use of STATS/ON, and all of that other nonsense, (for clarity's sake, this means the ONLY DataPage related thing you put in your program is the external command at the end). You will only need to change where the Importer looks for the XML files.
The DataPageStats.exe sends the XML files (by default) to C:\Users\Username\AppData\Roaming\DataPage+ (you will need to have "Show hidden files or folders" enabled).
If you're using XML files and data importer, try this instead:
At the end of the program, Insert>External Command>DataPageStats.exe (this is found in your DataPage installation folder). This doesn't require the use of STATS/ON, and all of that other nonsense, (for clarity's sake, this means the ONLY DataPage related thing you put in your program is the external command at the end). You will only need to change where the Importer looks for the XML files.
The DataPageStats.exe sends the XML files (by default) to C:\Users\Username\AppData\Roaming\DataPage+ (you will need to have "Show hidden files or folders" enabled).
Thanks for the tip, not too concern for clarity, we just needed it to work.
The IT guy should install SQL Express on the server, you can then use the external command as previously stated and the Data importer to send it to the SQL.
For info, you can use the external command at the start of the program (or start of dimensions) using -l (listening) after the .exe, then use another command at the end of the program with -e (end), this way it sends the data as it sees it rather than in one chunk at the end. Can be useful if you have long running programs which do not play up!.
so to clarify: Datapagestats.exe -l (beginning) and Datapagestats.exe -e (end)
First you need a SQL server at least to the revision that Datapage is using and it cannot be lower. So if you're Datapage is running SQL 2008R2, than your SQL server needs to be at least SQL 2008R2 or greater. It does not matter if you are running SQL express or a fully licensed version of SQL. If you are installing a version of SQL Express on a virtual machine then it can be the only instance of SQL on that virtual machine, ports cannot be shared between the same computer.
You then will need to create a database on your Datapage machine and then disconnect it from the SQL server either by killing the process (not preferred) or by using SQL server management studio (SSMS is the preferred method). After you kill the process or disconnect it then you can move or copy this file to another location without VSS giving you issues. Once this database is created and saved to another area you can give that to your IT professional to attach to the SQL server where you wish to host your database. Your IT professional will then be required to attach this file to the database through SSMS.
At this point your SQL server should be visible on the network and you should be able to create a database connection string through data importer or if you wish to use the stats/on command you will need to create an ODBC data source for each user of the computer that intends to use the machine with the same name for each user. if your ODBC data source name that you create is not an exact match for the name of the database you use in your stats on command it will not work.
I do this all of the time and it's rarely ever easy. Unless your IT professional is relatively decent with SQL you're not going to have much luck.
