public void OneTimeSetUp()
{
var origDom = new HtmlDom(roundtripTestBook, true);
_roundtrippedDom = new HtmlDom(roundtripTestBook, true); //Will get imported into
// We want to test that exporting a book with branding in the data-dive and importing into a book with no branding
// does not reinstate the branding. So we need to remove it from the pre-import DOM, which is otherwise
// (for this test) the same as what we originally exported.
var branding =
_roundtrippedDom.SelectSingleNode("//div[@data-book='outside-back-cover-branding-bottom-html']");
branding.ParentNode.RemoveChild(branding);
AssertThatXmlIn.Dom(origDom.RawDom).HasSpecifiedNumberOfMatchesForXpath("//div[@id='simpleFormattingTest']", 1);
AssertThatXmlIn.Dom(origDom.RawDom).HasSpecifiedNumberOfMatchesForXpath("//div[@id='nestedFormattingTest']", 1);
var mockLangDisplayNameResolver = new Mock <ILanguageDisplayNameResolver>();
mockLangDisplayNameResolver.Setup(x => x.GetLanguageDisplayName("en")).Returns("English");
var exporter = new SpreadsheetExporter(mockLangDisplayNameResolver.Object);
exporter.Params = new SpreadsheetExportParams();
_sheetFromExport = exporter.Export(origDom, "fakeImagesFolderpath");
using (var tempFile = TempFile.WithExtension("xslx"))
{
_sheetFromExport.WriteToFile(tempFile.Path);
var sheet = InternalSpreadsheet.ReadFromFile(tempFile.Path);
var importer = new SpreadsheetImporter(null, _roundtrippedDom);
importer.Import(sheet);
}
}
public static int Handle(SpreadsheetImportParameters options)
{
try
{
string folderPath = Directory.GetParent(options.BookPath).FullName;
BookStorage.SaveCopyBeforeImportOverwrite(folderPath);
var sheet = InternalSpreadsheet.ReadFromFile(options.InputPath);
var dom = new HtmlDom(XmlHtmlConverter.GetXmlDomFromHtmlFile(options.BookPath, false));
var importer = new SpreadsheetImporter(null, dom, Path.GetDirectoryName(options.InputPath), folderPath);
if (!string.IsNullOrEmpty(options.ParamsPath))
{
importer.Params = SpreadsheetImportParams.FromFile(options.ParamsPath);
}
var messages = importer.Import(sheet);
foreach (var message in messages)
{
Debug.WriteLine(message);
Console.WriteLine(message);
}
// Review: A lot of other stuff happens in Book.Save() and BookStorage.SaveHtml().
// I doubt we need any of it for current purposes, but later we might.
XmlHtmlConverter.SaveDOMAsHtml5(dom.RawDom, options.BookPath);
Console.WriteLine("done");
return(0); // all went well
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
return(1);
}
}
protected override void InitializeImporter(SpreadsheetImporter importer)
{
base.InitializeImporter(importer);
importer.Params = new SpreadsheetImportParams()
{
RemoveOtherLanguages = true
};
}
public void StringWithNewlinesMakesParas()
{
SpreadsheetImporter.SetContentAsText(_editable, "This is some text\r\n\r\nSome more\r\nand more");
AssertThatXmlIn.Dom(_dom).HasSpecifiedNumberOfMatchesForXpath("//p", 4);
AssertThatXmlIn.Dom(_dom).HasSpecifiedNumberOfMatchesForXpath("//p[text()='This is some text']", 1);
AssertThatXmlIn.Dom(_dom).HasSpecifiedNumberOfMatchesForXpath("//p[text()='']", 1);
AssertThatXmlIn.Dom(_dom).HasSpecifiedNumberOfMatchesForXpath("//p[text()='Some more']", 1);
AssertThatXmlIn.Dom(_dom).HasSpecifiedNumberOfMatchesForXpath("//p[text()='and more']", 1);
}
public void OneTimeSetup()
{
_testFolder = new TemporaryFolder("SpreadsheetImporterWithBookTests");
// We need 2 layers of temp folder because BringBookUpToDate will change the name of the book
// folder to match an imported title.
_bookFolder = new TemporaryFolder(_testFolder, "Book");
var settings = new NewCollectionSettings();
settings.Language1.Iso639Code = "en";
settings.Language1.SetName("English", false);
settings.SettingsFilePath = Path.Combine(_bookFolder.FolderPath, "dummy");
var fileLocator = new BloomFileLocator(settings, new XMatterPackFinder(new string[] { }), ProjectContext.GetFactoryFileLocations(),
ProjectContext.GetFoundFileLocations(), ProjectContext.GetAfterXMatterFileLocations());
var bookFilePath = Path.Combine(_bookFolder.FolderPath, "testBook.htm");
if (File.Exists(bookFilePath)) // Shouldn't ever happen, but... just being careful.
{
RobustFile.Delete(bookFilePath);
}
_dom = SetupTestDom();
// Write out our test book
File.WriteAllText(bookFilePath, _dom.RawDom.OuterXml.ToString());
var storage = new BookStorage(_bookFolder.FolderPath, fileLocator, new BookRenamedEvent(), settings);
var book = new Bloom.Book.Book(new BookInfo(_bookFolder.FolderPath, true), storage, null,
settings, new Bloom.Edit.PageSelection(),
new PageListChangedEvent(), new BookRefreshEvent());
// Create the regular production importer
_importer = new SpreadsheetImporter(null, book, _bookFolder.FolderPath);
// Set up the internal spreadsheet rows directly.
var ss = new InternalSpreadsheet();
var columnForEn = ss.AddColumnForLang("en", "English");
var columnForImage = ss.GetColumnForTag(InternalSpreadsheet.ImageSourceColumnLabel);
var newTitle = "My new book title";
var titleRow = new ContentRow(ss);
titleRow.AddCell(InternalSpreadsheet.BookTitleRowLabel);
titleRow.SetCell(columnForEn, newTitle);
var coverImageRow = new ContentRow(ss);
coverImageRow.AddCell(InternalSpreadsheet.CoverImageRowLabel);
coverImageRow.SetCell(columnForImage, Path.Combine("images", "Othello 199.jpg"));
_importer.Import(ss);
_resultElement = ReadResultingBookToXml(newTitle);
}
private static ImportRun CreateImportRun(ImportConfig importConfig, string fileToken)
{
SpreadsheetImporter importer = ( SpreadsheetImporter )Factory.Current.Resolve <ISpreadsheetImporter>( );
ImportSettings importSettings = new ImportSettings
{
FileToken = fileToken,
ImportConfigId = importConfig.Id,
TimeZoneName = ""
};
ImportRun importRun = importer.CreateImportRunEntity(importConfig, importSettings);
return(importRun);
}
public void OneTimeSetUp()
{
// Cases we want to test:
// - page has too many translation groups
// - V1: warn, leave extras unmodified
// - eventual: ?
// - page has too few translation groups (special case: none)
// - V1: warn, drop extra inputs
// - V2: insert extra copies of page (and something else if it has no TGs)
// - eventual: insert extra pages using template specified in sheet
// - there are input lines for pages that don't exist (pathological, in the middle; likely, after last; test both)
// - V1: warn, ignore
// - eventual: insert extra pages using template specified in sheet
// - there are pages that have no input lines (but later pages do)
// - there are pages after the last input line
// - V1: warn, leave unchanged.
// - eventual: ?
// In this test suite, the blocks on the last page and the pages run out before
// we run out of lines. So we can't test the case of running out of lines first.
// Another class tests that.
_dom = new HtmlDom(inputBook, true);
_sheet = new InternalSpreadsheet();
_sheet.ColumnForLang("en");
_sheet.ColumnForLang("fr");
_sheet.AddRow(MakeRow("1", "New message about tigers", "New message about French tigers"));
// problem 1: input DOM has a second TG on page 1; sheet does not.
_sheet.AddRow(MakeRow("2", "More about tigers", "More about French tigers"));
// problem 2: input DOM has no second TG on page 2.
_sheet.AddRow(MakeRow("2", "Still more about tigers", "Still more about French tigers"));
_sheet.AddRow(MakeRow("2", "More and more about tigers", "More and more about French tigers"));
// problem 3: input DOM has no page 3 at all.
_sheet.AddRow(MakeRow("3", "Lost story about tigers", "Lost story about French tigers"));
_sheet.AddRow(MakeRow("3", "Another lost story about tigers", "Another lost story about French tigers"));
// problem 4: input DOM has no page 4 at all.
_sheet.AddRow(MakeRow("4", "Yet another lost story about tigers", "Yet another lost story about French tigers"));
_sheet.AddRow(MakeRow("5", "A good story about tigers", "A good story about French tigers"));
_sheet.AddRow(MakeRow("5", "Another good story about tigers", "Another good story about French tigers"));
// problem 5: an extra block on page 5
_sheet.AddRow(MakeRow("5", "Page 5 lost story about tigers", "Page 5 lost story about French tigers"));
// problem 6: an extra block on after the last page
_sheet.AddRow(MakeRow("6", "Page 6 lost story about tigers", "Page 6 lost story about French tigers"));
var importer = new SpreadsheetImporter(this._dom, _sheet);
_messages = importer.Import();
}
public void OneTimeSetUp()
{
_dom = new HtmlDom(SpreadsheetTests.kSimpleTwoPageBook, true);
AssertThatXmlIn.Dom(_dom.RawDom).HasSpecifiedNumberOfMatchesForXpath("//div[@lang='en']/p[text()='Riding on elephants can be risky.']", 1); // unchanged
var exporter = new SpreadsheetExporter();
_sheet = exporter.Export(_dom);
var indexDe = _sheet.ColumnForLang("de");
_sheet.Header.SetCell(indexDe, "[tpi]");
_sheet.ContentRows.First().SetCell(_sheet.ColumnForLang("en"), "<p>This elephant is running amok.</p>");
_sheet.ContentRows.Skip(2).First().SetCell(_sheet.ColumnForLang("fr"), "<p>Riding on French elephants can be very risky.</p>");
var importer = new SpreadsheetImporter(this._dom, _sheet);
InitializeImporter(importer);
importer.Import();
}
/// <summary>
/// This is our primary entry point for importing from a spreadsheet. There is also a CLI command,
/// but we shouldn't need that one much, now that we have this on our book thumb context menus.
/// </summary>
public void HandleImportContentFromSpreadsheet(Book.Book book)
{
if (!_collectionModel.CollectionSettings.HaveEnterpriseFeatures)
{
Enterprise.ShowRequiresEnterpriseNotice(Form.ActiveForm, "Import to Spreadsheet");
return;
}
var bookPath = book.GetPathHtmlFile();
try
{
string inputFilepath;
using (var dlg = new DialogAdapters.OpenFileDialogAdapter())
{
dlg.Filter = "xlsx|*.xlsx";
dlg.RestoreDirectory = true;
dlg.InitialDirectory = GetSpreadsheetFolderFor(book, false);
if (DialogResult.Cancel == dlg.ShowDialog())
{
return;
}
inputFilepath = dlg.FileName;
var spreadsheetFolder = Path.GetDirectoryName(inputFilepath);
SetSpreadsheetFolder(book, spreadsheetFolder);
}
var importer = new SpreadsheetImporter(_webSocketServer, book, Path.GetDirectoryName(inputFilepath));
importer.ImportWithProgress(inputFilepath);
// The importer now does BringBookUpToDate() which accomplishes everything this did,
// plus it may have actually changed the folder (and subsequent 'bookPath')
// due to a newly imported title. That would cause this call to fail.
//XmlHtmlConverter.SaveDOMAsHtml5(book.OurHtmlDom.RawDom, bookPath);
book.ReloadFromDisk(null);
BookHistory.AddEvent(book, TeamCollection.BookHistoryEventType.ImportSpreadsheet);
_bookSelection.InvokeSelectionChanged(false);
}
catch (Exception ex)
{
var msg = LocalizationManager.GetString("Spreadsheet:ImportFailed", "Import failed: ");
NonFatalProblem.Report(ModalIf.All, PassiveIf.None, msg + ex.Message, exception: ex, showSendReport: false);
}
}
public void OneTimeSetUp()
{
// Cases we want to test:
// - there are more blocks on the last page after we run out of input lines
// - there are pages after the last input line
// - V1: warn, leave unchanged.
// - eventual: ?
// In this test suite, lines run out before the blocks.
_dom = new HtmlDom(inputBook, true);
_sheet = new InternalSpreadsheet();
_sheet.ColumnForLang("en");
_sheet.ColumnForLang("fr");
_sheet.AddRow(SpreadsheetImportSyncWarnings.MakeRow("1", "New message about tigers", "New message about French tigers"));
_sheet.AddRow(SpreadsheetImportSyncWarnings.MakeRow("2", "More about tigers", "More about French tigers"));
// problem: there's no input corresponding to the second block on page 2, nor any of page 4.
var importer = new SpreadsheetImporter(this._dom, _sheet);
_messages = importer.Import();
}
public void OneTimeTearDown()
{
_dom = null;
_importer = null;
_testFolder?.Dispose();
}
public void SimpleStringMakesPara()
{
SpreadsheetImporter.SetContentAsText(_editable, "This is some text");
AssertThatXmlIn.Dom(_dom).HasSpecifiedNumberOfMatchesForXpath("//p[text()='This is some text']", 1);
}
/// <summary>
/// Provides a hook where a subclass can change something to apply similar tests with
/// a slightly different state (e.g., different import params).
/// </summary>
protected virtual void InitializeImporter(SpreadsheetImporter importer)
{
}
