Discussion Forum: Thread 334128

 Author: EricPWDeLong View Messages Posted By EricPWDeLong
 Posted: Jan 30, 2023 07:39
 Subject: CSV File Format
 Viewed: 105 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

EricPWDeLong (2)

Location:  USA, New Hampshire
Member Since Contact Type Status
Oct 28, 2020 Contact Member Seller
Buying Privileges - OKSelling Privileges - Revoked
Store Closed Store: The Odds
Can someone provide an example of a Working CSV file (it only needs the headers
in correct order)?

I am not sure why there is so much focus on XML - but I am not fond of the format-at
all!
 Author: ErwinNL View Messages Posted By ErwinNL
 Posted: Jan 30, 2023 07:58
 Subject: Re: CSV File Format
 Viewed: 52 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

ErwinNL (632)

Location:  Netherlands, Overijssel
Member Since Contact Type Status
Oct 27, 2019 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: TheBug
In Technical Issues, EricPWDeLong writes:
  Can someone provide an example of a Working CSV file (it only needs the headers
in correct order)?

I am not sure why there is so much focus on XML - but I am not fond of the format-at
all!

A CSV file for what exactly?
 Author: EricPWDeLong View Messages Posted By EricPWDeLong
 Posted: Jan 30, 2023 09:17
 Subject: Re: CSV File Format
 Viewed: 58 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

EricPWDeLong (2)

Location:  USA, New Hampshire
Member Since Contact Type Status
Oct 28, 2020 Contact Member Seller
Buying Privileges - OKSelling Privileges - Revoked
Store Closed Store: The Odds
In Technical Issues, EricPWDeLong writes:
  Can someone provide an example of a Working CSV file (it only needs the headers
in correct order)?

I am not sure why there is so much focus on XML - but I am not fond of the format-at
all!

To import from Excel a CSV file to populate my Collection/Store. Not really
sure what else you might need one for on this site.
 Author: ErwinNL View Messages Posted By ErwinNL
 Posted: Jan 30, 2023 09:47
 Subject: Re: CSV File Format
 Viewed: 52 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

ErwinNL (632)

Location:  Netherlands, Overijssel
Member Since Contact Type Status
Oct 27, 2019 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: TheBug
In Technical Issues, EricPWDeLong writes:
  In Technical Issues, EricPWDeLong writes:
  Can someone provide an example of a Working CSV file (it only needs the headers
in correct order)?

I am not sure why there is so much focus on XML - but I am not fond of the format-at
all!

To import from Excel a CSV file to populate my Collection/Store. Not really
sure what else you might need one for on this site.

I don't think importing a collection with CSV currently works, whatever I
try it says my file is empty.

It should be something like this:

ITEMTYPE,ITEMID,CONDITION,SUBCONDITION,COLOR,QTY
SET,60267,N,S,0,1

With one item per row, this is usually how it works, there are multiple possible
separators (, and sometimes you need to quote "values", but I haven't
found anything that works yet.

Importing store inventory only works with XML afaik.
 Author: ErwinNL View Messages Posted By ErwinNL
 Posted: Jan 30, 2023 09:50
 Subject: Re: CSV File Format
 Viewed: 72 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

ErwinNL (632)

Location:  Netherlands, Overijssel
Member Since Contact Type Status
Oct 27, 2019 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: TheBug
In Technical Issues, ErwinNL writes:
  In Technical Issues, EricPWDeLong writes:
  In Technical Issues, EricPWDeLong writes:
  Can someone provide an example of a Working CSV file (it only needs the headers
in correct order)?

I am not sure why there is so much focus on XML - but I am not fond of the format-at
all!

To import from Excel a CSV file to populate my Collection/Store. Not really
sure what else you might need one for on this site.

I don't think importing a collection with CSV currently works, whatever I
try it says my file is empty.

It should be something like this:

ITEMTYPE,ITEMID,CONDITION,SUBCONDITION,COLOR,QTY
SET,60267,N,S,0,1

With one item per row, this is usually how it works, there are multiple possible
separators (, and sometimes you need to quote "values", but I haven't
found anything that works yet.

Importing store inventory only works with XML afaik.

This works!

ITEMTYPE,ITEMID,CONDITION,SUBCONDITION,COLOR,QTY
S,60267-1,N,S,0,1

However, I still get the error message but imports fine
 Author: EricPWDeLong View Messages Posted By EricPWDeLong
 Posted: Jan 31, 2023 10:42
 Subject: Re: CSV File Format
 Viewed: 46 times
 Topic: Technical Issues
 Report:
Cancel Message
Cancel		Reply to Message
Reply
BrickLink
ID Card

EricPWDeLong (2)

Location:  USA, New Hampshire
Member Since Contact Type Status
Oct 28, 2020 Contact Member Seller
Buying Privileges - OKSelling Privileges - Revoked
Store Closed Store: The Odds
Thanks for the Feedback. I am going to try example and of course work through
it. I have a couple of hundred Instructions I would like to list and entering
them one at a time...argh. No rush though. Thanks for all your help.