C# import excel to Datatable
When passing a local path to an XLS to import to a datable, the system is giving an error where it is looking for the c:\ on the server rather than on the local machine. How can I import an XLS directly to a datable. ...
import
Sharing handlers and backing beans
Hi All, I am wondering if it is possible to have a JSF handler and some of the backing beans in a war that is shared. I say war because I have a jsp which has a handler and backing beans that are shared between different applications, and need to be called by 2 different war files. From my earlier investigation I found that it is not p...
Best way to handle reload-ing of objects, not modules
Hi, I'm doing a lot of development in IPython where In[3]: from mystuff import MyObject and then I make lots of changes in mystuff.py. In order to update the namespace, I have to do In[4]: reload(mystuff) In[5]: from mystuff import MyObject Is there a better way to do this? Note that I cannot import MyObject by referencing mystuff...
Newbie: Import data from certain cells in Excel to SQL?
Hi, I am new to importing data into SQL Server tables - I have only used the Import/Export Wizard in MS SQL Server 2008 so far. However, I have a need to import hundreds of Excel files that are formatted exactly the same, but the data is in different cells/rows/columns in the workbook. There is no header row. I am wondering if there ...
How to save a ado recordset into a new local table in access 2003?
I'm trying to import tables from a FoxPro 9.0 database into access 2003. So far, from google searches and many trials, the only way for me to connect to the tables is through an OLE DB connection programatically. I have set up 3 ODBC connections with different configurations but none of them work. I get unspecified errors, that I can't f...
Can I create database schema based on a non-standard raw Excel format?
Schema has been described crudely in Excel as follows: tablename columnname columnid type length description table1 table1col1 1 int 4 blah blah table1 table1col2 2 varchar 15 dah dah dah table2 table2col1 1 int 4 etc table3 table3col1 1 money 10 $$$ There is a ...
How to transfer Magento upgraded Testsystem (v1.4.1) to Livesystem (v1.3.2.4) without Losing Orders
Hi everyone, I was asking how I could transfer a Magento Shop from my testserver to my Liveserver without losing the order and customer data from my live-system. Problem is that I installed various extensions, upgraded magento to 1.4.1 and also changed many files. If replace the database of the live-system with the one from my test-syst...
CSV with multiple header rows; import into mysql using php
Hi, I've got a CSV file with two sets of data in it [its pulled of a temperature logger]. I'm wondering if there's a way to import the first two rows as one set of data and the rest as a second set of data. I'm familiar with PHP, but have never had to do anything like this. I've attached a subset of data below. Any help or direction woul...
another Django ImportError
Hi, I got ImportError while I try to import mercurial module into django app. This is part of Django debug page: ImportError at / No module named mercurial Python Path: ['/usr/lib/python2.5', '/usr/lib/python2.5/plat-linux2', '/usr/lib/python2.5/lib-tk', '/usr/lib/python2.5/lib-dynload', '/usr/local/lib/python2...
Django import error.
Hi. I have two django-apps. news and comments in news/models.py I import my comments with "from my_proj.comments.models import Comment" and in my comments/models.py I import my news class with "from my_proj.news.models import News" Then in my third app (named frontpage) I import News in the view.py. But I get the error: Could not impor...
Python import inconsistent behavior
I have a py file like this, which errors out. from world import acme def make_stuff_happen(): acme.account.foo() # Works acme.subscription.bar() # FAIL: "module 'object' has no attribute 'subscription'" make_stuff_happen() But this works! from world import acme from world.acme import subscription def make_stuff_hap...
celery-django can't find settings
I have a Django project that uses Celery for running asynchronous tasks. I'm doing my development on a Windows XP machine. Starting my Django server (python manage.py runserver 80) works fine, but attempting to start the Celery Daemon (python manage.py celeryd start) fails with the following error: ImportError: Could not import settin...
import matplotlib._png fails
Hi, I have a problem getting matplotlib 1.0.0 work in Python 2.5.2 (Ubuntu 10.04) See attached console output. Any ideas appreciated. Thanks Python 2.5.2 (r252:60911, Jul 23 2010, 23:04:44) [GCC 4.4.3] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import numpy >>> import scipy >>> import matplotli...
Importing into Wordpress Via RSS feed
I am creating a wordpress blog for a magazine. They have a legacy blog engine with years of archives, and I am trying to migrate all of the content into wordpress posts. My method is to import all of the content via the RSS feed. I am using a plugin called Feed Wordpress which imports RSS feeds into posts. The only problem is that is on...
How to write Rake task to import data to Rails app?
Goal: Using a CRON task (or other schedule event) update rails database with nightly export of data from an existing system. All data is created/updated/deleted in an existing system. The website does no directly integrate with this system, so the rails app simply needs to reflect the updates that appear in the data export. I have a .t...
slow category import in magento
Hi I wrote a custom adapter for importing 6K categories using the advanced profiles. The import is too slow. I've tried increasing the number of records from 1 to 5 but it doesn't help. I also tried using ->setDisplayMode($dispMode) and ->setIsMassupdate(true) before saving the category but it also doesn't help. Any idea how to speed t...
How to import all submodules?
I have a directory structure as follows: | main.py | scripts |--| __init__.py | script1.py | script2.py | script3.py From main.py, the module scripts is imported. I tried using pkgutils.walk_packages in combination with __all__, but using that, I can only import all the submodules directly under main using from scripts import...
basic questions about "import"
I have some questions about Python's import statement: What is the difference between import <module> and from <module> import *? How can I import a module that is not in the same directory? (and not in PythonHome) Please consider I am a Python newbie ...
Dynamic Loading of Modules then using "from x import *" on loaded module
I have some django apps which are versioned by app name. appv1 appv2 The models.py in the apps are slightly different based on the version, but have the same model names. I'm attempting to load the models dynamically into the current namespace. So I've made a function that attempts to get the module and return it: def get_models_modu...
Having Problems with importing xlwt?
I am using Eclipse with the PyDev plugin. I am using xlwt which is for writing to an excel sheet. I have the xlwt library in my src file. I have another python file called gene_sorter.py where i try to import xlwt. using import xlwt I keep gettting back this error: File "C:\Documents and Settings\Ben Fossen\Pythonworkspace\MTBgenes\...