URGENT URGENT URGENT!!!!!MIGRATION of a .net website to DRUPAL

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
apurdeshpande's picture

hey guys,

i have a website in .net, a regualar .net website with database, i want that site to be managed through drupal.

every time when i have to upload data into my website it is taking forever, so i want to minimize it. lemme know how it can be done.

if it is possible then how?

P.S i am new to DRUPAL.

Comments

It could be rebuilt in Drupal

dpatte's picture

It could be rebuilt in Drupal

how?

apurdeshpande's picture

how????

regards,
Apur Deshpande

Not enough information

cyberhiker's picture

You will need to provide more information in order to receive a useful answer.

What is the business problem you are trying to solve?

You mention that you want to manage a .NET site through drupal (I'm assuming you mean you would like to convert the site from the .NET platform to drupal - not a trivial task for a large site) but it's not really clear why... If you provide some context around your question you may get some useful input.

The length of time to load data into your existing site also needs more info - when you say it is 'taking forever' are we talking seconds/minutes/hours/days, how much data, what speed is your connection, is the data compressed, what type of data, is it structured, are you loading a full dataset or only changes, ... indeed if that is your immediate problem drupal isn't going to be the solution - looking at the architecture on how the upload is structured and options to improve that would be better than switching platforms :-) I've seen poorly designed data export/imports that take hours reduced to minutes when redesigned but you'll need to provide some details for anyone to comment.

If you want to pursue drupal there is a lot of introductory material over at http://drupal.org/start

okay, lemme explain it...

apurdeshpande's picture

first of all, thanks for the reply. i have a .net website which is operated by somebody else, so they give us information and we upload it in the website, but with the help of drupal we want to minimize the effort we are putting in uploading the information from the excel sheet. so if we integrate our website with drupal, then may be i dont have to upload the information all the time, it can be done easily by them, uploading the records and moreover with drupal i can opt for many themes available.

i hope u understood my problem. jus give me a procedure to follow on what needs to be done or atleast the modules that require.

regards,
Apur Deshpande

OK - you didn't really answer

cyberhiker's picture

OK - you didn't really answer my question related to volume, time etc. My gut feeling is I don't think Drupal is what you need - it would be kind of a sledgehammer to attack a nut approach. You say you are 'uploading' the info from an excel sheet but I get the feeling that what you're doing is rekeying/manual inputting off of an Excel sheet. Why don't you write an upload utility in .NET to bulk load the data? Based on the minimal info that would be my suggestion but you need to do your own due diligence.

As you mentioned you are new to Drupal - so looking at the introductory material is the place to go for initial learning - or there are plenty of companies providing Drupal consulting.

Best of luck with whichever option you choose!

or use google

okay. but still.

apurdeshpande's picture

i want to manage a .net website (C# code and SQL database ) from drupal. i really hope you understand my problem. i was thinking of using the migrate module. will it help in anyway?

regards,
Apur Deshpande

If you keep asking ambiguous

xcafebabe's picture

If you keep asking ambiguous questions you only will get ambiguous answers.

If is so urgent and important your website you need to find a Drupal professional in your area. They will be glad to help you.

And yes, migration module COULD BE an option, BUT, when you said "manage a .net website (C# code and SQL database ) from drupal" what does this means ?

Do you want to keep using this website in .net and try to use Drupal only for particular admin tasks?

"manage a .net website from

mikeryan's picture

"manage a .net website from Drupal" really doesn't make much sense. If you want to use Drupal instead of the .net CMS for managing your website, then you would use the Migrate module to move the data from the .net database to Drupal. Drupal is a full CMS - it's not something to plugin as the front-end to another CMS.

Mike Ryan

installed module.

apurdeshpande's picture

no no no... not just the admin tasks, the whole website should be managed from drupal. like any updates i would want to make to that website(adding few images, articles, updating the information) it should be through drupal.

ok. so it is possible to migrate content from .net database to drupal. thanks for that. i have installed the migrate module. so i just have to transfer the content. and start managing it. ?????

pardon my ambiguous questions,

regards,
apur deshpande

regards,
Apur Deshpande

you have top start from fresh

dpatte's picture

you have to start from fresh in drupal, and build a new site then import the data from the old site's databases.

i have the site built

apurdeshpande's picture

hi

i have built the site, but how do i import the data( the aspx pages, the .vb pages, to DRUPAL ) please show me a way...

regards,
Apur Deshpande

Then you need to consider

xcafebabe's picture

Then you need to consider learn PHP. Becouse as I presume, you want to do-it-yourself.

For Migration module you will definitely need PHP skills.

My two-cents are : You'll not regret move to Drupal, but if is urgent you definitely need to hire a Drupal professional to support you on how to proceed.

I wrote this because we are talking about a website of one of your clients, right?

hmm yeah that's true. okay so

apurdeshpande's picture

hmm yeah that's true.

okay so i should start learning php then. ooof. okhai.

but how do i import data, using migrate module is just enough.???

and what all things can i migrate from a website???

thank you

regards,
Apur Deshpande

Migrate moves old tables into a new format

holtzermann17's picture

Here's a real working example that I use for a website I'm working on -- it will give you a sense of what Migrate can do.

https://github.com/cdavid/drupal_planetary/blob/master/sites/all/modules/planetmath_migration/planetmath_migration.inc

You will typically need to "massage" the SQL tables before you can import them. Here, again, is a real working example:

https://github.com/cdavid/drupal_planetary/blob/master/tables-into-drupal-pt2.sql

okhai, i will look into

apurdeshpande's picture

okhai, i will look into that...

thank you

regards,
Apur Deshpande

2 questions!!

apurdeshpande's picture

2 questions:

• If a site is without any database, then how would I handle the migration in Drupal?
• Why Php is required for working on Drupal. For instance, if WAMP is not available on the server I am working on, then what?

regards,
Apur Deshpande

Migrate without DB & PHP support

readyman's picture

If the site doesn't have a database, then you will need to manually migrate all the data into Drupal via the admin.
Drupal is a CMS based on the PHP language, so your server needs to support PHP to use Drupal. Ask your host if they support PHP & MySQL, otherwise you are wasting your time pursuing it further for this host.

or write a script!

holtzermann17's picture

"Manually" could be a lot of work. A drush script could probably be used to build and insert nodes from filesystem content.

Too new for drush

readyman's picture

I don't think he'd be able to work that one out on his own - He definitely needs a professional.

yeah. i think i would need

apurdeshpande's picture

yeah. i think i would need one for that. but i gotta work by myself.

regards,
Apur Deshpande

and....

apurdeshpande's picture

thank you,

and if i have the database i just have to migrate it. can i also migrate the content, i mean the front end of the website to drupal? or do i have to start from the scratch? uploading images and etc.

regards,
Apur Deshpande

migrate just moves MySQL content

holtzermann17's picture

You'll have to build the rest of your Drupal website from scratch.

ok. thank you very much.

apurdeshpande's picture

ok. thank you very much.

regards,
Apur Deshpande

I would consider using Feeds module

Dustin@PI's picture

If you are starting from a spreadsheet, I would consider using the feeds module rather then Migrate. Migrate is more powerful, but Feeds is easier to set up and can be done entirely in config without custom coding.

another thought: MigrateSourceCSV

holtzermann17's picture

Since no one mentioned it so far:

It is also possible to use Migrate to move CSV files, see for example: http://drupal.org/node/1152158

This could be another option, if you can export the Excel files as CSV.