can anyone help me import a multi-line expense rep...
# csvimports
m
can anyone help me import a multi-line expense report? From what I understand, you need to import multi files. In my file I have the external ID, the employee, the accounting account, the date and the sublist information, category, memo, amount, date, currency.
k
so what is the problem? for any multi-line record you need to repeat non-variable data for each line, same here
m
the problem is that the procedure for importing an expense report with multi lines is not the same as for other records. I need to import with multiple files. One file contains the header info, the second one contains the rows but it’s not working
k
you are right! so use multiple external ids from your header for the lines, that’s how you tie the two files
employee external ID = 100, employee expenses uses externals employee id 100 for each line of the expense report
m
yes I understood my error because of an external id used twice in header . Thanks for the help anyway
👍🏻 1