Setup I have a VBScript for driving the stress testing of a web service. The script creates a data file of measurements, with each record timestamped with a general date/time: FormatDateTime(Now(), 0) This creates dates like mm/dd/yyyy hh:mm:ss [AM|PM] I need to import this data file into a MS-Access 2003 database. The table in th...
I have an application that uses MS SQL Server for which I'll need to do a bulk insert from a file. The sticking point is that the database and my application will be hosted on separate servers. What is the best way to do a bulk insert across a network? Two ideas I'd come up with so far: From the app server, share a directory that th...
I have an SVN repo at a hosted SVN service which I need to move to our locally hosted SVN service. The host offers an export feature, which I've used. But how do I take that exported file and import it into a new repository? EDIT I tried using svnadmin load, but got an error message: % svnadmin load . < ~/ss2_14066_rev36 svnadmin: Mal...
We have an existing TFS 2005 install and a newer 2008. The 2008 server already has some newer projects on it but I am looking to move the older projects from 2005 onto this newer server. Does anyone know an easy way to do this and maintain the audit history rather than just break source control on the project and then add it to the 2008...
When I add the following line to Google's helloworld example: from reportlab.pdfgen import canvas I get the following error: <type 'exceptions.ImportError'>: No module named reportlab.pdfgen I can get at the reportlab.pdfgen library from the python console. Why can't I get at it from google's dev_appserver? ...
On a Mac, I have a txt file with two columns, one being an autoincrement in an sqlite table: , "mytext1" , "mytext2" , "mytext3" When I try to import this file, I get a datatype mismatch error: .separator "," .import mytextfile.txt mytable How should the txt file be structured so that it uses the autoincrement? Also, how do I ente...
Hi, Basically I'm asking the same question as this guy: http://stackoverflow.com/questions/72852/how-to-do-relative-imports-in-python But no one gave him a correct answer. Given that you are inside a subfolder and you want to go up a directory and then into ANOTHER subfolder, doing what they suggested does not work (as the OP pointed o...
In SQL Server 2005, is there a way I can create a INSERT script from a table that has several rows? A lot of times, while developing, I need to drop the table and recreate it. I end up having to manually add the rows that existed before. I have used SELECT FOR XML AUTO before dropping the table but it still needs some manual intervention...
Hello friends, I need an urgent help on importing dll. In my Python script i m importing a dll written in vb .net. I m callng a function of initialisation in my script.It takes 2 arguments.One path of xml file and 2nd a string.It returns an integer ,0 for success ,else error.The second argument is passed by reference.So if ...
I need to import an excel spreadsheet into SQL Server 2005. What steps would I need to take to accomplish that? ...
Hi I'm having an issue when trying to import an existing export using stsadm. Having succesfully exported the site collection, I then create a new blank site. When I run the import command, it runs for a while, then completes with the following error: 01/28/2009 13:04:28.84 STSADM.EXE (0x3F54) 0x1D74 Windows Shar...
What is the best way to import/export data from a Apache Jackrabbit repository? Right now, I have a website based on a repository with over 100GB data in a server but I frequently need to take a subset of this data in my notebook for in-loco demonstrations. How can I do this in the easiest and fastest way? ...
Hi everyone! I am starting a project with asp.net visual studio 2008 / SQL 2000 (2005 in future) using c#. The tricky part for me is that the existing DB schema changes often and the import files columns will all have to me matched up with the existing db schema since they may not be one to one match on column names. (There is a lookup ...
Hi :) How does one import a dll into an Eclipse C++ project? ...
Hi, I'm new to python, so please excuse what is probably a pretty dumb question. Basically, I have a single global variable, called _debug, which is used to determine whether or not the script should output debugging information. My problem is, I can't set it in a different python script than the one that uses it. I have two scripts:...
Hi everyone, I'm working on my first significant Python project and I'm having trouble with scope issues and executing code in included files. Previously my experience is with PHP. What I would like to do is have one single file that sets up a number of configuration variables, which would then be used throughout the code. Also, I wan...
Im searching for a .Net component to read and write xls files from an application in working on. I dont want use automation with Excel. It should support reading and write Excel 97 and newer versions. And it would be great if its open source or free since its a very low budget project. I have found this one: MyXLS that looks very promi...
During our work as web developer for a meteorological company, we are faced with the same task over and over again: Get some files from somewhere (FTP/Web/directory/mail) and import the contained data to a database. Of course the file format is never the same, the databases are always designed differently, countless special cases have t...
Given a string of a Python class, e.g. 'my_package.my_module.MyClass', what is the best possible way to load it? In other words I am looking for a Class.forName() function in Python. It needs to work on Google App Engine. Preferably this would be a function that accepts the FQN of the class as a string, and returns a reference to the c...
Hello All, I'm currently trying to write a website for testing / learning purposes that will wrap around the IMDB datasets that are dumped. I'm having trouble determining the best way to extract the data into a format that is easier to manage. I will need to pull data from several files: movies.list = Movie list of all movies and yea...