Fogbugz-importer - Automatically imports tickets (cases) and their history from Excel spreadsheet in

FogBugz Importer reads tickets (cases) data from an Excel spreadsheet and automatically imports that data into FogBugz using FogBugz XML API. You can prepare a spreadsheet with data by hand or with some tool. If you migrating from Unfuddle then you may want to check Unfuddle Backup Parser. That parser will process your backup file and prepare spreadsheet for you. Usage: FogBugzImporter.exe FogBugzApiUrl "Your Name" "Your Password" "X:\\Path\\To\\tickets.xlsx" Example: FogBugzImporter.exe https://your-account.fogbugz.com/api.asp "John Doe" "Strong password" "C:\\Users\\John Doe\\Documents\\tickets.xlsx" NOTE: You should create users, projects, areas, milestones in FogBugz before import. You may want to tune up workflow in FogBugz before import if you need non-standard workflow. There should be folder media next to tickets.xlsx even if you don't plan to import attachments to tickets. The format of the tickets.xlsx is as follows (you may download sample tickets.xlsx using link on the right of this page or in Downloads section): number of rows is unrestricted. first row is reserved (used as header) - data in it won't be imported. data from first 12 columns (A to L, inclusive) will be processed. column A (cmd) contains one of the FogBugz commands (new, edit, assign, reactivate, reopen, resolve or close). An empty cell in this column will cause stop of processing. column K contains reporter (author) name. This column should not contain empty cells. each other cell (B, C, D, E, F, G, H, I, J and L) can be empty. DateTime values in columns B (dt) and J (dtDue) should be in UTC format. values in columns C (sProject), D (sArea) and E (sFixFor) should correspond to existing (created in FogBugz) project, area and milestone names. values in columns I (sPersonAssignedTo) and K (reporter) should correspond to existing (created in FogBugz) user names. attached files are presented as string with format attachment-name;attachment-file-name. attachment-file-name should point to a file in media folder next to tickets.xlsx. Here is a screenshot of sample tickets.xlsx



http://code.google.com/p/fogbugz-importer

Bookmark and Share          351



comments powered by Disqus


Related Products

SQL Workbench - DBMS-independent SQL query tool

SQL Workbench is a DBMS-independent, cross-platform SQL query tool. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. It could compare the data of two database and generate the necessary SQL statements to migrate one to the other.

Read more

Ankhsvn

AnkhSVN is a Subversion Source Control Provider for Microsoft Visual Studio 2005, 2008 and 2010. AnkhSVN provides source code management support to all project types supported by Visual Studio and allows you to perform the most common version control operations directly from inside the Microsoft Visual Studio IDE.

Read more

Quick Launch

Quick Launch - a New Lightweight and Fast Way to Manage and Launch Thousands of Tools and Applications

Read more

Python Tools for Visual Studio

PTVS is a free & OSS add-in from Microsoft that turns VS into a Python IDE. It supports CPython, IronPython, Intellisense, debugging, profiling, Azure, etc.

Read more

WebSearch.Net

WebSearch.Net is an open-source research platform that provides uniform data source access, data modeling, feature calculation, data mining, etc.

Read more

Torque 3D - Game Engine

Torque 3D is the best full source, open source solution available. orque 3D comes equipped with a full suite of tools to allow your team to excel and produce high-quality games and simulations. Its feature include World Editing Suite, Lighting, Programming, Terrain, Asset pipeline, Networking.

Read more

WiX Toolset - Windows Installer XML

The Windows Installer XML (WiX) is a toolset that builds Windows installation packages from XML source code. The toolset supports a command line environment that developers may integrate into their build processes to build MSI and MSM setup packages.

Read more

Feed4TestNG

Feed4TestNG makes it easy to write and feed parameterized TestNG tests with data imported from files (CSV or Excel) or generated.

Read more

VsVim - Vim Emulator Plugin for Visual Studio 2010+

Vim Emulator Plugin for Visual Studio 2010+

Read more

MinGW - Minimalist GNU for Windows

MinGW: A native Windows port of the GNU Compiler Collection (GCC), with freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All of MinGW's software will execute on the 64bit Windows platforms.

Read more

Related Tags
Browse projects by tags.

We have collection of more than 1 Million open source products ranging from Enterprise product to small libraries in all platforms. We aggregate information from all open source repositories. Search and find the best for your needs.