| Author |
Message |
| Registered: March 24, 2007 | | Posts: 16 |
| | Posted: | | | | Is it possible to export only the upc codes to a csv file? I've installed the "export to csv" plugin but I don't see any option for selecting on the upc. Lots of other data options to export but no upc.
Is this possible?
Thanks,
Tom |
|
| Registered: March 14, 2007 | Reputation:  |  Posts: 17,804 |
| | Posted: | | | | Maybe a workaround if you own excel:
Goto menu/export profiler database. this one creates an *.xml file. This one can be opened in MS Excel. One of the column contains the UPC. You could edit this sheet and save this in *.csv format! I tested this with M/S Excel 2002. | | | | Thorsten |
|
| Registered: March 24, 2007 | | Posts: 16 |
| | Posted: | | | | After a bit more playing around with the CSV plugin, I learned that PROFILE ID is indeed the UPC code. |
|
| Registered: May 19, 2007 | | Reputation: |  Posts: 5,917 |
| |
| Registered: March 13, 2007 |  Posts: 350 |
| | Posted: | | | | Ummm, I thought that the profile ID was the UPC/EAN code followed by a period then followed by the locality code, except for US locality, whiere it is just UPC code.
Of course that distinction may not be important if your collection is exclusively US locality, but us canajans wind up with lotsa xxx.3's and the European profilers, whoo!
I haven't used the CSV plugin, so I may be mistaken ... | | | | -fred |
|
| Registered: March 13, 2007 | Reputation:  | | Posts: 2,217 |
| | Posted: | | | | Quoting FredLooks: Quote:
Of course that distinction may not be important if your collection is exclusively US locality, but us canajans wind up with lotsa xxx.3's and the European profilers, whoo! Sure, but gettin rid of to much data is always easier than working with too little data. In this special case I would simply search&replace the "." with a LF/CR and "." converting 1234567890.3 1234567891.4 to 1234567890 .3 1234567891 .4 Then sort and kill all lines beginning with "." cya, Mithi PS Under unix it would be sed 's/\./\n\./g'|grep -v '\.'  | | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki | | | | Last edited: by Mithi |
|
| Registered: March 13, 2007 | | Posts: 350 |
| | Posted: | | | | well of course using sed, one could simply: sed 's/\..*//' or alternatively construct a similar little scriptlet to extract the UPCs from an XML export ... but i take your point  | | | | -fred |
|
| Registered: May 22, 2007 | Reputation:  | | Posts: 1,033 |
| | Posted: | | | | or just bring the csv file into textpad or another similar text editor with more functionality than notepad and you can do find/replace using regular expressions. in text pad it would be Find: \..+\n Replace: \n just make sure you have the Regular Expressions checkbox ticked last one might get skipped if there isn't a blank line, but its easy enough to just do the one manually, or add the line before running the Find/Replace -Agrare |
|
| Registered: March 13, 2007 | Reputation:  | | Posts: 3,321 |
| | Posted: | | | | It's Profile ID because that's what the SDK called it. Looking back on it, I should had named it UPC instead on Profile ID. But I didn't.  | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|