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

  •        0

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 "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



Related Projects

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.


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.

Quick Launch

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

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.


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

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.

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.


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

VsVim - Vim Emulator Plugin for Visual Studio 2010+

Vim Emulator Plugin for Visual Studio 2010+


C++/C library to construct Excel .xls files in code.