Question about csv import
by Goblin Hero
Moderators: charmer, CCGHQ Admins
Question about csv import
by wwwmagnottait » 09 May 2021, 18:54
Hi all,
I downloaded latest version of Magic Album, to organize my Magic cards inventory.
I've nearly 3.000 cards stored on Cardmarket and Cartrader, and I exported an excel file with all my cards.
Unfortunately, when I try to import them in Magic Album with csv import I always get a FAIL message. I also tryed to download your .csv example (in Help folder) and pasted there all data in the right columns, but it still fails.
The problem is that the csv generated by Cardtrader do not have the Set\Expansions abbreviation as in Magic Album, but contains unique numbers for each set. I need at least to import all the cards, and then try to change manually the expansions. Is there a way to put a "default" field in the Set column, so maybe I don't get the error?
Many thanks for your support
I downloaded latest version of Magic Album, to organize my Magic cards inventory.
I've nearly 3.000 cards stored on Cardmarket and Cartrader, and I exported an excel file with all my cards.
Unfortunately, when I try to import them in Magic Album with csv import I always get a FAIL message. I also tryed to download your .csv example (in Help folder) and pasted there all data in the right columns, but it still fails.
The problem is that the csv generated by Cardtrader do not have the Set\Expansions abbreviation as in Magic Album, but contains unique numbers for each set. I need at least to import all the cards, and then try to change manually the expansions. Is there a way to put a "default" field in the Set column, so maybe I don't get the error?
Many thanks for your support
- wwwmagnottait
- Posts: 3
- Joined: 09 May 2021, 18:48
- Has thanked: 0 time
- Been thanked: 0 time
Re: Question about csv import
by Goblin Hero » 10 May 2021, 08:23
It's not possible. MA checks card's existence in the set during import.wwwmagnottait wrote:I need at least to import all the cards, and then try to change manually the expansions.
The only way for you - edit csv before import and replace all numeric codes with sets abbreviations.
When you´re a goblin, you don´t have to step forward to be a hero -- everyone else just has to step back.
-
Goblin Hero - Site Admin
- Posts: 1992
- Joined: 23 Oct 2005, 09:37
- Location: Russia
- Has thanked: 218 times
- Been thanked: 351 times
Re: Question about csv import
by bismarc123 » 06 Sep 2022, 09:55
I often have problems with CSV file import. The main reason I faced these issues was the wrong structure of the CSV file.
- bismarc123
- Posts: 2
- Joined: 06 Nov 2020, 09:55
- Has thanked: 0 time
- Been thanked: 0 time
Re: Question about csv import
by anonymous1989 » 07 Sep 2022, 09:42
I'll try to describe my process of importing CSV files. First, I opened the file in Excel and checked the column titles. They must be consistent across all rows and well written for Excel to recognize them correctly. Next, I look into column types (Numeric, Date, or time). Numeric columns should be formatted as such. Date and time columns should be formatted as "mm/dd/yyyy" and "hh:mm:ss". If not, Excel will ignore them and show them as numbers. After that, I save the file in CSV format, and then I can open it in Tableau. More often than, this process works well. If this won't work, I can recommend using https://www.coupler.io/excel-integrations/asana-to-excel.bismarc123 wrote:I often have problems with CSV file import. The main reason I faced these issues was the wrong structure of the CSV file.
- anonymous1989
- Posts: 5
- Joined: 12 Jul 2020, 06:40
- Has thanked: 0 time
- Been thanked: 0 time
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 28 guests