Canventory to Excel File Transfer Question

Discussion issues on Beer Cans,, Breweriana, Attended Shows etc...

Moderators: Forum Moderator, Current Officers, Previous Officers

User avatar
JohnLi67
Rust Master
Rust Master
Posts: 242
Joined: Mon Oct 28, 2013 4:40 pm
Answers: 0
Rusty Bunch Member Number: 1103
BCCA Number: 34303
eBay name: johnlij
Year Started Collecting: 2000
Location: Cloquet, MN
Been thanked: 15 times
Zodiac:
Status: Offline
United States of America

Canventory to Excel File Transfer Question

#1

Post by JohnLi67 »

I know there are some in the Rusty Bunch that use Canventory software to catalog their collection. I think I remember a thread that mentioned that you can transfer the information in the Canventory software over to an Excel spreadsheet. Can anyone confirm if that is true? And if anyone knows how to perform that task, can they post a short explanation on how to do it?

Thanks for any information in advance.

John


MI-Cans
Rust Governor
Rust Governor
Posts: 2641
Joined: Mon Jan 07, 2013 8:19 am
Answers: 0
Rusty Bunch Member Number: 1128
Has thanked: 4696 times
Been thanked: 1621 times
Status: Offline
United States of America

Re: Canventory to Excel File Transfer Question

#2

Post by MI-Cans »

According to their site, the data is exportable in CSV format. MS Excel can open up a CSV file and you should be able to then save as an MS Excel file.

(MI-Cans)
Attachments
Export.png
User avatar
gorrister
Cone Top
Cone Top
Posts: 146
Joined: Wed Sep 30, 2015 10:22 pm
Answers: 0
Rusty Bunch Member Number: 1277
BCCA Number: 34786
eBay name: emefree
Year Started Collecting: 2015
Has thanked: 30 times
Been thanked: 24 times
Zodiac:
Status: Offline
United States of America

Re: Canventory to Excel File Transfer Question

#3

Post by gorrister »

File->Export Project
User avatar
JohnLi67
Rust Master
Rust Master
Posts: 242
Joined: Mon Oct 28, 2013 4:40 pm
Answers: 0
Rusty Bunch Member Number: 1103
BCCA Number: 34303
eBay name: johnlij
Year Started Collecting: 2000
Location: Cloquet, MN
Been thanked: 15 times
Zodiac:
Status: Offline
United States of America

Re: Canventory to Excel File Transfer Question

#4

Post by JohnLi67 »

Thanks Guys for your responses. I was able to export a CSV file and then open it in Excel using the character | as the column divider. I was then able to obtain a fairly complete spreadsheet file of my collection.
Uncle Jackson
Rust Master General
Rust Master General
Posts: 524
Joined: Mon Sep 13, 2010 9:09 pm
Answers: 0
Rusty Bunch Member Number: 929
BCCA Number: 953
eBay name: JLC0953
Year Started Collecting: 1969
Location: North East, PA
Has thanked: 2 times
Been thanked: 107 times
Zodiac:
Status: Offline
United States of America

Re: Canventory to Excel File Transfer Question

#5

Post by Uncle Jackson »

I do this frequently, but there are always a couple of lines that end up wrong. Please check to make sure no lines have wrong data in the right columns.
Jerry Cole
User avatar
gorrister
Cone Top
Cone Top
Posts: 146
Joined: Wed Sep 30, 2015 10:22 pm
Answers: 0
Rusty Bunch Member Number: 1277
BCCA Number: 34786
eBay name: emefree
Year Started Collecting: 2015
Has thanked: 30 times
Been thanked: 24 times
Zodiac:
Status: Offline
United States of America

Re: Canventory to Excel File Transfer Question

#6

Post by gorrister »

Uncle Jackson wrote: Tue Dec 11, 2018 7:03 am I do this frequently, but there are always a couple of lines that end up wrong. Please check to make sure no lines have wrong data in the right columns.
I'm willing to bet that this is because you are exporting the file and a CSV (comma separated values) and that there is a comma in your data and the export file isn't handling the comma in the data quite right. Just a guess based on programming experience. I haven't seen the code for this program so I can't be sure.
Post Reply Previous topicNext topic

Return to “General Discussion”