Re: [mdb-dev] Command line option to suppress binary data

[Alfonso Muñoz-P. F. <alf...@vt...>]

Thanks! I’ve already pulled from the Github repo and the code I added 
was pretty much the same ;)

Great work. I’ll let you know how the octal thing works for testing 
purposes. I pretty much settled on discarding the replication fields, 
though.

Regards.

On 05/12/12 15:09, Nirgal wrote:
> I added a simmilar option in repository last Sunday (!)
>
> Source is available at:
> https://github.com/brianb/mdbtools/archive/master.tar.gz
>
> You can now use -b strip to remove the binary data.
>
> Also, I could export the binary data into a postgres database using octal encoding, with new option -b octal.
> I then used psql COPY command to import the data, but somehow, I had to replace \ by \\ in the csv file first (sed -e s/\\/\\\\/g)
>
> See existing bug repport at:
> https://github.com/brianb/mdbtools/issues/16
> https://bugs.launchpad.net/ubuntu/+source/mdbtools/+bug/390730
>
> Cheers
>
> On Monday 03 December 2012 17:15:35 Alfonso Muñoz-Pomer Fuentes wrote:
>> Hi again.
>>
>> In the database we’re migrating from Access to PostgreSQL we have some
>> fields which contain binary data. They’re used for replication so they
>> can be safely ignored for the migration process. The issue is that there
>> are certain rows in which these binary fields may contain escape
>> sequences which break the import to PostgreSQL. I’ve added a command
>> line option (-B) to skip binary data with blank fields.
>>
>> I don’t know if this is a known issue and if such a workaround would be
>> welcome.
>>
>>
>
> ------------------------------------------------------------------------------
> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
> Remotely access PCs and mobile devices and provide instant support
> Improve your efficiency, and focus on delivering more value-add services
> Discover what IT Professionals Know. Rescue delivers
> http://p.sf.net/sfu/logmein_12329d2d
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>

-- 
Alfonso Muñoz-Pomer Fuentes
Johann Heinrich von Thünen-Institut
Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei
Institut für Forstgenetik
Sieker Landstrasse 2
22927 Grosshansdorf

Telefon: +49 (0)4102/696-145
Fax:     +49 (0)4102/696-200
Email:   alf...@vt...
Web:     http://www.vti.bund.de