Hi all,
Here's the thing. A few years ago I did a trawl through all our gINT projects to pull out a list of all projects / Points that had National Grid co-ords. This was done on a text table report, key set to Project?. Upon output, I seem to remember that I could point gINT at a folder on my HD and either that was eonugh and gINT would load all the projects in the folder (by load I mean work through) or I selected all the projects in the folder.
Someone asked a question about doing that type of thing on here recently and I explained about how I used to do it (bearing in mind I last did this a good few years ago). The person has emailed me asking if they need to populate the multi-project tab list with each individual file or was there another way. I thought they were doing something wrong, so I hunted out the old Text Table report and ran it, only to be presented with a project manager window to choose all the projects from. Obviously the Project Manager holds only a tiny proportion of our thousands on gINT projects. Needless to say, this is about as much use as a chocolate Tea Pot. By the time I've added every single project from the folder to the Project Manager I could have opened up most of the projects manually and exported the data bit at a time.
My question is, is there a way of pre-populating the Project Manager (don't think so) or is there a way of using the "old" (for old, see the word "better") method of pointing gINT at a whole folder full of files and bypassing the project manager?
Miles
HiMiles
Perhaps use a multi prcocess script, but first you'd need to make a list of the full path-name of each project. The script could be created using excel formulas, with some effort.
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
Scripting is the way to go, though definitely not in Excel. Use VBScript or Powershell to automate the process of extracting the data from gINT projects in folders (it can be made to run in sub-folders as well), then output to a single CSV.
Hi Tony - have you developed any Powershell scripts to do this? and would you be willing to share them or have any suggestions where to look online for info/tutorial? Thanks!
--I have seen ways to access Access DB w/Powershell, but am more confused about hitting them all at once in a folder and the output to .csv part...
Yes I've developed both VB and Powershell scripts, but you'll understand that because they can save clients considerable amounts of time and money they are of commercial value, so I don't want to share them. All the info is out there on the web, just not in one place.
Ah - gotcha - thanks for getting back to me though.