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

  •        619

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


raspBerry+ is a web-based administration platform for Blackberry Enterprise Server for MS Exchange (BES). You can group-based activate/kill/delete/add and get status of users, their handhelds and services. With a little download-area and a comment-system


RASP's A Sneakernet Proxy; download using a thumbdrive.


RasmusDSP is an embeddable Audio/MIDI processor. It contains various filters and generators (including SoundFont 2.0 compatible synthesizer). Has a script interpreter which is used to describe instruments, route Audio/MIDI signal between processor units.


An acronym for cRoss-plAtform accesS control for Enterprise Applications. Rasea aims to become a reference in access control as a service based on the RBAC model.


Rascal, the Advanced Scientific CALculator, is a platform independent modular calculator. Based on modules for integer, doubles, strings, vectors and matrices it can be easily extended with existing C or C++ code.


RARS is the Robot Auto Racing Simulation, in which the drivers are robot programs. It is intended as a competition among programmers. It consists of a simulation of the physics of cars, a graphic display of the race, and a robot driver for each car.


This small program allows you to play a video directly from a RAR file and do so in real-time. Both VLC and MPlayer are supported video players.


RAReXtract is a Front-End for the UnRAR command line utility for Mac OS X 10.5 (Leopard). Its purpose is the rapid and convenient extraction of RAR archives with a double click.

RAR Expander

Rar Expander is a MacOSX program which extracts the files contained in single or multi-volume RAR archives. It uses the official unRAR library internally so it is fully compatible with archives produced by WinRAR.


This program uses a brute force algorithm to guess your encrypted compressed file\'s password. If you forget your encrypted file password, this program is the solution. This program can crack zip,7z and rar file passwords.


RArcInfo is a package for R ( to import data from binary Arc/Info V7.X coverages and E00 files . This will allow R users to used it as a primary GIS tool.

rar brute force shell script - rarbrute

This is rarbrute, a shell script to brute force encrypted rar files under unix and linux. A long wordlist and a paper about security in internet cafes is included.

Raquel Database System

The system will : 1. use RAQUEL (= Relational Algebra Query, Update and Executive Language) for programming, implementing Third Manifesto principles. 2. have a 'Lego-like' architecture of building blocks and plug-ins, for wider applicability.


RAPv4 is an engine for building web application with only a business description (in XML format). NEW 04/2006 : Stable 2006 release. Add new functions like mail, sms, web services, graph, map engine (GIS), Excel output, QBE... and also a beta release of


2d Scroller. Clone of Raptor: Call of the Shadows and Tyrian. Fun game written in c++ using allegro.


Lightweight XML based transformation tool written in C that builds upon expat, tidylib and XSLT to tranform authored web content (incl. Word processor generated HTML) into styled web content suitable for publication.


RapidSMS is an open-source internet and communications platform


RapidSmith is a research-based FPGA CAD tool framework written in Java for modern Xilinx FPGAs. Based on XDL, its objective is to serve as a rapid prototyping platform for research ideas and algorithms relating to low level FPGA CAD tools.

Rapidshare Mass Downloader

What this program does is bringing out human interaction while downloading files from rapidshare(without premium account). It downloads all the rapidshare links sequentially to the specified location.

rapido visual profiler

rapido is a visual profiler for linux-x86. It traces function call using the ptrace interface and displays the information collected in a nice visual flow chart. rapido does not require the re-compilation of the application.