Re: [Dataperf] Import txt file

[Juan Salhus]

Thanks, Bruce

El mié., 15 ene. 2020 06:07, Bruce Conrad  escribió:

> Hi Juan,
>
> I have seen imports fail when a record is too wide. I don't remember how
> wide a record can be, but you might try looking at it in a text editor and
> perhaps shortening long lines?
>
> Many thanks and best wishes,
> Bruce
>
> On Tue, Jan 14, 2020 at 3:43 PM Juan Salhus  wrote:
>
>> Hi, one question,
>> There a límits to import a txt file to Dp?
>> I have a file with 110.000 récords, when import they stop aprox in récord
>> 30 000
>> Thanks
>> Best regards
>> ___
>> Dataperf mailing list
>> Dataperf@dataperfect.nl
>> http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
>>
> ___
> Dataperf mailing list
> Dataperf@dataperfect.nl
> http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
>
___
Dataperf mailing list
Dataperf@dataperfect.nl
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf

Re: [Dataperf] Import txt file

[Bruce Conrad]

Hi Juan,

I have seen imports fail when a record is too wide. I don't remember how
wide a record can be, but you might try looking at it in a text editor and
perhaps shortening long lines?

Many thanks and best wishes,
Bruce

On Tue, Jan 14, 2020 at 3:43 PM Juan Salhus  wrote:

> Hi, one question,
> There a límits to import a txt file to Dp?
> I have a file with 110.000 récords, when import they stop aprox in récord
> 30 000
> Thanks
> Best regards
> ___
> Dataperf mailing list
> Dataperf@dataperfect.nl
> http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
>
___
Dataperf mailing list
Dataperf@dataperfect.nl
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf

Re: [Dataperf] Import txt file

[Tim Rude]

Hi Juan,

I'm not aware of any limits on imports, other than disk space. I think there 
are also some limits on the size of the .TXX file that DP uses to hold 
multi-line text fields. Could it be that you're bumping up against that?

Just curious, what happens if you break up the text file into 4 chunks of about 
27,500 records each and then import each of the 4 chunks separately?

Tim Rude

On 1/13/2020 2:14 PM, Juan Salhus wrote:
Hi. I need to import a txt file separarte by tab, when I import the file stop 
at récord 30,000. The file have 110.000 récords.
There some límites?
Regards



___
Dataperf mailing list
Dataperf@dataperfect.nl
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf


___
Dataperf mailing list
Dataperf@dataperfect.nl
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf