.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Import/Export Translations :: Variations 2010

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :SharePoint

1) Options available [Import/Export] Transaltions in SharePoint 2010. My root site http://Mysite/. is in English. and when I  crated variation heirarchy I got http://Mysite/EN/ and http://Mysite/FR webaddress. Then I created 2 publishing sites under English. Now

a) when I make content changes in English\siteA and click on publish... does it create a new page under French or I need to create new publishing site in French?

b) If do Export of my english\SiteA does the resource file will contain all custom webparts and contents available to change by a transaltor or only standard Transtable columns availble in resource files?

c) When I import the .resx file to French, I need to have similar site exists in french like French\siteA to reflect the changes?

Thanks in advance.

View Complete Post

More Related Resource Links

Configuring Profile Image Export in SharePoint 2010

It's no secret that I am thrilled with the new social features of SharePoint 2010. I am most excited about the new Profile Picture handling. I strongly believe that the more we can show the faces of our colleagues to one another the more connected we will feel. Clearly Microsoft feels that way as witnessed by the many features that make use of the Profile Image like the Activity Feed and Colleagues list

sql server 2008 import/export wizard... completely useless??



import/export wizard in 2000 had lots of options.

I could copy databases without a care in the world. Including constraints, stored proc., AND the data, etc.

Now, with v2008, the wizard is dumbed down too much. It's a "stupid" copy function that fails on the first constraint it meets.

"Copy database.." is not an option here: it needs sysadmin on both source and destination server.

Re-adding the constraints manually is not an option either: the database is WAY too large. 

I'm actually hoping there is a temporary bug in the import/export wizard. Each option (and you have THREE...) returns with a new error.

Googling, I found I am not alone:


This post is exactly my situation. Here's what his post says: (bolded key parts)


I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy.

Firstly I created a new empty db on the local machine. Then I scripted the structure of the db on the remote machine and ran the resulting query on the local machin

SSIS Import/Export Wizard: "Unexpected Unrecoverable Error"

For whatever reason, whenever the SSIS Import/Export Wizard needs to display an error message, it throws up "Unexpected Unrecoverable Error" instead. The three buttons - Abort, Retry, and Ignore - all cause the wizard to close. I see some activity in Process Monitor that looks like DTSWizard.exe is probing around for some System.Web assemblies, and not finding them. I'm running 2008 SP1 on Win 7 x86, and I've reinstalled the client tools and Integration Services. Anybody else seen this issue? Should I file a report on Connect?

stsadm export / import custom view / personal view views

Hi, i have to export and import a website with a sharepoint list including all personal views. The personal views are used by the endusers in excel data connections binded to the list.  Loss of personal views during import is not mentioned in the technet discription of export / import command ( http://technet.microsoft.com/en-us/library/cc766807(office.12).aspx  ) I am actually testing the export / import between two site collections, but always losing the personal views (MOSS 2007 with CU April 2010). This discussion had the same topic http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/4e299838-72c2-4f56-8dc3-05ba2a2999d9  but with no definite answer. Please tell me if this is by design or what could cause this behavior. Thanks in advance. Boris Boris Schlotthauer

How to export data from SQL 2008 R2 to excel 2010

Hi, I am using microsoft sql 2008 R2 express server and I have window 7 64 bit and office 2010.  I would like to export data form sql to excel using a query in sql.  I tried a few examples I found on the web, but they don't work.  Please help. Thanks

Import / Export - Workflows

I exported my site, then imported it on a new empty site. Result was unsatisfying by many reasons (which i can overcome postfactum though), but specially - i lost all workflow information. So, can i save workflows during import/export ? PS And is it possible to make 100 % twin site by export/import operations ?

DTS Import/Export

i need to import data from dbf to mssql using DTS Import/Export wizard. But there isn't "dBase" selection in DataSource combobox. And i tried to select "Flat File Source", it display error dialog. Plz help me

export not compatible with import for null smallints

We have one system that exports a table to a pipe-delimited "|" csv file, and another that reads the csv file into a very similar table. One field in the table(s) is a nullable smallint. When the values in the table are null, SSIS exports to the flatfile as an empty field, just two adjacent separators. When I try to read that file back in, it generates an error, can't convert string to smallint. So, what's up with that? I suppose I can fix this one field, but is this going to be a general problem?  Is there a quick fix other than put in my own transformation? Thanks. Josh  --- oh hey, I think I fixed it!  Well, worked around it anyway.  Went to the source in the dataflow, in the advanced editor changed the output column type to DT_I2.  Now it imports as 0 instead of null.  Hmm, is that good enough?

how can i export/import maintenance plans from 2005 to 2008?

I have this link http://sqlservernewbie.blogspot.com/2008/10/how-to-importexport-sql-server.html However, it is not the solution for me. When I expand SERVERNAME (Integration Services), all I can see it is Running packages and Stored packages, and I cannot expand any deeper. And the scripting way which described in the link above, seems is not finished. It just tells you about the select...JulieShop

SharePoint 2010 Export list Items to Excel, wrong url in iqy file

Hi, I have a SharePoint 2010 Environment that uses https://portal.<something>.com. Exporting to Excel of a list uses wrong URL. When I go to the a list, select the list to show the "office ribbon" and then select export to excel, excel will show the error "Excel cannot connect to the SharePoint List". When I take a look at the IQY file that is created it contains the wrong url: http://portal.<something>.com instead of https://portal.<something>.com Changing the URL in the IQY file manualy to https://portal.<something>.com and then opening it will excel is working fine, list data is exported to excel then. Alternate access mapping is configured to use https://portal.<something>.com as default, export to access is working normaly. I already deleted the http://portal.<something>.com alternate access mapping once to see if this fixes the problem. No fix, even not after IISreset or rebooting the server. Where or how is the export to Excel IQY file created and where is it possible to fix the URL it is putting in the IQY file? Grtz, Arjan

Import Visual Studio 2005 to 2010



I am updating/extending a site I originally created in Visual Studio 2005. My new site I am starting in 2010. If I select add exiting item to project I notice a number of differences. 

1. CodeFile has been replaced by CodeBehind (without changing this, any code goes in script on the aspx page, not the .cs file. Why?

2. There is a file called filename.designer.cs created with new pages that my imported pages do not have. What is the purpose of this file and is it required and/or how can it be constructed from imported content?

thanks in advance

Issue with Picture Library Slideshow Web Part after export/import of site collection (SP2010)


I recently exported/imported an SP2010 site collection from Dev to Prod. The site collection had about 90 sites, which were all driven from a site template. Once the export/import had taken place, I created an additional 15 sites (in Prod), using the original site template that was created in the Dev environment. Everything seemed to be working just fine, but I found an issue with the Picture Library Slideshow Web Parts (PLSWP) on all the sites that were created in Prod. Basically, I have a Picture Library, and any pictures added to this library show up in the PLSWP. The original 80 site's PLSWP works fine, but the new 15 sites will not show the pictures through the PLSWP (the viewer just shows up blank). Here is the difference in the html output of the picture viewer:

 PLSWP from Dev:

 <a target="_blank" href="http://forefronttest/realestate/RE/West/HOU/3560/Project%20Pictures/test.jpg" id="MSOPictureLibrarySlideshowWebPart_ctl00_m_g_28b22a62_6d8

Export MySQL and import into CRM


I'd like to export an non-MS MySQL database and re-import it into CRM but I'd like to keep the relationships (foreign keys) between tables in the MySQL database in the CRM system. Does anyone know the best way to do such a thing?


Cannot Export SQL 2008 Table to Excel 2010


I'm trying to use SSIS in Visual Studio 2008 to export a table to Excel 2010 and get the following error:


The table cannot be created. (Microsoft Visual Studio)


Syntax error in field definition. (Microsoft Office Access Database Engine)

Program Location:

   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
   at Microsoft.DataTransformationServices.Design.PipelineUtils.ExecuteSqlStatement(ConnectionManager connectionManager, String sqlStatement, IServiceProvider serviceProvider, Boolean getReader)
   at Microsoft.DataTransformationServices.Design.DtsTableCreator.okButton_Click(Object sender, EventArgs e)

Import and Export data between servers


I hope this is the right place to ask.

I am conencting two different sql server with different IPs. I want to copy some of data from one server table to another server table. I saw from my friend there was Import and Export Data from Tools menu (he said that he added before), he wrote ips and then choose tables and columns ... I couldn't find this right now in Management Studio. Where is it? I anyone can help me, i will be appreciated.


I am using sql server 2005 standart edition



Ahmet UZUN

Site export/import not getting all docs in a library

I am using stsadm to move a site form one site collection to another and for some reason a doc library in the restored site is missing docs. Any thoughts?

Import Word docs with Metadata into SharePoint 2010 from Windows Server 2003


I need to import 700 Word docs (2003 & 2007) from Windows Server 2003 into a SharePoint Server 2010 library.  I only have a test server to work with right now and want to do as much pre-work before we launch the actual server. 

My goal: When we launch the shpt server, import all docs into a library so that columns propagate with metatdata automatically.

I'm not sure what the best approach is...

Can I can open each doc and add custom properties (maybe with InfoPath) to import as metadata, then import managed metadata through the term store tool and have it associate with the manually entered custom properties? I don't fully understand managed metadata, which might pose a problem.  And before I start importing terms, I thought I should find out if I've completely misunderstood how taxonomies work.

Or I have an excel spreadsheet with info about each doc in columns that can act as metadata. I could upload this as a list then associate each doc with the list.  But it seems wiser to enter the metadata into the documets.  

Is it possible to update my docs in advance so that uploading goes smoothly? I have help now for data entry that I won't have later.

I have no resources to spend on tools, and have to figure out and build this&nbs

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend