+ Post New Thread
Results 1 to 7 of 7
How do you do....it? Thread, PaperCut Export/Import in Technical; Hi Guys and Gals, I'm trying to migrate our PaperCut server to our new print server. The old PaperCut is ...
  1. #1

    Join Date
    Mar 2011
    Location
    Coventry
    Posts
    61
    Thank Post
    12
    Thanked 6 Times in 6 Posts
    Rep Power
    8

    PaperCut Export/Import

    Hi Guys and Gals,

    I'm trying to migrate our PaperCut server to our new print server. The old PaperCut is 8.5 and the new is 11.1.

    I'm probably missing something completely obvious but can't seem to get our old system to export our users in a format that the new PaperCut will accept as an import file.

    Its expecting TSV and the only option I can find to export is CSV (and PDF or HTML). So I tried exporting as CSV, opening in excel and saving as TSV and then it complains that there's too many fields.

    Has anyone successfully exported and then imported to a different server? If so any pointers would be greatly appreciated.

    Thanks,

    Ash

  2. #2

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,712
    Thank Post
    144
    Thanked 548 Times in 492 Posts
    Rep Power
    149
    Try viewing your tsv import file in Notepad, and look at the format - something may have messed up the formatting and it should be easier to spot it.

  3. Thanks to 3s-gtech from:

    iMash (8th April 2011)

  4. #3
    Big_Ted's Avatar
    Join Date
    Apr 2011
    Location
    Clevedon
    Posts
    135
    Thank Post
    1
    Thanked 20 Times in 20 Posts
    Rep Power
    10
    I would make a full backup (or 2) first.

    Then i would upgrade my current install of PaperCut NG to v11.1
    I would then export from 11.1 into a fresh install of 11.1 on the new server
    PaperCut KB | Migrating PaperCut to a New Server

    They add new tables etc into the database in new versions so its always wise to upgrade first before moving.

  5. Thanks to Big_Ted from:

    iMash (8th April 2011)

  6. #4

    Join Date
    Mar 2011
    Location
    Coventry
    Posts
    61
    Thank Post
    12
    Thanked 6 Times in 6 Posts
    Rep Power
    8
    Quote Originally Posted by Big_Ted View Post
    I would make a full backup (or 2) first.

    Then i would upgrade my current install of PaperCut NG to v11.1
    I would then export from 11.1 into a fresh install of 11.1 on the new server
    PaperCut KB | Migrating PaperCut to a New Server

    They add new tables etc into the database in new versions so its always wise to upgrade first before moving.
    Brilliant . Ill follow that KB. Thanks Big_Ted.

    As long as it lets me use the one license to upgrade the old version and not expect me to buy a new license.

  7. #5
    Big_Ted's Avatar
    Join Date
    Apr 2011
    Location
    Clevedon
    Posts
    135
    Thank Post
    1
    Thanked 20 Times in 20 Posts
    Rep Power
    10
    Oh..2 secs do you have the software assurance to upgrade to v11 from 8?

  8. #6

    Join Date
    Mar 2011
    Location
    Coventry
    Posts
    61
    Thank Post
    12
    Thanked 6 Times in 6 Posts
    Rep Power
    8
    No, we purchased a license for the new server (I think they gave us the upgrade price, I didn't actually do the purchasing of the license file).

    But its fine because it gave me a 40 day trial on the old server that allowed it to upgrade, and as it is being "de-commissioned" after its moved it should be fine.

    I have now updated the users and balances on the new server .

    Thanks for your help.

    Its good to see that sharing printers from 2008R2 to XP clients is nice and easy to do [/Sarcasm].

  9. #7
    jimmy_2k's Avatar
    Join Date
    Jun 2009
    Location
    Bristol
    Posts
    191
    Thank Post
    4
    Thanked 9 Times in 9 Posts
    Rep Power
    12
    I had all this fun last month. I had to basically, create a group in AD for LDAP to import papercut users. Add the staff and students to the group. Tell papercut to import users via the security group, imported all users. Extracted all users using papercuts CSV export. cut the spreadsheet down to 4 columns I think it was, user-name, first name, surname and card id. Extract the card id's from SIMS. Download a script which converts .CSV to .TSV formats, run the script, import the tsv file back into papercut telling it to overwrite all existing users etc and hey presto after that pollava one working and provisioned papercut system complete with card ID's. :-D

SHARE:
+ Post New Thread

Similar Threads

  1. Export Users, then import as Contacts
    By mplexo in forum Windows Server 2008 R2
    Replies: 6
    Last Post: 1st April 2011, 03:24 PM
  2. Active Directory Export and Import
    By stevo1565 in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 19th July 2010, 09:01 PM
  3. [MS Office - 2003] Access will not export or import
    By stoppaan in forum Office Software
    Replies: 2
    Last Post: 23rd November 2009, 01:56 PM
  4. SIMS AM7 -Export and Import Marksheet
    By LittleRedFoot in forum MIS Systems
    Replies: 4
    Last Post: 20th October 2008, 07:52 PM
  5. Export/Import into SIMS Marksheets
    By Sleepmaster in forum MIS Systems
    Replies: 1
    Last Post: 24th September 2008, 12:55 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •