Re: Import log, posted by Stefan Ritt on Tue Apr 24 12:26:32 2007
|
| bob wrote: | Hi,
it is possible to import the file *.log of Elog towards another Elog?
thank you
Bob |
There are three methods:
- Copy over the *.log files from one Elog to the other. Make sure not to have entries with the same ID twice then.
- Set-up mirroring between two servers. This ensures a 1:1 copy of the server
- Export entries in CSV format (comma-separated-values) via 'Find', 'Mode = CSV', and do a 'CSV import' on the other side.
|
|
Re: Import log, posted by bob on Tue Apr 24 14:43:07 2007
|
| Stefan Ritt wrote: |
| bob wrote: | Hi,
it is possible to import the file *.log of Elog towards another Elog?
thank you
Bob |
There are three methods:
- Copy over the *.log files from one Elog to the other. Make sure not to have entries with the same ID twice then.
- Set-up mirroring between two servers. This ensures a 1:1 copy of the server
- Export entries in CSV format (comma-separated-values) via 'Find', 'Mode = CSV', and do a 'CSV import' on the other side.
|
thank you,
but the last method (simplest for me) does not import the comment.
it's a pity... |
|
Re: Import log, posted by Stefan Ritt on Thu May 10 13:03:51 2007
|
| bob wrote: | thank you,
but the last method (simplest for me) does not import the comment.
it's a pity... |
Ok, I implemented the XML import which also includes the text body. However there are currently two limitations:
- If you want to import entries which contain replies, it only works if import them into an empty logbook, where the imported entries can obtain the same entry IDs as in the original logbook.
- The names of possible attachments are correctly imported, but not the files themselves. These you have to copy by hand.
|
|
Re: Import csv with another date, posted by Stefan Ritt on Thu Jan 22 09:30:13 2009
|
| Michael Dannmeyer wrote: |
|
Hello,
i have problems with importing csv files. What i want to do is the following:
Import a list of log entries from a csv file with another date like the actual date
I tried to do this but the only thing which happend was that all the entries have the actual date in elog. Then i created a seperate Date column in the csv file an tried to import this.
It worked but in the default date column i have the import date and in a second date column i have the date from the csv file.
Is there a chance to get the csv column imported in the standard Date field?
Or is there a possibility to hide/supress the default date field and only display the imported date field?
Thanks
Michael
|
Importing dates from CSV files was not implemented for a good reason: There are dozens of date formats (such as "1/22/09", "Jan 1 2009", "Mon 1 January '09") and it is almost impossible to handle all formats. I changed now the code to catch at least some formats, such as the internal RFC2822 compliant date which is also used internall by elog. An example of this format is "Thu, 22 Jan 2009 09:26:00". This date format will also be used if you export a logbook via a CSV file. Another format I added is "1/22/09". So give a try to the new code (I made an intermediate release for windows V2.7.5-3) and see if it works for you. |
|
Re: Import a CSV, posted by Stefan Ritt on Mon Apr 2 15:48:25 2012
|
| Ben wrote: |
|
I am trying to import a CSV file in to a logbook. The Attributes seem to import fine but it kicks out the first 2 columns of data and shifts the data over to the left by 2 columns. Has anyone tried to do this?
|
The CSV file must be wrongly formatted. But I don't see it I can't tell you what's wrong. |
Re: Import a CSV, posted by Ben on Mon Apr 2 16:07:48 2012 
|
| Stefan Ritt wrote: |
|
| Ben wrote: |
|
I am trying to import a CSV file in to a logbook. The Attributes seem to import fine but it kicks out the first 2 columns of data and shifts the data over to the left by 2 columns. Has anyone tried to do this?
|
The CSV file must be wrongly formatted. But I don't see it I can't tell you what's wrong.
|
Here is an example of the CSV I am trying to import. |
|
Re: Import a CSV, posted by Stefan Ritt on Mon Apr 2 17:06:33 2012
|
| Ben wrote: |
|
| Stefan Ritt wrote: |
|
| Ben wrote: |
|
I am trying to import a CSV file in to a logbook. The Attributes seem to import fine but it kicks out the first 2 columns of data and shifts the data over to the left by 2 columns. Has anyone tried to do this?
|
The CSV file must be wrongly formatted. But I don't see it I can't tell you what's wrong.
|
Here is an example of the CSV I am trying to import.
|
Thanks for reporting this bug. I fixed it now in SVN revision 2446. |
|
Re: Import a CSV, posted by Ben on Mon Apr 2 17:24:17 2012
|
| Stefan Ritt wrote: |
|
| Ben wrote: |
|
| Stefan Ritt wrote: |
|
| Ben wrote: |
|
I am trying to import a CSV file in to a logbook. The Attributes seem to import fine but it kicks out the first 2 columns of data and shifts the data over to the left by 2 columns. Has anyone tried to do this?
|
The CSV file must be wrongly formatted. But I don't see it I can't tell you what's wrong.
|
Here is an example of the CSV I am trying to import.
|
Thanks for reporting this bug. I fixed it now in SVN revision 2446.
|
Thanks for the quick response!! |