| Splasm Software Discussions https://www.splasmstrands.com.splasm.com/ |
|
| Format for importing CSV or TSV files with split entries https://www.splasmstrands.com.splasm.com/viewtopic.php?f=3&t=6981 |
Page 1 of 1 |
| Author: | bernie [ Fri May 12, 2023 1:24 pm ] |
| Post subject: | Format for importing CSV or TSV files with split entries |
Hi, is there a way to encode split entries in a CSV or tab-separated file for importing? I see elsewhere how QIF files portray split entries, but haven't found the way to do that in a CSV or TSV format. Thanks. |
|
| Author: | Allan W. [ Fri May 12, 2023 2:29 pm ] |
| Post subject: | Re: Format for importing CSV or TSV files with split entries |
There is indeed! Assuming you're working in a spreadsheet program, just create a special column for some unique identifiers, which you can name "Split ID" (or whatever you like), create a row to be treated as the parent entry, then assign it a unique value to be entered in the special column, like "001". Next, create or move rows below the parent entry you'd like treated as its split lines, with values matching that which was assigned to the parent entry included in the special column. Repeat all that with a new value for subsequent split entries, then you're good to go. In the end, you can import with "Split Entry Parent ID" selected up above the column in the Data Layout section of the Import Options. |
|
| Author: | mikerosen [ Tue Jun 13, 2023 3:54 pm ] |
| Post subject: | Re: Format for importing CSV or TSV files with split entries |
Allan, I am in awe of your knowledge beyond CBP, as well as your willingness to share! Thank you, from all of us! |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|